/
/
See which campaign clicks turned into Dynamics SL orders
For marketers who want Constant Contact clickers matched to Dynamics SL customers and their later sales orders, by asking their AI assistant.
On this page
Connector
Connect Constant Contact, pick your AI tool and paste the prompt.
The problem
Dynamics SL cannot match a clicker by email
Marketing wants to know whether campaign clickers went on to order, but Dynamics SL cannot search customers by email. Matching by company name and checking orders in the weeks after is slow and easy to get wrong when names are similar.
Without PopdockAI
- Export clickers and their companies
- Search Dynamics SL by company name
- Guess between similar customer names
- Check sales orders customer by customer
With PopdockAI
- Each unique clicker is listed with first click date and links
- Customers are matched by company only when the match is clear
- Doubtful matches stay unmatched, never guessed
- Orders after each click are totalled and labelled as correlation
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Constant Contact campaign `{campaign}`, find the contacts who clicked and show which of them are Dynamics SL customers that placed a sales order within `{window-days}` days of the click (default 30).
**Step 1: Identify the campaign**
Call `constant-contact-get-campaign` with `campaign-id` = `{campaign}`; if nothing comes back, use `name.contains` = `{campaign}`. If more than one matches, list them (id, name, last sent date) and stop. Note the `last-sent-date`.
**Step 2: Who clicked**
Call `constant-contact-get-campaign-click` with the `campaign-id`. Keep one row per contact: `contact-id`, `email-address`, the earliest click `created-date`, and the links clicked. Then call `constant-contact-get-contact` with each `contact-id` to get `company-name`.
**Step 3: Carry across to Dynamics SL**
Dynamics SL customers cannot be filtered by email, so match on company. For each clicker with a company name, call `dynamics-sl-get-customers` with `customer-name.contains` = the company name. Accept a customer only if its `email-address` matches the contact's email, or it is the single result and the names agree once case and suffixes like Inc, LLC or Ltd are ignored. Mark everything else as unmatched; do not guess.
**Step 4: Orders after the click**
For each matched customer, call `dynamics-sl-get-sales-orders` with the `customer-id`, `order-date.from` = the click date and `order-date.to` = the click date plus {window-days} days.
**Step 5: Report**
* Campaign name, send date, number of unique clickers, how many matched to a Dynamics SL customer.
* A table of matched clickers: contact email, customer id and name, links clicked, orders in the window (count and total), first order date.
* A short list of unmatched clickers by email and company.
* State plainly that an order after a click is a correlation, not proof that the campaign caused it.
**Rules & Guidelines:**
* constant-contact tools: `constant-contact-get-campaign`, `constant-contact-get-campaign-click`, `constant-contact-get-contact`. dynamics-sl tools: `dynamics-sl-get-customers`, `dynamics-sl-get-sales-orders`.
* Read-only. Do not call `constant-contact-resend-campaign-to-non-openers`, `constant-contact-update-campaign` or any other write tool.
* If the user has named a Dynamics SL company, pass it as `company` on every dynamics-sl call.
**Validation:**
* If the campaign has no clicks, say so and stop.
* If a clicker has no company name, list them as unmatched.Who it's for
One answer, three teams that use it
Marketing managers
Show what followed a campaign
Orders placed after each click give a grounded answer to whether the email moved buyers.
Which clickers on our New Catalog email in Constant Contact placed a Dynamics SL order within 45 days?
Sales managers
Spot customers responding to email
Matched clickers with fresh orders show which accounts are paying attention.
Total the Dynamics SL sales orders placed by clickers on our Q2 Promo campaign in the following month.
Business analysts
Trust the matches you report
Uncertain matches are listed separately instead of guessed, so your numbers hold up.
List clickers on our Spring Catalog email that could not be matched to a Dynamics SL customer.
How it works
What PopdockAI does when you ask
You name a campaign and your AI assistant matches clickers to Dynamics SL customers carefully and totals orders placed afterwards. It only reads.
01
Ask
You name the campaign, and optionally a window, 30 days by default.
02
Collect
It lists each unique clicker with first click date and links.
03
Match
It matches clickers to Dynamics SL customers by company, leaving doubtful ones unmatched.
04
Report
You get orders placed after each click, labelled as correlation.
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-campaign
constant-contact-get-campaign-click
constant-contact-get-contact
dynamics-sl-get-customers
dynamics-sl-get-sales-orders
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
Campaign clicks traced to Dynamics SL orders, carefully
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)
