/
/
Set Business Central invoices beside Mailchimp campaign revenue
For marketing teams who want a finance-grade revenue figure for a Mailchimp campaign, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
The problem
Mailchimp says one number, finance trusts another
Mailchimp reports the store revenue it attributes to a campaign, but finance trusts what Business Central invoiced. Comparing them means listing the campaign's buyers, finding each as a customer and totalling their invoices after the send.
Without PopdockAI
- Pull attributed orders from the Mailchimp report
- Find each buyer in Business Central
- Total their invoices in the window
- Add up different currencies by mistake
With PopdockAI
- Headline numbers and attributed orders are read from Mailchimp
- Each buyer's Business Central invoices in the window are totalled
- Both figures are shown buyer by buyer
- Currencies are never mixed, and both systems are left as they are
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Mailchimp campaign `{campaign-title}`, compare the e-commerce revenue Mailchimp attributes to it with the sales Business Central invoiced to the same customers in the `{days-after-send}` days after it was sent (default 30). Use the Business Central company `{company}`; if it is empty, omit the `company` filter.
**Step 1: Find the campaign**
Call `mailchimp-get-report` with `campaign-title.contains` set to `{campaign-title}`. If more than one campaign matches, list them (campaign-title, send-date, emails-sent) and stop so the user can pick one. Note send-date, emails-sent, open-rate, click-rate and total-revenue.
**Step 2: Orders Mailchimp attributes to it**
Call `mailchimp-get-order` with `outreach-name.contains` set to the campaign title. Collect the distinct customer-email-address values with each one's summed order-total and currency-code.
**Step 3: Carry each buyer into Business Central**
For each email, call `business-central-get-customer` with `email` set to it to get the customer-number. Then call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to it, `posting-date.from` set to the send-date and `posting-date.to` set to the send-date plus the window. Sum total-amount per customer.
**Step 4: Report**
The campaign's headline numbers, then a table: email, customer-number, Mailchimp attributed order total, Business Central invoiced total in the window, invoice count. Finish with the two totals side by side and the number of buyers not found in Business Central.
**Rules & Guidelines:**
* `mailchimp-get-report` and `mailchimp-get-order` are on the mailchimp server. `business-central-get-customer` and `business-central-get-posted-sales-invoice` are on the business-central server.
* Business Central invoices in the window are correlation, not proof of attribution. Say so once in the report.
* This prompt is read-only. Do NOT call `mailchimp-replicate-campaign` or any business-central create or update tool.
**Validation:**
* If Mailchimp attributes no orders to the campaign, report the campaign metrics and stop.
* If a buyer's email is not a Business Central customer, list them as not found and continue.
* If currency-code differs between the two systems for a buyer, show both amounts with their currency and do not add them together.Who it's for
One answer, three teams that use it
Email marketers
Back your campaign numbers with invoices
See Mailchimp's attributed revenue next to what was actually invoiced, buyer by buyer.
Compare Mailchimp revenue for our Black Friday campaign with Business Central invoices in the 14 days after.
Finance analysts
Check marketing revenue claims
Invoiced totals from Business Central give finance its own view of campaign revenue.
What did Business Central invoice buyers from our Summer Sale Mailchimp campaign within 30 days?
Marketing operations
Find buyers missing from the ERP
Buyers not found in Business Central are listed, pointing to customer setup gaps.
Which buyers from our Mailchimp Spring Launch campaign are not in Business Central?
How it works
What PopdockAI does when you ask
You name the campaign and a window and your AI assistant sets Mailchimp's figure beside what Business Central invoiced. It states that this shows correlation, not proof.
01
Ask
You name the campaign and a window after the send.
02
Read
It reads the campaign's headline numbers and attributed orders.
03
Match
Each buyer is found in Business Central and invoices in the window are totalled.
04
Report
You get both figures side by side, buyer by buyer.
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.
mailchimp-get-report
mailchimp-get-order
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 finance grade revenue figure for every campaign
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)
