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 drove clicks before the commissioning call at 2 PM today.
The data is in Mailchimp's click report. It is Monday morning and you have four hours.
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 the workbook
- The URL column has full tracking URLs with UTM parameters, not clean article titles
- You spend two hours stripping parameters, labeling categories, and building a pivot table in Excel
- The 2 PM call starts and you are still in the workbook.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your workbook that pulls the full click report for a campaign and writes each URL's stats into the Click Report tab, 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 the Click Report tab. Sort by total clicks descending.
SheetXAI calls the Mailchimp API, fetches every tracked link, and writes the results into the Click Report tab. Nine URLs, nine rows, ranked by performance.
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
- Unique clicks — one count per subscriber
- Click-through rate — unique clicks as a share of list size
The ranking is your editorial signal. If the top three are all long reads, that is a data point, not a hunch.
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 tracking appended. You want clean destination URLs in the workbook.
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 of the Click Report tab. 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/, /news/, /opinion/.
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 of the Click Report tab. 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 of the Click Report tab. Group the results by URL so you can see which articles appeared in multiple campaigns and how their click counts changed.
When you need both click types and a calculated CTR for the board export
The data needs to go into a board-ready format: clean URLs, both click types, CTR 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 of the Click Report tab, 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, formatted as a percentage. Sort by CTR descending. Write the top URL in cell F1 with its CTR.
The pattern: pull the raw click data, then layer on category labels, comparisons, or calculated fields in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, 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 from Excel or the Mailchimp in Excel overview.