/
/
See which Constant Contact clicks turned into WooCommerce orders
For marketers who want a campaign's clicks matched to later WooCommerce orders and revenue by asking their AI assistant, measured honestly.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
Campaign clicks in one system, orders in another
After a Constant Contact campaign goes out, clicks live in one system and orders in another. Working out who clicked and then bought means exporting the click list, searching WooCommerce orders email by email and checking dates.
Without PopdockAI
- Export the click list from Constant Contact
- Search WooCommerce orders email by email
- Check each order date against the click date
- Build a spreadsheet nobody trusts
With PopdockAI
- Sends, opens and clicks are read for the campaign
- Orders by each clicker within the window are found by email
- Canceled, failed, refunded and earlier orders are left out
- Revenue per currency is shown as correlation, not proof
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Measure how many WooCommerce orders followed clicks on the Constant Contact campaign `{campaign-name}`, counting an order when the same email placed it within `{attribution-days}` days (default 7) after their first click.
**Step 1: Identify the campaign**
Call `constant-contact-get-campaign` with `name.contains` = `{campaign-name}`. If more than one campaign matches, list them with `name`, `status` and `last-sent-date` and stop so the user can pick. If none match, say so and stop. Note `campaign-id`, `last-sent-date`, `sends`, `opens` and `clicks`.
**Step 2: Collect the clickers**
Call `constant-contact-get-campaign-click` with `campaign-id`, `max-records` 1000. For each distinct `email-address`, keep the earliest click `created-date`. If there are no clicks, report the campaign's send and open counts, say no clicks were recorded, and stop.
**Step 3: Look for their orders**
For each clicker, call `woocommerce-get-order` with `customer-email` = the clicker's email, `created-date.from` = their first click date and `created-date.to` = that date plus the attribution window. Ignore orders whose `status` is `cancelled`, `failed` or `refunded`. If there are more than 200 clickers, check the first 200 and say the result is a sample.
**Step 4: Report**
* Campaign: name, sent date, sends, opens, clicks
* Clickers checked, clickers who ordered, conversion rate (ordered / checked)
* Attributed orders and revenue (sum of `total`, per `currency`)
* A table of attributed orders: email, `order-number`, order date, days after click, `total`, `status`
* The 5 most clicked links (`link-url`) for context
**Rules & Guidelines:**
* Tools whose names start with woocommerce- are on the woocommerce MCP server; tools whose names start with constant-contact- are on the constant-contact MCP server. If a tool from either server is missing, stop and tell the user that both servers must be connected.
* Match records by email address only: WooCommerce `email` / `customer-email` against Constant Contact `email-address`. Trim and lower-case both sides before comparing. Never match on name alone.
* This is a correlation (same email, order inside the window), not proof the email caused the order. Say so in the report.
* This prompt is read-only. Do NOT call any write tool on either server. On Constant Contact that is `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-add-contact-note`, `constant-contact-add-contact-list`, `constant-contact-update-contact-list`, `constant-contact-add-contact-tag`, `constant-contact-update-contact-tag`, `constant-contact-add-campaign`, `constant-contact-update-campaign`, `constant-contact-resend-campaign-to-non-openers`. On WooCommerce that is `woocommerce-add-coupon`, `woocommerce-update-coupon`, `woocommerce-add-order`, `woocommerce-update-order`, `woocommerce-add-order-note`, `woocommerce-add-refund`, `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-add-product`, `woocommerce-update-product`, `woocommerce-update-product-variation`, `woocommerce-send-order-details`.
**Validation:**
* An order placed before the click does not count, even on the same day: compare dates, and if only dates are available treat a same-day order as attributed and flag it.
* If a clicker has no WooCommerce orders at all, count them as not converted; do not search by name.Who it's for
One answer, three teams that use it
Email marketers
Show what a campaign earned
Get the conversion rate, attributed orders and revenue from clickers, ready for your campaign report.
What WooCommerce revenue came from clickers on the Black Friday preview campaign in Constant Contact?
Marketing managers
Compare campaigns on results
See which campaigns turn clicks into orders, measured the same way each time.
How many clickers on the Spring sale campaign ordered in WooCommerce within 14 days?
Store owners
See which links drive sales
The most clicked links show which products and offers pull people through to buy.
Which links in the New arrivals Constant Contact email got the most clicks, and did those people buy?
How it works
What PopdockAI does when you ask
You name the campaign and a window, and your AI assistant links clicks to later orders by email. It is read-only and states plainly that this is correlation, not proof.
01
Ask
You name the campaign and an attribution window.
02
Read
It reads the campaign's sends, opens and clicks.
03
Match
It finds orders placed by each clicker by email within the window after the click.
04
Report
You get conversions, revenue per currency and top links, read-only.
What PopdockAI provides
The tools behind the answer
Ready made tools for WooCommerce and one secure connection to your AI tool. No code, no exports.
constant-contact-get-campaign
constant-contact-get-campaign-click
woocommerce-get-order
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 revenue measured honestly
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)
