HN Showcase
Back to browse
StackStats – Analytics tool for Substack writers, runs 100% locally

StackStats – Analytics tool for Substack writers, runs 100% locally

by rishikeshs·Mar 17, 2026·1 point·0 comments
Visit ProjectView on HN

AI Analysis

●●SolidNiche GemCozySolve My Problem

Bot-filtered open rates fix GoogleImageProxy inflation that Substack's dashboard ignores.

Strengths
  • •Bot-filtered open rates correct GoogleImageProxy inflation—author saw 51% fake opens
  • •Local-only processing means no API keys, no data leaving your machine ever
  • •AI insights support any provider including offline Ollama—no vendor lock-in
Weaknesses
  • •Manual CSV export workflow instead of automatic syncing limits daily utility
  • •Electron app is heavier than a web alternative for a dashboard tool
Category
Productivity
Target Audience

Substack newsletter writers and creators

Similar To

Substack native analytics · ConvertKit analytics · Beehiiv analytics

Post Description

Hi HN,

I've been writing on Substack for about 5 years with close to 3,000 subscribers. The platform has grown a lot but the analytics have barely changed, and there's still no API support.

I like to explore data, and Substack lets you export some analytics as CSVs from the creator dashboard. I've been doing that for a while, mostly with local scripts, but realized this could be useful to other writers as a simple local tool.

So I built StackStats. A better analytics app for Substack Writers.

You export your CSVs, point it at the folder, and everything populates. Growth sources, engagement scoring, cohort retention, bot-filtered open rates (GoogleImageProxy alone inflated my opens by ~51%), best day/hour to post, and more.

There's an optional AI feature for deeper insights. Totally optional, but why not go with the hype :D. You can use any provider (Claude, GPT-4, Gemini, Groq, OpenRouter) or run Ollama fully offline. BYOK, no lock-in.

Built with Electron and vanilla JS. No cloud, no account, no telemetry. All data stays on your machine.

You can see a live demo with my actual newsletter data here: https://demo.stackstats.app

Happy to answer questions about the app!

Similar Projects

SaaS●Mid

Pluma – Write professional articles for your ideas and projects

Clean typography and a block-based editor that explicitly supports code blocks and rendered math give Pluma immediate appeal for technical posts. It bundles useful extras — subdomains, a discover feed, newsletter and markdown export — so you can publish and distribute without stitching services together. Still, the product lives in a crowded field (Ghost, Hashnode, Substack) and I didn't see a single standout feature that demands switching over yet; try the demo to judge the editor's "snappiness."

SlickNiche GemShip It
nader0913
103mo ago