Connectors

/

BigCommerce

/

Find top BigCommerce customers not engaged in Drip
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find top BigCommerce customers not engaged in Drip
Rank my top 20 BigCommerce customers by spend over the last year and show how engaged each is in Drip.
Of your top 20 customers, 7 are engaged in Drip and 13 need attention. - Rank 1: Northwind Traders, 14,200.00 spend, 11 orders, lead score 82, 3 active campaigns, engaged - Rank 4: Contoso Ltd, 9,850.00 spend, 8 orders, not in Drip - Not in Drip: 5, not active: 3, no campaigns: 4 - Unknown (no email): 1 Want the full ranked table of all 20?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
bigcommerce-get-customer
drip-get-subscriber
drip-get-campaign-subscriber
bigcommerce-get-subscriber

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Rank

It totals BigCommerce spend by customer, leaving out guest orders.

bigcommerce-get-order
bigcommerce-get-customer

03

Look up

It finds each in Drip by email and reads status, lead score and active campaigns.

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

04

Report

It shows a ranked table marked not in Drip, not active, no campaigns or engaged.

Your AI tool

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.

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

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

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

bigcommerce-get-subscriber

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

Top spenders who have gone quiet in Drip

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