ZoomInfo

How to Calculate Churn Rate

What Is Churn Rate?

Churn rate is the percentage of customers or revenue you lose during a specific time period, calculated as: Customers Lost ÷ Customers at Start × 100. Sometimes called customer attrition rate or subscriber churn, it measures how many customers canceled or how much recurring revenue disappeared from cancellations and downgrades in a month, quarter, or year for B2B and SaaS companies.

Two types of churn matter for measuring whether your growth is real or just replacing what's slipping away:

  • Customer churn: The percentage of accounts lost during the period

  • Revenue churn: The percentage of MRR or ARR lost from cancellations and downgrades

Why Churn Rate Matters for GTM Teams

Churn rate directly impacts your ability to scale. Here's why it matters:

  • Growth sustainability: Acquiring new customers is expensive, and high churn forces acquisition to work harder just to maintain growth.

  • Revenue predictability: Higher churn reduces confidence in future revenue and makes forecasting difficult for SaaS companies.

  • Unit-economics impact: When customers leave early, the drag shows up fast in your LTV to CAC ratio.

  • Valuation and investment risk: For investors or acquirers, sustained low churn or negative net churn signals stronger product-market fit and scaling potential.

Churn rate is the inverse of retention rate (5% monthly churn means 95% retention). Not tracking it creates three blind spots:

  • Acquisition becomes a treadmill: You keep adding customers but lose so many that net growth stalls

  • Spend scales inefficiently: More budget goes to replacing churned revenue instead of growing

  • Value erosion goes unnoticed: Customer count looks stable while high-value accounts walk out

How to Calculate Customer Churn Rate

Customer churn rate measures the percentage of customers who terminated their contract or failed to renew in a given period. The focus is purely on account count, regardless of how much revenue each account represented.

Customer Churn Rate Formula

Customer Churn Rate (%) = Customers Lost During Period ÷ Customers at Start of Period × 100

Example calculation:

  • Customers at month start: 500

  • Customers lost: 25

  • Calculation: 25 ÷ 500 × 100 = 5% monthly churn rate

Critical rule: Do not include new customers acquired during the period in your starting count. The denominator should only reflect the customer base at period start.

Choosing the Right Time Period

If you have monthly churn data and want to understand annualized impact, use this formula:

Annual Churn Rate = 1 − (1 − Monthly Churn Rate)^12

Example: A monthly churn of 8% translates to 63.23% annually, not 96% (8 × 12), because compounding reduces the effect of simply adding monthly rates together.

Monthly tracking is most common for SaaS businesses because it provides faster feedback on retention trends, while annual tracking is typical for companies with longer contract cycles.

How to Calculate Churn Rate in Excel

To set up the basic churn formula in a spreadsheet, you need two columns: customers at start of period and customers lost. In Excel or Google Sheets, use this formula syntax: =(B2/A2)*100 where A2 is starting customers and B2 is lost customers.

How to Calculate Revenue Churn Rate

Revenue churn measures the recurring revenue lost due to cancellations, downgrades, or non-renewals. Because not all customers generate equal revenue, revenue churn gives a financial perspective on attrition.

MRR and ARR Churn Formulas

Revenue Churn Rate (%) = Recurring Revenue Lost ÷ Recurring Revenue at Start × 100

Example calculation:

  • MRR at month start: $120,000

  • MRR lost from cancellations and downgrades: $9,600

  • Calculation: $9,600 ÷ $120,000 × 100 = 8% revenue churn rate

This formula measures total revenue lost before any offsetting from expansions. ARR churn follows the same logic on an annual basis.

Why Revenue Churn Often Matters More

Revenue churn is often more actionable than customer churn for B2B and SaaS companies because losing one enterprise account can have a larger revenue impact than losing several SMB accounts. Tracking both metrics gives a complete picture: customer churn shows how many accounts you're losing, while revenue churn shows how much that attrition actually costs.

When Customer Churn and Revenue Churn Tell Different Stories

Customer churn and revenue churn can tell different stories about your business health. Two common divergence scenarios:

  • Scenario 1: High customer churn, low revenue churn. You're losing many small customers while retaining large enterprise accounts, so your logo churn looks bad but revenue impact is minimal.

  • Scenario 2: Low customer churn, high revenue churn. You're losing one enterprise account while retaining many SMBs, meaning your logo churn looks fine but you just lost significant revenue.

Note on terminology: Logo churn and customer churn are the same metric (both count accounts lost, not revenue impact). Segment your churn data by customer tier, region, and contract term to see where retention issues actually live.

Gross Churn vs. Net Churn

Gross churn and net churn measure revenue loss differently. Understanding both gives you a complete picture of revenue health.

Metric

Gross Revenue Churn

Net Revenue Churn

Definition

Total revenue lost from cancellations and downgrades (no offsetting expansions)

Gross churn minus expansion revenue from existing customers (upsells, cross-sells)

Formula

Revenue Lost ÷ Revenue at Start × 100

