How to Measure SaaS Churn (and MRR Movement)
·Ultra BI Team ·8 min read
TL;DR
SaaS churn measures the revenue or customers you lose over a period. Gross revenue churn counts lost revenue only; net revenue churn subtracts expansion, so it can go negative. Logo churn counts lost customers. Read alongside MRR movement — new, expansion, contraction, and churned — these metrics explain whether your recurring revenue is healthy.
Churn is the metric every SaaS founder watches and many measure inconsistently. The confusion is understandable: “churn” refers to several related numbers, and which one you mean changes the story. Here’s how to measure it cleanly.
The three churn numbers that matter
Gross revenue churn is the percentage of recurring revenue you lost in a period from downgrades and cancellations, ignoring any new or expansion revenue. It only ever goes up from zero — it’s a pure measure of leakage.
Gross revenue churn = (contraction MRR + churned MRR) ÷ starting MRR
Net revenue churn subtracts expansion revenue from existing customers. Because upsells can outweigh losses, this number can be negative — the holy grail, where your existing base grows on its own.
Net revenue churn = (contraction + churned − expansion MRR) ÷ starting MRR
Logo churn ignores money entirely and counts customers: how many logos you lost as a share of the count you started with. Two large accounts leaving barely moves logo churn but can wreck revenue churn — which is why you watch both.
How MRR movement ties it together
Churn is one slice of a bigger picture: MRR movement. In any month your recurring revenue changes through four forces:
- New MRR from new customers
- Expansion MRR from upgrades
- Contraction MRR from downgrades
- Churned MRR from cancellations
Add them up and you get net new MRR. Churn metrics are just the contraction and churned components expressed as rates. Looking at the whole movement tells you why revenue moved, not just that it did.
The questions to ask your data
You don’t need a spreadsheet model to track these. Point a tool at your billing data and ask directly:
- “What was net MRR movement last month, broken into new, expansion, contraction, and churn?”
- “What’s our gross and net revenue churn this quarter?”
- “Which plans have the highest logo churn?”
With generative BI, each of these returns a full report — the chart, the explanation, and the query — straight from Stripe. For a ready-made structure, start from the churn & retention template and tailor it with follow-up questions. Teams running this regularly tend to build it into a weekly SaaS metrics ritual.
Measure consistently, then act
The biggest mistake isn’t picking the “wrong” churn metric — it’s switching definitions month to month so the trend becomes meaningless. Pick gross churn, net churn, and logo churn, define each once, and track all three over time. Consistency is what turns churn from a scary word into a number you can actually manage.