Connectors

/

Constant Contact

/

Constant Contact campaign clicks to Dynamics SL sales orders
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Constant Contact campaign clicks to Dynamics SL sales orders
Did anyone who clicked our Spring Catalog email in Constant Contact place a Dynamics SL order within 30 days?
6 of 54 clickers are Dynamics SL customers who ordered within 30 days. - Contoso: 2 orders, 14,800 total - Fabrikam: 1 order, 3,950 - Unmatched: 9 clickers with no clear customer match - Note: an order after a click is correlation, not proof Want the full list with order numbers?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
constant-contact-get-contact
dynamics-sl-get-customers
dynamics-sl-get-sales-orders

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Constant Contact

Constant Contact
Run it on your own Constant Contact data.

Connect Constant Contact, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Collect

It lists each unique clicker with first click date and links.

constant-contact-get-campaign
constant-contact-get-campaign-click

03

Match

It matches clickers to Dynamics SL customers by company, leaving doubtful ones unmatched.

constant-contact-get-contact
dynamics-sl-get-customers
dynamics-sl-get-sales-orders

04

Report

You get orders placed after each click, labelled as correlation.

Your AI tool

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.

get-data

constant-contact-get-campaign

Returns Constant Contact email campaigns with their status and headline counts: sends, opens, not opened, clicks, bounces, forwards and opt-outs. Filter by name, status, type and last sent 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-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

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-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.
Read only.Nothing in Constant Contact 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

Campaign clicks traced to Dynamics SL orders, carefully

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