Connectors

/

Nutshell

/

Check won Nutshell leads against BigCommerce orders
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check won Nutshell leads against BigCommerce orders
Did the Nutshell leads we won in the last 60 days place any BigCommerce orders?
Of 12 won leads, 7 have ordered, 3 have not ordered yet and 2 are not in the store. - Ordered: Northwind Traders, won 8,000, 3 orders since close, 6,420.00 - Ordered: Contoso, won 3,500, 1 order since close, 3,210.00 - No order yet: Fabrikam, won 5,000, closed 20 days ago - Not in store: Adventure Works Want the full table of all 12 leads?
Nutshell
Sample figures. Your results come from your own account.
nutshell-get-lead
nutshell-get-contact
bigcommerce-get-customer
bigcommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Nutshell

Nutshell
Run it on your own Nutshell data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Read

It lists won Nutshell leads and reads the first person on each.

nutshell-get-lead
nutshell-get-contact

03

Match

It finds the BigCommerce customer by email, then company name, and sums orders since the win.

bigcommerce-get-customer
bigcommerce-get-order

04

Report

It groups leads as ordered, no order yet or not in store, with counts.

Your AI tool

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.

get-data

nutshell-get-lead

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

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.
Read only.Nothing in Nutshell 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

See which wins became store revenue

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