Correctly calculating churn rate is the first step to understanding customer retention dynamics in your business. There are several approaches to calculating this indicator, but let’s start with the basic formula that applies to most business models.
The standard churn rate calculation formula looks like this:
Churn Rate = (Number of customers lost during the period / Number of customers at the beginning of the period) × 100%
The formula for churn rate is simple to apply and gives a quick idea of the customer attrition situation. For example, if you had 1000 customers at the beginning of the month, and during that month 50 customers canceled your services, then the monthly churn rate formula would give you:
(50 / 1000) × 100% = 5%
Calculating churn rate correctly using the basic formula is simple to apply, but may not account for some nuances, especially for fast-growing companies. For a more accurate assessment in a dynamic environment, you can use an adjusted formula:
Adjusted Churn Rate = Lost customers / [(Customers at beginning + Customers at end) / 2] × 100%
This approach takes into account the average number of customers for the period and gives a more representative picture for companies with rapidly changing customer bases.
For SaaS companies, it’s important to distinguish between customer churn rate formula and revenue churn formula. The revenue churn formula is calculated using:
Revenue Churn Rate = (Lost MRR during the period / MRR at the beginning of the period) × 100%
Where MRR is Monthly Recurring Revenue.
This indicator can be even more informative than customer churn, as it takes into account the financial impact of attrition. Interestingly, revenue churn can be negative if the revenue from expanded service usage by existing customers exceeds losses from departed customers. The net revenue churn formula includes expansion revenue:
Net Revenue Churn = [(Lost MRR – Expansion MRR) / Starting MRR] × 100%
For businesses focusing solely on lost revenue without accounting for expansions, the gross revenue churn formula is more appropriate:
Gross Revenue Churn Rate = (Lost MRR / Starting MRR) × 100%
For a deeper understanding, also discuss the basics of calculating churn rate to systematize approaches to data collection and analysis.
When calculating churn rate, it is critically important to clearly define who is considered a “departed customer.” Criteria may vary depending on the business model:
- For subscription services – cancellation of subscription
- For e-commerce – absence of repeat purchases within a certain period (e.g., 90 days)
- For mobile applications – absence of activity within an established timeframe
Some companies use the annual churn rate formula to understand longer-term trends: Annual Churn Rate = (Customers lost in a year / Customers at start of year) × 100%
Others need to track monthly patterns using the monthly churn rate formula: Monthly Churn Rate = (Customers lost in a month / Customers at start of month) × 100%
For those interested in tracking employee turnover, the employee churn rate formula works similarly: Employee Churn Rate = (Number of employees who left during period / Average number of employees) × 100%
For Excel users, implementing the churn rate formula in Excel can automate calculations. A simple spreadsheet might include columns for starting customers, ending customers, and new acquisitions, with a formula like: =((Starting-Ending+New)/Starting)*100 to calculate the percentage.
When comparing retention metrics, understanding the churn rate vs retention rate formula relationship is key: Retention Rate = 100% – Churn Rate
The net churn formula, which includes account expansions and contractions: Net Churn = (Lost Revenue – Expansion Revenue) / Starting Revenue × 100%