/
/
Find top BigCommerce customers who are not engaged in Drip
For account teams who want top spenders engaged, by asking their AI assistant to check each in Drip.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Disengaged big customers go unnoticed
Account teams rank top spenders from BigCommerce exports and check each one in Drip by hand. Disengaged big customers go unnoticed because nobody looks up their status, lead score and campaigns.
Without PopdockAI
- Export orders and total spend per customer
- Remove guest orders by hand
- Look up each top customer in Drip
- Note status, lead score and campaigns one by one
With PopdockAI
- Spend is totalled per customer, leaving out guest orders
- The top customers are looked up in Drip by email
- Status, lead score and active campaigns are shown
- Each is marked not in Drip, not active, no campaigns or engaged
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Rank the top `{top-n}` customers by spend over the last `{lookback-days}` days (default 365; top-n defaults to 20) and show how each one is engaged in Drip.
**Step 1: Get orders and rank**
Call `bigcommerce-get-order` (bigcommerce server) with `date-created.from` set to the start of the window. Total `total-including-tax` by `customer-id`, ignore guest orders (`customer-id` 0), and keep the top `{top-n}`.
**Step 2: Get customer details**
Call `bigcommerce-get-customer` (bigcommerce server) with `id` for each. Keep `email`, name and `company`.
**Step 3: Look each one up in Drip**
Call `drip-get-subscriber` (drip server) with `email`. Keep `status`, `lead-score`, `tags`, `lifetime-value`. Then call `drip-get-campaign-subscriber` (drip server) with `email` and count campaigns with a `campaign-status` of active.
**Step 4: Report**
A ranked table: rank, name, email, orders, spend, Drip status, lead score, active campaigns. Mark each row Not in Drip, Not active, No campaigns or Engaged. Finish with the counts of each mark.
**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 there are no orders in the window, say so and stop.
* A customer with no email is shown with Drip columns marked Unknown.
Who it's for
One answer, three teams that use it
Account managers
Re-engage your biggest buyers
Top spenders who are not active or in no campaign are the ones to call.
Which of my top 15 BigCommerce customers this year are not active in Drip?
Lifecycle marketers
Put VIPs in the right campaigns
Top customers with no active campaign show where your VIP program has gaps.
Rank our top 25 BigCommerce customers by spend and show which have no active Drip campaigns.
Sales managers
Use lead score to prioritise
Lead score beside spend helps you decide who gets attention first.
Show my top 10 BigCommerce customers from the last 6 months with their Drip lead score.
How it works
What PopdockAI does when you ask
You say how many top customers and how far back, and your AI assistant ranks BigCommerce spenders and checks their Drip engagement. It only reads.
01
Ask
You say how many top customers to rank and how far back to look.
02
Rank
It totals BigCommerce spend by customer, leaving out guest orders.
03
Look up
It finds each in Drip by email and reads status, lead score and active campaigns.
04
Report
It shows a ranked table marked not in Drip, not active, no campaigns or engaged.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-get-order
bigcommerce-get-customer
drip-get-subscriber
drip-get-campaign-subscriber
bigcommerce-get-subscriber
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
Top spenders who have gone quiet in Drip
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)
