/
/
Understand a shopper's buying and email habits in one read
For marketers who want WooCommerce orders and Constant Contact engagement for one shopper, by asking their AI assistant.
On this page
Connector
Connect Constant Contact, pick your AI tool and paste the prompt.
The problem
Buying and email habits live in different tabs
Understanding one shopper means WooCommerce orders and refunds in one tab and Constant Contact lists, opens and bounces in another. Without both side by side you cannot tell a loyal buyer who stopped reading from a keen clicker who stopped buying.
Without PopdockAI
- Open the WooCommerce orders and refunds
- Work out spend and top products by hand
- Search Constant Contact for engagement
- Guess how the two connect
With PopdockAI
- Orders, spend per currency, refunds and top products are read
- Guest buyers are found through their orders
- Constant Contact permission and engagement are added
- Different names are both shown, and nothing changes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a single profile of the shopper with email `{email}`, combining what they bought in WooCommerce with how they engage with email in Constant Contact, looking back `{lookback-days}` days (default 180).
**Step 1: Find the shopper in WooCommerce**
Call `woocommerce-get-customer` with `email` = `{email}`. Note `customer-id`, name, `billing-city`, `billing-state`, `billing-country`, `paying-customer` and `created-date`. If no customer comes back, they may still have ordered as a guest, so continue.
**Step 2: Their orders and refunds**
Call `woocommerce-get-order` with `customer-email` = `{email}` and `created-date.from` set to today minus the lookback. Record order count, total spend (sum of `total`, per `currency`), first and last order date, and statuses. Call `woocommerce-get-refund` with `customer-email` = `{email}` over the same window and record refund count and amount. For the top products, call `woocommerce-get-order-line` with `customer-email` = `{email}` and group by `line-name`.
**Step 3: Find them in Constant Contact**
Call `constant-contact-get-contact` with `email-address` = `{email}`. Note `contact-id`, `permission-to-send`, `tags` and `created-date`. If no contact comes back, report the shopper as "not in Constant Contact", skip Step 4, and go to the report.
**Step 4: Their email engagement**
Using that `contact-id`, call `constant-contact-get-contact-list-member` (list memberships), `constant-contact-get-contact-activity` with `created-date.from` set to today minus the lookback, and `constant-contact-get-campaign-bounce` and `constant-contact-get-campaign-unsubscribe` filtered by `contact-id`. Count sends, opens and clicks from the activity, using `activity-type`.
**Step 5: Report**
* **Shopper:** name, email, WooCommerce customer id (or "guest"), Constant Contact contact id (or "not in Constant Contact")
* **Purchases:** orders, spend, refunds, first and last order date, top 5 products
* **Email:** permission to send, lists, tags, sends / opens / clicks, any bounce or unsubscribe with its date and reason
* **Read:** two or three sentences connecting the two, for example a frequent buyer who never opens email, or a heavy clicker who has not ordered since a given date
**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 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:**
* If neither server has a record for `{email}`, say so and stop.
* If the WooCommerce customer and the Constant Contact contact have different names, show both rather than picking one.
* Report money in the order's own `currency`; do not convert.Who it's for
One answer, three teams that use it
Email marketers
Target offers to real behavior
Top products next to email clicks show what to put in front of each shopper.
What does sam@contoso.com buy on WooCommerce, and which of our emails does he click?
Customer support agents
Handle calls with the full history
Orders, refunds and email standing in one profile make support calls shorter.
Pull WooCommerce orders and refunds plus Constant Contact status for priya@fabrikam.com.
Ecommerce managers
Spot loyal buyers going quiet
A regular buyer who stopped opening email is easy to see before they stop ordering.
Is dana@northwindtraders.com still opening our emails, and when did she last order on WooCommerce?
How it works
What PopdockAI does when you ask
You give an email address and your AI assistant combines WooCommerce buying with Constant Contact engagement. It only reads.
01
Ask
You give an email address and a lookback, 180 days by default.
02
Shop
It reads WooCommerce orders, spend per currency, refunds and top products.
03
It reads Constant Contact permission, lists, tags and engagement.
04
Report
You get one profile and a short read, with nothing changed.
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.
woocommerce-get-customer
woocommerce-get-order
woocommerce-get-refund
woocommerce-get-order-line
constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity
constant-contact-get-campaign-bounce
constant-contact-get-campaign-unsubscribe
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
One read on a shopper's buying and email habits
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)
