/
/
Check whether won Nutshell leads ordered on BigCommerce
For sales leaders who want won Nutshell leads checked for BigCommerce orders by asking their AI assistant.
On this page
Connector
Connect Nutshell, pick your AI tool and paste the prompt.
The problem
Won deals, but did they ever buy
Managers cannot tell whether deals won in Nutshell became real store revenue without matching leads to customers by hand. It means reading each lead, finding the email, searching BigCommerce and adding up orders.
Without PopdockAI
- List won leads in Nutshell
- Find the email of the person on each
- Search BigCommerce for the customer
- Add up orders since each win
With PopdockAI
- Won leads are listed and the first person read
- The BigCommerce customer is found by email, then company name
- Orders since the close date are summed
- Leads are grouped as ordered, no order yet or not in store
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Nutshell leads won in the last `{lookback-days}` days (default 60), check whether the customer has placed a BigCommerce order since the win, up to `{max-leads}` leads (default 20).
**Step 1: List won leads**
Call `nutshell-get-lead` with `status` set to won, `closed-time.from` set to today minus `{lookback-days}` days and `max-records` set to `{max-leads}`. Keep `id`, `name`, `value`, `closed-time`, `people` and `companies`.
**Step 2: Find the store customer**
For each lead, take the first person in `people`, call `nutshell-get-contact` with `id` set to that person to read `name` and `emails`. Then call `bigcommerce-get-customer` with `email` set to the first email. If nothing matches, try `company.contains` using the company name. If still nothing, mark the lead "not in store".
**Step 3: Look for orders**
Call `bigcommerce-get-order` with `customer-id` set to the customer `id` and `date-created.from` set to the lead `closed-time`. Sum `total-including-tax`.
**Step 4: Report**
Report a table: lead, won value, close date, store customer, orders since close, order total. Group into "ordered", "no order yet" and "not in store". End with the counts.
**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 won-lead status value is rejected, call `nutshell-get-lead` without the status filter and keep leads whose `status` reads won.
* A different currency on the lead and the order means the totals are not comparable; say so.Who it's for
One answer, three teams that use it
Sales leaders
Check wins turn into revenue
See which won deals placed orders, so pipeline wins are backed by real sales.
Did the Nutshell leads we won last quarter order on BigCommerce?
Account managers
Follow up wins that never ordered
Leads with no order yet are listed, so you can help the customer get started.
Which Nutshell leads won in the last 30 days have no BigCommerce orders yet?
Revenue operations
Find won customers not in the store
Leads with no matching store customer show where onboarding or data is missing.
Which won Nutshell leads from the last 90 days are not BigCommerce customers?
How it works
What PopdockAI does when you ask
You give a lookback period and a lead limit, and your AI assistant matches won Nutshell leads to BigCommerce orders. Currency mismatches are flagged, and nothing is changed.
01
Ask
You give a lookback period and a maximum number of leads.
02
Read
It lists won Nutshell leads and reads the first person on each.
03
Match
It finds the BigCommerce customer by email, then company name, and sums orders since the win.
04
Report
It groups leads as ordered, no order yet or not in store, with counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for Nutshell and one secure connection to your AI tool. No code, no exports.
nutshell-get-lead
nutshell-get-contact
bigcommerce-get-customer
bigcommerce-get-order
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
See which wins became store revenue
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)
