Newsletter Creator Revenue & Growth Tracker
Your newsletter as a business, on one screen.
Most newsletter templates track what you published. This one tracks what you earned.
Eight tabs in Google Sheets, built for writers earning from paid subscriptions, sponsorships, affiliates and products all at once, the situation almost every monetizing newsletter ends up in, and the one almost no template is designed for.
What's inside:
- Monthly Overview dashboard driven by a single dropdown, subscribers, paid conversion rate, revenue by stream, net profit, and two charts
- Subscriber Growth logging with milestones that flag themselves as you cross them
- Revenue Per Subscriber calculator and trend view
- Content Calendar with a send-date cadence helper and open/click rate tracking
- Sponsorship Tracker running Pitched to Confirmed to Ran to Paid, feeding your revenue totals automatically
- Combined Revenue Streams view and a Simple P&L with an annual rollup
Warm, readable design, no clinical blue-grey dashboards. Plain-language labels throughout, because being good at newsletters doesn't mean being good at spreadsheets.
Comes pre-filled with seven months of sample data from a fictional newsletter so you can watch every formula work before trusting it with your own numbers. Clearly labeled, delete it in one pass.
Works with: Substack, beehiiv, ConvertKit, Kit and Ghost. Requires a free Google account.
This template was designed with AI-assisted tools and reviewed by a human creator.
Questions? Message the shop, happy to help.
