The Scenario
You are a content director at a media company. Last week you sent a newsletter with 9 article links across three content categories: long reads, news briefs, and opinion pieces. The editorial team wants to know which category is driving clicks so they can decide what to commission next month.
The data is in Mailchimp's click report. It is Monday morning. The commissioning call is at 2 PM.
The bad version of this morning:
- You open Mailchimp's Reports tab and find the campaign
- You navigate to the Click Activity report
- You export it as a CSV and open it in Google Sheets
- The URL column has full tracking URLs with UTM parameters, not the clean article titles you wanted
- You spend an hour stripping parameters, manually labeling categories, and building a pivot table
- The click counts do not match the unique click counts and you are not sure which one to use
- The 2 PM call starts and you are still formatting the sheet.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls the full click report for a campaign and writes each URL's stats directly into the sheet, sorted and ready for analysis.
Open the SheetXAI sidebar and type:
Fetch the click report for Mailchimp campaign ID in cell A1 and list every tracked URL, its total clicks, unique clicks, and click-through rate in this sheet. Sort by total clicks descending.
SheetXAI calls the Mailchimp API, fetches every tracked link in the campaign, and writes the results into the sheet. Nine URLs, nine rows, sorted by performance. No CSV export, no UTM stripping.
What You Get
One row per tracked link, ranked by total clicks:
- URL — the destination URL as Mailchimp tracked it
- Total clicks — all clicks including repeat clicks from the same subscriber
- Unique clicks — one count per subscriber, regardless of how many times they clicked
- Click-through rate — unique clicks as a share of list size
The ranking is your editorial signal. If the top three spots are all long reads and the news briefs are at the bottom, that is a data point the editorial team can act on, not a hunch.
Want to add category labels? Tell SheetXAI to read the URL patterns and write a category tag into a new column, and it does that in the same pass.
What If the Data Is Not Quite Ready
Click reports are rarely one-and-done. SheetXAI handles enrichment and multi-campaign pulls in the same prompt.
When the URLs have UTM parameters you want stripped for readability
The raw URLs are 200-character strings with utm_source, utm_medium, and utm_campaign appended. You want clean destination URLs in the sheet.
Fetch the click report for Mailchimp campaign ID in cell A1. For each tracked URL, strip everything from the ? character onward and write the clean URL into column A. Write total clicks into column B, unique clicks into column C, and click-through rate into column D. Sort by total clicks descending.
When you want to label each URL by content category
You know the URL patterns: /long-reads/ for long reads, /news/ for news briefs, /opinion/ for opinion pieces.
Fetch the click report for campaign ID in cell A1 and write each URL, total clicks, unique clicks, and CTR into columns A through D. In column E, write "Long Read" if the URL contains /long-reads/, "News Brief" if it contains /news/, and "Opinion" if it contains /opinion/. Sort by total clicks descending.
When you want to compare click performance across the last three campaigns
The editorial team wants a trend view, not just last week's numbers.
Fetch click reports for the three campaign IDs in cells A1, A2, and A3. For each campaign, write the campaign name, URL, and total clicks into a row. Group the results by URL so you can see which articles appeared in multiple campaigns and how their click counts changed.
When you need total click counts and unique click counts both, plus a calculated CTR for the commission decision
The data needs to go into a board-ready format: clean URLs, both click types, and CTR calculated from list size in cell B1.
Fetch the click report for campaign ID in cell A1. Strip UTM parameters from each URL. Write clean URL into column A, total clicks into column B, unique clicks into column C. In column D, calculate CTR as unique clicks divided by the list size in cell B1 and format as a percentage. Sort by CTR descending. Write the top URL in cell F1 with its CTR.
The pattern: pull the raw click data first, then enrich it with category labels, comparisons, or calculated fields in the same prompt or a follow-up.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, paste your campaign ID, then ask it to pull the full click report. The Mailchimp integration is included in every plan. For related workflows, see how to pull quarterly campaign stats or the Mailchimp in Google Sheets overview.