/
/
Learn which campaigns cost you valuable Shopify buyers
For marketing teams who want to know who unsubscribed, what they spend and which campaign pushed them away, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
An unsubscribe count that hides who you lost
An unsubscribe count says little until you know who left. Working out which unsubscribes are valuable Shopify buyers, why they left and which campaign pushed them away means matching each email and reading their spend.
Without PopdockAI
- Export unsubscribes and reasons
- Look up each email as a Shopify customer
- Rank them by spend by hand
- Miss customers whose store consent is still on
With PopdockAI
- Unsubscribes since your date are matched to Shopify by email
- Paying customers are ranked by spend with reason
- Campaigns are ranked by paying customers lost
- Consent to fix is listed 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:** Find everyone who unsubscribed from a Mailchimp campaign on or after `{unsubscribe-from}` (default: 30 days before today), look them up as Shopify customers, and show which valuable buyers were lost from email and why.
**Step 1: Unsubscribes in Mailchimp**
Call `mailchimp-get-campaign-unsubscribe` with `unsubscribe-date.from` = `{unsubscribe-from}`. Keep `email`, `first-name`, `last-name`, `unsubscribe-date`, `reason`, `campaign-name` and `list-id`. If the same email unsubscribed from several campaigns, keep the earliest and list the campaigns.
**Step 2: Look each one up in Shopify**
For each email, call `shopify-get-customer` with `email`. Note `total-spent`, `orders-count`, `accepts-marketing`, `tags` and `last-order-name`. If none, mark the person "not a Shopify customer".
**Step 3: Report**
* Count of unsubscribes, how many are Shopify customers, and their combined total spent.
* Table of the Shopify customers with total spent of at least `{min-total-spent}` (default 0), sorted by total spent descending: name, email, orders, total spent, campaign they left, reason.
* Reasons grouped and counted, and campaigns ranked by how many paying customers they lost.
* **Consent still on in Shopify:** customers whose Shopify `accepts-marketing` is still true. Shopify consent cannot be changed with these tools; list them for the user to fix in Shopify admin.
**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-update-list-member`, `mailchimp-add-list-member`, `shopify-update-customer` or any other add or update tool. Never resubscribe anyone.
**Validation:**
* If there are no unsubscribes in the window, say so and stop.
* If several Shopify customers share an email, list them all rather than picking one.Who it's for
One answer, three teams that use it
Email marketers
Learn which campaigns drive buyers away
Campaigns ranked by paying customers lost show where content or frequency needs a rethink.
Which Mailchimp campaigns lost us the most paying Shopify customers since September?
Retention managers
Spot valuable customers who opted out
Paying customers are ranked by spend with their reason, so you can respond to the biggest losses.
Which Shopify customers who spent over 500 unsubscribed from Mailchimp in the last 60 days?
Store managers
Tidy consent in Shopify
Customers whose Shopify marketing consent is still on are listed for you to fix in Shopify admin.
Which Mailchimp unsubscribes still have marketing consent on in Shopify?
How it works
What PopdockAI does when you ask
You set a start date and optionally a minimum spend, and your AI assistant shows which buyers left and why. It only reads.
01
Ask
You set a start date and optionally a minimum spend.
02
Read
It reads Mailchimp unsubscribes since that date.
03
Match
Each person is looked up as a Shopify customer by email.
04
Report
You get ranked buyers, grouped reasons, campaigns by loss and consent to fix.
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-campaign-unsubscribe
shopify-get-customer
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 which campaigns cost you valuable buyers
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
Check which Mailchimp abandoned carts became Shopify orders
Ask your AI which Mailchimp abandoned carts turned into Shopify orders and it classes each as recovered, not recovered or unknown, with the recovery rate.
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.