/
/
See a buyer's BigCommerce orders and Mailchimp engagement
For marketing teams who want a buyer's purchases and Mailchimp engagement in one answer, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
You cannot tell if your buyers actually read your email
Checking whether a buyer opens your email means searching BigCommerce for orders and Mailchimp for the audience record, then matching by hand. Unsubscribed buyers, or buyers who never open anything, slip through.
Without PopdockAI
- Total a customer's orders in BigCommerce
- Search each Mailchimp audience for the email
- Read open and click rates on the member record
- Miss that a regular buyer has unsubscribed
With PopdockAI
- Orders and spend are totalled from BigCommerce
- Each Mailchimp audience shows status, rating, opens, clicks and tags
- Campaign activity in the window and attributed orders are counted
- Unsubscribed buyers who still order are flagged, 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.
**Objective:** Build a combined purchase and email-engagement profile for the customer with email `{email}`, looking back `{lookback-days}` days (default 180).
**Step 1: Find the customer in BigCommerce**
Call `bigcommerce-get-customer` (bigcommerce server) with `email` set to `{email}`. If nothing matches, report that the customer is not in BigCommerce and continue with Step 3 only. Keep `id`, `name`, `company` and `date-created`.
**Step 2: Get their orders**
Call `bigcommerce-get-order` (bigcommerce server) with `customer-id` set to the customer id and `date-created.from` set to the start of the window. Total the order count and `total-including-tax`, and note the latest `date-created`.
**Step 3: Find them in Mailchimp**
Call `mailchimp-get-list-member` (mailchimp server) with `email` set to `{email}`. List each audience (`list-name`) with `status`, `vip`, `rating`, `average-open-rate`, `average-click-rate` and `tags`. If nothing matches, report the person as present in BigCommerce and absent from Mailchimp.
**Step 4: Get campaign activity**
Call `mailchimp-get-campaign-email-activity` (mailchimp server) with `email-address` set to `{email}` and `activity-date.from` set to the start of the window. Count activity by `action` and note the latest `activity-date`. Also call `mailchimp-get-order` (mailchimp server) with `customer-email-address` set to `{email}` and report any orders carrying an `outreach-name`.
**Step 5: Report**
One block per system: BigCommerce (customer, order count, revenue, last order) and Mailchimp (audiences, status, opens and clicks, campaign-attributed orders). Close with flags: unsubscribed but still ordering, ordering but never opened an email, subscribed but no orders.
**Rules & Guidelines:**
* `bigcommerce-*` tools run on the bigcommerce server and `mailchimp-*` tools on the mailchimp server. Both servers must be connected.
* Match the two systems on email address, ignoring case.
* This prompt is read-only. Never call any `bigcommerce-*-add`, `-update` or `-delete` tool, and never call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-update-customer` or any other Mailchimp write tool.
**Validation:**
* If either side returns nothing, say so and still report the other side.
* If `max-records` truncates a result, say the figures are partial.
Who it's for
One answer, three teams that use it
Email marketers
See if a buyer engages with campaigns
Open and click rates and recent campaign activity show whether your emails reach this customer.
Does jo@contoso.com open our Mailchimp campaigns, and how much have they bought on BigCommerce?
Ecommerce managers
Check which orders came from email
Orders attributed to a campaign sit next to total spend, so you can see what email drives.
Which of lee@fabrikam.com BigCommerce orders came from a Mailchimp campaign in the last 90 days?
Customer success managers
Spot loyal buyers who unsubscribed
A buyer who still orders but has left the audience is flagged, so you reach them another way.
Is dana@northwindtraders.com unsubscribed in Mailchimp even though she still orders on BigCommerce?
How it works
What PopdockAI does when you ask
You give a customer email and your AI assistant reads their purchases and Mailchimp engagement side by side. Both systems are only read.
01
Ask
You give the customer email and an optional lookback in days.
02
Orders
It finds the BigCommerce customer and totals orders and spend.
03
Audience
It finds the Mailchimp member and counts campaign activity.
04
Report
You get both blocks plus flags such as unsubscribed but still ordering.
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.
bigcommerce-get-customer
bigcommerce-get-order
mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-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
Purchases and engagement for one buyer read together
Related use cases
More ways to put this data to work
Find BigCommerce subscribers missing from a Mailchimp audience
Ask your AI which recent BigCommerce subscribers are not in a Mailchimp audience and it reports gaps without re-adding anyone who opted out.
Learn More
BigCommerce customer order history
Ask your AI for a customer's BigCommerce order history and it returns a lifetime summary plus the latest orders with their line items.
Learn More
BigCommerce new customer review
Ask your AI to review new BigCommerce customers and it shows who has and has not placed an order, grouped by customer group.
Learn More
Explain a BigCommerce order
Ask your AI to explain a BigCommerce order and get its status, money, items, customer and anything unusual in plain language, with nothing changed.
Learn More
BigCommerce and Drip customer purchase profile
Ask your AI for a customer's BigCommerce orders alongside their Drip status, tags, lead score and campaigns, matched by email, with nothing changed.
Learn More
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.