/
/
Find paying 2Checkout customers who unsubscribed in Mailchimp
For support teams who ask their AI assistant which people unsubscribing from a Mailchimp campaign hold active 2Checkout subscriptions.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
Paying subscribers treated like cold contacts
Unsubscribes are reviewed in Mailchimp with no view of who pays. A person who just opted out of a campaign may hold an active 2Checkout subscription, yet gets treated like any cold contact.
Without PopdockAI
- Export the campaign's unsubscribes
- Search 2Checkout for each email
- Check subscription status and expiry
- Miss paying customers among the opt outs
With PopdockAI
- Unsubscribes are read, stopping if several campaigns match
- Each email is looked up in 2Checkout, ignoring case
- Active subscriptions show product and expiry date
- It only reads and never suggests resubscribing anyone
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For unsubscribes from Mailchimp campaign `{campaign-name}` in the last `{lookback-days}` days (default 30), find which unsubscribers are current 2Checkout customers so that support can handle them differently.
**Step 1: Get the unsubscribes**
Call `mailchimp-get-campaign-unsubscribe` with `campaign-name.contains` set to `{campaign-name}` and `unsubscribe-date.from` set to today minus `{lookback-days}` days. If rows come from more than one campaign-id, list the campaigns and stop. Take `email`, `unsubscribe-date` and `reason` from each row (cap 50).
**Step 2: Look each one up in 2Checkout**
Call `2checkout-get-customer` with `email` set to the unsubscriber's email. If a customer is found, call `2checkout-get-subscription` with that `customer-reference` and keep active ones.
**Step 3: Report**
Table of customers with an active subscription: email, unsubscribe-date, reason, product-name, expiration-date. Then a count of unsubscribers with no 2Checkout record, without listing them.
**Rules & Guidelines:**
* `2checkout-*` tools belong to the 2checkout server and `mailchimp-*` tools to the mailchimp server; both servers must be connected.
* This prompt is read-only. Never call any 2checkout write tool (for example `2checkout-customer-add`, `2checkout-customer-update`, `2checkout-subscription-disable`) or any mailchimp write tool (`mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`).
* Match emails case-insensitively after trimming spaces; never alter the stored value in the report.
**Validation:**
* If there are no unsubscribes, say so and stop.
* If `{campaign-name}` is empty, stop and ask for it.
* Never suggest resubscribing anyone; report only.Who it's for
One answer, three teams that use it
Support leads
Know which opt outs pay you
See which unsubscribers hold active subscriptions, so the team can treat them with care.
Which unsubscribers from our Mailchimp Product Tips campaign in the last 30 days have active 2Checkout subscriptions?
Customer success managers
Spot customers at risk of churn
An opt out from a paying customer can signal frustration, with the expiry date beside it.
Show paying 2Checkout customers who unsubscribed from the Mailchimp Renewal Reminder campaign, with expiry dates.
Email marketers
Understand why paying customers leave
Unsubscribe reasons from paying customers point to what to change in the campaign.
Why did paying 2Checkout customers unsubscribe from our Mailchimp Autumn Newsletter?
How it works
What PopdockAI does when you ask
You name a campaign and a look back period, and your AI assistant finds which unsubscribers are paying customers. It only reads.
01
Ask
You name a campaign and optionally a look-back in days.
02
Collect
It reads the campaign's unsubscribes and stops if several campaigns match.
03
Match
It looks up each email in 2Checkout and keeps active subscriptions.
04
Report
You get a table of paying customers and a count of unsubscribers with no record.
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
2checkout-get-customer
2checkout-get-subscription
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
Opted out customers handled with care
Related use cases
More ways to put this data to work
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
Capture Mailchimp campaign clickers as Salesforce leads
Ask your AI to create Salesforce leads from a Mailchimp campaign's clickers and it drops existing contacts, leads and unsubscribes, then creates only what you confirm.
Learn More
Log Mailchimp campaign clicks as HubSpot contact notes
Ask your AI to log a Mailchimp campaign's clicks in HubSpot and it adds one note per contact with the links clicked, after you review and confirm every note.
Learn More
Log Mailchimp campaign clicks as Salesforce tasks
Ask your AI to log a Mailchimp campaign's clicks as Salesforce tasks and it adds one completed task per person, skipping anyone already logged.
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.