Connectors

/

Microsoft Dynamics 365 Business Central

/

Create Dynamics 365 Business Central contacts from Constant Contact campaign clicks
Write
Cross-Connector

Turn Constant Contact clickers into Business Central contacts

For sales teams who want interested campaign clickers on file in Business Central, without duplicates, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Create Dynamics 365 Business Central contacts from Constant Contact campaign clicks
Create Business Central contacts for the people who clicked our Winter Product Preview campaign in Constant Contact.
74 people clicked Winter Product Preview; 15 are not in Business Central. - To create: 12, such as Jordan Lee, Contoso, Buyer - No job title: 3, skip them or give a value - Already on file: 59 as customers or contacts Shall I create the 12 contacts?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
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

Campaign clickers never reach the sales team

People who click a Constant Contact campaign are showing interest, but sales never sees them if they are not in Business Central. Adding them by hand means checking each email against customers and contacts and typing in their details.

Without PopdockAI

  • Export the click report from Constant Contact
  • Search each email in customers and contacts
  • Type names, companies and job titles by hand
  • Create a duplicate for someone already on file

With PopdockAI

  • Every clicker is gathered with their contact details
  • Emails are checked against both customers and contacts
  • Matches are on email, never on name
  • Missing job titles are marked, and nothing is created until you confirm

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 Constant Contact campaign `{campaign-name}`, find people who clicked a link but are neither a customer nor a contact in Business Central, and, once the user confirms, create them as Business Central contacts.

**Step 1: Find the campaign and its clickers in Constant Contact**

Call `constant-contact-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one matches, list them and stop. Then call `constant-contact-get-campaign-click` with `campaign-id`, and keep the distinct `email-address` values. For each, call `constant-contact-get-contact` with `email-address` for `first-name`, `last-name`, `company-name`, `job-title`, `phone-number`, `city`, `state` and `country`.

**Step 2: Check Business Central**

For each clicker, call `business-central-get-customer` with `email`, then `business-central-get-contact` with `email`. Keep only clickers found in neither.

**Step 3: Confirm**

Show the people to be created: name, email, company, job title, phone. Business Central requires a job title; mark anyone without one and ask whether to skip them or use a value the user gives. Ask the user to confirm before creating anything. Do not proceed without a clear yes.

**Step 4: Create the contacts**

For each confirmed person, call `business-central-create-contact` with `display-name` set to first and last name (or the email if both are empty), `job-title`, `email`, `company-name`, `phone-number`, `city`, `state` and `country` where present, and `type` set to Person. Keep the returned `number`. Stop and report on the first error.

**Step 5: Report**

Created (with the new contact number), skipped as already in Business Central, skipped for missing job title, and failed.

**Rules & Guidelines:**

* `constant-contact-get-campaign`, `constant-contact-get-campaign-click` and `constant-contact-get-contact` are on the constant-contact server; `business-central-get-customer`, `business-central-get-contact` and `business-central-create-contact` are on the business-central server.
* The only write tool allowed is `business-central-create-contact`, on the business-central server, after confirmation.
* Do NOT call `business-central-create-customer`, `business-central-create-opportunity`, `constant-contact-update-contact` or any other create, update or add tool.
* Pass `company` to Business Central tools only if the user names a company.

**Validation:**

* If nobody clicked, or every clicker is already in Business Central, say so and stop.
* Compare emails ignoring case. Never treat a name match as a match.

Who it's for

One answer, three teams that use it

Sales reps

Follow up on people who showed interest

Clickers become Business Central contacts you can call, without waiting for a marketing handover.

Add the people who clicked our Spring Catalog campaign in Constant Contact as Business Central contacts.

Marketing managers

Hand engaged prospects to sales

Turn campaign engagement into contacts sales can see, with a report of created, skipped and failed.

Create Business Central contacts from the Holiday Offers campaign clicks and skip anyone without a job title.

Sales operations

Add prospects without duplicates

Only people found in neither customers nor contacts are proposed, so existing records stay clean.

Who clicked the Product Webinar Invite campaign in Constant Contact but is not in Business Central yet?

How it works

What PopdockAI does when you ask

You name the campaign and your AI assistant finds the clickers who are not yet in Business Central. You choose what to do about missing job titles, and contacts are created only after you confirm.

01

Ask

You name the Constant Contact campaign.

Your AI tool

02

Check

It gathers clickers and checks each email against customers and contacts.

constant-contact-get-campaign
constant-contact-get-campaign-click
constant-contact-get-contact

03

Confirm

You see who will be created, with anyone missing a job title marked.

No items found.

04

Create

It creates the contacts and reports created, skipped and failed.

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

Returns Constant Contact email campaigns with their status and headline counts: sends, opens, not opened, clicks, bounces, forwards and opt-outs. Filter by name, status, type and last sent date.
get-data

constant-contact-get-campaign-click

Returns Constant Contact campaign clicks with the link clicked and the device used. Filter by campaign, campaign activity, contact, email address or domain, device type and date.
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

Interested prospects in Business Central, no duplicates

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