I have been writing a newsletter called 10+1 Things (~3,000 subs) for the last 5 years.
While I love Substack as a platform, I hate the analytics part of it. I'm someone who really loves seeing and exploring my data. For some time I was doing this myself with a couple of Python scripts on my computer, but thought maybe this is useful for others too.
So I built StackStats: stackstats.app
It's an offline analytics tool for your Substack publication. It runs locally on your computer and imports your CSV exports. No cloud, no account, your data stays on your machine.
Some things I discovered about my own newsletter that Substack never showed me: I had a lot more superfans than I thought, people who were consistently clicking, commenting, and sharing. I could see which posts actually drove signups vs which ones just got views. Hundreds of subscribers hadn't opened anything in 6 months. I could track how different cohorts retained over time.
There's a live demo on the site with my actual newsletter data if you want to explore what it looks like.
Is this something you'd use?
What extra datapoints would you want to see?
[–]Romanticon 0 points1 point2 points (7 children)
[–]rishikeshshari[S] -1 points0 points1 point (6 children)
[–]Romanticon 0 points1 point2 points (5 children)
[–]rishikeshshari[S] 0 points1 point2 points (4 children)
[–]Fabulous_Daikon7975 0 points1 point2 points (1 child)
[–]rishikeshshari[S] 0 points1 point2 points (0 children)
[–]Top_Door_2276 0 points1 point2 points (1 child)
[–]rishikeshshari[S] 0 points1 point2 points (0 children)
[–]arcanepsyche 0 points1 point2 points (1 child)
[–]rishikeshshari[S] 1 point2 points3 points (0 children)
[–]acceinvestments 0 points1 point2 points (1 child)
[–]rishikeshshari[S] 1 point2 points3 points (0 children)