DEV Community

Otto
Otto

Posted on

The 8 SaaS Metrics Every Solo Founder Must Track (With Google Sheets Template)

#webdev #business #startup #productivity

The 8 SaaS Metrics Every Solo Founder Must Track (With Google Sheets Template)

Building a SaaS solo? You're wearing 10 hats at once.

Product. Marketing. Sales. Support. Finance.

It's overwhelming — and most solo founders don't track the numbers that actually matter. They track vanity metrics (page views, signups) while their business slowly dies.

Here are the 8 metrics that tell you the truth about your SaaS.

Why Metrics Matter More When You're Solo

When you're a team of one:

  • You can't afford to waste time on things that don't work
  • You need clear signals to make fast decisions
  • You have no one to sanity-check your intuitions

Metrics replace the team discussions you're not having.

The 8 Essential SaaS Metrics

1. Monthly Recurring Revenue (MRR)

What it is: The predictable monthly revenue from subscriptions.

Formula: MRR = Number of subscribers × Average monthly price

Why it matters: It's your business health indicator. Track it daily.

Healthy growth: 10-20% MoM for early-stage SaaS.

Example:
100 subscribers × €29/month = €2,900 MRR
Enter fullscreen mode Exit fullscreen mode

2. Churn Rate

What it is: The percentage of subscribers who cancel each month.

Formula: Churn = (Cancelled subscribers / Total subscribers at start) × 100

Benchmarks:

  • < 2%/month = Great
  • 2-5%/month = Acceptable
  • > 5%/month = You have a problem

The math is brutal: 5% monthly churn = 46% annual churn. Half your users gone every year.

3. Customer Acquisition Cost (CAC)

What it is: How much you spend to acquire one paying customer.

Formula: CAC = Total marketing spend / New customers acquired

Why it matters: If CAC > LTV, you're burning money with every sale.

Benchmark: LTV should be 3x CAC minimum.

4. Lifetime Value (LTV)

What it is: Total revenue from a customer over their entire relationship.

Formula: LTV = Average MRR per customer / Monthly churn rate

Example:

  • Average plan: €29/month
  • Monthly churn: 3%
  • LTV = €29 / 0.03 = €967

5. Net Revenue Retention (NRR)

What it is: Revenue retained + expansions, minus churned customers.

Formula: NRR = (Starting MRR + Expansion MRR - Churned MRR) / Starting MRR × 100

Benchmarks:

  • > 120% = World-class (customers spend more over time)
  • > 100% = Good (expansion offsets churn)
  • < 100% = Revenue shrinking

This is the metric VCs care most about.

6. Activation Rate

What it is: Percentage of signups who reach the "aha moment."

Why it matters: High activation = users understand your value = lower churn.

How to measure:

  1. Define your "aha moment" (first project created, first report generated, etc.)
  2. Track what % of new users reach it within 7 days

Benchmark: Aim for > 40% activation within first week.

7. Feature Adoption Rate

What it is: What % of users use your key features.

Why it matters: If your killer feature is unused, nobody knows your real value — and they'll churn.

Action: Low adoption → improve onboarding for that feature.

8. Revenue per Employee (You!)

As a solo founder, this is your personal productivity metric.

Formula: Revenue per employee = MRR / Number of team members (1 for solo)

Benchmark: At €10K MRR with 1 person = €10K revenue per employee. That's exceptional.

The Simple Tracking Spreadsheet

You don't need expensive tools. Here's your weekly tracking routine:

Monday metrics check (30 minutes):
□ Pull MRR from Stripe dashboard
□ Calculate new signups vs cancellations
□ Calculate this week's churn
□ Log CAC if you ran paid acquisition
□ Update your metrics dashboard
Enter fullscreen mode Exit fullscreen mode

Columns you need:

  • Week | MRR | Subscribers | New | Churned | CAC | NRR

Warning Signs to Watch

🚨 Red flags that require immediate action:

  • MRR declining 2+ weeks in a row
  • Churn suddenly spikes (check for product issue or competitor)
  • Activation rate drops (check for onboarding bug or UX regression)
  • CAC increasing while LTV stays flat

Tools Stack (Free to Start)

Metric Free Tool
Revenue Stripe (built-in) / Lemon Squeezy
Churn ChartMogul (free up to €5K MRR)
Activation PostHog (free tier)
Overall Google Sheets (manually)

Build Faster with the Right Foundation

If you're building a SaaS solo, having the right templates and systems is critical.

The MVP SaaS Roadmap (€19) gives you a complete 90-day plan to go from idea to first paying customers — including which metrics to focus on at each stage.

For AI-powered content and marketing that fills your funnel, the Freelancer AI Power Kit — 40 Prompts (€14.99) saves you hours every week.

The bottom line: You can't improve what you don't measure. Set up a simple Google Sheet this week, add these 8 metrics, and review them every Monday.

The founders who obsess over metrics outlast the ones who trust their gut.

Which metric surprised you most? Share in the comments 👇

Top comments (0)