/
/
Answer what a Drip campaign audience was invoiced
For analysts who want a clear revenue figure for a Drip campaign's subscribers from real Business Central invoices, 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
Leadership asks what a campaign brought in, and the revenue is elsewhere
Leadership asks what a Drip campaign brought in, but the revenue is in Business Central. Answering means exporting subscribers, matching emails to customers and summing invoices since launch, and it is easy to overstate the result.
Without PopdockAI
- Export the campaign's subscribers
- Match emails to customers in a spreadsheet
- Sum posted invoices since launch
- Present it as revenue the campaign caused
With PopdockAI
- The campaign and up to 200 subscribers are read
- Subscribers are matched to customers by email
- Invoices before tax since launch are totalled with match rate
- Shared emails are flagged and the figure framed honestly
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Show how much the subscribers of Drip campaign `{campaign-name}` have been invoiced in Business Central since the campaign was created. Use Business Central company `{bc-company}` if given.
**Step 1: Find the campaign**
Call `drip-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one campaign matches, list them (name, `campaign-id`, `status`, `created-date`) and stop so the user can pick. If none match, say so and stop. Note its `created-date`; that is the start of the window.
**Step 2: List its subscribers**
Call `drip-get-campaign-subscriber` with `campaign-id` set to the campaign's `campaign-id` (`max-records` 200). Keep each `email` and `campaign-status`.
**Step 3: Carry each email into Business Central**
For each email, call `business-central-get-customer` with `email` set to it. For each matched customer, call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to its `customer-number` and `posting-date.from` set to the campaign's created date. Sum `total-amount` (before tax).
**Step 4: Report**
* Campaign name, status, created date, subscribers read
* Matched to a customer: count and percent; invoiced since start: total and number of invoices
* Top 10 customers by invoiced amount: name, customer number, email, invoiced
* Subscribers with no matching customer: count only, plus up to 10 example emails
State plainly that this is invoiced revenue from people on the campaign, not proof the campaign caused it.
**Rules & Guidelines:**
* Tools whose names start with drip are on the drip server; tools whose names start with business-central are on the business-central server. Pass `{bc-company}` only to business-central tools.
* This prompt is read-only. Do NOT call `drip-pause-campaign`, `drip-activate-campaign`, `drip-remove-subscriber-from-campaign` or any Business Central create or update tool.
**Validation:**
* If the campaign has 200 subscribers or more, say the result covers the first 200 only.
* If two customers share an email, count the invoices of both and flag the duplicate.
* Compare emails case-insensitively and ignoring surrounding spaces.Who it's for
One answer, three teams that use it
Marketing analysts
Answer the revenue question with real invoices
Match rate, invoice count and total give a figure you can defend.
How much have subscribers of our Drip Win Back campaign been invoiced in Business Central since it started?
Marketing leaders
Report campaign value without overclaiming
The figure is framed as invoiced revenue from people on the campaign, not revenue it caused.
Give me the invoiced revenue from our Drip Trial Nurture subscribers in Business Central.
Sales managers
See top customers on a campaign
The top 10 customers by invoiced amount show who on the campaign is buying.
Who are the top Business Central customers among subscribers to our Drip Product Tips series?
How it works
What PopdockAI does when you ask
You name a Drip campaign and your AI assistant totals what its subscribers were invoiced in Business Central. It states plainly that this is not proof of cause, and changes nothing.
01
Ask
You name the Drip campaign and optionally a company.
02
Read
It finds the campaign and reads up to 200 subscribers.
03
Match
Subscribers are matched to customers and posted invoices since launch are totalled.
04
Report
You get match rate, invoiced total, top customers and unmatched count.
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.
drip-get-campaign
drip-get-campaign-subscriber
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
An honest revenue figure for a campaign audience
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)
