Connectors

/

Microsoft Dynamics SL

/

Dynamics SL customer Constant Contact engagement profile
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Dynamics SL customer Constant Contact engagement profile
Show me Fabrikam's account in Dynamics SL and how they engage with our Constant Contact emails.
Fabrikam Inc is a large buyer that has not opened an email in 90 days. - Balance: 18,200, with 4,100 over 60 days - Days to pay: 47 on average - Email: 9 sends, 0 opens, permission implicit - Read: chase the overdue balance by phone, not email Want the recent sales orders too?
Microsoft Dynamics SL
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics SL

Microsoft Dynamics SL
Run it on your own Microsoft Dynamics SL data.

Connect Microsoft Dynamics SL, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Read

It reads balance, aging, credit limit, days to pay and recent orders.

dynamics-sl-get-customers
dynamics-sl-get-customer-balances
dynamics-sl-get-sales-orders

03

Match

It tries each email in Constant Contact and reads permission and activity.

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

04

Report

You get one profile and a short read on what it suggests.

Your AI tool

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.

get-data

dynamics-sl-get-customers

Returns Dynamics SL customers with their contact details, address, terms, credit limit and salesperson. Filter by customer ID, name, city, state, class, salesperson or status.
get-data

dynamics-sl-get-customer-balances

Returns Dynamics SL customer balances, including current balance, aging buckets, credit limit, open orders and average days to pay. Filter by customer, balance range or last invoice date.
get-data

dynamics-sl-get-sales-orders

Returns Dynamics SL sales orders with totals, balance due, unshipped balance, status and invoice details. Filter by customer, order number, status, order total or order date.
get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
get-data

constant-contact-get-campaign-send

Returns who each Constant Contact campaign was sent to. Filter by campaign, campaign activity, contact, email address or domain and date.
get-data

constant-contact-get-campaign-open

Returns Constant Contact campaign opens with the device used. Filter by campaign, campaign activity, contact, email address or domain, device type and date.
get-data

constant-contact-get-campaign-click

Returns Constant Contact campaign clicks with the link clicked and the device used. Filter by campaign, campaign activity, contact, email address or domain, device type and date.
get-data

constant-contact-get-campaign-bounce

Returns Constant Contact campaign bounces with the bounce type. Filter by campaign, campaign activity, contact, email address or domain, bounce type and date.
get-data

constant-contact-get-campaign-unsubscribe

Returns Constant Contact campaign unsubscribes with the reason given. Filter by campaign, campaign activity, contact, email address or domain, reason and date.
Read only.Nothing in Microsoft Dynamics SL 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

Financial standing and engagement in one profile

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