The Scenario
You are a solopreneur. You have sent 30 newsletters through Kit over the past year. You want to know which had the highest click-to-open rate and build a performance table in an Excel workbook you can sort and share with a collaborator.
Kit's analytics tab shows you one broadcast at a time. You need all 30 in one sortable table in Excel.
The bad version of this Sunday:
- You go to Kit's analytics tab
- You look at one broadcast at a time, manually writing down stats
- Thirty broadcasts, one at a time
- By broadcast 8 you are copy-pasting into the workbook 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 workbook.
Open the SheetXAI sidebar and type:
Fetch stats for every broadcast in my Kit account and write each one as a row in this workbook. 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 workbook, and sorts it. Your answer is in the top row.
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, open rate, click rate — the standard Kit metrics
- Click-to-open rate — engagement quality, computed per row
- Unsubscribe count — the signal that tells you when you went wrong
Sorted by click-to-open rate descending, the top performers appear at the top immediately. Add a chart, apply a filter, pivot by month — the data is in Excel and ready to work with.
What If the Data Is Not Quite Ready
Raw broadcast exports have edge cases. SheetXAI handles them inline.
When you only want broadcasts from the last 6 months
Fetch Kit broadcast stats for broadcasts sent in the last 180 days only. Write each as a row in this workbook — broadcast name in column A, sent count in column B, open rate in column C, click rate in column D, unsubscribe count in column E. Sort by sent date ascending.
When you want to flag broadcasts below a performance baseline
Fetch Kit broadcast stats for all sent broadcasts. Write the full table into this workbook. 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 month in a separate tab
Fetch Kit broadcast stats for all sent broadcasts. Write the full detail table into the Data tab. In the Summary tab, write one row per calendar month — month, number of broadcasts, average open rate, and average click rate.
When you want the full analysis: raw data, top and bottom 5, and subject line interpretation
Fetch Kit broadcast stats for all sent broadcasts. Write the full table to columns A through F. In a Summary section starting at row 35, list the top 5 broadcasts by click-to-open rate and the bottom 5. Below those, write a short paragraph noting any observable patterns in the subject lines of the top 5 versus bottom 5.
The pattern: pull the data, rank it, and interpret it in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, 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 in Excel or the Kit in Excel overview.