The Scenario
You are a freelance email consultant. You just signed a new client. Day one of your engagement, you need a baseline metrics table — Kit account-level email stats for the last 90 days — in a Google Sheet so you can start the audit conversation.
Kit shows these numbers in its dashboard. But you need them in a sheet so you can compare month over month, annotate them, and share the sheet with the client's team without giving them 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 sheet
- You realize you do not know if the numbers are trailing 90 days or calendar month
- You go back to Kit to check the date range
- 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 sheet.
Open the SheetXAI sidebar and type:
Fetch my Kit account email stats for the last 90 days and write the totals into this sheet. 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, pulls the 90-day account-level metrics, and writes them into the labeled table you specified. Your baseline is done before the client intro call.
What You Get
A labeled baseline metrics table with every key account stat in one place:
- Emails sent and delivered — the top-of-funnel volume
- Open rate and unique opens — list health at a glance
- Click rate — content engagement
- Unsubscribe rate — the signal your client probably does not want to look at but needs to
The labeled layout in column A means the client can read the sheet without you explaining each cell. You paste it into your audit doc and the conversation starts immediately.
This table becomes the baseline. Next quarter, pull the same stats and compare. SheetXAI writes the new numbers and you have a before-and-after side by side.
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
Your client wants to see whether performance has improved or declined each month.
Fetch Kit email stats for each of the last 3 calendar months separately. Write one section per month into this sheet — month name in column A, then stats in column B for sent, delivered, open rate, click rate, and unsubscribe rate. Separate each month's section with a blank row.
When you need to benchmark the client's stats against industry averages
You want to flag which metrics are below typical email benchmarks.
Fetch Kit account email stats for the last 90 days and write them into the Baseline tab. Then in the Benchmark tab, write a comparison table: column A is the metric name, column B is the client's value, column C is a typical email industry benchmark (e.g. open rate ~30%, click rate ~2%, unsubscribe rate <0.3%), and column D writes "BELOW BENCHMARK," "AT BENCHMARK," or "ABOVE BENCHMARK" for each metric.
When you need to pull stats for multiple Kit accounts
You manage Kit accounts for three clients and want their baselines in one workbook.
Fetch the 90-day email stats for my primary Kit account and write them into the Client A tab with labeled rows. Then repeat for the secondary Kit account and write to the Client B tab. Include sent count, open rate, click rate, and unsubscribe rate for each.
When you want the full audit starter pack: stats, broadcast performance, and a narrative in one pass
You want the baseline metrics, a top-5 broadcast list, and a short paragraph summarizing account health — all before the client call.
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 short paragraph (3-4 sentences) 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, not three.
Try It
Get the 7-day free trial of SheetXAI and open a blank audit sheet, 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 a sheet or the Kit in Google Sheets overview.