/
/
See a customer's balance and email engagement together
For account managers who want a Dynamics SL customer's account position and Constant Contact engagement in one profile, by asking their AI.
On this page
Connector
Connect Microsoft Dynamics SL, pick your AI tool and paste the prompt.
The problem
Chasing an invoice without knowing they ignore your email
A customer's balance and orders are in Dynamics SL while their email engagement is in Constant Contact. The two rarely end up side by side, so you may chase by email someone who has not opened one in months.
Without PopdockAI
- Read balance and aging in Dynamics SL
- Open recent sales orders
- Search Constant Contact for each email
- Compare opens and clicks by hand
With PopdockAI
- Balance, aging, credit limit and orders are read
- Each email on file is tried in Constant Contact
- Sends, opens, clicks, bounces and opt outs are reported
- A short read explains the combination, nothing is touched
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build one profile for Dynamics SL customer `{customer}` that shows their account position (balance, aging, recent orders) next to their email engagement in Constant Contact over the last `{lookback-days}` days (default 90).
**Step 1: Identify the customer in Dynamics SL**
Call `dynamics-sl-get-customers` with `customer-id` = `{customer}`. If nothing comes back, call it again with `customer-name.contains` = `{customer}`. If more than one customer matches, list them (id, name, city) and stop so the user can pick.
**Step 2: Account position**
Call `dynamics-sl-get-customer-balances` with the `customer-id` for current balance, the age-balance buckets, credit limit and average days to pay. Then call `dynamics-sl-get-sales-orders` with the `customer-id` and `order-date.from` set to {lookback-days} days ago for recent orders.
**Step 3: Find the contact in Constant Contact**
Take `email-address` from the customer record and call `constant-contact-get-contact` with it as `email-address`. If the SL field holds several addresses, try each. If no contact matches, report the account section, state that the customer has no Constant Contact contact, and stop there.
**Step 4: Email engagement**
With the contact's `contact-id` and `created-date.from` set to {lookback-days} days ago, call `constant-contact-get-campaign-send`, `constant-contact-get-campaign-open`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-bounce` and `constant-contact-get-campaign-unsubscribe`.
**Step 5: Report**
* **Account** (Dynamics SL): customer id and name, current balance, overdue buckets, credit limit, average days to pay, number and total of orders in the window.
* **Contact** (Constant Contact): contact id, permission-to-send, tags, lists.
* **Engagement**: sends, opens, clicks (with link URLs), bounces, unsubscribes in the window, and the open rate.
* **Read**: two or three sentences on what the combination suggests, such as an engaged customer with an overdue balance, or a large buyer who never opens email.
**Rules & Guidelines:**
* dynamics-sl tools: `dynamics-sl-get-customers`, `dynamics-sl-get-customer-balances`, `dynamics-sl-get-sales-orders`. constant-contact tools: the get-contact and get-campaign-* reads above.
* Read-only. Do not call `constant-contact-update-contact`, `constant-contact-add-contact-note` or any other write tool.
* If the user has named a Dynamics SL company, pass it as `company` on every dynamics-sl call.
**Validation:**
* An engagement tool that returns nothing means zero for that measure, not an error.
* Do not compute an open rate when there were no sends.Who it's for
One answer, three teams that use it
Account managers
Know a customer before you call
See balance, days to pay and recent orders beside how they respond to your email.
Profile Contoso from Dynamics SL and Constant Contact over the last 180 days.
Collections specialists
Choose the right channel to chase
Know whether a customer with a balance actually opens email before relying on it.
Does Northwind Traders open our Constant Contact emails, and what do they owe in Dynamics SL?
Marketing managers
Spot big buyers who ignore email
The short read flags combinations like a large buyer who never opens email.
How engaged is customer FAB001 with Constant Contact compared with their order volume?
How it works
What PopdockAI does when you ask
You name a customer and your AI assistant combines their Dynamics SL account with Constant Contact engagement. It reads only.
01
Ask
You give a Dynamics SL customer id or name and a look-back, 90 days by default.
02
Read
It reads balance, aging, credit limit, days to pay and recent orders.
03
Match
It tries each email in Constant Contact and reads permission and activity.
04
Report
You get one profile and a short read on what it suggests.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics SL and one secure connection to your AI tool. No code, no exports.
dynamics-sl-get-customers
dynamics-sl-get-customer-balances
dynamics-sl-get-sales-orders
constant-contact-get-contact
constant-contact-get-campaign-send
constant-contact-get-campaign-open
constant-contact-get-campaign-click
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
Financial standing and engagement in one profile
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)
