/
/
Find ActiveCampaign contacts that never reached Dynamics 365 Sales
For marketing teams who want their AI assistant to check recent ActiveCampaign contacts against Dynamics 365 Sales contacts and leads.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Marketing leads that never made it to sales
Marketing exports new contacts from ActiveCampaign and compares them to Dynamics 365 Sales by eye, checking contacts and leads one at a time. Missing leads are easy to overlook, so some never reach sales.
Without PopdockAI
- Export new contacts from ActiveCampaign
- Search each email in Dynamics contacts
- Search again in Dynamics leads
- Compare the results by eye and lose the thread
With PopdockAI
- Recent contacts are read up to a cap you set
- Each email is checked as a Dynamics contact, then as a lead
- Only people found in neither are called missing
- Nothing is created or changed in either system
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find ActiveCampaign contacts created on or after `{created-since}` (an ISO date) that do not exist in Dynamics 365 Sales. Check at most `{max-contacts}` contacts (default 25).
**Step 1: Read the recent contacts from ActiveCampaign**
Call `activecampaign-get-contact` (server: ActiveCampaign) with `created-date.from` set to `{created-since}` and `max-records` set to `{max-contacts}` (use 25 when empty). Keep the id, email, first name, last name and organization name of each.
**Step 2: Check each one in Dynamics 365 Sales**
For every contact that has an email, call `dynamics-365-sales-get-contacts` (server: Dynamics 365 Sales) with `email` set to that email. If it returns nothing, call `dynamics-365-sales-get-leads` with the same email. Skip contacts with no email and list them separately.
**Step 3: Report**
Give counts: checked, found as contact, found as lead, missing. Then a table of the missing ones with email, name, organization and ActiveCampaign created date. End with one sentence saying how to create one of them as a lead (use the prompt that syncs a single contact).
**Rules & Guidelines:**
* Tool origins: `activecampaign-get-contact` on ActiveCampaign; `dynamics-365-sales-get-contacts` and `dynamics-365-sales-get-leads` 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 ActiveCampaign returns no contacts, say so and stop.
* If the date is not a valid ISO date, ask for a corrected one and stop.
* Never report a contact as missing until both Dynamics 365 Sales lookups returned nothing.Who it's for
One answer, three teams that use it
Marketing managers
Show which leads sales never received
Get a clear list of recent contacts missing from Dynamics 365 Sales to take to the sales team.
List ActiveCampaign contacts created since 1 October that are not in Dynamics 365 Sales.
Sales operations
Check lead routing without a spreadsheet
Confirm that new marketing contacts end up as contacts or leads in Dynamics 365 Sales.
Check the last 25 ActiveCampaign contacts and tell me how many exist as contacts or leads in Dynamics 365 Sales.
Sales managers
Catch leads before they go cold
See which recent leads are not yet in the CRM so a rep can pick them up.
Which new ActiveCampaign sign ups since last Monday are missing from Dynamics 365 Sales?
How it works
What PopdockAI does when you ask
You give a start date and your AI assistant checks each recent contact in Dynamics 365 Sales. It only reads, and it ends with a pointer on how to add one as a lead.
Ask
You give a start date and the most contacts to check.
Read
It reads recent ActiveCampaign contacts and sets aside any with no email.
Check
It looks each email up as a Dynamics 365 Sales contact, then as a lead if none is found.
Report
You get the counts and a table of the contacts missing from both.
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-contact
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-leads
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
A reliable list of leads that never reached sales
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)
