How to Calculate Customer Churn Rate and Revenue Churn Rate
The easy way to find out the rate at which customers churn — and ways to reduce attrition
Time to read: 5 minutes
How do you calculate customer churn rate, and what are the differences between customer churn and revenue churn?
To find out how to calculate customer and revenue churn, it’s important to start by discussing the two different methods of calculating churn: customer churn and revenue churn.
What is customer churn?
What is a churn rate?
Why is customer churn important?
How do you calculate customer churn rate?
To determine the percentage of revenue that has churned, take all your monthly recurring revenue (MRR) at the beginning of the month and divide it by the monthly recurring revenue you lost that month — minus any upgrades or additional revenue from existing customers. Do not include new sales in the month, as you are looking for how much total revenue you lost. New revenue from existing customers is revenue you have gained.
For example, if Company ADG had 500 customers at the beginning of the month and only 450 customers at the end of the month, its customer churn rate would be 10%.
Four Ways to Reduce Customer Churn
#1: Understand why customers churn.
#2: Provide supporting resources and education.
#3: Make sure you’re targeting the right audience for your products.
#4: Know the signs that a customer is likely to leave.
What is revenue churn?
How do you calculate revenue churn rate?
To determine the percentage of revenue that has churned, take the monthly recurring revenue (MRR) you lost that month — minus any upgrades or additional revenue from existing customers, and divide it by your total MMR at the beginning of the month. Do not include new sales in the month, as you are looking for how much total revenue you lost. New revenue from existing customers is revenue you have gained.
For example, if Company ADG had $500,000 MRR at the beginning of the month, $450,000 MRR at the end of the month, and $65,000 MRR in upgrades that month from existing customers, its revenue churn rate would be -3%.
The difference between customer churn rate and revenue churn rate
#1: Basic:
#2: Premium:
While similar, customer and revenue churn rate are not identical because the basic and premium packages are not worth the same revenue. This discrepancy will only grow as you gain more product lines or the price difference between product lines grows. Clearly communicate which method you use and be consistent in your regular reporting.
You may need to use both calculations as you manage your business. Revenue churn is a great way to report on performance and understand the financial health of your customer base. Customer churn is important for staffing reasons as an employee can only manage so many accounts at one time.
Calculating customer churn rate: cohort analysis
As mentioned, you can calculate churn over a monthly, quarterly, or annual time frame. While this is true, there is an important caveat to consider.
In the monthly calculation, there is an underlying assumption that no customer can churn in the first month. This is based on the assumption that your customers pay for the month up front. So when you take a snapshot at the beginning of the month and then divide that by the total number of churned customers, you don’t have to worry about any new sales churning in that time period.
If in the same model we calculated churn over a quarter, we could run into a problem. There will be some new sales from the first month in the quarter that could churn in the second or third month of the quarter. If those churns are accidentally included in the calculation, then we’ll overstate churn.
For example, Company ADG wants to calculate quarterly churn.
If we look over the quarter, our initial cohort of 1,000 customers only has 850 customers remaining, giving a customer churn rate of 150/1000 = 15%.
During that same time frame, there were 300 new sales, of which 15 churn. If you included those 15 churns in your calculation, you’d have 165/1000 = 16.5%.
The simplest way to get around this problem is to exclude all new sales from churn calculations. If you do that, you get the churn rate of Cohort A, which was our install base at the beginning of the quarter. This method gives you the true churn rate, without replacement, of your customer base over a quarter.
You may, however, want to include the churn rate of Cohorts B and C. If that’s the case, you can use a weighted average.