Revenue Churn vs Customer Churn: 4 Formulas (2026)

Revenue churn and customer churn answer different questions. Customer churn tells you how many accounts left. Revenue churn tells you how much recurring revenue those departures and downgrades removed. If your customers pay different prices, the two rates can move in opposite directions—and that difference changes what you should fix.

The short answer: track both. Use customer churn to understand retention across your account base, and revenue churn to measure the financial damage. Add net revenue churn when expansions and upgrades matter. This guide gives you the four formulas, two worked examples, and a practical dashboard you can build from your billing database.

Revenue churn vs customer churn at a glance

Customer churn, also called logo churn, is the percentage of customers who cancel during a period. Every lost account counts once, whether it paid $50 or $50,000 per month.

Revenue churn is the percentage of starting recurring revenue lost through cancellations and, depending on the version used, downgrades. It weights customers by financial impact. Losing a large account therefore matters much more than losing a small account.

Use customer churn when you are diagnosing product-market fit, onboarding, customer experience, or retention by segment. Use revenue churn when you are forecasting growth, evaluating customer-success priorities, or reporting to investors. Neither metric replaces the other.

Formula 1: customer churn rate

Customer churn rate = customers lost during the period ÷ customers active at the start of the period × 100.

If you began August with 200 paying customers and 8 cancelled, your monthly customer churn rate was 4%. Customers acquired during August should not enter the starting denominator; mixing them in makes period comparisons unreliable.

Define a customer consistently. For a workspace product, one paying workspace is usually one customer even if it has 20 users. For a usage-based API, you might count paying organizations rather than API keys. Document that choice beside the metric.

Formula 2: gross revenue churn

Gross revenue churn = recurring revenue lost from cancellations and downgrades ÷ recurring revenue at the start of the period × 100.

Suppose you started with $100,000 in monthly recurring revenue. Cancellations removed $2,500 and downgrades removed another $1,000. Gross revenue churn was 3.5%. Expansion revenue is deliberately excluded, so the metric exposes the total erosion hidden inside the customer base.

Gross revenue churn cannot be negative. It is the cleaner measure for judging how much revenue your retention motion failed to protect, because a large upgrade cannot conceal cancellations elsewhere.

Formula 3: net revenue churn

Net revenue churn = (cancellation MRR + downgrade MRR − expansion MRR) ÷ starting MRR × 100.

Using the same example, assume existing customers added $4,500 through upgrades. Net revenue churn becomes −1%: ($2,500 + $1,000 − $4,500) ÷ $100,000. A negative result is good. It means expansion from retained customers exceeded revenue lost during the month.

Do not present net revenue churn without gross revenue churn. A healthy negative net rate can coexist with a weak cancellation experience. You want to know whether growth came from excellent retention or simply from a few large expansions.

Formula 4: net revenue retention

Net revenue retention, or NRR, = (starting MRR − cancellation MRR − downgrade MRR + expansion MRR) ÷ starting MRR × 100. It is also 100% minus net revenue churn.

The example above produces 101% NRR. Revenue churn and NRR describe the same movement from opposite directions, but NRR is often easier to use in board reporting. Values above 100% mean the existing customer base expanded before any new-customer revenue was added.

Why the two churn rates disagree

Imagine losing 8 of 200 customers, all on a $50 plan. Customer churn is still 4%, but the $400 lost from $100,000 of starting MRR produces only 0.4% gross revenue churn. The problem is concentrated among low-value accounts. That points you toward self-serve onboarding, documentation, and product fixes rather than high-touch rescue calls.

Now reverse the pattern. You lose one $15,000 account from the same 200-customer base. Customer churn is only 0.5%, while gross revenue churn is 15%. The logo count looks calm, but the financial damage is severe. Enterprise adoption, executive sponsorship, reliability, and renewal management deserve immediate attention.

Averages hide this shape. Always break both metrics down by plan, account size, acquisition channel, geography, tenure, and customer-success owner. The overall rate tells you that something changed; segmentation tells you what to do about it.

Which churn metric should drive each decision?

For product and onboarding decisions, start with customer churn. A rising logo-loss rate across small accounts often reveals weak activation, confusing workflows, or a mismatch between acquisition promises and delivered value.

For revenue forecasts and customer-success staffing, start with gross revenue churn. It quantifies the recurring revenue at risk and helps you prioritize high-impact accounts without pretending that every cancellation has equal weight.

