The Scenario
You are a product marketer. You sent a Mailcoach campaign last week with eight different CTAs in the email body. The campaign got strong open numbers. But before you write the follow-up, you need to know which CTAs actually drove clicks.
The data is in Mailcoach. You have the campaign UUID. You need it in an Excel workbook, ranked, before the copy deadline in two days.
The bad version:
- Open the Mailcoach dashboard
- Navigate to the campaign
- Click through to the link stats view
- Copy each URL and its click count by hand
- Switch to Excel and paste them row by row
- Sort manually
- Calculate percentage share yourself
- You spend thirty minutes on data entry before making a single decision.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the Mailcoach API and writes the click data directly into your workbook.
Open the SheetXAI sidebar and type:
Fetch the click data for Mailcoach campaign UUID [X] and list each link URL, total clicks, and unique click count into this workbook — sort by total clicks descending.
SheetXAI calls the Mailcoach campaign links endpoint, retrieves the full per-URL breakdown, and writes the table sorted by total clicks. Your highest-performing CTA is in row one.
What You Get
A click breakdown table with one row per link:
- URL — the full destination link from the campaign
- Total clicks — all clicks including repeats
- Unique click count — one per subscriber regardless of how many times they clicked
Sorted by total clicks descending. The winner is immediately visible.
From here you can ask SheetXAI to add a percentage share column, highlight the top three, or group links by domain.
What If the Data Is Not Quite Ready
Click data is usually clean out of the API, but the analysis layer benefits from extra steps. SheetXAI handles them inline.
When you want percentage share of total clicks
You want each link's share of the campaign's total click volume.
Pull click stats for Mailcoach campaign [UUID] into this workbook and add a column showing each link's percentage share of total clicks. Sort by total clicks descending.
When you want to group links by destination domain
You have eight links but some go to the same domain. You want a domain-level rollup.
Fetch the click data for campaign [UUID], extract the root domain from each URL, group the click counts by domain, and write a summary table showing domain and total clicks. Keep the full per-link table below it.
When you want to highlight the top three CTAs
You want a visual callout so the follow-up campaign decision is obvious.
Pull click stats for campaign [UUID], sort by total clicks descending, and apply a green background to the top three rows. Add a note in column D for those rows saying "Feature in follow-up."
When you want to compare two campaigns side by side
Did the same links perform differently in last week's send versus the one two weeks before?
Fetch click data for campaign [UUID-A] and campaign [UUID-B]. Write both tables side by side — campaign A in columns A through C, campaign B in columns E through G. Add a column H showing the click count difference per matching URL.
The pattern: describe the analysis you need and SheetXAI handles the API call, the table structure, and the formatting in one pass.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull the click breakdown for any Mailcoach campaign into an open Excel workbook. The Mailcoach integration is included in every SheetXAI plan. For related workflows, see how to rank Mailcoach campaigns by open rate in Excel or the Mailcoach in Excel overview.