Report

Find the abandoned carts you can actually recover by email

For marketing teams who want to know which Mailchimp abandoned carts are worth chasing and which stores lack cart recovery, by asking their AI assistant.

Mailchimp abandoned cart review

Review the Mailchimp abandoned carts from the last 14 days and tell me which we can recover.

78 carts worth 11,600 USD were abandoned in the last 14 days. - Reachable: 6,900 USD from subscribed shoppers - Not reachable: 4,700 USD from shoppers not subscribed - Top cart: Jordan Lee, 860 USD, returning customer - First fix: the Northwind store has no active cart recovery automation Want the table of the ten largest carts?

Mailchimp

Sample figures. Your results come from your own account.

mailchimp-get-store

mailchimp-get-cart

mailchimp-get-customer

mailchimp-get-list-member

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Run it on your own Mailchimp data.

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

The problem

Abandoned revenue you cannot tell how to recover

Knowing which abandoned carts are worth chasing means checking each shopper's history and whether you may email them. It is also easy to miss that a store never switched cart recovery on.

Without PopdockAI

Export carts per store and total them by currency
Look up each big shopper's order history
Check subscription status before emailing
Miss stores with cart recovery switched off

With PopdockAI

Recent carts are totalled per store in each currency
The ten largest carts get returning and subscription checks
Reachable value is shown against unreachable
It never suggests emailing non subscribers and changes nothing

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt

**Objective:** Review the carts abandoned in the last {lookback-days} days (default 14) worth at least {min-cart-value} (default no minimum), work out which can be recovered by email, and recommend what to do.

**Step 1: Stores**

Call `mailchimp-get-store`. For each store note name, platform, currency-code, list-id, is-syncing and abandoned-cart-automation-status. A store that is still syncing may be missing carts; say so.

**Step 2: Carts**

Work out the start date as today minus the lookback. Call `mailchimp-get-cart` with `created-at-date.from` set to that date, `order-total.min` if a minimum was given, and `max-records` set to 200. Group the carts by store-id: count and total value, in the store's currency.

**Step 3: Can each shopper be reached?**

For the 10 highest-value carts:

* Call `mailchimp-get-customer` with `email` set to the cart's customer-email, to see orders-count and total-spent (a returning customer or a first-time shopper) and opt-in-status.
* Call `mailchimp-get-list-member` with `email` set to the same address, and check the status on the store's audience (the store's list-id). Only `subscribed` contacts can receive a recovery email.

**Step 4: Report**

* Per store: carts, total value, and abandoned-cart-automation-status.
* A table of the top carts: customer name, email, value, created date, returning or new, reachable (yes or no, and why), checkout-url.
* The total value that is reachable by email versus not.
* Recommendations. If a store with carts does not have its abandoned cart automation active, that is the first recommendation.

**Rules & Guidelines:**

* Read only. Do not call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-update-product`, `mailchimp-update-order`, `mailchimp-replicate-campaign`, `mailchimp-start-automation` or `mailchimp-pause-automation`.
* Never recommend emailing a contact whose status is not `subscribed` or whose opt-in-status is false.
* Carts in different currencies must not be summed together. Total them per currency.

**Validation:**

* If no carts match, say so and stop.
* If there are no stores, say the account has no connected e-commerce store and stop.

Who it's for

One answer, three teams that use it

Ecommerce marketers

Size the cart recovery opportunity

See how much abandoned value sits with shoppers you can legally email, per store.

How much abandoned cart value from the last 30 days in Mailchimp can we reach by email?

Store owners

Catch stores with recovery switched off

Any store without cart recovery is the first recommendation, so a missing automation does not cost you for months.

Review Mailchimp abandoned carts for all our stores this week and tell me if any store lacks cart recovery.

Retention specialists

Focus on the biggest carts

The top carts show whether the shopper is new or returning and subscribed, so follow up is targeted.

Show the ten largest Mailchimp abandoned carts over 200 from the last 7 days and whether each shopper is subscribed.

How it works

What PopdockAI does when you ask

You choose a lookback period and an optional minimum cart value, and your AI assistant reviews the carts across your stores. It only reads and recommends.

Ask

You choose a lookback period and an optional minimum cart value.

Your AI tool

Read

It reads your stores and recent abandoned carts, totalled per store.

mailchimp-get-store

mailchimp-get-cart

Check

For the ten largest carts it checks returning or new and subscription status.

mailchimp-get-customer

mailchimp-get-list-member

Report

You get reachable against unreachable value and recommendations.

Your AI tool

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.

get-data

mailchimp-get-store

Returns the e-commerce stores connected to Mailchimp, with platform, domain, currency and linked audience.

get-data

mailchimp-get-cart

Returns open (abandoned) carts from the e-commerce stores connected to Mailchimp, with the customer, cart total and checkout link.

get-data

mailchimp-get-customer

Returns e-commerce customers from the stores connected to Mailchimp, with order counts, total spent and marketing opt-in.

get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.

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

The outcome

Know how much cart revenue email can win back

Related use cases

More ways to put this data to work

Mailchimp and Dynamics 365 Business Central customer profile by email

Ask your AI for a profile by email and it combines Mailchimp status, opens, spend and carts with the Dynamics 365 Business Central balance, invoices and orders.

Learn More

Mailchimp contact profile

Ask your AI for a Mailchimp contact profile and it gathers audiences, tags, activity, unsubscribes, orders, carts and surveys for one exact email address.

Learn More

Mailchimp top customers review

Ask your AI to review your top Mailchimp store customers and it flags who is unsubscribed, missing from the audience, not marked VIP or drifting.

Learn More

Check which Mailchimp abandoned carts became WooCommerce orders

Ask your AI which Mailchimp carts became WooCommerce orders and it classes each as recovered, attempted or unrecovered, ranking open carts by value.

Learn More

Mailchimp and Capsule CRM contact profile

Ask your AI for a contact profile and it combines Capsule CRM history, tasks and opportunities with Mailchimp audiences, clicks and orders, then flags what needs attention.

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.