The Scenario
You are a product marketer. You sent a Mailcoach campaign last week with eight different CTAs: a free trial button, a demo booking link, a pricing page link, a case study, a feature page, a webinar registration, a blog post, and a changelog link.
The campaign got a solid open rate. But you need to know which CTAs actually drove clicks before you decide which one to feature in the follow-up send going out in two days.
The bad version of this analysis:
- Open the Mailcoach dashboard
- Navigate to the campaign
- Click through to the link stats view
- Copy each URL and its click count by hand
- Paste into a sheet row by row
- Sort manually
- Calculate each link's percentage share of total clicks yourself
- You spend thirty minutes on data entry before you can make a single decision.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that calls the Mailcoach API and writes the click data directly into your sheet.
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 sheet — 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 from the same subscriber
- Unique click count — one count per subscriber regardless of how many times they clicked
Sorted by total clicks descending, so the highest-performing link is immediately at the top.
From here you can ask SheetXAI to add a percentage share column, highlight the top three, or group links by domain to see if one destination consistently outperforms.
What If the Data Is Not Quite Ready
Click data is usually clean out of the API, but the analysis layer benefits from a few 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, not just the raw count.
Pull click stats for Mailcoach campaign [UUID] into this sheet 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 to see which domain drove the most traffic.
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
You want a visual callout on the sheet so the follow-up campaign decision is obvious at a glance.
Pull click stats for campaign [UUID], sort by total clicks descending, and format the top three rows with a green background. Add a note in column D for those rows saying "Feature in follow-up."
When you want to compare two campaigns side by side
You want to see whether the same links performed 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: you describe the output 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 sheet. The Mailcoach integration is included in every SheetXAI plan. For related workflows, see how to rank campaigns by open rate or the Mailcoach in Google Sheets overview.