One issue's stats tell you nothing; the trend tells you everything. This dashboard logs the metrics that matter per issue — open rate, click rate, unsubscribes, and net growth — so you can spot what's working and catch problems before they compound.
What you get
A per-issue log of open rate, click rate, and unsubscribes
Benchmark targets so you know if a number is good or bad
A trend view that turns scattered stats into a clear direction
Editable CSV for Google Sheets or Excel, plus a branded summary PDF
How to use this template
1
Log every issue. Record the core metrics 48 hours after each send, when opens and clicks have mostly settled. Consistent timing keeps comparisons fair.
2
Compare to your own baseline. Judge each issue against your rolling average, not industry numbers. Your audience and niche set your real benchmark.
3
Investigate the outliers. When an issue beats or misses your average, note why in the dashboard. Patterns in the notes become your playbook.
4
Review the trend monthly. Once a month, look at the direction of open rate, click rate, and net growth together — the trend matters more than any single send.
What's inside
Here's a preview. Unlock the free download to get all 3 sections (2 more below).
Per-issue metrics log
One row per issue, logged ~48 hours after sending. Net growth = new subscribers minus unsubscribes that week.
Subscriber count is a vanity number until you know where they came from and how many stay. This tracker logs gross adds, unsubscribes, and net growth by source each week so you double down on the channels that actually work.
Inactive subscribers quietly drag down your open rates and your sender reputation. This 3-email win-back flow gives dormant readers a reason to come back — and a clean way to remove the ones who won't, so your deliverability actually improves.
When sponsors ask for your rates, a clear rate card makes you look professional and protects your pricing. This template lays out your audience stats, placement options, and package pricing so you can quote confidently and close faster.
Open rate, click rate, unsubscribe rate, spam-complaint rate, and net subscriber growth per issue. Click rate and replies are the most reliable signals of real engagement, since open rate has become noisy due to privacy protections.
Why is my open rate unreliable now?
+
Apple's Mail Privacy Protection and similar features pre-load tracking pixels, registering opens whether or not the email was truly read. Treat open rate as a rough trend and lean on click rate, replies, and conversions to measure real engagement.
How often should I review my metrics?
+
Log every issue, but review the trend monthly. Single sends are noisy; the direction of your open rate, click rate, and net growth over several issues tells you whether your newsletter is genuinely getting stronger.