For expansion strategy, use net revenue churn and NRR together. They show whether upgrades, added seats, and cross-sells compensate for contraction. Then inspect gross churn separately so expansion does not become statistical deodorant for a leaky product.

For board or investor reporting, publish customer churn, gross revenue churn, and NRR with the same period and cohort rules. A single churn number invites ambiguity. Three labeled numbers make the economics legible.

Build a churn dashboard that leads to action

1. Fix the measurement window. Monthly reporting works for most SaaS teams, while annual contracts may need quarterly views. Store period start and end dates so nobody silently compares a 28-day month with a 31-day month.

2. Snapshot the opening base. Capture active customer IDs, plan, MRR, tenure, owner, and key segment attributes on the first day. Reconstructing the opening state from today's subscription table is a common source of wrong churn rates.

3. Classify every movement. Separate new business, reactivation, expansion, downgrade, cancellation, and billing failure. New MRR must never reduce churn; it belongs in growth reporting.

4. Calculate all four formulas from the same movement table. This keeps customer counts and revenue movements aligned and makes discrepancies easier to audit.

5. Add segment views. Show churn by plan, tenure band, account size, acquisition source, industry, and customer-success owner. Require a minimum cohort size before treating a segment rate as a trend.

6. Add a customer drill-down. Every chart should lead to the accounts behind the number, including cancellation date, lost MRR, last meaningful activity, downgrade history, and stated reason.

7. Attach thresholds to owners. Alert customer success when high-value accounts become inactive, finance when gross revenue churn crosses the forecast, and product when a newly released feature correlates with a retention drop.

Calculate churn from your database without SQL

You do not need to export billing data into a spreadsheet every month. If subscription, account, invoice, and product-usage data already live in PostgreSQL, MySQL, MongoDB, Supabase, BigQuery, or another database, you can calculate the metrics at the source.

At aifordatabase.com, connect a read-only database and ask: “For August 2026, calculate customer churn, gross revenue churn, net revenue churn, and NRR. Exclude new customers from the opening cohort and break the results down by plan.” You can inspect the generated result before saving it.

Save the result as a self-refreshing dashboard so the definitions stay consistent from one period to the next. Then add an action workflow that sends an email, Slack message, or webhook when gross revenue churn exceeds your threshold or when a high-value account enters a risk segment.

The useful distinction is not AI versus SQL. It is a repeatable metric pipeline versus a monthly spreadsheet ritual. Your team should spend its time explaining churn and reducing it, not rebuilding the same report.

Common churn measurement mistakes

Do not mix annual recurring revenue with monthly movements. Convert every amount to the same recurring interval before calculating rates. Also separate voluntary cancellations from involuntary churn caused by failed payments; the owners and fixes differ.

Do not count paused, delinquent, or trial accounts differently each month. Write explicit state rules and version them when the business changes. If a cancelled customer reactivates, record reactivation as a separate movement rather than rewriting history.

Do not compare blended churn across radically different segments. A 5% monthly rate may be normal for a low-price self-serve tier and disastrous for annual enterprise contracts. Compare like with like, then roll the values up.

Finally, do not celebrate low customer churn while ignoring revenue concentration. One large cancellation can erase months of small-account growth. That is precisely why the revenue churn vs customer churn comparison belongs on the same dashboard.

Questions SaaS teams ask

Which is more important: revenue churn or customer churn?

Revenue churn is more useful for forecasting financial impact; customer churn is more useful for diagnosing how widely retention problems affect your accounts. Track both because either one alone can hide the risk the other exposes.

Can revenue churn be negative?

Gross revenue churn cannot be negative because it only counts cancellations and downgrades. Net revenue churn can be negative when expansion revenue from existing customers is larger than cancellation and downgrade revenue.

How often should a SaaS company calculate churn?

Calculate it monthly for operating reviews and also examine rolling three-month or quarterly trends when account counts are small. Use the same definitions and period boundaries every time.

What data do you need to calculate both rates?

At minimum, you need customer IDs, subscription status, recurring revenue, effective dates, and a record of cancellations, downgrades, and expansions. Plan, tenure, and account-owner fields make the result actionable.

What tool lets a non-technical team track churn without SQL?

AI for Database lets your team ask for churn metrics in plain English, save the result as a live dashboard, and trigger alerts from database changes. Use a read-only connection and verify metric definitions before sharing the dashboard.

The practical rule

Customer churn measures lost relationships. Revenue churn measures lost economic value. Put both beside gross and net views, segment them, and connect every threshold to a named owner. Then churn stops being a backward-looking percentage and becomes an operating signal your team can act on.