Connectors

/

Drip

/

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

See which Drip campaign subscribers bought in Shopify

For ecommerce marketers who want to know how many people in a Drip series ordered in Shopify, stated honestly, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check which Drip campaign subscribers bought in Shopify
How many subscribers in our Drip Spring Launch campaign have ordered in Shopify since March 1?
Of 100 Spring Launch subscribers checked, 23 ordered in Shopify since 2026-03-01. - Conversion: 23 percent - Revenue: 4,870 USD and 610 CAD - Top buyer: Dana Whitfield, 3 orders, 640 USD - Note: orders show overlap, not proof the campaign caused them Want the table of buyers?
Drip
Sample figures. Your results come from your own account.
drip-get-campaign
drip-get-campaign-subscriber
shopify-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

Nobody can say whether a Drip series led to Shopify orders

Drip and Shopify do not share a view of who bought after an email series. Exporting subscribers and searching orders for each email, minus voided and cancelled ones, is slow, so most teams guess.

Without PopdockAI

  • Export the campaign's subscribers from Drip
  • Search Shopify orders for each email
  • Strip out voided and cancelled orders
  • Total revenue without mixing currencies

With PopdockAI

  • The campaign is found and its subscribers read
  • Each email is checked for Shopify orders since your date
  • Voided and cancelled orders are ignored
  • Results are framed as overlap, not proof of cause

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Show how many subscribers of the Drip campaign named `{campaign-name}` placed Shopify orders on or after `{since-date}` (default 30 days ago), and the revenue from those orders.

**Step 1: Find the campaign**

Call `drip-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one matches, list them with name, status and campaign-id and stop. If none match, say so and stop.

**Step 2: List its subscribers**

Call `drip-get-campaign-subscriber` with `campaign-id` set to the campaign-id from Step 1 and `max-records` set to 100. Keep each subscriber's email, first-name, last-name and status.

**Step 3: Check Shopify orders for each subscriber**

For each subscriber, call `shopify-get-order` with `email` set to the subscriber's email and `created-at.from` set to `{since-date}` (or 30 days before today, YYYY-MM-DD). Ignore orders whose financial-status is voided or whose cancelled-at is set. Sum total-price per subscriber, noting the currency.

**Step 4: Report**

* Campaign name, status and the date window used.
* Subscribers checked, subscribers who ordered, conversion rate as a percentage.
* Total revenue, by currency if more than one.
* A table of the buyers: email, orders, revenue, most recent order name.

**Rules & Guidelines:**

* `drip-get-campaign` and `drip-get-campaign-subscriber` are on the drip server; `shopify-get-order` is on the shopify server.
* This prompt is read-only. Do NOT call `drip-pause-campaign`, `drip-activate-campaign`, `drip-remove-subscriber-from-campaign` or `shopify-update-order`.
* An order is evidence of overlap, not proof the campaign caused it. Say so in the report.

**Validation:**

* If the campaign has no subscribers, say so and stop.
* If Drip returned exactly 100 subscribers, say the results cover only the first 100.
* Shopify order lookup by email is exact; if a subscriber has no orders, also try their email in lowercase before counting them as a non-buyer.

Who it's for

One answer, three teams that use it

Marketing analysts

Measure campaign overlap with real orders

Get the conversion rate and revenue by currency for a Drip series, stated as overlap rather than attribution.

What share of our Drip Welcome Series subscribers ordered in Shopify since September 1?

Ecommerce managers

See what campaign subscribers spent

Know how many subscribers became buyers and what they spent, without exporting orders into a spreadsheet.

Show Shopify revenue from subscribers in the Drip Back in Stock campaign since August 15.

Lifecycle marketers

Compare series by buyer overlap

Check each email series against orders to see which ones overlap with purchases and which do not.

How many people in the Drip Cart Reminder campaign placed a Shopify order since October 1?

How it works

What PopdockAI does when you ask

You name a Drip campaign and a start date, and your AI assistant checks Shopify orders for its subscribers. Nothing is changed in either system.

01

Ask

You name the Drip campaign and a start date.

Your AI tool

02

List

It finds the campaign and reads up to 100 subscribers.

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

03

Check

It looks up Shopify orders for each email, ignoring voided and cancelled ones.

shopify-get-order

04

Report

You get buyers, conversion rate and revenue, framed as overlap.

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

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
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

An honest view of who bought after the campaign

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