The Ultimate Substack Content Planner & Stats Tracker

Teaching you how to be a freak in the sheets.

Let’s face it, Substack’s analytics and content planning capabilities are basic. If you’re serious about growing a newsletter your audience connects with, you’ll need to run on more than vibes.

You’ll need to pay attention to what’s working. After all, your newsletter isn’t about you—it’s about your reader.

And while you might get a good idea of what’s landing based on comments, restacks and views, the ability to drill down further and plan your content accordingly is invaluable.

That’s why I created The Ultimate Substack Content Planner & Stats Tracker.

It’s a tool I share with my clients to bridge that stats gap and help them learn from their audience. And now I’m sharing it with paid and free subscribers of Virtually Annie.

Using this Google Sheet you’ll be able to:

• Plan, track and analyse up to three Substacks at once.

• Capture any ideas you have for posts, notes, podcasts etc.

• View your stats at a monthly glance including:

  • Monthly Followers

  • Monthly All Subs

  • Monthly Paid Subs

  • Monthly Open Rate

  • Monthly Engagement Rate

  • Monthly Click Rate

• View your planned content for the month in a printable format.

• Print your bank of content ideas and published posts.

• Keep track of individual series posts (eg work out how a challenge performed).

Want to know how to use these stats to best analyse your stack and create posts your readers love?

Stay subscribed for an upcoming post.

How Pro Authors Plan Their Substack Newsletters (and Avoid Burnout)

---

Video Tutorial/Walkthrough

Video walkthrough notes:

• I cleaned out the dummy data to save you the step.

• The grey cells in the month section aren't for use (I fixed the issue I mentioned).

• Create a new spreadsheet annually to keep your stats clean. I may release an updated version next year based on feedback.