/
/
See the Rillet ARR behind recent Mailchimp unsubscribes
For account owners who want to know which unsubscribes came from contacts at Rillet customers, with ARR and contract end dates.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Paying customers unsubscribe and nobody tells the account owner
An unsubscribe from a paying customer can be an early sign of trouble, but Mailchimp does not know who pays you. Spotting the risky ones means matching each to a Rillet customer and checking ARR and contract end, which rarely happens in time.
Without PopdockAI
- Export unsubscribes from Mailchimp
- Match each email to a Rillet customer
- Look up ARR and the next contract end date
- Hear about it at the renewal meeting
With PopdockAI
- Unsubscribes for your date range read from Mailchimp
- Each matched to Rillet customers with ARR and contract end
- A table sorted by ARR with campaign and reason
- ARR affected totalled per currency, read-only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find people who unsubscribed from Mailchimp campaigns between `{from-date}` (default 30 days ago) and `{to-date}` (default today) and are contacts on Rillet customers, so account owners can follow up.
**Step 1: Read the unsubscribes**
Call `mailchimp-get-campaign-unsubscribe` with `unsubscribe-date.from` and `unsubscribe-date.to` (YYYY-MM-DD). Keep `email`, `unsubscribe-date`, `reason`, `campaign-name` and `company`. If there are none, say so and stop.
**Step 2: Match to Rillet**
Call `rillet-get-customer-emails` once (no filters) and match the unsubscribed emails. Match emails case-insensitively after trimming spaces. A Rillet customer can have several emails (`email-type`), and one email can appear on more than one Rillet customer: keep every pairing and say so in the report.
**Step 3: Pull the account value**
For each distinct matched `customer-id`:
* Call `rillet-get-arr-waterfall` with `customer-id` and take the most recent month's `arr`, `currency` and `status`.
* Call `rillet-get-contracts` with `customer-id` and note the nearest future `end-date`.
**Step 4: Report**
Table sorted by ARR, highest first: Rillet customer name, email, `unsubscribe-date`, campaign, reason, current ARR, next contract end date. Then: total unsubscribes in the window, how many were Rillet customers, and ARR affected per currency. List the campaigns that drove more than one customer unsubscribe.
**Rules & Guidelines:**
* Tools named mailchimp- come from the mailchimp MCP server; tools named rillet- come from the rillet MCP server. If a tool from either server is missing, stop and say which server is not connected rather than working around it.
* The only key shared by the two systems is the email address. Mailchimp `customer-id` values (e-commerce store customers) are NOT Rillet customer ids; never pass one system's id into the other.
* Read-only. Do not call any Mailchimp tool whose name starts with mailchimp-add-, mailchimp-update-, mailchimp-start-, mailchimp-pause- or mailchimp-replicate-, and do not call any Rillet tool whose name starts with rillet-add-, rillet-update-, rillet-apply-, rillet-unapply-, rillet-record-, rillet-set- or rillet-setup-. In particular never call `mailchimp-add-list-member`, `mailchimp-update-list-member` or `mailchimp-add-segment-member` from this prompt.
* Never re-subscribe anyone. The follow-up this prompt supports is a human conversation, not an email.
**Validation:**
* If either date is empty, use the default; if `{from-date}` is after `{to-date}`, swap them and say so.
* An unsubscribe with no Rillet match is counted but not listed.
* If `reason` is empty, show "not given".Who it's for
One answer, three teams that use it
Account executives
Get an early warning on your accounts
See which of your paying customers opted out, with ARR and the next contract end date.
Did anyone at Contoso unsubscribe from our Mailchimp emails this quarter? What is their ARR?
Sales leaders
Rank revenue at risk by value
A table sorted by ARR shows where to put the team's attention first.
Which Rillet customers unsubscribed from Mailchimp in the last 60 days, sorted by ARR?
Customer success
Find campaigns that drive customers away
Campaigns that lost more than one paying customer are named, so you can raise it with marketing.
Which Mailchimp campaigns made more than one Rillet customer unsubscribe last month?
How it works
What PopdockAI does when you ask
You pick a date range and your AI assistant matches Mailchimp unsubscribes to paying Rillet customers. It only reads and never resubscribes anyone.
01
Ask
You pick a date range, the last 30 days by default.
02
Read
It reads Mailchimp unsubscribes in that range.
03
Match
It matches each email to Rillet customers and pulls ARR and contract end.
04
Report
You get a table by ARR, totals per currency and repeat-offender campaigns.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
mailchimp-get-campaign-unsubscribe
rillet-get-customer-emails
rillet-get-arr-waterfall
rillet-get-contracts
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
Hear about unhappy paying customers in time
Related use cases
More ways to put this data to work
Add renewing Rillet customers to a Mailchimp segment
Ask your AI to add renewing Rillet customers to a Mailchimp segment and it adds only subscribed contacts not already in it, after you confirm.
Learn More
Find Rillet customers who engaged with a Mailchimp campaign
Ask your AI which Rillet customers engaged with a Mailchimp campaign and it matches openers and clickers to customers and totals their ARR per currency.
Learn More
Rate Rillet renewals by Mailchimp engagement
Ask your AI to rate upcoming Rillet renewals and it checks each customer's contacts in Mailchimp and rates every contract engaged, silent or unreachable.
Learn More
Add missing Rillet customers to a Mailchimp audience
Ask your AI to add missing Rillet customers to a Mailchimp audience and it adds only new addresses as pending after you confirm, checking each one.
Learn More
Log Rillet billing status as a Constant Contact note
Ask your AI to log a Rillet customer's billing status in Constant Contact and it writes a short factual note on their contacts after you confirm.
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.