Connectors

/

ActiveCampaign

/

ActiveCampaign Won lost deal summary
Report

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.

Try PopdockAI free
Get a live demo
ActiveCampaign Won lost deal summary
Summarise won and lost deals in ActiveCampaign for the last quarter, with win rate by owner.
Win rate for 1 Aug to 31 Oct is 34 percent: 27 won and 52 lost. - Value: 410,000 won and 890,000 lost - Average deal size: 15,200 won and 17,100 lost - Best owner result: Sam Patel, 8 won of 14 closed - Most lost deals ended at: Proposal Want the full per owner table?
ActiveCampaign
Sample figures. Your results come from your own account.
activecampaign-get-deal
activecampaign-get-user
activecampaign-get-dealstage

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

ActiveCampaign

ActiveCampaign
Run it on your own ActiveCampaign data.

Connect ActiveCampaign, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Pull

It reads the won deals and the lost deals created in that period.

activecampaign-get-deal
activecampaign-get-user
activecampaign-get-dealstage

Resolve

It looks up the owners and stages involved.

No items found.

Report

You get win rate, values, average deal size, a per owner table and the stage where most lost deals ended.

Your AI tool

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.

get-data

activecampaign-get-deal

Returns ActiveCampaign deals with the fields and filters the connector exposes. Read only.
get-data

activecampaign-get-user

Returns ActiveCampaign users with the fields and filters the connector exposes. Read only.
get-data

activecampaign-get-dealstage

Returns ActiveCampaign deal stages with the fields and filters the connector exposes. Read only.
Read only.Nothing in ActiveCampaign Changes

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.

How Popdock AI secures your data

The outcome

Board ready win rate without the export

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation