5 Churn Prediction Metrics Every Solo Founder Should Track

If you've ever stared at a dashboard with 20 charts and wondered which number actually matters, you're not alone. Analytics paralysis is real. The good news: you don't need enterprise-level BI to predict churn and build a viable SaaS business. You need five metrics, calculated with spreadsheets you already have. This post gives you every formula in copy-paste form—no expensive tools, no assumptions about your data stack.

You're tracking too many metrics — here are the only 5 that matter

The SERP is dominated by comprehensive guides written for VP-level CS and finance teams. They assume you have a data team, a CRM with perfect hygiene, and time to build cohort analyses. Solo founders don't. This guide assumes you have a billing system (Stripe, Paddle, etc.), a list of customers, and 30 minutes on a Monday morning. That's it.

The five metrics: Customer churn rate, Gross MRR churn, Net Revenue Retention, LTV:CAC ratio, and Customer Engagement Score. Master these and you'll have a clearer picture of your business than most funded startups. We'll cover how to calculate churn rate, why revenue churn vs customer churn matters, and exactly what "good" looks like at your stage—without the finance jargon. Every formula in this post is copy-pasteable into a spreadsheet. No Excel macros, no SQL, no BI tools required. If you have a billing system and a list of customers, you have everything you need.

Metric 1 — Customer churn rate (the foundation)

Customer churn rate answers: What percentage of my customers left this period?

Formula (copy-paste ready):

(Churned Customers ÷ Customers at Start of Period) × 100

Annualized: 1 – (1 – Monthly Rate)^12

Example: 10 customers at month start, 1 churned. Monthly churn = (1 ÷ 10) × 100 = 10%. Annualized = 1 – (1 – 0.10)^12 ≈ 71%. Note: annualized churn is not simply monthly × 12. The formula accounts for compounding—each month you're churning from a slightly smaller base. This is how to calculate churn rate correctly when comparing to annual benchmarks.

What "good" looks like by your stage

Start here — calculate this one first, this Monday morning

Pull last month's customer count from your billing system. Count how many churned. Divide. That's your baseline. Track it monthly in a single row. No fancy tools required.

Concrete example: You had 80 customers at the start of January. Five churned. Customer churn rate = (5 ÷ 80) × 100 = 6.25%. Put that in a spreadsheet. Do it again next month. After three months you'll see a trend. If it's dropping, you're improving. If it's flat or rising, you have a retention problem before you need to worry about any other metric.

Metric 2 — Gross MRR churn (the honest number)

Revenue churn vs customer churn: Customer churn counts logos. Revenue churn counts dollars. They often tell different stories. A $50/mo customer and a $500/mo customer both count as "1" in customer churn—but losing one enterprise deal can hurt more than losing ten small accounts. Gross MRR churn is the honest number because it weighs every customer by what they pay.

Formula (copy-paste ready):

(Churned MRR + Contraction MRR) ÷ Starting MRR × 100

Churned MRR = revenue lost from cancellations. Contraction MRR = revenue lost from downgrades (customers who stayed but downgraded plans). Starting MRR = MRR at the beginning of the period. Pull these from your billing system—Stripe, Paddle, and similar tools all expose this data. If you're on annual billing, convert to MRR by dividing annual contracts by 12. The key is consistency: use the same period (usually calendar month) every time.

Benchmark: Under 2% monthly is excellent for B2B SaaS. Above 3% monthly and you're bleeding faster than most healthy businesses.

This metric surfaces the true cost of churn. If you're losing a few small accounts but one enterprise deal, gross MRR churn will spike. That's the signal you need. Example: $60K MRR at month start. You lost $1,200 in churned MRR and $600 in downgrades. Gross MRR churn = ($1,200 + $600) ÷ $60,000 × 100 = 3%. At that rate, you're replacing a meaningful chunk of revenue every year—and that's before considering whether new sales can keep up.

Metric 3 — Net Revenue Retention (the metric investors obsess over)

NRR answers: Is my existing customer base growing or shrinking—before any new sales?

Formula (copy-paste ready):

(Beginning MRR + Expansion – Contraction – Churn) ÷ Beginning MRR × 100

Above 100% means your existing base grows without new sales. Expansion (upsells, add-ons) outweighs churn and contraction. In plain English: take your MRR at the start, add what you gained from upsells, subtract what you lost from cancellations and downgrades, divide by starting MRR, multiply by 100. That's your NRR.

ARPU dependency: Only 2% of SaaS with ARPU under $25/month have NRR over 100%. Nearly 50% of those with ARPU over $1K/month achieve it. If you're selling low-ticket, NRR is harder—but not impossible with strong expansion playbooks. The net revenue retention formula rewards companies that grow within their existing customer base, which is why it's the metric investors obsess over when valuing SaaS.

For more stage-appropriate benchmarks, see our SaaS churn benchmarks guide.

Metric 4 — LTV:CAC ratio (are you building a viable business?)

LTV:CAC tells you if your unit economics work. Are you spending more to acquire a customer than they'll ever pay you?

LTV Formula (copy-paste ready):

ARPU ÷ Monthly Churn Rate

Example: $100 ARPU, 5% monthly churn. LTV = 100 ÷ 0.05 = $2,000. The formula assumes constant churn—in reality, churn often decreases over time as customers get more embedded. But for a quick check, this simplified version is accurate enough. Use your actual monthly churn rate from Metric 1; don't guess.

LTV:CAC benchmarks:

