Connectors

/

ActiveCampaign

/

Compare an ActiveCampaign contact with Dynamics 365 Sales
Report
Cross-Connector

Compare a contact in ActiveCampaign with Dynamics 365 Sales

For sales reps who want one person checked in both systems, as contact and lead, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare an ActiveCampaign contact with Dynamics 365 Sales
Compare dana@northwindtraders.com in ActiveCampaign and Dynamics 365 Sales and show what differs.
Dana Whitfield is in ActiveCampaign and Dynamics 365 Sales, as both a contact and a lead. - First and last name: match in all three records - Phone: match, only the formatting differs - Company: Northwind Traders in ActiveCampaign and the contact, Northwind in the lead - Where she exists: both systems Want me to check another person?
ActiveCampaign
Sample figures. Your results come from your own account.
activecampaign-get-contact
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-leads

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

Stale phones and names hide between two systems

Comparing a marketing contact with the CRM by eye misses stale phones, names and companies. In Dynamics 365 Sales the person may also be a lead rather than a contact, so there is more to search.

Without PopdockAI

  • Search ActiveCampaign for the email
  • Search Dynamics 365 Sales contacts, then leads
  • Compare phones, names and companies by eye
  • Guess which system is right

With PopdockAI

  • Both systems searched by email in one request
  • Contacts and leads in Dynamics 365 Sales both checked
  • Phones compared by digits, formatting differences noted
  • Differences shown, no winner picked, 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.

Prompt
**Objective:** Compare the person with email `{email}` across ActiveCampaign and Dynamics 365 Sales and report every difference.

**Step 1: Find the person in ActiveCampaign**

Call `activecampaign-get-contact` (server: ActiveCampaign) with `email` set to `{email}`. If more than one contact is returned, list them with their ids and stop. If none is returned, say the email is absent from ActiveCampaign and continue to Step 2.

**Step 2: Find the person in Dynamics 365 Sales**

Call `dynamics-365-sales-get-contacts` (server: Dynamics 365 Sales) with `email` set to `{email}`. Then call `dynamics-365-sales-get-leads` with `email` set to `{email}`. Matching is case-insensitive and ignores surrounding spaces.

**Step 3: Report**

Show a table with one row per field: first name, last name, phone, company (organization name in ActiveCampaign; parent customer or company name in Dynamics 365 Sales). Columns: ActiveCampaign value, Dynamics 365 Sales contact value, Dynamics 365 Sales lead value, and a Match column. Then give one line stating where the person exists: both, ActiveCampaign only, Dynamics 365 Sales only, or neither. Do not decide which system is right.

**Rules & Guidelines:**

* `activecampaign-get-contact` is on ActiveCampaign; `dynamics-365-sales-get-contacts` and `dynamics-365-sales-get-leads` are on Dynamics 365 Sales. Both servers must be connected.
* 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 a side returns nothing, mark its column "not found" and keep going.
* Compare phone numbers by digits only. Treat differences in capitalisation or punctuation as a match, and say so.
* If the email argument is empty, ask for it and stop.

Who it's for

One answer, three teams that use it

Sales reps

Call with the right details

See if phone and company agree before you call.

Compare priya@contoso.com in ActiveCampaign and Dynamics 365 Sales.

Marketing operations

Find stale marketing data

Spot where ActiveCampaign details differ from the CRM record.

Does tom@fabrikam.com exist in both ActiveCampaign and Dynamics 365 Sales?

CRM administrators

Check lead versus contact

See whether a person is a contact, a lead or both in Dynamics 365 Sales.

Is lee@northwindtraders.com a lead or a contact in Dynamics 365 Sales, and do the details match ActiveCampaign?

How it works

What PopdockAI does when you ask

You give an email and your AI assistant checks both systems and compares the details. It only reads and stops if ActiveCampaign returns several contacts.

Ask

You give the person's email address.

Your AI tool

Find

It looks in ActiveCampaign, then in Dynamics 365 Sales contacts and leads.

activecampaign-get-contact
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-leads

Compare

It compares first name, last name, phone and company, with phones matched by digits.

No items found.

Report

A table marks each field and one line says where the person exists.

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

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

microsoft-dynamics-365-sales-get-contacts

Returns Dynamics 365 Sales contacts. Filter by full name, email, city, job title, state, parent customer, created date and status, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-leads

Returns Dynamics 365 Sales leads. Filter by created date, name, status, rating, owner, company name, email and lead source, and cap how many records come back.
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

Know where a person exists and what differs

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