Connectors

/

BigCommerce

/

Find top BigCommerce customers with no open Nutshell lead
Report
Cross-Connector

Find top BigCommerce customers with no open Nutshell lead

For sales reps who want repeat buyers worked, by asking their AI assistant to compare store spend with Nutshell leads.

Try PopdockAI free
Get a live demo
Find top BigCommerce customers with no open Nutshell lead
Which of my top 10 BigCommerce customers by spend in the last 90 days have no open lead in Nutshell?
4 of your top 10 customers have no open lead in Nutshell. - Northwind Traders: 6,320.00 net spend, 7 orders, last order 14 Oct, no open lead - Contoso Ltd: 4,100.00 net spend, 5 orders, last order 9 Oct, no CRM contact - With an open lead: 6 customers Want the full list of the 4 flagged customers?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
bigcommerce-get-customer
nutshell-get-contact
nutshell-get-lead

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

Heavy buyers with no open lead mean revenue left unworked

Reps cannot see which heavy BigCommerce buyers have no active lead in Nutshell, so repeat revenue goes unworked. Ranking buyers means netting refunds out of exports, then searching Nutshell for each contact and lead.

Without PopdockAI

  • Export orders and net out refunds
  • Rank customers by spend in a sheet
  • Search Nutshell for each contact
  • Check each for an open lead

With PopdockAI

  • Net spend is totalled per customer from up to 250 orders
  • Guest orders are left out
  • Each top customer's Nutshell contact is confirmed by email and checked for an open lead
  • Flagged customers come with a reason, 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:** Find the top `{top-n}` BigCommerce customers by spend over the last `{lookback-days}` days (default 90, top 10) who have no open lead in Nutshell.

**Step 1: Read recent orders**

Call `bigcommerce-get-order` with `date-created.from` set to today minus `{lookback-days}` days and `max-records` 250. Group by `customer-id`, summing `total-including-tax` and subtracting `refunded-amount`. Ignore customer-id 0 (guest orders). Take the top `{top-n}`.

**Step 2: Identify them**

For each, call `bigcommerce-get-customer` with `id` set to the `customer-id` to get `name`, `email` and `company`.

**Step 3: Look for a CRM lead**

Call `nutshell-get-contact` with `name` set to the customer name and confirm the match by `emails`. If found, call `nutshell-get-lead` with `person-id` set to the contact `id` and `status` set to open. If the contact is missing or has no open lead, flag the customer.

**Step 4: Report**

Report the flagged customers ranked by net spend: name, company, net spend, order count, last order date, and whether the cause is "no CRM contact" or "no open lead". Also list the top customers who do have an open lead, briefly.

**Rules & Guidelines:**

* `bigcommerce-*` tools are on the bigcommerce server and `nutshell-*` tools are on the nutshell server. Both servers must be connected.
* This is read-only. Never call any add, update or delete tool on either server (for example `bigcommerce-customer-update`, `nutshell-add-person`, `nutshell-update-lead`, `nutshell-delete-company`).

**Validation:**

* If the 250 order cap was reached, say the ranking may be incomplete.
* If no orders exist in the period, say so and stop.

Who it's for

One answer, three teams that use it

Sales reps

Find repeat revenue to chase

Top buyers with no open lead are the obvious next conversations.

Which of my top 20 BigCommerce customers this quarter have no open Nutshell lead?

Sales managers

Check top accounts are being worked

Flagged customers with a reason show where the pipeline misses your best buyers.

Show top BigCommerce customers from the last 6 months with no Nutshell contact or no open lead.

Account managers

Plan expansion with real spend

Net spend after refunds gives a fair ranking of who is worth growing.

Rank my top 10 BigCommerce customers by net spend this year and show their Nutshell lead status.

How it works

What PopdockAI does when you ask

You say how many top customers and how far back, and your AI assistant finds BigCommerce buyers with no open Nutshell lead. It warns when the order cap may affect the ranking.

01

Ask

You say how many top customers to find and how far back to look.

Your AI tool

02

Rank

It totals net BigCommerce spend per customer, after refunds and without guest orders.

bigcommerce-get-order
bigcommerce-get-customer

03

Check

It finds each in Nutshell by name, confirms by email and looks for an open lead.

nutshell-get-contact
nutshell-get-lead

04

Report

It lists flagged customers by net spend with the reason, then briefly lists those with a lead.

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

nutshell-get-contact

Returns Nutshell people (contacts) with their emails, phones and linked companies. Filter by name, email, owner and other fields.
get-data

nutshell-get-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
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

Heavy buyers with no open lead, ready to work

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