(Churned Revenue − Expansion Revenue) ÷ Revenue at Start × 100

What It Reveals

Raw revenue leakage from lost customers

Net impact on revenue after accounting for growth from existing customers

Net churn can be negative when expansion exceeds contraction:

  • Negative net churn: Revenue from existing customers grows faster than revenue lost to churn

  • Related metric: Net dollar retention (NDR) measures this same dynamic as above or below 100%

What Is Negative Churn?

Negative net churn occurs when expansion revenue from existing customers exceeds revenue lost from churned customers. This means the existing customer base is growing in value even after accounting for losses.

Negative churn is a strong indicator of product-market fit and pricing power.

Example: If you lose $10,000 MRR from cancellations but gain $15,000 MRR from upsells and cross-sells to existing customers, your net churn is negative 5%.

What Is a Good Churn Rate?

What counts as "good" churn varies by business model, contract length, company stage, and customer segment. Factors that determine acceptable churn for your business:

  • Contract term: Annual contracts create lower monthly churn than month-to-month subscriptions

  • Customer segment: Enterprise accounts churn less frequently than SMB customers

  • Company stage: Early-stage companies often have higher churn as they refine product-market fit

  • Industry vertical: Some industries have inherently higher vendor switching rates

How to Make Churn Data Actionable

Calculating churn correctly requires consistency and discipline. Follow these rules:

  • Define your time window and stay consistent. Choose monthly, quarterly, or annually and stick with it to make trends readable.

  • Do not include new customers in the denominator. The starting customer count should only include customers who existed at the beginning of the period.

  • Segment churn by customer tier, region, and contract term. Break it down by SMB vs. enterprise, by geography, by annual vs. monthly contracts to see where to focus retention efforts.

  • Track trends over time rather than fixating on single-period numbers. Look at rolling three-month or six-month averages to spot real patterns.

Avoid Common Calculation Mistakes

These errors skew your churn rate and lead to bad decisions:

  • Mistake: Including new customers in the denominator artificially lowers your churn rate by inflating the starting customer count. Your churn rate should measure retention of the existing base, not dilute it with new acquisitions.

  • Mistake: Mixing time periods creates false trends. Standardize your reporting period to avoid comparing monthly churn to quarterly churn without adjusting for time window.

  • Mistake: Not excluding one-time revenue from revenue churn calculations. Only include recurring revenue because one-time implementation fees or professional services don't belong in the churn calculation.

  • Mistake: Failing to segment by customer type masks whether you're losing high-value or low-value customers. Segment by tier to see where the real problem lives.

Segmenting Churn by Firmographics and Technographics

Aggregate churn hides which customer profiles are actually at risk. Key segmentation dimensions to reveal where churn concentrates:

  • Firmographics: Industry, company size (employee count), revenue band, geography

  • Technographics: Tech stack composition, recent tool changes, competitive tools installed

  • Behavioral signals: Product usage patterns, engagement frequency, support ticket volume

How to Predict and Reduce Churn

Reducing churn starts with knowing when accounts are at risk and why. Segment your churn data across these dimensions:

  • Contract size: SMB vs. mid-market vs. enterprise

  • Customer tenure: 0-6 months vs. established accounts

  • Product line: Which offerings see the highest attrition

  • Geography: Regional retention patterns

To spot churn risk, you need clean customer records. Smart teams use ZoomInfo to enrich customer records with firmographic and technographic data that's accurate today, not last quarter.

Account and Stakeholder Mapping for Renewals

Churn risk spikes when key contacts leave or org charts shift. Track these changes to act before renewal risk materializes:

  • Executive turnover: CRO, CMO, or VP-level departures at customer accounts

  • New stakeholders: Buyers entering the approval chain or decision committee

  • Reporting changes: Shifts in budget ownership or decision authority

Churn Indicators and Early Warning Signals

Intent data and trigger events give CS teams early warning on churn risk or expansion opportunity. Proactive outreach beats reactive saves.

Key signals to monitor:

  • Competitive research: Customer accounts showing intent for alternative solutions

  • Hiring activity: New RevOps, sales leadership, or procurement roles that signal vendor evaluation

  • Funding or M&A events: Budget reviews or consolidation triggers from capital raises or leadership changes

Key Takeaways

Churn tells you what's slipping through the cracks. The formula is simple, but turning that number into action is where retention gets won.

  • Define your time period and be consistent (monthly, quarterly, annually) when calculating churn

  • Always include both customer count and revenue perspectives because churn in logo count alone doesn't tell the full story

  • Use the churn rate as a signal, not a final destination: investigate the why, segment the data, and act proactively

  • Lowering churn improves the ROI of your acquisition efforts, increases LTV, and strengthens forecast accuracy

  • Better retention makes your SaaS business more scalable and defensible

When you know how to calculate churn rate, you get a clear view of your business health and the power to shape your retention strategy. Growth gets derailed by the churn you don't measure and don't manage.

Talk to our team to learn how ZoomInfo can help you reduce churn with better account intelligence.