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 a Google Sheet 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 spreadsheet 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
- You spend twenty minutes on Thursday finding the discrepancy and fixing it
- You send the sheet to your CMO at 6:45 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 spreadsheet that reads a date range from the sheet and pulls the campaign data from Mailchimp directly, so you never have to open a single campaign 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 this sheet, one campaign per row. Sort by send date descending.
SheetXAI calls the Mailchimp API, fetches all 24 campaigns, and populates the sheet in one go. No copying, no retyping, no misread percentages.
What You Get
Twenty-four rows, 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, not a Mailchimp timestamp string
- List size — total subscribers the campaign was sent to
- Open rate, click rate, unsubscribe rate — as percentages
- Revenue — if your Mailchimp account has e-commerce tracking enabled
The CMO has her raw data immediately. She can add pivot tables, build her own charts, filter by date, and hand it to the team for analysis. She is not waiting on you to pull each number by hand.
Want to go deeper? Ask SheetXAI to also fetch unique click counts and bounce totals per campaign ID, and it adds the columns in a second pass.
What If the Data Is Not Quite Ready
Quarterly reports rarely come with clean 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 this sheet. Format all rate columns as percentages with two decimal places. One campaign per row, sorted by send date descending.
When the CMO wants the top 5 and bottom 5 campaigns highlighted
Same data, but she wants a second tab that pulls out the extremes.
List all Q2 Mailchimp campaigns in the main tab as usual. Then create a second tab called "Top and Bottom 5." In that tab, write the five campaigns with the highest open rate and the five with the lowest open rate, with a label column marking each as "Top" or "Bottom."
When you only want campaigns sent to a specific audience
You run campaigns to three different audiences and your CMO only wants the numbers for the main 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 this sheet, one row per campaign.
When you need a full performance breakdown including click details
The CMO has follow-up questions about which subject lines drove the most clicks, and she wants the click count per campaign alongside the rates so she can cross-reference.
First, list all Mailchimp campaigns sent between April 1 and June 30 and write campaign name, send date, subject line, list size, open rate, click rate, unsubscribes, and estimated revenue into columns A through H. Sort by open rate descending. Then for each campaign where click rate is above 3%, fetch the total clicks and unique clicks from the detailed stats and write them into columns I and J.
The pattern: start with the summary pull, then ask SheetXAI to enrich specific rows. You do not have to export and re-import at any step.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, 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 audience list or the Mailchimp in Google Sheets overview.