/
/
Find out which Mailchimp abandoned carts came back as Shopify orders
For marketing teams who want their real cart recovery rate and the carts still worth chasing, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
No way to tell which abandoned carts came back
Mailchimp tracks abandoned carts but cannot say which shoppers later bought in Shopify. You chase people who already ordered, and matching carts to orders by hand is too slow to do every week.
Without PopdockAI
- Export abandoned carts from Mailchimp
- Search Shopify orders for each shopper email
- Rule out canceled orders by hand
- Guess the recovery rate
With PopdockAI
- Carts since your start date are read from Mailchimp
- Each is matched to a later uncancelled Shopify order by email
- Carts are classed recovered, not recovered or unknown
- Nothing is sent to shoppers 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.
**Objective:** For abandoned carts in Mailchimp created on or after `{cart-created-from}` (default: 30 days before today) with a total of at least `{min-cart-total}` (default 0), find out from Shopify which shoppers went on to place an order and which did not.
**Step 1: Open carts in Mailchimp**
Call `mailchimp-get-cart` with `created-at-date.from` = `{cart-created-from}` and `order-total.min` = `{min-cart-total}` if given. Keep `cart-id`, `customer-email`, `customer-first-name`, `customer-last-name`, `order-total`, `currency-code`, `created-at-date`, `campaign-id` and `checkout-url`.
**Step 2: Look for a later order in Shopify**
For each cart with a `customer-email`, call `shopify-get-order` with `email` = `customer-email` and `created-at.from` = the cart's `created-at-date`. If one or more orders come back and the order is not cancelled, mark the cart **recovered** and note the first `order-number`, `created-at` and `total-price`. If none, mark it **not recovered**. Carts without an email go into an **unknown** group.
**Step 3: Report**
* Counts and cart value by currency for recovered, not recovered and unknown, and the recovery rate.
* Recovered: shopper, cart total, order number, order total, days from cart to order. Note when the order total is well below the cart (partial recovery).
* Not recovered: shopper, email, cart total, cart age in days, whether a `campaign-id` is attached, sorted by cart total descending. These are the carts still worth chasing.
**Rules & Guidelines:**
* `mailchimp-*` tools are on the mailchimp server; `shopify-*` tools are on the shopify server.
* Match on email only, case-insensitive and trimmed.
* Read-only. Do NOT call `mailchimp-start-automation`, `mailchimp-add-segment-member`, `mailchimp-update-list-member` or any add or update tool on either server, and do not send anything to the shoppers.
**Validation:**
* If Mailchimp returns no carts, say so and stop.
* A cart still showing in Mailchimp while Shopify has a matching order means the Mailchimp cart was not cleared; say how many there are.Who it's for
One answer, three teams that use it
Ecommerce marketers
Prove whether cart recovery works
See the recovery rate and value per currency, so you can tell whether your cart emails are earning their place.
What was our Mailchimp abandoned cart recovery rate in Shopify for October?
Retention specialists
Chase only carts still open
Unrecovered carts are sorted by value, so follow up goes to shoppers who have not ordered yet.
Which Mailchimp abandoned carts over 150 since last Monday have no Shopify order yet?
Store managers
Spot smaller comebacks
Recovered carts that ordered much less than the cart are noted, which shows where shoppers trimmed their basket.
Which recovered Mailchimp carts this month ended up as much smaller Shopify orders?
How it works
What PopdockAI does when you ask
You set a start date and an optional minimum cart value, and your AI assistant matches the carts to Shopify orders. It only reads.
01
Ask
You set a start date and optionally a minimum cart value.
02
Read
It reads Mailchimp abandoned carts created since then.
03
Match
It looks for a later, uncancelled Shopify order from the same email.
04
Report
You get counts, value, the recovery rate and the open carts worth chasing.
What PopdockAI provides
The tools behind the answer
Ready made tools for Mailchimp and one secure connection to your AI tool. No code, no exports.
mailchimp-get-cart
shopify-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
Your real cart recovery rate
Related use cases
More ways to put this data to work
Mailchimp and Shopify customer profile by email
Ask your AI for a customer profile and it combines Shopify orders and shipments with Mailchimp status, activity and open carts, and flags consent mismatches.
Learn More
Check Mailchimp campaign revenue against Shopify orders
Ask your AI to check a Mailchimp campaign's attributed revenue against Shopify and it finds each order, counts cancellations and refunds, and shows how far the figure overstates.
Learn More
Review Mailchimp unsubscribes from Shopify customers
Ask your AI to review Mailchimp unsubscribes against Shopify and it ranks paying customers by spend, groups reasons and ranks campaigns by buyers lost.
Learn More
Add a contact to a Mailchimp audience safely
Ask your AI to add someone to a Mailchimp audience and it checks for an existing member, refuses to re-add anyone who opted out, and writes only after you confirm.
Learn More
Add Mailchimp store customers missing from HubSpot
Ask your AI to find Mailchimp store customers over a spend threshold who are not in HubSpot, and it creates only the contacts you confirm, with no duplicates.
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.