/
/
Get win rate and won versus lost value for any period
For leaders who want a won and lost deal summary with per owner results, just by asking their AI assistant.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Win rate reviews depend on manual counting
Before a board meeting someone exports deals, splits won from lost and counts them. Per owner and per stage numbers take more work, and each version of the sheet differs.
Without PopdockAI
- Export deals for the period
- Split won from lost and count each
- Total value and work out average deal size
- Break results down by owner and stage
With PopdockAI
- Won and lost deals for your period read from ActiveCampaign
- Win rate, value and average deal size worked out
- Owners and stages resolved by name
- Read only, so no deal is edited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Summarise won and lost deals created between {from-date} and {to-date} (default last 90 days), optionally in pipeline {pipeline-id}.
**Step 1: Pull deals**
Call `activecampaign-get-deal` with `created-date.from`, `created-date.to`, `pipeline-id` = {pipeline-id} when given, once for won and once for lost (use the status filter values for those states; verify them from sample results).
**Step 2: Resolve**
Resolve owners with `activecampaign-get-user` and stages with `activecampaign-get-dealstage`.
**Step 3: Report**
Win rate (won / won plus lost), total won and lost value, average deal size per outcome, per-owner table, and the stage where most lost deals ended.
**Rules & Guidelines:**
* Read-only job. Do NOT call any write tool: no add, update, delete, sync, move, duplicate or bulk tool, in particular `activecampaign-deal-update` and `activecampaign-deal-delete`. If the user asks for a change, tell them to use a write prompt instead.
* Never guess an id. Only use ids returned by a tool in this run. Report only what the tools returned; say so when a value is missing.
**Validation:**
* If a lookup returns no records, say so and stop rather than widening the search silently.
* If a name or email matches more than one record, list the matches (id and key fields) and ask which one to use before continuing.
Who it's for
One answer, three teams that use it
Sales leaders
Report win rate with confidence
Get win rate and value for a period in one request.
Give me the win rate for ActiveCampaign deals created in the last 90 days.
Executives
Prepare for the board
See won and lost value and where deals are being lost.
Summarise won and lost deals for pipeline 1 this quarter.
Sales managers
Coach by owner
See each owner's won and lost results side by side.
Show won and lost deals by owner for 1 July to 30 September.
How it works
What PopdockAI does when you ask
You set the period and your AI assistant reads the won and lost deals and does the arithmetic. It only reads, so no deal is edited.
Ask
You give a date range, or use the last 90 days, and optionally a pipeline.
Pull
It reads the won deals and the lost deals created in that period.
Resolve
It looks up the owners and stages involved.
Report
You get win rate, values, average deal size, a per owner table and the stage where most lost deals ended.
What PopdockAI provides
The tools behind the answer
Ready made tools for ActiveCampaign and one secure connection to your AI tool. No code, no exports.
activecampaign-get-deal
activecampaign-get-user
activecampaign-get-dealstage
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
Board ready win rate without the export
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)
