/
/
Learn why your Pipedrive deals are won and lost
For sales leaders who want win rate, deal size, cycle and grouped lost reasons from Pipedrive for a period, with findings they can act on.
On this page
Connector
Connect Pipedrive, pick your AI tool and paste the prompt.
The problem
The same losses repeat because nobody analyses them
Understanding why deals are won and lost means pulling closed Pipedrive deals, working out win rates and cycle times, and reading free-text lost reasons that say the same thing ten ways. Few teams do it regularly, so the same losses repeat.
Without PopdockAI
- Export won and lost deals
- Work out win rate and cycle time in a spreadsheet
- Read and group lost reasons by hand
- Skip it next quarter because it took too long
With PopdockAI
- Won and lost deals are read for the period
- Win rate, deal size and cycle are worked out per currency
- Results are split by owner and loss stage, with lost reasons grouped
- Three findings with numbers and recommendations, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Analyze the deals won and lost between `{from-date}` and `{to-date}` (default: the last 90 days), optionally only in the `{pipeline-name}` pipeline, and explain why deals are won and lost.
**Step 1: Pull the closed deals**
* Call `pipedrive-get-deal` with `status` = won, and keep deals whose won-date falls in the period.
* Call `pipedrive-get-deal` with `status` = lost, `expected-close-date.from` and `expected-close-date.to` set to the period. Deals carry no lost date, so the expected close date stands in for it. Say so in the report.
* If `{pipeline-name}` is given, keep only rows whose pipeline matches it. Set `max-records` high enough (e.g. 500) to see the whole period.
**Step 2: Analyze**
* Win rate by count and by value (won / (won + lost)), per currency.
* Average won deal size, and average sales cycle in days (won-date minus created-date).
* Win rate and totals by owner.
* Lost deals by the stage they were lost in (the stage field on a lost deal).
* Lost reasons: group similar free-text reasons (e.g. "price", "too expensive") and count each group.
**Step 3: Report**
1. Headline metrics table.
2. By owner table.
3. Lost by stage table.
4. Lost reasons, grouped, with counts and value lost.
5. Three findings and one recommendation per finding, each backed by a number from the tables.
**Rules & Guidelines:**
* Read-only. Do not call `pipedrive-update-deal` or any other add or update tool.
* Never add values across currencies.
* Count lost deals with a blank lost-reason as "No reason recorded" and report how many there are.
**Validation:**
* If fewer than 10 deals closed in the period, give the numbers but say the sample is too small to draw conclusions.
* If `{from-date}` is after `{to-date}`, swap them and say so.Who it's for
One answer, three teams that use it
Sales leaders
See why you lose
Grouped lost reasons with counts show the patterns behind losses, with a recommendation for each finding.
Run a Pipedrive win-loss analysis for the last six months and give me three findings.
Sales managers
Compare win rates by owner
Win rate, deal size and cycle by owner show where coaching would help most.
What were win rates and sales cycles by owner in the Enterprise pipeline last quarter?
Product marketing
Find the stage where deals die
A breakdown by the stage where deals were lost shows where the pitch or product falls short.
At which Pipedrive stage did we lose most deals this year, and why?
How it works
What PopdockAI does when you ask
You pick a period, and a pipeline if you like, and your AI assistant analyses the closed Pipedrive deals. It warns when the sample is too small and only reads.
01
Ask
You pick a period, and optionally a pipeline.
02
Read
It reads won and lost deals in that period.
03
Analyze
It works out rates, size and cycle by owner and loss stage.
04
Report
You get grouped lost reasons and three findings with recommendations.
What PopdockAI provides
The tools behind the answer
Ready made tools for Pipedrive and one secure connection to your AI tool. No code, no exports.
pipedrive-get-deal
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Know where and why deals slip away
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
