The Analytics System Every Solopreneur Needs
Most Substack writers check their open rate and move on. Here is the analytics and review system that turns numbers into decisions.
Access your FREE Solopreneur Success Hub - your subscribers-only comprehensive command center for building and scaling a successful one-person business.
I created this all-in-one toolkit for building a profitable one-person business, something I wish existed when I first started, and it saves me 20+ hours a week.
Now, it’s yours… FREE!
This is post 6 of 18 in the Solopreneur Systems Series.
Paid subscribers get the full setup guide, tool recommendations, and maintenance schedule for every system.
Section 1: What the System Is
The metric that fools most Substack writers
You published six times last month.
Your open rate looks fine.
You feel like things are working.
Then a subscriber upgrades. You have no idea which post pushed them over.
You have no idea which topic drives paid conversions.
You have no idea which content format your readers share.
You are flying with a covered windshield.
That is the problem the Analytics and Review System solves.
This is post 6 of 18 in the Solopreneur Systems Series. Every post covers one system a solopreneur needs to run a one-person business without burning out.
This week: the system that tells you what is actually working.
What it is
The Analytics and Review System is a structured, repeatable process for collecting, reading, and acting on the data your newsletter produces.
Not just checking numbers. Turning numbers into decisions.
Most solopreneurs treat analytics as a passive activity. You look at the dashboard, feel good or bad depending on the numbers, then go write the next post. Nothing strategic gets done…
A real analytics system has four components:
A daily check that takes under two minutes
A weekly review tied to one specific decision
A monthly deep analysis that shapes your next 30 days
A structured way to act on what you find, not just observe it
Why it matters for solopreneurs
You do not have a team. You do not have a marketing department pulling reports and flagging anomalies.
Every content decision, every format choice, every topic pick, all of it falls on you.
Without a review system, you repeat what feels good instead of what performs.
You keep writing content that your readers open but never share. You miss the posts that are quietly driving paid upgrades. You make decisions based on emotion and recency.
When this system runs well, you know exactly which topics to write more of, which formats to retire, and which posts to push harder.
You stop guessing. You start deciding.
Section 2: How I Set Mine Up
Three layers, one decision per review
I did not build this system all at once. For a long time, I checked the Substack dashboard when I remembered, felt relieved if the open rate was above 40%, and moved on.
That worked when I had a few hundred subscribers. It stopped working when the audience started growing.
Here is what I use now.
Layer 1: Daily (Substack mobile app)
Every morning, I open the Substack app on my phone. I check subscriber count, recent post opens, and any new paid upgrades. This takes under two minutes.
I am not making decisions here. I am staying oriented. If something spikes or drops, I notice it. I file it mentally and pick it up in the weekly review. The daily check is about pattern recognition, not analysis.
Layer 2: Weekly (Google Analytics 4)
I connected Google Analytics 4 to my Substack. The setup is straightforward and documented in a post I wrote specifically on this.
Once a week I open GA4 and look at one thing: traffic source by post.
Which posts are getting external views?
Which posts are pulling readers in from search or social?
The native Substack stats show you how your subscribers are engaging. GA4 shows you how the world is finding you.
This distinction matters. A post with a low open rate but high external traffic is doing a different job.
It is building discovery, not engagement. GA4 is where I catch that.
Layer 3: Monthly (CSV export plus Claude)
At the end of every month, I export my post stats from Substack as a CSV file. Then I drop that file into my Claude Project.
This is where the real analysis happens. I have a detailed analytics prompt at the bottom of this post that I use for this.
It is not a generic “summarize this data” instruction.
It is a structured five-pillar analysis covering:
top performers,
hidden anomalies,
audience segment differences,
title patterns, and
a four-action plan I take into the next month.
The output tells me things the Substack dashboard never surfaces.
Which posts drove the most paid upgrades.
Which titles are failing in a pattern.
Which posts have high external sharing potential.
Which content is being opened but not clicked.
I take that analysis and make four decisions.
What to write more of.
What to repackage or resend.
What to retire.
What to distribute harder.
What did not work: relying solely on native Substack stats.
They are good for email performance.
They tell you nothing about discoverability, sharing, or how your content performs outside your list.
Right now this system tracks a newsletter growing at 50 to 100 new subscribers per week.
The monthly CSV analysis is what lets me see the patterns behind that number, not just the number itself.
Section 3: How to Build Yours
Part A: Readiness Check
Before you build the system, answer these
Most newsletter writers think they have an analytics setup because they have access to a dashboard.
These questions will tell you whether you have a system or just a login.
When you sit down to plan next week’s content, what data do you look at? If the answer is “nothing specific” or “whatever I remember from the last post,” you are publishing without a feedback loop.
Do you know which three posts from the last 90 days drove the most paid upgrades? Not opens, not clicks. Paid upgrades. If you do not know, you have no idea what is actually converting your audience.
When a post underperforms, what do you do with that information? If the answer is “nothing” or “I feel bad about it,” you are collecting data you never act on.
Do you track your content differently by audience type? Free subscribers and paid subscribers behave differently. If you are reviewing one number that mixes both, you are misreading what each group needs.
What would have to be true for you to change what you publish next month? If you cannot name a specific metric or threshold that would change your content decisions, your review process is decorative, not functional.
If those questions surfaced something uncomfortable, that is the point. You are missing a system to use it.
You now know where your gaps are.
The rest of this guide covers how to close them.
What follows includes the step-by-step setup for all three review layers, tool recommendations at every budget level, the five most common analytics mistakes solopreneurs make, a maintenance schedule that fits inside 30 minutes a week, and a real working example of what my monthly review produces.
The resources in the Premium Vault sit directly below this guide as the implementation layer.
The Email Marketing Accelerator Kit covers the sequences that move free subscribers toward paid.
The Substack Accelerator Kit covers the positioning and upgrade mechanics in detail.
The Solopreneur Diagnostic Matrix helps you identify exactly where your revenue bottleneck is.
This guide tells you how to build the system.
The Vault gives you the tools to run it.
If you are a paid subscriber and have not worked through those resources yet, start there after finishing this post.
Here is a preview:
The setup starts with one rule: separate your review cadence from your publishing cadence. Most writers check their stats right after publishing a post, when they are emotionally invested in the result. That is the worst time to make content decisions. Instead
Become a paid subscriber to read the full guide.
This is post 6 of 18 in the Solopreneur Systems Series.
Paid subscribers get the full setup guide, tool recommendations, and maintenance schedule for every system in the series. Upgrade here:
Here is a question to leave you with: when you look at your last 10 posts, do you know which one did the most to grow your paid subscriber count? Not which one got the most opens. Which one converted readers into paying subscribers.
If you know the answer, reply and tell me what made it work. If you do not, that is the exact gap this system closes.
I read every reply.
You’re doing everything. But nothing is moving?
You are doing everything. But nothing is moving.
That is not a motivation problem.
Most solopreneurs are learning from everywhere and getting nowhere. Too much information. No clear system connecting effort to results.
You have everything it takes. You just do not have a clear system yet.
That is what paid subscribers get. Every system, playbook, prompt, and template. All inside the Premium Vault.
All for $79/year. That’s $6.58/month.
Upgrade now and unlock the Premium Vault.
Part B: The Analytics and Review System Setup Guide
How to use this guide
This guide walks you through the full three-layer analytics system: daily, weekly, and monthly.
Work through the setup steps in order the first time.
After that, use the maintenance schedule at the end as your ongoing reference.
One resource powers the monthly layer: the Substack Analytics Prompt included in Step 4. This is the exact prompt I use every month to turn a raw CSV export into four content decisions. Copy it once, save it somewhere accessible, and use it every time you run your monthly review. It works with Claude, ChatGPT, or any LLM you already use.
One rule before you start: separate your review cadence from your publishing cadence. Most writers check their stats right after publishing, when they are emotionally invested in the result. That is the worst time to make content decisions. Schedule your reviews on a different day from your publishing day. The distance matters.
A Real Example: What My Monthly Review Produces
At the end of May, I exported my Substack CSV and uploaded it to my Claude Project with the Substack Analytics Prompt.
The analysis flagged something I had missed manually: two posts about AI workflows for solopreneurs had driven the highest number of paid upgrades in the last 90 days, but I had not published in that topic cluster for six weeks.
The four-action plan output gave me this:
Double-down framework: write a follow-up post on AI workflows specifically for newsletter writers. The audience signal was there. I had stopped feeding it.
Monetization move: one post on Notion templates had 40% higher conversion than average but had only been seen by 30% of my list. Flag it for a resend to non-openers.
Distribution lever: a post on solopreneur systems had external traffic 3x higher than its open rate implied. It was being shared beyond my list. I pinned it as a recommended post and added it to my welcome sequence.
Optimization fix: posts with generic titles like “What I Learned This Month” were consistently in the bottom 10 by click rate. The format stayed. The title structure changed.
That review took 40 minutes total: 5 to export and upload, 2 for the analysis to generate, 30 to read and write my four decisions, and 3 to update my Notion content calendar.
The next month’s content plan looked different from the previous month’s.
That is the sign the system is working.
Step-by-Step Setup
Step 1: Connect Google Analytics 4 to your Substack
Go to your Substack settings, find the Analytics section, and paste your GA4 Measurement ID. If you do not have a GA4 property yet, create one at analytics.google.com. The Measurement ID starts with G-.
Why this matters: Substack’s native stats track what happens inside your email. GA4 tracks what happens on your public post pages. These are two different audiences. Your email subscribers and the people finding your posts through search, shares, or Substack recommendations behave differently. You need both data sets.
Decision point: if you have under 300 subscribers and publish less than once a week, skip GA4 for now. Come back when you have at least 20 published posts. Before that threshold, the data is too thin to be useful.
Step 2: Install the Substack mobile app and configure your daily check
Download the app and spend five minutes learning where the stats live. On the home tab you see your subscriber count. In the post view you see opens and clicks per post.
Create a small habit trigger. I check mine during my first coffee. Same time, same place, every day. Under two minutes.
What to look for daily:
any unusual spike in subscribers,
any paid upgrade notification,
any post getting significantly more or less engagement than usual.
If something looks off, file it mentally and pick it up in the weekly review.
Step 3: Set a fixed weekly review slot
Pick one day that is not your publishing day. Block 20 minutes. This is your Google Analytics day.
Open GA4.
Go to Reports, then User Engagement, then Pages and Screens.
Set the date range to the last 7 days. Sort by Views.
You can also go to:
Generate leads
User acquisition
Ask one question: which posts are getting traffic from outside my subscriber list?
Any post with views significantly higher than your average subscriber count is reaching people beyond your list.
That post is doing discovery work. Note the topic and the title format.
Decision point: if all your traffic is coming from within Substack and nowhere else, your posts are serving your existing subscribers but not building new audience. That is useful information for how you think about your content mix.
Step 4: Build your monthly export workflow
On the last day of each month, go to your Substack dashboard, navigate to:
Audience
Stats
Posts, and
Export the CSV.
The file contains every post you have published with opens, clicks, views, subscriber conversions, and estimated value.
This CSV is your raw material. On its own it tells you very little. What you do with it is what matters.
Open your Claude Project (or any LLM you use) and upload the CSV as a file attachment.
Then paste in the prompt below.
The Substack Analytics Prompt
This is the exact prompt I run every month. It is structured around five pillars that move from surface-level performance to hidden patterns to a four-action plan. Change the CSV filename in the first paragraph to match your own export. Everything else runs as written.
