The Scenario
You are a digital marketing manager. Your CMO wants the Q2 email marketing report before the leadership review on Friday at 2 PM. That means 24 Mailchimp campaigns sent between April 1 and June 30, with open rate, click rate, unsubscribe rate, and revenue for each one, in an Excel workbook so she can build the charts herself.
You have until Thursday EOD to get the data in there.
The slow version of this week:
- You go into Mailchimp's Reports section and open campaign one
- You note the open rate, click rate, unsubscribe rate, and revenue in a workbook row
- You click back, open campaign two, note the numbers
- You repeat for campaigns three through twenty-four
- You mistype the click rate on campaign nine and do not notice until the chart looks wrong on Thursday
- You send the corrected workbook to your CMO at 7 PM with an apology note.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your workbook that reads a date range and pulls the campaign data from Mailchimp directly into the Q2 Report tab, without opening a single Mailchimp report.
Open the SheetXAI sidebar and type:
List all Mailchimp campaigns sent between April 1 and June 30 2025 and write campaign name, send date, subject line, list size, open rate, click rate, and unsubscribe rate into the Q2 Report tab, one campaign per row. Sort by send date descending.
SheetXAI calls the Mailchimp API, fetches all 24 campaigns, and populates the Q2 Report tab in one go. No copying, no retyping, no transposed numbers.
What You Get
Twenty-four rows in the Q2 Report tab, one per campaign, with no manual data entry:
- Campaign name and subject line — exactly as they appear in Mailchimp
- Send date — formatted as a date for Excel pivot tables
- List size, open rate, click rate, unsubscribe rate — ready for charts
- Revenue — if your Mailchimp account has e-commerce tracking enabled
The CMO has her raw data on Thursday afternoon. She can add pivot tables, build charts, filter by date, and share with the team without waiting on you.
What If the Data Is Not Quite Ready
Quarterly reports rarely come with perfectly formatted data on the first pull. SheetXAI handles formatting, filtering, and enrichment in the same prompt.
When Mailchimp returns open rates as decimals instead of percentages
The API returns 0.2147 and your CMO wants 21.47% in the cell.
List all Mailchimp campaigns sent between April 1 and June 30 2025 and write campaign name, send date, open rate, click rate, and unsubscribe rate into the Q2 Report tab. Format all rate columns as percentages with two decimal places. Sort by send date descending.
When the CMO wants the top 5 and bottom 5 campaigns in a separate tab
Same data pull, but she wants a second tab isolating the extremes for the leadership slide.
List all Q2 Mailchimp campaigns in the Q2 Report tab as usual. Then create a second tab called "Top and Bottom 5" with the five campaigns with the highest open rate and the five with the lowest open rate, labeled "Top" or "Bottom" in a new column.
When you only want campaigns sent to a specific audience
You run campaigns to three different Mailchimp audiences and your CMO only wants the numbers for the main newsletter list.
List all Mailchimp campaigns sent between April 1 and June 30 that were sent to audience ID in cell A1 only. Write campaign name, send date, subject line, open rate, click rate, and unsubscribe rate into the Q2 Report tab, one row per campaign.
When you need a full performance breakdown including detailed click counts
The CMO has follow-up questions about which subject lines drove the most clicks, and she wants total and unique click counts alongside the rates.
First, list all Mailchimp campaigns sent between April 1 and June 30 into the Q2 Report tab with campaign name, send date, subject line, list size, open rate, click rate, unsubscribes, and estimated revenue in columns A through H. Sort by open rate descending. Then for each campaign where click rate is above 3%, fetch total clicks and unique clicks from the detailed stats and write them into columns I and J.
The pattern: pull the summary first, then ask SheetXAI to enrich the rows that need more detail. No additional exports at any step.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask SheetXAI to pull your last quarter of Mailchimp campaign stats. The Mailchimp integration is included in every plan. For related workflows, see how to audit your full Mailchimp audience from Excel or the Mailchimp in Excel overview.