/
/
See what Drip campaign members bought in WooCommerce
For ecommerce teams who want an honest read of WooCommerce purchases by a Drip campaign's members, by asking their AI assistant.
On this page
Connector
Connect Drip, pick your AI tool and paste the prompt.
The problem
Drip campaign results stop at the inbox, not the store
Knowing whether Drip series members bought in WooCommerce means searching orders for every email and removing cancelled and refunded ones. It is slow, and the answer is easy to overstate.
Without PopdockAI
- Export campaign members from Drip
- Search WooCommerce orders for every email
- Remove cancelled, failed and refunded orders
- Total sales without mixing currencies
With PopdockAI
- The campaign is found and its members read
- Orders are read from the right start date
- Cancelled, failed and refunded orders are left out
- Revenue is totaled per currency and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Measure WooCommerce purchases made in the last `{lookback-days}` days (default 30) by the people in the Drip campaign matching `{campaign-name}`.
**Step 1: Find the Drip campaign**
Call `drip-get-campaign` with `name.contains` set to `{campaign-name}`. If none or several match, list them and stop. Note the campaign-id, status, created date and active subscriber count.
**Step 2: List its members**
Call `drip-get-campaign-subscriber` with `campaign-id` set to the campaign's id and `max-records` set to 500. Note each member's email and campaign status.
**Step 3: Read their orders**
Use as the start date whichever is later: the campaign's created date or today minus `{lookback-days}` days. For each member, call `woocommerce-get-order` with `customer-email` set to their email and `created-date.from` set to that date. If there are more than 100 members, check the first 100 and say so.
**Step 4: Report**
- Campaign: name, status, start date used, members checked
- Buyers: how many members ordered, as a count and a percentage of members checked
- Revenue: order count and total per currency, excluding cancelled, failed and refunded orders
- Top 10 buyers by total spent, with order count
- Members who left: buyers whose campaign status is no longer active
**Rules & Guidelines:**
* Tools whose names start with drip- are on the drip server; tools whose names start with woocommerce- are on the woocommerce server. Both servers must be connected.
* Match people across the two systems by email, compared case-insensitively with surrounding spaces removed. Drip uses `email`; WooCommerce uses `email` on customers and `customer-email` on orders, order lines and refunds.
* Compute dates as today minus the stated number of days and pass them as YYYY-MM-DD.
* This prompt is read-only. Do not call any write tool on either server, including `drip-add-subscriber`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-remove-subscriber-tag`, `drip-add-subscriber-to-campaign`, `drip-unsubscribe-subscriber`, `woocommerce-update-customer`, `woocommerce-update-order`, `woocommerce-add-order-note` or `woocommerce-add-refund`.
* Present the result as purchases by campaign members, not as revenue caused by the campaign; this data cannot show causation.
**Validation:**
* If the campaign has no members, say so and stop.
* If no member ordered in the period, report zero buyers rather than stopping.
* Never add amounts in different currencies together; total each currency separately.Who it's for
One answer, three teams that use it
Marketing analysts
Report purchases by campaign members
Get buyers as a count and percentage with revenue per currency, presented as purchases by members.
How much did members of our Drip Spring Sale campaign spend in WooCommerce in the last 90 days?
Store owners
See who your best campaign buyers are
The top 10 buyers from a campaign are listed, so you know who responds to which series.
Who are the top buyers in WooCommerce from our Drip VIP Early Access campaign over 30 days?
Email marketers
Check a series before you rerun it
See what members bought before deciding whether a campaign deserves another send.
Did members of the Drip Black Friday Preview campaign buy anything in WooCommerce over the last 45 days?
How it works
What PopdockAI does when you ask
You name a Drip campaign and a lookback, and your AI assistant reads its members' WooCommerce orders. The report changes nothing and avoids claiming cause.
01
Ask
You name the Drip campaign and a lookback period.
02
List
It finds the campaign and reads its members.
03
Read
It reads their WooCommerce orders, leaving out cancelled, failed and refunded ones.
04
Report
You get buyers, revenue per currency and the top 10 buyers.
What PopdockAI provides
The tools behind the answer
Ready made tools for Drip and one secure connection to your AI tool. No code, no exports.
drip-get-campaign
drip-get-campaign-subscriber
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
What campaign members bought, without overstating it
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)
