Newsletter Writer Templates
Subscriber growth, sponsorship slots, and churn — all in one place, so you always know exactly who’s paying and who’s about to leave.
| Issue # | Subs | Open Rate | |
|---|---|---|---|
| 1 | Issue 41 | 4,812 | 48.2% |
| 2 | Issue 42 | 4,930 | 51.0% |
| 3 | Issue 43 | 5,004 | 47.6% |
Four systems for four different jobs
Each one is a standalone spreadsheet — use one or use all four together.
Subscriber Growth Tracker
Week-over-week subscriber counts with growth rate and source tracking, so you know exactly what’s moving the needle.
| Week | Subs | Growth | |
|---|---|---|---|
| 1 | Wk 41 | 4,812 | +2.1% |
| 2 | Wk 42 | 4,930 | +2.5% |
- ✓ Auto-calculated week-over-week growth %
- ✓ Source tagging (referral, social, paid)
- ✓ Milestone markers
Sponsorship Slot Calendar
Every ad slot you’ve sold, who bought it, when it runs, and whether they’ve paid — in one calendar view.
| Issue | Sponsor | Status | |
|---|---|---|---|
| 1 | #43 | Fernway Journal | Paid |
| 2 | #44 | Basil & Bloom | Pending |
- ✓ Slot-by-issue calendar layout
- ✓ Payment status per sponsor
- ✓ Sponsor contact log built in
Open Rate & Churn Log
Issue-by-issue open rate and unsubscribe tracking, with space for notes on what worked and what didn’t.
| Issue | Open Rate | Unsubs | |
|---|---|---|---|
| 1 | #43 | 48.2% | 12 |
| 2 | #44 | 51.0% | 8 |
- ✓ Open-rate trend by issue
- ✓ Unsubscribe count and rate
- ✓ Notes column for what changed
Newsletter Revenue Dashboard
Combines sponsorship income and paid-subscription revenue into one dashboard so you see total newsletter income at a glance.
| Month | Sponsorship | Subs Rev | |
|---|---|---|---|
| 1 | Jun | $1,200 | $890 |
| 2 | Jul | $1,450 | $960 |
- ✓ Sponsorship + subscription combined view
- ✓ Monthly recurring revenue calculation
- ✓ Year-over-year comparison tab
Why a spreadsheet, not another login
SaaS tools are great until the price triples or the company shuts down. A spreadsheet just keeps working.
You own it, forever
No subscription cutoff, no data export scramble. It’s a file on your computer, not a rented seat.
Runs where you already are
Opens straight in Excel or Google Sheets — nothing new to log into, nothing new to learn.
Edit anything, anytime
It’s your formula, not our roadmap. Rename a column, add a tab, make it yours.
Common questions
Does this work with Substack, ConvertKit, beehiiv, etc.?
Can I track paid subscriptions and sponsorships in the same sheet?
How do I import my existing subscriber history?
Is there a version for a weekly vs monthly send schedule?
Pick a newsletter template. Open the sheet. Start today.
No account required to preview — see exactly what you’re getting before you download anything.