Connectors

/

Microsoft Dynamics 365 Business Central

/

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

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.

Try PopdockAI free
Get a live demo
Measure Dynamics 365 Business Central revenue from a Drip campaign
How much have subscribers of our Drip Onboarding Series been invoiced in Business Central since it started?
Onboarding Series: 200 subscribers read, 74 matched to customers, 37 percent. - Invoiced since start: 96,300 before tax, 142 invoices - Top customer: Fabrikam, 12,800 - Shared email: 1 address matches two customers - Unmatched: 126 subscribers This is invoiced revenue from people on the campaign, not proof of cause. Want the top 10?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
drip-get-campaign
drip-get-campaign-subscriber

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

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.

Prompt
**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.

Your AI tool

02

Read

It finds the campaign and reads up to 200 subscribers.

drip-get-campaign
drip-get-campaign-subscriber

03

Match

Subscribers are matched to customers and posted invoices since launch are totalled.

No items found.

04

Report

You get match rate, invoiced total, top customers and unmatched count.

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

drip-get-campaign

Returns Drip email series campaigns with status, active and unsubscribed counts, number of emails, sender and opt-in settings. Filter by name, status, minimum active subscribers or created date.
get-data

drip-get-campaign-subscriber

Returns the people subscribed to each Drip email series campaign, with the campaign's status and the person's tags and lead score. Filter by campaign id or name, a person's email, subscriber status or minimum lead score.
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

An honest revenue figure for a campaign audience

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