/
/
One view of a customer's email standing and Business Central account
For account managers who want Constant Contact engagement next to the Business Central balance and orders, by asking their AI assistant.
On this page
Connector
Connect Constant Contact, pick your AI tool and paste the prompt.
The problem
A customer's full picture is split across two systems
Before you call, the subscription and email history sits in Constant Contact and the balance, orders and invoices sit in Business Central. Switching between them, it is easy to miss that a customer who owes money has unsubscribed.
Without PopdockAI
- Search Constant Contact for the email
- Open Business Central and find the customer
- Compare names and balances by eye
- Miss the conflict that matters on the call
With PopdockAI
- Constant Contact permission, lists and activity are read
- The Business Central customer comes with balances and open documents
- Conflicts like a bounce on an active customer are flagged
- Several matches are each reported, and nothing changes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Give a single view of `{email-address}`: their Constant Contact subscription and engagement, and their Business Central customer account and recent sales, looking back `{lookback-days}` days (default 90).
**Step 1: Constant Contact**
Call `constant-contact-get-contact` with `email-address` set to `{email-address}`. Keep `contact-id`, name, `company-name`, `permission-to-send` and `tags`. Then call `constant-contact-get-contact-list-member` with `email-address` for list memberships, and `constant-contact-get-contact-activity` with `email-address` and `created-date.from` set to `{lookback-days}` days ago (default 90). Also call `constant-contact-get-campaign-bounce` and `constant-contact-get-campaign-unsubscribe` with `email-address`.
If no contact is found, say the person is not in Constant Contact and continue to Step 2.
**Step 2: Business Central**
Call `business-central-get-customer` with `email` set to `{email-address}`. If no customer comes back, call `business-central-get-contact` with `email` and report the contact if found. If neither matches, report that the person is not in Business Central.
For a matched customer, call `business-central-get-sales-transaction` with `sell-to-customer-number` set to the `customer-number` for open documents, and `business-central-get-posted-sales-invoice` with `sell-to-customer-number` and `posting-date.from` set to `{lookback-days}` days ago.
**Step 3: Report**
* **Marketing (Constant Contact):** permission to send, lists, tags, activity counts by `activity-type`, last activity date, any bounce (with `bounce-type`) or unsubscribe (with `reason`).
* **Account (Business Central):** customer number and name, salesperson, `balance`, `balance-due`, `outstanding-orders`, open sales documents (number, type, status, amount), posted invoices in the window (count and total).
* **Flags:** call out an unsubscribe or bounce on an active customer, a balance due on a contact who cannot be emailed, and a company name that differs between the two systems.
**Rules & Guidelines:**
* Tools whose names start with constant-contact are on the constant-contact server; tools whose names start with business-central are on the business-central server.
* Read-only. Do NOT call `constant-contact-update-contact`, `constant-contact-add-contact-note`, `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 the email is not found in either system, say so and stop.
* If Business Central returns several customers for the email, list them all and report each account separately.Who it's for
One answer, three teams that use it
Account managers
Prepare for a call in one request
Know the balance, open orders and email engagement before you pick up the phone.
Profile sam.patel@fabrikam.com across Constant Contact and Business Central before my call.
Credit controllers
Know if reminders will arrive
Spot a customer who owes money but has bounced or unsubscribed before you rely on email.
Does priya@contoso.com owe us anything in Business Central, and are they still subscribed in Constant Contact?
Customer service reps
See the whole customer at once
Orders, invoices and email standing together mean fewer surprises in a conversation.
What open orders and recent invoices does dana@northwindtraders.com have, and which lists is she on?
How it works
What PopdockAI does when you ask
You give an email address and your AI assistant brings together the Constant Contact and Business Central sides of that customer. It only reads.
01
Ask
You give an email address, and optionally a look-back period.
02
It reads Constant Contact permission, lists, activity, bounces and unsubscribes.
03
Account
It finds the Business Central customer with balances, open orders and invoices.
04
Report
You get both sides with conflicts flagged, and nothing is changed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Constant Contact and one secure connection to your AI tool. No code, no exports.
constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity
constant-contact-get-campaign-bounce
constant-contact-get-campaign-unsubscribe
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
Marketing and account standing in one view
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)
