Connectors

/

Attio

/

Compare Attio deals with BigCommerce orders
Report
Cross-Connector

Compare Attio deal value with BigCommerce revenue

For finance teams who ask their AI assistant whether an account's Attio deals line up with what its customers ordered in BigCommerce.

Try PopdockAI free
Get a live demo
Compare Attio deals with BigCommerce orders
Compare the Attio deals for Northwind Traders with what they have ordered in BigCommerce over the last 6 months.
Northwind Traders has 48,000 in won deals in Attio and 31,500 in BigCommerce orders over 180 days. - Deals: 2 won, 1 open (Renewal 2026, stage Negotiation) - Customers: 3 found, 2 by company field and 1 by email - Orders: 14 orders, all in USD - Note: the open deal belongs to a company that is already ordering Want the same comparison for another account?
Attio
Sample figures. Your results come from your own account.
attio-get-record-companies
attio-get-record-deals
bigcommerce-get-customer
attio-get-record-people
bigcommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Attio

Attio
Run it on your own Attio data.

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

Try PopdockAI free

The problem

Pipeline value and store revenue never get compared

Checking pipeline against real revenue means exporting Attio deals and BigCommerce orders and comparing them by hand. Customers must be found by company field or by each contact's email, and the two measures are easy to compare wrongly.

Without PopdockAI

  • Export the company's deals from Attio
  • Search BigCommerce by company name and by each contact email
  • Remove duplicate customers and total their orders
  • Compare figures in different currencies

With PopdockAI

  • The company and its deals are found in Attio
  • BigCommerce customers are found by company and contact email, without duplicates
  • Won deal value is compared with store revenue
  • Currency differences are flagged, not converted

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 the company `{company-name}`, compare the deals recorded in Attio with the orders placed in BigCommerce by customers of that company, over the last `{lookback-days}` days (default 180).

Servers: `attio-*` tools are on the attio server, `bigcommerce-*` tools are on the bigcommerce server. Both must be connected.

**Step 1: Find the company and its deals (attio)**

Call `attio-get-record-companies` with `name` = `{company-name}`. If there is more than one match, list them and stop. Then call `attio-get-record-deals` with `associated-company` = the company name. Keep `deal-name`, `deal-stage`, `deal-value`, `created-at`.

**Step 2: Find the store customers (bigcommerce)**

Call `bigcommerce-get-customer` with `company` = `{company-name}`. Also call `attio-get-record-people` with `company` = `{company-name}` and, for each person with an email, call `bigcommerce-get-customer` with that `email`. Combine the results and remove duplicates by customer `id`.

**Step 3: Find their orders (bigcommerce)**

For each customer call `bigcommerce-get-order` with `customer-id` and `date-created.from` set to today minus the look-back. Sum `total-including-tax` and count orders.

**Step 4: Report**

Show deals (with stage and value), customers found and how each was matched (company field or email), orders and revenue. Then state: total won deal value vs total store revenue, and any open deal for a company that is already ordering, or any lost deal for a company that kept ordering.

**Rules & Guidelines:**

* Read-only. Do not call `attio-update-deal`, `attio-add-deal`, `attio-delete-deal` or any write tool on either server.
* Treat deal value and order total as different measures; compare, do not reconcile to zero.

**Validation:**

* If no store customers match, say the company has no store activity and stop after Step 1.
* Mention any currency mismatch you can see (`currency-code` on orders against the deal value) instead of converting.

Who it's for

One answer, three teams that use it

Finance analysts

Check deal value against what customers spend

See won deal value beside order totals for an account, with the matching method stated so you can trust the figure.

Compare Contoso's won Attio deals with their BigCommerce order totals for the last 12 months.

Account managers

Spot customers ordering without a deal

Lost deals for companies that kept ordering, and open deals for companies already buying, are called out.

Does Fabrikam have open Attio deals while already ordering in BigCommerce?

Sales leaders

Test pipeline against revenue

See whether an account's deals translate into store revenue before you plan the next quarter.

Show Attio deal value against BigCommerce revenue for Northwind Traders this year.

How it works

What PopdockAI does when you ask

You name a company and your AI assistant compares its Attio deals with its BigCommerce orders. It shows how each customer was matched and changes nothing.

01

Ask

You name the company and, optionally, a lookback period.

Your AI tool

02

Deals

It finds the company and its deals in Attio.

attio-get-record-companies
attio-get-record-deals

03

Orders

It finds BigCommerce customers by company and by contact email, then totals their orders.

attio-get-record-people
bigcommerce-get-customer
bigcommerce-get-order

04

Report

You get won deal value against store revenue, plus open and lost deal mismatches.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Attio and one secure connection to your AI tool. No code, no exports.

get-data

attio-get-record-companies

Returns companies from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-deals

Returns deals from Attio CRM. Read-only; filter by the fields the tool offers.
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

attio-get-record-people

Returns people from Attio CRM. Read-only; filter by the fields the tool offers.
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 Attio 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

Pipeline value next to real 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