Connectors

/

Microsoft Dynamics 365 Business Central

/

Measure Dynamics 365 Business Central revenue from a Constant Contact campaign
Report
Cross-Connector

Put a revenue figure next to a Constant Contact campaign

For marketing teams who want to know what engaged contacts went on to buy in Business Central, stated honestly, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Measure Dynamics 365 Business Central revenue from a Constant Contact campaign
How much did customers who engaged with our Fall Catalog campaign in Constant Contact buy in Business Central within 30 days?
Fall Catalog: 1,240 engaged contacts, 186 matched to customers. - Bought in 30 days: 52 customers - Invoiced: 148,600 USD - Top buyer: Contoso, clicked, 3 invoices, 18,400 - No customer: 1,054 engaged contacts This is correlation within a window, not proof the campaign caused the sale. Want the buyer table?
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-campaign-open

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

Proving a campaign led to sales means a spreadsheet nobody finishes

Showing an email campaign led to sales means matching everyone who opened or clicked to Business Central customers, then adding up invoices posted after the send. By hand it is a spreadsheet of lookups few teams ever finish.

Without PopdockAI

  • Export opens and clicks from Constant Contact
  • Look up each email as a customer
  • Sum invoices posted after the send
  • Overstate the result as revenue the campaign caused

With PopdockAI

  • Everyone who opened or clicked is collected
  • Emails are matched to customers, never by name
  • Posted invoices in the window are totalled by currency
  • The report states it shows correlation, not cause, 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:** Measure the Business Central revenue from customers who engaged with the Constant Contact campaign `{campaign-name}`, counting posted sales invoices dated within `{attribution-days}` days (default 30) after the campaign was sent.

**Step 1: Find the campaign in Constant Contact**

Call `constant-contact-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one campaign matches, list them with `name`, `status` and `last-sent-date` and stop so the user can choose. If the campaign has no `last-sent-date`, say it has not been sent and stop. Keep `campaign-id`, `last-sent-date`, `sends`, `opens` and `clicks`.

**Step 2: Collect the engaged contacts**

Call `constant-contact-get-campaign-click` with `campaign-id`, then `constant-contact-get-campaign-open` with `campaign-id`. Build one list of distinct `email-address` values, recording for each whether the contact clicked or only opened.

**Step 3: Match each contact to a Business Central customer**

For each email, call `business-central-get-customer` with `email` set to the address. If no customer comes back, count the contact as engaged but not a customer and move on. If several come back, list all of them in the report rather than picking one.

**Step 4: Pull the invoices**

For each matched customer, call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to the `customer-number`, `posting-date.from` set to the campaign's `last-sent-date`, and `posting-date.to` set to `{attribution-days}` days (default 30) after it. Sum `total-amount` per customer.

**Step 5: Report**

* A header line: campaign name, sent date, sends, opens, clicks, attribution window.
* Totals: engaged contacts, matched customers, customers who bought in the window, invoiced amount (by `currency-code` if there is more than one currency).
* A table of buying customers: customer number, name, email, clicked or opened, invoice count, invoiced amount, first invoice date.
* The number of engaged contacts with no Business Central customer.

State plainly that this is correlation within a time window, not proof the campaign caused the sale.

**Rules & Guidelines:**

* `constant-contact-get-campaign`, `constant-contact-get-campaign-click` and `constant-contact-get-campaign-open` are on the constant-contact server; `business-central-get-customer` and `business-central-get-posted-sales-invoice` are on the business-central server.
* Read-only. Do NOT call `constant-contact-add-contact`, `constant-contact-update-contact`, `business-central-create-sales-invoice`, `business-central-update-customer` or any other create, update or add tool.
* Pass `company` to Business Central tools only if the user names a company.

**Validation:**

* If nobody opened or clicked, report the send counts and stop.
* Compare emails ignoring case. Never match on name.
* Business Central dates are yyyy-MM-dd; convert the Constant Contact sent date to that format before filtering.

Who it's for

One answer, three teams that use it

Email marketers

Show what your campaign was worth

Put a revenue figure from real invoices next to your open and click rates.

How much did people who clicked our Spring Catalog campaign buy in Business Central within 21 days?

Marketing directors

Compare campaigns on revenue, not opens

Engaged count, buyers and invoiced amount give you a business number to compare campaigns with.

What revenue in Business Central followed our Holiday Offers campaign within 45 days?

Sales managers

See which customers bought after engaging

A table of buying customers shows who acted on the campaign, for follow up.

List the Business Central customers who bought within 30 days of engaging with our New Range campaign.

How it works

What PopdockAI does when you ask

You name the campaign and optionally a window and your AI assistant totals what engaged customers were invoiced in Business Central. It is honest that this is correlation, and it only reads.

01

Ask

You name the campaign and optionally an attribution window.

Your AI tool

02

Collect

It gathers everyone who opened or clicked, noting which.

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

03

Match

Each email is matched to a customer and posted invoices in the window are totalled.

No items found.

04

Report

You get totals and a table of buying customers, with a correlation caveat.

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

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

A revenue figure beside every campaign, honestly framed

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