/
/
Summarize a month of Mailchimp campaigns in one report
For marketing teams who want period email results totalled, ranked and checked for problems, by asking their AI assistant instead of copying reports.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
A month of campaign reports copied by hand
Reporting on a month of campaigns means opening each Mailchimp report, copying numbers into a spreadsheet and working out weighted rates. Campaigns with abuse reports or high bounces slip by when you only look at averages.
Without PopdockAI
- Open every campaign report in the period
- Copy sends, opens and clicks into a spreadsheet
- Work out weighted rates by hand
- Miss campaigns with abuse reports or high bounces
With PopdockAI
- Every campaign in the window is read and totalled
- Open and click rates are weighted by emails sent
- Best, worst and top earning campaigns are ranked
- Problem campaigns are flagged 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:** Report on every Mailchimp campaign sent in the last {lookback-days} days (default 30), for the audience {list-name} if one is given (default all audiences), and point out what needs attention.
**Step 1: Collect the campaigns**
Work out the start date as today minus the lookback. Call `mailchimp-get-report` with `send-date.from` set to that date, `list-name` if one was given, and `max-records` set to 200. If exactly 200 come back, say the report may be incomplete.
**Step 2: Totals and ranking**
* Total campaigns, emails sent, unique opens, clicks, unsubscribes, abuse reports and revenue.
* Overall open rate and click rate, weighted by emails sent (not a plain average of the rates).
* The 3 best and 3 worst campaigns by click rate, ignoring campaigns sent to fewer than 100 people.
* The top 3 campaigns by total revenue, if any campaign has revenue.
**Step 3: Flags**
List every campaign with any abuse report, a hard bounce rate (hard-bounces / emails-sent) above 2%, or an unsubscribe rate (unsubscribed / emails-sent) above 0.5%.
**Step 4: Audience growth**
If a list-name was given, call `mailchimp-get-list-growth` with `list-name` and report subscribed, unsubscribed and cleaned for the months that overlap the period.
**Step 5: Report**
* A 2 to 3 sentence summary.
* The totals from Step 2.
* A table of all campaigns: campaign-title, send-date, list-name, emails sent, open rate, click rate, unsubscribes, revenue, sorted by send-date.
* The best, worst and revenue lists.
* The flagged campaigns, each with the reason.
**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`.
* Rates are returned as fractions (0.25 means 25%). Show them as percentages.
* Do not draw a trend from fewer than 3 campaigns. Say there are too few to compare.
**Validation:**
* If no campaigns were sent in the period, say so and give the date of the most recent campaign from `mailchimp-get-campaign` with `status` set to `sent`.
* If the list-name matches no report, call `mailchimp-get-list` with `name.contains` and suggest the closest audience names.Who it's for
One answer, three teams that use it
Email marketers
Skip the monthly spreadsheet
Get totals, weighted rates and a ranked campaign table without opening each report.
Report on every Mailchimp campaign we sent in October.
Marketing directors
See what worked and what did not
Best and worst campaigns by click rate and the top earners show where to invest next.
Which Mailchimp campaigns in the last 90 days had the best and worst click rates?
Deliverability specialists
Catch problem sends
Campaigns with abuse reports, high hard bounces or high unsubscribes are flagged with reasons.
Flag any Mailchimp campaigns sent to the Customers audience this month with abuse reports or high bounces.
How it works
What PopdockAI does when you ask
You choose a period and optionally an audience, and your AI assistant builds the campaign report. It only reads, and will not call a trend from too few campaigns.
01
Ask
You choose a lookback period and optionally an audience.
02
Total
It reads every campaign sent and totals results with weighted open and click rates.
03
Rank
It ranks best and worst by click rate, ignoring tiny sends, and the top earners.
04
Report
You get a summary, a campaign table and flagged campaigns with reasons.
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-report
mailchimp-get-list-growth
mailchimp-get-campaign
mailchimp-get-list
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 email results summarized and ready to share
Related use cases
More ways to put this data to work
Mailchimp campaign clicks to Dynamics SL sales orders
Ask your AI to link a Mailchimp campaign's clickers to Dynamics SL and it totals the sales orders matched customers placed in the window after the send.
Learn More
Mailchimp audience health check
Ask your AI to check a Mailchimp audience and it weighs growth, churn, bounces, pending contacts and last send into a healthy, watch or at risk verdict.
Learn More
Review a Mailchimp campaign's performance
Ask your AI to review a Mailchimp campaign and it compares every metric with recent campaigns to the same audience, with top links and unsubscribe reasons.
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.