Connectors

/

WooCommerce

/

Attribute WooCommerce orders to a Constant Contact campaign
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Attribute WooCommerce orders to a Constant Contact campaign
How many WooCommerce orders came from our October flash sale campaign in Constant Contact?
18 of 640 clickers on October flash sale placed a WooCommerce order within 7 days, a 2.8 percent conversion rate. - Revenue: 2,940.00 USD from 21 attributed orders - Top link: Shop the sale, 412 clicks - Excluded: 3 refunded or canceled orders - Caution: this shows correlation, not proof the email caused the sale Want the attributed orders listed?
WooCommerce
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
woocommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

WooCommerce

WooCommerce
Run it on your own WooCommerce data.

Connect WooCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Read

It reads the campaign's sends, opens and clicks.

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

03

Match

It finds orders placed by each clicker by email within the window after the click.

woocommerce-get-order

04

Report

You get conversions, revenue per currency and top links, read-only.

Your AI tool

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.

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

woocommerce-get-order

Returns WooCommerce orders with status, totals, discounts, shipping, payment method and paid date. Filter by status, customer email or id, order number, created date range, total range or billing last name.
Read only.Nothing in WooCommerce 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 revenue measured honestly

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