Connectors

/

Microsoft Dynamics 365 Business Central

/

Reconcile Dynamics 365 Business Central customers with Constant Contact contacts
Report
Cross-Connector

Find which customers your Constant Contact campaigns miss, and why

For marketing teams who want Business Central customers checked against Constant Contact contacts, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Dynamics 365 Business Central customers with Constant Contact contacts
Reconcile our Business Central customers with Constant Contact contacts for salesperson SP.
50 customers checked: 34 matched, 9 missing, 7 with no email. - Missing: 9, such as Contoso, ops@contoso.com - Not emailable: 5 matched contacts are unsubscribed or pending - No email: 7 customers have no email in Business Central Want the missing customers so you can add them?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
constant-contact-get-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Your campaigns miss customers and nobody knows why

Active Business Central customers should be reachable in Constant Contact, but some never made it across, some unsubscribed and some have no email at all. Telling which is which means checking customers one at a time.

Without PopdockAI

  • Export active customers
  • Search each email in Constant Contact
  • Check permission status contact by contact
  • Lose track of who has no email at all

With PopdockAI

  • Active customers are read, 50 by default
  • Each email is looked up in Constant Contact, never by name
  • Missing, not emailable and no email customers get their own table
  • Duplicate contacts are noted, 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 Business Central customers with Constant Contact contacts, matched on email address, for customers of salesperson `{salesperson-code}` (default: all salespeople), checking at most `{max-customers}` customers (default 50).

**Step 1: List the customers in Business Central**

Call `business-central-get-customer` with `blocked` set to false, `max-records` set to `{max-customers}` (or 50), and `salesperson-code` set to `{salesperson-code}` when it is given. Keep `customer-number`, `name`, `email`, `salesperson-code` and `balance` for each customer. Set aside every customer whose `email` is empty; they cannot be matched.

**Step 2: Look each customer up in Constant Contact**

For each customer with an email, call `constant-contact-get-contact` with `email-address` set to the customer's `email`. Compare email addresses ignoring case and surrounding spaces. If more than one contact comes back, use the exact match and note the duplicate.

**Step 3: Report**

Give a count line first (customers checked, matched, missing from Constant Contact, without an email), then three tables:

1. **Missing from Constant Contact:** customer number, name, email, salesperson.
2. **Matched but not emailable:** customer number, name, email, the contact's `permission-to-send` value. Include every contact whose permission is not explicit or implicit (for example unsubscribed or pending).
3. **No email in Business Central:** customer number, name, salesperson.

End with one sentence suggesting the `add-customers-to-contact-list` prompt for the first table.

**Rules & Guidelines:**

* `business-central-get-customer` is on the business-central server; `constant-contact-get-contact` is on the constant-contact server.
* Read-only. Do NOT call `constant-contact-add-contact`, `constant-contact-update-contact`, `business-central-update-customer` or any other create, update or add tool on either server.
* Pass `company` to the Business Central tool only if the user names a company.

**Validation:**

* If Business Central returns no customers, say so and stop.
* If an email in Business Central holds several addresses separated by `;` or `,`, look up the first one and note the others in the report.
* Never treat a name match as a match. Email is the only key.

Who it's for

One answer, three teams that use it

Email marketers

Close the gaps in your audience

See which customers are missing from Constant Contact and fix each gap in the right place.

Which active Business Central customers are not in Constant Contact?

Marketing operations

Understand why customers cannot be emailed

Customers whose permission status blocks email are listed apart from those who are simply missing.

Reconcile 100 Business Central customers with Constant Contact and show who cannot be emailed.

Account managers

Find customers with no email on file

Customers with no email in Business Central are listed, so you can collect one.

For salesperson MK, which Business Central customers have no email or are missing from Constant Contact?

How it works

What PopdockAI does when you ask

You optionally name a salesperson and your AI assistant checks each Business Central customer's email in Constant Contact. You get three tables, and neither system is changed.

01

Ask

You optionally name a salesperson and how many customers to check.

Your AI tool

02

Read

It reads active Business Central customers.

No items found.

03

Match

Each email is looked up in Constant Contact, never by name.

constant-contact-get-contact

04

Report

You get a count line and three tables, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.

get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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 which customers your campaigns miss, and why

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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