The Scenario
You are a freelance email consultant. Day one with a new client. You need a baseline metrics table — Kit account-level email stats for the last 90 days — in an Excel workbook so you can start the audit conversation without giving the client dashboard access.
The bad version of day one:
- You screenshot Kit's stats dashboard
- You manually type sent count, open rate, click rate, bounce rate, and unsubscribe rate into a workbook
- You realize you do not know if the numbers are trailing 90 days or calendar month
- You go back to Kit to check
- You spend 45 minutes on five numbers that should have taken five minutes.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI calls Kit's email stats endpoint and writes the account-level metrics directly into the workbook.
Open the SheetXAI sidebar and type:
Fetch my Kit account email stats for the last 90 days and write the totals into this workbook. Include: emails sent in B2, emails delivered in B3, total opens in B4, unique opens in B5, open rate in B6, total clicks in B7, click rate in B8, unsubscribes in B9, and unsubscribe rate in B10. Label each metric in column A.
SheetXAI calls Kit's stats API and writes the labeled table. Your baseline is ready before the client intro call.
What You Get
A labeled baseline metrics table with every key account stat:
- Emails sent and delivered — top-of-funnel volume
- Open rate and unique opens — list health at a glance
- Click rate — content engagement
- Unsubscribe rate — the uncomfortable signal your client needs to see
The labeled layout in column A means the client can read the workbook without explanation. Paste it into your audit deck and the conversation starts immediately.
What If the Data Is Not Quite Ready
Audit baselines for new clients always have wrinkles. SheetXAI handles them inline.
When you need a month-by-month breakdown instead of a single 90-day total
Fetch Kit email stats for each of the last 3 calendar months separately. Write one section per month — month name in column A, sent, delivered, open rate, click rate, and unsubscribe rate in column B. Separate each month with a blank row.
When you need to benchmark the client's stats against industry averages
Fetch Kit account email stats for the last 90 days and write them into the Baseline tab. In the Benchmark tab, write a comparison table: metric name in column A, client value in column B, typical industry benchmark in column C, and "BELOW BENCHMARK," "AT BENCHMARK," or "ABOVE BENCHMARK" in column D.
When you need to pull stats for multiple Kit accounts into one workbook
Fetch the 90-day email stats for my primary Kit account and write them to the Client A tab. Repeat for the secondary Kit account and write to the Client B tab. Include sent count, open rate, click rate, and unsubscribe rate in each.
When you want the full audit starter: stats, top broadcasts, and a narrative in one pass
Fetch Kit account email stats for the last 90 days and write the labeled table into the Stats tab. Fetch all sent Kit broadcasts in the same window and write their name, open rate, and click rate into the Broadcasts tab, sorted by open rate descending. In the Summary tab, write a 3-4 sentence paragraph summarizing account health based on the stats and the top and bottom performing broadcasts.
The pattern: pull everything you need for the audit in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank audit workbook, then ask SheetXAI to pull your Kit account stats into it. The Kit integration is included in every SheetXAI plan. For broadcast-level analysis, see how to pull Kit broadcast performance data into Excel or the Kit in Excel overview.