Connectors

/

Constant Contact

/

Constant Contact and WooCommerce customer profile by email
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Constant Contact and WooCommerce customer profile by email
Build a profile of alex.morgan@northwindtraders.com from WooCommerce and Constant Contact.
Alex Morgan is a loyal buyer who has stopped reading email. - Orders: 9 in 180 days, 1,860 USD - Refunds: 1, 45 USD - Top product: Ceramic Pour-Over Set - Email: no opens since July Want the order list?
Constant Contact
Sample figures. Your results come from your own account.
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

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

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.

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

Your AI tool

02

Shop

It reads WooCommerce orders, spend per currency, refunds and top products.

woocommerce-get-customer
woocommerce-get-order
woocommerce-get-refund
woocommerce-get-order-line

03

Email

It reads Constant Contact permission, lists, tags and engagement.

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

04

Report

You get one profile and a short read, with nothing changed.

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

woocommerce-get-customer

Returns WooCommerce customer accounts with name, billing address, role and whether they have paid for an order. Filter by email, id, last name, billing country or state, role and created date range.
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.
get-data

woocommerce-get-refund

Returns WooCommerce refunds with amount, reason, who made them and whether the gateway returned the money. Filter by order, customer, amount range and date range.
get-data

woocommerce-get-order-line

Returns the product lines on WooCommerce orders: product, SKU, quantity, price, line total and tax. Filter by order, customer, SKU or product id, order status and date range.
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

constant-contact-get-contact-list-member

Returns the members of Constant Contact contact lists with their email permission. Filter by list name or ID, contact, email address and permission.
get-data

constant-contact-get-contact-activity

Returns a Constant Contact contact's email activity timeline, such as opens, clicks and bounces. Filter by contact, email address, campaign activity, activity type and date.
get-data

constant-contact-get-campaign-bounce

Returns Constant Contact campaign bounces with the bounce type. Filter by campaign, campaign activity, contact, email address or domain, bounce type and date.
get-data

constant-contact-get-campaign-unsubscribe

Returns Constant Contact campaign unsubscribes with the reason given. Filter by campaign, campaign activity, contact, email address or domain, reason and 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

One read on a shopper's buying and email habits

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