The Scenario
You are a solopreneur. You have sent 30 newsletters over the past year through Kit. You have a gut feeling that your click-through rate has been declining since February, but you have never actually pulled the numbers into a table you could sort.
It is Sunday. You want to know which of your last 30 broadcasts had the highest click-to-open rate, and you want to be able to sort, filter, and chart the data in a Google Sheet before you write tomorrow's issue.
The bad version of this Sunday:
- You go to Kit's analytics tab
- You look at one broadcast at a time, manually writing down the stats
- Thirty broadcasts, one at a time
- By broadcast 8 you are copy-pasting into a sheet and losing formatting
- You give up and write tomorrow's issue based on a hunch.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Kit account and writes the broadcast stats directly into the sheet, so you never have to look at broadcasts one by one.
Open the SheetXAI sidebar and type:
Fetch stats for every broadcast in my Kit account and write each one as a row in this sheet. Include broadcast name in column A, sent count in column B, open rate in column C, click rate in column D, click-to-open rate in column E, and unsubscribe count in column F. Sort by click-to-open rate descending.
SheetXAI calls Kit's broadcast stats API, pulls every sent broadcast, writes the table into the sheet sorted by click-to-open rate, and you have your answer before the coffee is cold.
What You Get
A sortable broadcast performance table with every campaign in one place:
- Broadcast name — so you know what each row refers to
- Sent count — total recipients
- Open rate and click rate — the standard Kit metrics
- Click-to-open rate — the engagement quality metric you actually care about
- Unsubscribe count — the signal that tells you when you went wrong
Sorted by click-to-open rate descending, the top performers land at the top. You can see immediately which topics, subject line patterns, or send days produced real engagement versus opens with no clicks.
Once the table is in the sheet, add a chart, highlight the top five, or pivot by send month — the data is yours to work with.
What If the Data Is Not Quite Ready
Raw broadcast exports from any email platform have edge cases. SheetXAI handles them inline.
When you only want broadcasts from the last 6 months
You have 3 years of Kit history and only want recent data for a trend analysis.
Fetch Kit broadcast stats for broadcasts sent in the last 180 days only. Write each one as a row with broadcast name in column A, sent count in column B, open rate in column C, click rate in column D, and unsubscribe count in column E. Sort by sent date ascending.
When you want to flag broadcasts with open rates below your baseline
You want to identify underperforming broadcasts so you can study their subject lines.
Fetch Kit broadcast stats for all sent broadcasts. Write the full table — name, sent count, open rate, click rate — into this sheet. Add a column F where you write "BELOW BASELINE" for any broadcast with an open rate below 25% and leave it blank for the rest.
When you need a pivot summary by send month
You want to see average performance per month, not per broadcast.
Fetch Kit broadcast stats for all sent broadcasts. Write the full detail table into the Data tab. Then in the Summary tab, write one row per calendar month showing the month, number of broadcasts sent, average open rate, and average click rate.
When you want the full analysis: raw data, performance ranking, and subject line pattern notes in one pass
You want the table, the top 5 and bottom 5 called out, and a short paragraph interpreting what the subject line patterns suggest.
Fetch Kit broadcast stats for all sent broadcasts. Write the full table into column A through F. Identify the top 5 by click-to-open rate and highlight them in a separate summary at the top of the sheet. Identify the bottom 5 and list them below the top 5. Look at the subject lines of the top 5 and the bottom 5 and write a short paragraph in cell A20 noting any observable patterns — length, phrasing, question vs. statement.
The pattern: pull the data, rank it, and interpret it in one prompt instead of three separate sessions.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask SheetXAI to pull your Kit broadcast stats into it. The Kit integration is included in every SheetXAI plan. For the content creation side, see how to turn a content calendar into Kit broadcast drafts or the Kit in Google Sheets overview.