/
/
Reconcile a company's open deals across ActiveCampaign and Attio
For sales teams who track deals in two systems and want their AI assistant to pair them and flag what does not line up.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Pipeline reviews built on whichever system was updated last
Deals tracked in both ActiveCampaign and Attio pick up different values and stages over time. Comparing them by hand means two exports and a lot of squinting, and the review ends up trusting the wrong number.
Without PopdockAI
- Open the company in ActiveCampaign and list its deals
- Open the same company in Attio and list its deals
- Match deals by title in a spreadsheet
- Total each side and hope the currencies agree
With PopdockAI
- Both systems are read for the named company
- Deals are paired by title with values and stages side by side
- Stage differences are flagged only when they clearly conflict
- Currencies are reported separately, never added together
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the company called `{company-name}`, compare its ActiveCampaign deals with its Attio deals and report mismatches in value, status or presence. Include only deals of status `{deal-status}` on the ActiveCampaign side (default 0, meaning open).
**Step 1: ActiveCampaign deals**
Call `activecampaign-get-account` with `name.contains` = `{company-name}`. If it matches more than one, list them and stop. Then call `activecampaign-get-deal` with `account-id` = the account id and `status` = `{deal-status}`. Record `title`, `value`, `currency`, `stage-id`, `owner-id` and `pipeline-id`. Call `activecampaign-get-dealstage` with `pipeline-id` to turn each `stage-id` into its `title`.
**Step 2: Attio deals**
Call `attio-get-record-companies` with `name.contains` = `{company-name}`. If it matches more than one, list them and stop. Then call `attio-get-record-deals` with `associated-company` = that company's `record-id`. Record `deal-name`, `deal-value`, `deal-stage` and `deal-owner`.
**Step 3: Match and compare**
Pair deals whose titles match once case and punctuation are ignored. For each pair compare the value. Treat the two stage vocabularies as different systems: show both stage names side by side and flag a pair only when the stages plainly imply different states (for example Won on one side, Open on the other).
**Step 4: Report**
Three lists: Matched (title, both values, both stages, flag), Only in ActiveCampaign, Only in Attio. End with the total value on each side.
**Rules & Guidelines:**
* `activecampaign-get-account`, `activecampaign-get-deal` and `activecampaign-get-dealstage` are on the ActiveCampaign server. `attio-get-record-companies` and `attio-get-record-deals` are on the Attio server.
* Read-only. Never call `activecampaign-deal-add`, `activecampaign-deal-update`, `attio-add-deal`, `attio-update-deal` or any other write tool.
**Validation:**
* If the currencies differ, do not add the values together; report each currency separately.
* If the company is missing in one system, report that and list the deals found in the other.Who it's for
One answer, three teams that use it
Sales managers
Review a pipeline you can trust
Before a forecast call, see which of a company's deals disagree between the two systems and which exist in only one.
Compare the open deals for Northwind Traders in ActiveCampaign and Attio before my pipeline review.
Account executives
Check your own accounts quickly
Confirm the deal values and stages for one of your accounts match in both systems before you update the customer.
Do Fabrikam's won deals in ActiveCampaign match what is in Attio? Use status 1.
Revenue operations
Find deals that exist in only one system
Spot deals missing from one side so the fix is a targeted update instead of a full clean up.
Which Contoso deals are in ActiveCampaign but not in Attio, and do any values differ?
How it works
What PopdockAI does when you ask
You name a company and your AI assistant reads its deals from both systems. It stops if a company name matches more than one record, and it never writes to either account.
Ask
You name the company and optionally the deal status, with open as the default.
Gather
It lists the company's deals in ActiveCampaign with stage names, then its deals in Attio.
Match
It pairs deals by title and compares values, showing both stage names without forcing them to match.
Report
You get matched deals, deals in only one system and the total value on each side.
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-account
activecampaign-get-deal
activecampaign-get-dealstage
attio-get-record-companies
attio-get-record-deals
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
One reconciled view of the company's pipeline
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)
