The Scenario
You are a newsletter analyst. Your client is presenting to investors in three weeks. They want a 6-month subscriber growth chart in Excel — a date-indexed table showing daily net new subscribers from Kit that feeds a line chart.
There is no built-in date-range growth export in Kit's UI. The data is in the API, but you have never pulled it before.
The bad version of getting this data:
- You search Kit's help docs for "export subscriber growth by date"
- You find there is no daily growth export in the UI
- You look at the API docs, find the stats endpoint, realize you need to paginate
- You consider building a script, estimate two hours
- You tell the client the chart will be ready "next week."
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI calls Kit's growth stats API and writes the date-indexed table directly into the workbook.
Open the SheetXAI sidebar and type:
Fetch Kit subscriber growth stats for the past 180 days and write one row per day into this workbook. Include date in column A, total subscriber count in column B, new subscribers that day in column C, and unsubscribes that day in column D. Sort by date ascending.
SheetXAI calls Kit's growth endpoint, pulls the 180-day window, and writes the date-indexed table. Add a chart using column A as the x-axis and column B as the y-axis. Done.
What You Get
A 180-row growth table, one row per day, ready to feed a line chart:
- Date — one per day in column A
- Total subscriber count — the running count in column B, which drives the line chart
- New subscribers — net adds that day in column C
- Unsubscribes — churn signal in column D
The total subscriber count column is the chart series. New subscribers and unsubscribes give you the story behind the trend line.
What If the Data Is Not Quite Ready
Growth data across a 180-day window sometimes needs reshaping for investor presentations. SheetXAI handles it inline.
When you need weekly averages instead of daily rows
Fetch Kit subscriber growth stats for the past 180 days. Aggregate to weekly totals — one row per week showing the week starting date in column A, total new subscribers in column B, total unsubscribes in column C, and net growth in column D.
When you need to align the growth window with a specific date range
Fetch Kit subscriber growth stats from January 1, 2026 to June 30, 2026. Write one row per day — date, total subscribers, new subscribers, unsubscribes — sorted by date ascending.
When you want to annotate the chart data with broadcast send dates
Fetch Kit growth stats for the past 180 days and write the daily table into the Data tab. Fetch all Kit broadcasts sent in the same window and write their send dates and names into the Campaigns tab. In the Data tab, add a column E with the broadcast name for any date matching a send date, blank otherwise.
When you need the full investor-ready analysis: data, chart config, and narrative
Fetch Kit growth stats for the past 180 days. Write the daily table into the Data tab. In the Summary tab, write: total subscriber count at start and end of the period, net growth over 180 days, the highest single-day new subscriber count and when it happened, the highest single-day unsubscribe count and when it happened, and a two-sentence growth narrative suitable for an investor update.
The pattern: pull the data, shape it for the audience, and write the narrative 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 subscriber growth stats into it. The Kit integration is included in every SheetXAI plan. For broadcast-level analysis, see how to pull Kit broadcast stats into Excel or the Kit in Excel overview.