Connectors

/

ActiveCampaign

/

Compare open deals in ActiveCampaign and Attio
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Compare open deals in ActiveCampaign and Attio
Compare the open deals for Contoso in ActiveCampaign and Attio and tell me what does not line up.
Contoso has 3 deals in ActiveCampaign and 2 in Attio, with one value gap and one missing deal. - Matched: Contoso renewal, 12,000 in ActiveCampaign vs 14,500 in Attio (value differs) - Matched: Contoso onboarding, 4,000 on both sides, stages agree - Only in ActiveCampaign: Contoso training add on, 2,500 - Totals: 18,500 in ActiveCampaign, 18,500 in Attio Should I check another company?
ActiveCampaign
Sample figures. Your results come from your own account.
activecampaign-get-account
activecampaign-get-deal
activecampaign-get-dealstage
attio-get-record-companies
attio-get-record-deals

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

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.

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

Your AI tool

Gather

It lists the company's deals in ActiveCampaign with stage names, then its deals in Attio.

activecampaign-get-account
activecampaign-get-deal
activecampaign-get-dealstage
attio-get-record-companies
attio-get-record-deals

Match

It pairs deals by title and compares values, showing both stage names without forcing them to match.

No items found.

Report

You get matched deals, deals in only one system and the total value on each side.

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-account

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

activecampaign-get-deal

Returns ActiveCampaign deals 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.
get-data

attio-get-record-companies

Returns companies from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-deals

Returns deals from Attio CRM. Read-only; filter by the fields the tool offers.
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

One reconciled view of the company's pipeline

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