Connectors

/

Drip

/

Check which Drip campaign subscribers bought in WooCommerce
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check which Drip campaign subscribers bought in WooCommerce
What have members of our Drip Holiday Gift Guide campaign bought in WooCommerce over the last 60 days?
41 of 380 Holiday Gift Guide members bought in WooCommerce, 11 percent. - Revenue: 6,215 USD and 940 EUR - Top buyer: Jordan Lee, 4 orders, 520 USD - Since left: 6 buyers have left the campaign - Note: these are purchases by members, not revenue the campaign caused Want the top 10 buyers?
Drip
Sample figures. Your results come from your own account.
drip-get-campaign
drip-get-campaign-subscriber
woocommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Drip

Drip
Run it on your own Drip data.

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

Try PopdockAI free

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.

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

Your AI tool

02

List

It finds the campaign and reads its members.

drip-get-campaign
drip-get-campaign-subscriber

03

Read

It reads their WooCommerce orders, leaving out cancelled, failed and refunded ones.

woocommerce-get-order

04

Report

You get buyers, revenue per currency and the top 10 buyers.

Your AI tool

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.

get-data

drip-get-campaign

Returns Drip email series campaigns with status, active and unsubscribed counts, number of emails, sender and opt-in settings. Filter by name, status, minimum active subscribers or created date.
get-data

drip-get-campaign-subscriber

Returns the people subscribed to each Drip email series campaign, with the campaign's status and the person's tags and lead score. Filter by campaign id or name, a person's email, subscriber status or minimum lead score.
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 Drip 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

What campaign members bought, without overstating it

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