/
/
Reconcile a customer's ActiveCampaign deals with Dynamics 365 Sales
For sales managers who want one customer's deals and opportunities lined up with the gaps shown, just by asking their AI assistant.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Two pipelines for one customer never add up
A manager opens ActiveCampaign deals and Dynamics 365 Sales opportunities for the same customer and tries to line them up. Titles and amounts are close but not identical, so the totals never agree.
Without PopdockAI
- Find the customer account in ActiveCampaign and list its deals
- Find the customer in Dynamics 365 Sales and list opportunities
- Match items by title and amount by eye
- Add up each side and chase the difference
With PopdockAI
- The account is found by name, with a list if several match
- Deals and opportunities read from both systems
- Close pairs labelled likely matches, never certain
- Gaps and totals shown, currencies not converted, and nothing is changed
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 customer named `{account-name}`, compare open pipeline in ActiveCampaign with open opportunities in Dynamics 365 Sales.
**Step 1: Find the account in ActiveCampaign**
Call `activecampaign-get-account` (server: ActiveCampaign) with `name.contains` set to `{account-name}`. If more than one account matches, list them with ids and stop. If none, report "no ActiveCampaign account" and continue to Step 3.
**Step 2: Read its deals**
Call `activecampaign-get-deal` (server: ActiveCampaign) with `account-id` set to the account `id`. Keep title, value, currency, status and percent.
**Step 3: Read the opportunities in Dynamics 365 Sales**
Call `dynamics-365-sales-get-accounts` (server: Dynamics 365 Sales) with `account-name.contains` set to `{account-name}` to confirm the customer exists, then call `dynamics-365-sales-get-opportunities` with `potential-customer.contains` set to `{account-name}`. Keep topic, est-revenue, status, sales-stage and probability.
**Step 4: Report**
Two tables (deals, opportunities) and a short reconciliation: pair items whose titles and amounts are close, then list deals with no opportunity and opportunities with no deal. Give total open value on each side. Flag currency mismatches rather than converting.
**Rules & Guidelines:**
* `activecampaign-get-account` and `activecampaign-get-deal` are on ActiveCampaign; `dynamics-365-sales-get-accounts` and `dynamics-365-sales-get-opportunities` are on Dynamics 365 Sales.
* This prompt is read-only. Never call any create, update, add or delete tool on either server, including `activecampaign-contact-add`, `activecampaign-contact-update`, `activecampaign-contact-sync`, `activecampaign-contact-delete`, `activecampaign-note-add`, `activecampaign-deal-add`, `activecampaign-deal-update`, `activecampaign-contacttag-add`, `dynamics-365-sales-create-lead`, `dynamics-365-sales-create-contact`, `dynamics-365-sales-create-account`, `dynamics-365-sales-create-opportunity`, `dynamics-365-sales-create-note`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-case`, `dynamics-365-sales-create-phone-call`, `dynamics-365-sales-update-lead`, `dynamics-365-sales-update-contact`, `dynamics-365-sales-update-account`, `dynamics-365-sales-update-opportunity`.
**Validation:**
* If either side is empty, report the other side alone and say which system had nothing.
* Matching on title and amount is a judgment: label each pair "likely match" and never call it certain.Who it's for
One answer, three teams that use it
Sales managers
Agree the numbers
See deals and opportunities for a customer side by side with the gap.
Reconcile Contoso in ActiveCampaign and Dynamics 365 Sales.
Revenue operations
Find missing records
List deals with no opportunity and opportunities with no deal.
Which Fabrikam deals in ActiveCampaign have no opportunity in Dynamics 365 Sales?
Account executives
Prepare for a customer review
Get open value on each side before you meet the customer.
Compare the open pipeline for Northwind Traders in both systems.
How it works
What PopdockAI does when you ask
You name a customer and your AI assistant reads from both systems and reconciles. It only reads, and pairings are always labelled as likely.
Ask
You give the customer name.
Deals
It finds the account in ActiveCampaign and reads its deals.
Opportunities
It confirms the customer in Dynamics 365 Sales and reads the opportunities.
Reconcile
It pairs close items as likely matches, lists the gaps and totals 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
microsoft-dynamics-365-sales-get-accounts
microsoft-dynamics-365-sales-get-opportunities
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 customer, one reconciled pipeline view
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)
