Connectors

/

Drip

/

Find unsubscribed Drip people still buying in BigCommerce
Report
Cross-Connector

Find unsubscribed Drip people who are still buying in BigCommerce

For marketing teams who must respect opt-outs, by asking their AI assistant to compare Drip with store orders.

Try PopdockAI free
Get a live demo
Find unsubscribed Drip people still buying in BigCommerce
Which people who unsubscribed in Drip have placed a BigCommerce order in the last 90 days?
6 of the 50 unsubscribed people have ordered from BigCommerce in the last 90 days. - Dana Whitfield (dana@northwindtraders.com): 3 orders, 410.00, latest 12 Oct - Sam Patel (sam@contoso.com): 1 order, 89.00, latest 2 Oct - No BigCommerce customer: 31 - No recent orders: 13 These people must not be re-subscribed without consent. Want the full list of 6?
Drip
Sample figures. Your results come from your own account.
drip-get-subscriber
bigcommerce-get-customer
bigcommerce-get-order
bigcommerce-get-subscriber
drip-get-campaign-subscriber

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

Opted out buyers look like any other customer

People who unsubscribed in Drip can still be emailed from other tools because nobody checks them against store orders. A recent buyer who opted out looks like anyone else in BigCommerce.

Without PopdockAI

  • Export unsubscribed people from Drip
  • Search BigCommerce for each email
  • Read their recent orders
  • Other tools keep emailing them

With PopdockAI

  • Unsubscribed Drip people are read
  • Each is found in BigCommerce by email with recent orders
  • Recent buyers are listed with order count and spend
  • Read-only, never suggests re-subscribing anyone

The prompt

Use this prompt

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

Prompt
**Objective:** Find people whose Drip status is `unsubscribed` and who have placed a BigCommerce order in the last `{lookback-days}` days (default 90), so marketing can respect their choice and service messages go through the right channel.

**Step 1: List unsubscribed people**

Call `drip-get-subscriber` (drip server) with `status` set to `unsubscribed` and `max-records` set to `{max-people}` (default 50). Keep `email`, name and `created-date`.

**Step 2: Find them in BigCommerce**

For each email call `bigcommerce-get-customer` (bigcommerce server) with `email`. Skip people with no BigCommerce customer.

**Step 3: Check recent orders**

Call `bigcommerce-get-order` (bigcommerce server) with `customer-id` and `date-created.from` set to the start of the window. Keep order count, total `total-including-tax` and latest `date-created`.

**Step 4: Report**

A table of unsubscribed people with recent orders: name, email, orders, spend, latest order date. Add the number of unsubscribed people checked and how many had no BigCommerce customer or no recent orders. End with one line reminding the reader these people must not be re-subscribed without consent.

**Rules & Guidelines:**

* `bigcommerce-get-customer`, `bigcommerce-get-order`, `bigcommerce-get-subscriber` are on the bigcommerce server. `drip-get-subscriber`, `drip-get-campaign-subscriber` are on the drip server.
* This prompt only reads. Never call any `bigcommerce-customer-add`, `bigcommerce-customer-update`, `bigcommerce-subscriber-add` or other bigcommerce add, update or delete tool, and never call `drip-add-subscriber`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-remove-subscriber-tag`, `drip-unsubscribe-subscriber` or any other Drip write tool.
* Match people across the two systems on email address, compared case-insensitively after trimming spaces. Drip `person-id` and BigCommerce `id` are unrelated and must not be compared.
* If the user supplied a Drip account, pass it as `company` on every Drip call; otherwise omit `company`.

**Validation:**

* If Drip returns nobody unsubscribed, say so and stop.
* Do not suggest re-subscribing anyone.

Who it's for

One answer, three teams that use it

Email marketers

Keep opted out buyers out of promotions

See which recent buyers have unsubscribed so other tools do not market to them.

Which unsubscribed Drip people ordered from BigCommerce in the last 30 days?

Customer service managers

Use the right channel for order messages

Know which buyers opted out so service messages go through the right channel.

List opted out Drip contacts with BigCommerce orders this quarter, with their latest order date.

Compliance leads

Check that consent is honored

Get counts of unsubscribed people with and without store activity as a consent check.

Check 500 unsubscribed Drip people against BigCommerce orders from the last 6 months.

How it works

What PopdockAI does when you ask

You set a lookback and how many to check, and your AI assistant finds opted out people who still buy. It only reads and stops if nobody is unsubscribed.

01

Ask

You say how far back to look and how many unsubscribed people to check.

Your AI tool

02

Read

It reads people in Drip with an unsubscribed status.

drip-get-subscriber

03

Match

It finds each in BigCommerce by email and reads their recent orders.

bigcommerce-get-customer
bigcommerce-get-order

04

Report

It lists those with recent orders, with counts, and reminds you not to re-subscribe without consent.

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-subscriber

Returns Drip people (subscribers) with name, email, location, tags, status, GDPR consent, lead score and lifetime value. Filter by exact email, email domain, tag, status, country, minimum lead score, minimum lifetime value or date added.
get-data

bigcommerce-get-customer

Returns customers from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

bigcommerce-get-subscriber

Returns subscribers from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
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.
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

Respect opt outs from people who still buy

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