All Topics

Retention Metrics, Explained from the Ground Up

Six core topics. Each one builds on the last. Start at churn rate and work through to the acquisition vs retention decision.

01
Foundation

Understanding Churn Rate

Churn rate is the percentage of subscribers who cancel in a given period. The monthly calculation is straightforward: divide the number of subscribers lost during the month by the number of subscribers at the start of the month.

What makes churn rate deceptive is its apparent simplicity. A 4% monthly churn sounds modest. But it compounds. And the definition of "lost subscriber" matters more than most operators realize. Did you count pauses? Downgrades? Failed payments that resolved? The denominator choice changes the number significantly.

What This Topic Covers
  • The correct formula and common denominator mistakes
  • Gross churn vs net churn and when each matters
  • Voluntary vs involuntary churn and why the split changes your response
  • How to interpret your churn rate in context
Read Full Topic
02
The Math That Matters

Why a 2% Monthly Difference Compounds Into Disaster

Mathematical notebook showing compound churn calculations with warm coffee-stained edges
the compounding problem

The gap between 3% and 5% monthly churn looks small on a dashboard. Over twelve months it's the difference between a business that's slowly rebuilding its subscriber base and one that's quietly hemorrhaging it.

The math is exponential, not linear. Each month's churn applies to a smaller base, so the absolute number of cancellations shrinks even as the percentage stays constant. This makes the damage feel gradual right up until it becomes undeniable.

This topic walks through the calculation month by month with real numbers. It also shows how to build a simple projection model in a spreadsheet so you can see where your current churn rate takes you over the next year.

Key Concepts
  • Month-by-month compounding calculation
  • Annual subscriber retention rate derived from monthly churn
  • Revenue impact modeling at different churn rates
  • The break-even acquisition rate needed to offset churn
Read Full Topic
03
Revenue Clarity

Customer Lifetime Value: The Napkin Formula

Customer lifetime value answers a specific question: how much revenue does a subscriber generate before they cancel? The answer shapes every acquisition and retention decision you make.

The napkin formula requires three inputs. Average monthly revenue per subscriber. Average monthly churn rate. And a margin percentage if you want a profit-adjusted number. From those three inputs you can calculate a CLV figure that's useful for decision-making even if it's not statistically perfect.

The Formula
CLV = (Monthly Revenue per Subscriber) / (Monthly Churn Rate)
Multiply by gross margin for a profit-adjusted figure

The limitations matter too. This formula assumes churn rate is constant, which it isn't. It doesn't account for expansion revenue. It treats all subscribers as identical. The topic covers these limitations and how to adjust the formula when your business has meaningful variance in subscriber behavior.

Read Full Topic
04
The Hidden Picture

What Cohort Analysis Reveals That Monthly Averages Hide

Colorful cohort retention grid in a spreadsheet on a vintage wooden desk
cohort grids reveal patterns

Monthly churn rate is a single number. It averages across everyone who cancelled this month regardless of when they signed up. A cohort analysis separates subscribers by the month they joined and tracks each group's retention independently.

This distinction reveals things that averages hide. A product change in March might have improved retention for new subscribers while long-tenured subscribers continued cancelling at the old rate. The monthly average would show no change. The cohort grid would show the split clearly.

Building a cohort grid requires more data organization than a simple churn calculation. This topic covers the data structure, the spreadsheet formulas, and how to read the resulting grid to identify which signup periods have retention problems.

What Cohort Analysis Shows
  • Which acquisition channels produce subscribers who stay longer
  • Whether product or pricing changes improved retention for new cohorts
  • The natural "churn cliff" timing for your specific product
  • Seasonal patterns in subscriber longevity
Read Full Topic
05
Build It Once

A Self-Updating Retention Dashboard in Google Sheets

Google Sheets retention dashboard glowing on a laptop screen in a cozy office
self-updating sheets template

The goal is a dashboard where you add a row of data each month and every metric recalculates automatically. No copy-pasting formulas. No manual chart updates. The structure does the work.

This topic covers the data input structure, the formula layer that converts raw data into metrics, and the chart layer that makes the trends visible. The downloadable template includes all three layers pre-built. You connect your own numbers and the dashboard responds.

The dashboard tracks monthly churn rate, subscriber count over time, MRR trend, cohort retention grid, and CLV estimate. Each metric is calculated from the same data input table so there's no risk of formulas pointing to different sources.

Dashboard Components
  • Data input tab: one row per month with subscriber counts and revenue
  • Metrics tab: auto-calculated churn rate, CLV, and MRR
  • Cohort tab: the retention grid built from subscriber-level data
  • Charts tab: visual trend lines for all key metrics
Download the Template
06
The Decision Framework

When to Invest in Acquisition vs Retention

Two-path decision diagram sketched on paper with warm amber desk lamp lighting
the acquire vs retain question

This question has a framework answer, not a universal answer. The right balance depends on your current churn rate, your CLV, your customer acquisition cost, and the stage of your business.

When churn is high, pouring money into acquisition is filling a leaking bucket. New subscribers replace cancelled ones but the underlying retention problem grows. The math on this is unambiguous: above a certain churn threshold, acquisition investment has a poor return regardless of how efficiently you acquire.

The topic covers the LTV:CAC ratio as a diagnostic tool. It explains what ratio suggests you have room to invest in acquisition and what ratio suggests retention work comes first. It also covers the specific retention interventions that have measurable impact versus those that feel productive but don't move the metric.

The Framework Covers
  • How to calculate your LTV:CAC ratio
  • The churn rate threshold where retention investment dominates
  • How to estimate the ROI of a retention improvement
  • Sequencing: what to fix before you scale acquisition
Read Full Topic
Free Downloads

Templates for Every Framework

Every topic on this blog has a corresponding downloadable template. They're built in Google Sheets and require no special software. Download, make a copy, and connect your own data.

Churn Rate Calculator

Input your subscriber counts for each month and the template calculates gross churn, net churn, and annual retention rate automatically.

Request Template

CLV Napkin Calculator

Three input cells. The template calculates basic CLV, margin-adjusted CLV, and shows how CLV changes as churn rate improves.

Request Template

Cohort Retention Grid

The full cohort analysis template. Input subscriber-level signup and cancellation dates and the grid populates automatically using COUNTIFS formulas.

Request Template

Full Retention Dashboard

All metrics in one place. Churn rate, CLV, MRR trend, cohort grid, and the acquisition vs retention diagnostic. One data input tab feeds everything.

Request Template