The 60-second LTV calculation you can do right now

Grab your average revenue per user (total MRR ÷ customers) and your monthly churn rate. Divide. That's LTV. Divide LTV by your CAC (total sales + marketing spend ÷ new customers) for the ratio. If it's below 3:1, you're either overpaying for acquisition or under-retaining. The LTV CAC ratio SaaS benchmark of 3:1 has held for years, though 2024 data from Benchmarkit shows the median creeping toward 3.6:1. Companies with 4:1 or better have more room to invest in growth without burning cash. Above 5:1, consider whether you're leaving money on the table by under-investing in acquisition.

Metric 5 — Customer Engagement Score (the only leading indicator)

Every metric above is lagging—it tells you what already happened. Customer Engagement Score (CES) is the only one that predicts churn before it occurs.

Formula (conceptual):

(w₁ × Logins) + (w₂ × Core Feature Use) + (w₃ × Support Signals)

Weight login frequency, usage of core features, and support sentiment. You assign weights based on what correlates with retention in your product—for many B2B SaaS tools, login frequency alone is surprisingly predictive. Start simple. The exact weights matter less than consistency and acting on the signal. Customers who reduce login frequency by 40% over 2 weeks are 3x more likely to churn within the next month.

Thresholds:

You don't need a perfect formula day one. Start with login frequency. If you have product analytics, add core feature usage. Tether's customer health scores combine these signals automatically—but you can approximate with a simple spreadsheet. Practical tip: build a "logins this period vs. last period" comparison per account. Flag anyone down 40% or more for a check-in before they cancel. New research on engagement score and churn correlation continues to reinforce that leading indicators beat lagging ones—act on drops in usage before the cancellation email arrives.

The compounding math of churn (why every percentage point matters)

This is the number that makes churn visceral:

At 5% monthly churn, only $0.54 of every dollar of MRR survives 12 months. At 2% monthly, $0.79 survives. That difference is the gap between a business that compounds and one that treads water. One common mistake: founders assume 1% monthly churn equals 12% annual. It doesn't. The conversion isn't linear—churn compounds. Use the table above when setting targets. If you're at 5% monthly, cutting to 2% doesn't just improve the number—it nearly doubles the revenue that sticks around. That's transformative for unit economics and growth.

The one-page dashboard that ties it all together

Imagine one view: all five metrics, color-coded green/yellow/red by stage-appropriate benchmarks. No tab-switching. No digging. That's the minimum viable dashboard. Most founders either track nothing or track everything—both are mistakes. The five metrics above, on a single page, give you everything you need to know whether your business is healthy. Green means you're on track. Yellow means watch closely. Red means act now.

We've built a free 5-Metric Churn Prediction Scorecard that calculates all five metrics from raw inputs, applies stage-based benchmarks, and auto-generates a churn health grade (A through F). Enter your numbers once and see where you stand. No competitor offers a single, founder-friendly template covering all five metrics with stage-appropriate benchmarks. The scorecard is free, requires no signup, and works in any browser. You can also download a CSV template to import into Google Sheets if you prefer to work in spreadsheets.

Which metric to start with (if you can only pick one)

Answer: Gross MRR churn.

It's the simplest to calculate from billing data you already have. It's the most honest—it doesn't hide behind logo count. And it's the clearest signal of product-market fit. If gross MRR churn is under 2% monthly, you're in good shape. If it's above 5%, that's your first priority. No other single metric gives you that clarity with that little effort. Customer churn alone can mislead you (losing one big customer vs. ten small ones). NRR and LTV:CAC require more inputs. Gross MRR churn is the definitive answer to "which metric to start with."

Stage-based progression:

• Months 1–3: Customer churn + gross MRR churn. Get these two in a spreadsheet. Track them every month. Nothing else matters until these are under control.
• Months 3–6: Add NRR and LTV:CAC. By now you should have enough history to see expansion vs. contraction, and enough new customers to estimate CAC.
• Months 6–12: Add CES and cohort analysis. Once basics are stable, start predicting churn before it happens with engagement data.
• Past 50 customers: Consider adjusted churn calculations—cohort-based, segment by plan size, etc. But don't overcomplicate. The five metrics above still drive decisions.

For founders in their first 90 days, focus on customer churn and gross MRR churn only. Add complexity as you grow. The goal is a minimum viable dashboard—not a maximum one. Thought leadership on metric prioritization consistently points to the same conclusion: too many dashboards lead to too little action. The companies that improve retention fastest are the ones that pick a few metrics, track them religiously, and act when they move. Simple churn calculators exist across the web, but few tie all five metrics together with stage-appropriate benchmarks in one place. That's why we built the scorecard—and why it's free.

Summary

Five metrics. Five formulas. One Monday morning. Start with gross MRR churn, add the rest as you scale, and use the churn scorecard to tie it together. You don't need expensive analytics tools—just consistency and the willingness to track what matters. Download our CSV template to import into Google Sheets if you prefer spreadsheets over the interactive calculator. Both give you the same formulas and benchmarks.

Your action items: This week, calculate gross MRR churn for last month. Next week, add customer churn rate. By month three, you'll have enough data to add NRR and LTV:CAC. No assumptions about expensive analytics tools—Stripe, Paddle, or a simple spreadsheet will do. The SaaS churn rate benchmarks in this post are from ChartMogul's dataset of 2,500+ businesses, so you're comparing yourself to real data. Use them to set targets, not to despair. Early-stage churn is normal. What matters is the trend.