Substack Data + Publication Intelligence
Your Substack data can tell you what is happening. It cannot tell you what it means.
18 months of subscriber-level analysis
1,000–191,000+ subscribers
3 case studies below
Your dashboard
can report
what happened
Most creators can feel when something is off. The work is figuring out what to do next.
It can't tell you what it means.
The Gap Nobody Talks About
Substack shows you numbers. It doesn’t show you what they mean for your writing.
Your dashboard tells you how many people opened last Tuesday’s post. It doesn’t tell you that your free readers haven’t viewed a single page of your archive in six months. It doesn’t tell you that the people who found you through Notes behave completely differently than the ones who came from your website. It doesn’t tell you that your paid subscribers are 3x more active than your free list — and what that gap means for every editorial decision you’re about to make.
I’ve spent the past 18 months inside the raw CSV data of Substack publications across every size and niche — not the dashboard summaries, the actual subscriber-level behavior. What I’ve found is a set of patterns that change how you think about what to write, who you’re writing for and how your publication actually grows.
An editorial partnership puts those patterns to work for your publication specifically — linking your audience data to your public-facing content so every strategic decision is grounded in what’s real, not what you’re guessing.
I started seeing the same thing across very different Substack publications
For nearly two years, I analyzed subscriber-level data for Substack publishers of very different sizes, audiences and business models.
Again and again, the headline metric was only the beginning of the story. The useful insight came from asking what that number meant inside this particular publication.
Here are three examples.
Case Study 1
7,654 free subscribers | Wellness & contemplative practice
What the data showed
Free readers averaged 0.02 post views — virtually zero engagement. Nearly 8,000 people had signed up, but almost none were reading. Paid subscribers showed only modestly better engagement. The conversion rate sat at 0.76%.
What that actually meant
The publication had become digital maintenance — people subscribed to an idea of the work without engaging with the work itself. The recommendation was to fundamentally reshape the model into something that felt alive and generative rather than obligatory. The problem wasn’t the audience. It was the container.
Case Study 2
Size: 191,000+ free subscribers | Media & mindfulness
What the data showed
78% of the free list — over 149,000 people — had zero post views in 30 days. They were opening emails (6+ per month) but never clicking through to the publication itself. Meanwhile, paid subscribers were 3x more active and those who did upgrade converted fast — within 26 to 34 days. Over 60% of the free list came from a single Substack discovery channel.
What that actually meant
The subscriber count looked like a success story. The engagement data told a different one — a massive audience consuming passively in the inbox, never encountering the archive, the community, or the full depth of the publication. The strategy shifted to archival re-engagement campaigns, restructuring the free-to-paid content ratio and building deliberate click-through behavior into the email experience.
Case Study 3
23,000+ free readers | Consciousness & contemplative practice
What the data showed
96% of free readers — over 22,000 people — were completely passive. Yet paid subscribers were deeply engaged: 20+ post views over six months, 6+ active days per month and a fast 50-day upgrade timeline. Reader shares were the single largest paid acquisition source, outperforming every other channel. The creator’s existing audience (from books, teaching and a personal site) converted at a higher rate than Substack-native discovery.
What that actually meant
The newsletter was competing with the creator’s own ecosystem — books, courses, video, live events — without answering the question: why this, specifically? The data showed that people who already knew the creator’s work upgraded fast and stayed engaged, but passive readers needed a reason to choose the newsletter over everything else. The strategy became about defining the publication’s unique editorial purpose — not as another channel, but as its own container. When you already have a platform, your newsletter has to earn its own reason to exist.
A publication is more than its data
No single metric can tell you whether a publication is working because a publication is a system.
To understand one, you have to be able to look across six different areas at once.
Purpose
What are you actually building?
The role of the publication, what belongs inside it and what rhythm you can sustain.
Evidence
What is the publication showing you?
The numbers that deserve attention, what normal looks like for your publication.
Audience
Who is gathering around the work?
What you know about them, what you're assuming and what you still need to learn.
Introductions
What does a new reader encounter?
What someone understands when they arrive, what invites them farther in, and where the publication is creating unnecessary friction.
Circulation
How does the work travel?
How people discover it, how you deepen existing relationships and which forms of promotion work.
Integration
What happens next?
What you keep, change, stop, test, and carry into the next publishing season.
Publication Intelligence is the practice of reading these things together.
What this work taught me
The more publications I studied, the less I believed in universal benchmarks.
Context wasn't something you added after looking at the data.
Context was what made the data meaningful at all.
Built for transition, growth and reinvention
Nobody reads their data when everything is fine. You read it when something is about to change, or already has: a book is coming, a team is moving onto Substack, a publication that used to grow has gone quiet — or has started moving and no one can say why.
Transition, growth, reinvention. That's the work I do, and the Substack Data Audit is where it starts: an editorial read of your publication's data, the way an editor reads a manuscript — for the pattern, and for what it asks of you next.
Who the Substack Data Audit is built for
The author with a launch ahead. A book asks your readers to do something — buy, share, show up. Before you ask, you should know who is actually there, how warm they are and which pieces have already done the work of introducing you. Six months out, that's strategy. The week the book ships, it's too late.
The traditional media group. You have the dashboard. What you don't have is someone whose job is to read it. I spent nearly twenty years in newsrooms and publishing houses before I spent the past two inside Substack's raw subscriber data, and I know what a team needs: segments that mean something, referral numbers you can trust next to your social reporting, and a read that connects editorial decisions to what paid readers actually do. The audit is the first read. For teams that want it, it becomes an ongoing one.
The independent author building momentum. Something has shifted, or something is working and you'd like to know why before it fades. The audit shows you what's alive inside your publication right now and how to build on it with the readers you already have, instead of chasing the ones you don't.
What the Substack Data Audit reads
Where your readers come from, and how the mix is shifting
How your free readers actually behave: opens versus post views, days active, the share who've gone quiet
How long readers take to upgrade, and from where
What your paid readers do once they're in
When people leave, and where a retention touch belongs
What your archive is still doing, months after you published it
Then we talk strategy: nurturing free readers toward paid, keeping paid readers close, putting your archive and your timing to work — and what to do first.
Book Your Substack Data Audit
Book below. Directions for exporting two Substack files arrive with your confirmation. I read your data before we meet, and we spend 60 minutes together on what it means for your voice, your next season of publishing and the readers you already have. You leave with next steps for your free readers and your paid ones, plus a recording and a searchable transcript.
If your publication is only a few months old, there isn't enough history to read yet. Write first, then come back.