Return to Chaotic Flow home >>>

SaaS Metrics FAQs | What is Churn?

saas metrics faqsA little over two years ago, I published a series of well received articles on SaaS metrics that culminated in the SaaS Metrics Guide to SaaS Financial Performance. Since then, I’ve received numerous inquiries regarding the many practical quirks encountered in day-to-day SaaS metrics implementation. In response, I’ve decided to revisit the SaaS metrics topic with this series of SaaS Metrics FAQs where I’ll elaborate on some of these finer SaaS metrics details in a simple Q&A format. This first SaaS Metrics FAQs installment tackles the many problems associated with measuring SaaS churn, so if you have a Q, please feel free to submit it in the comments and I’ll do my best to provide an A.

SaaS Metrics FAQ #1 | What is Churn?

SaaS churn is the percentage rate at which SaaS customers cancel their recurring revenue subscriptions. It is a key SaaS metric of historical SaaS business performance and an important parameter in revenue forecasting. When used in forecasting, SaaS churn can be interpreted as the probability rate at which customers will cancel their subscriptions. In it’s simplest form, SaaS churn can be stated as the number of customers cancelling (ΔC) per time interval (Δt) divided by the number of customers at the beginning of the interval (C).

SaaS Churn = ΔC
Δt x C

In the formula above, the Δ is a common math symbol that means change or interval.

That’s the simple answer. In practice, SaaS churn can be both difficult to define and difficult to measure. For example, it is very common to define SaaS churn rates at the customer level (customer churn), subscription level (product churn), and recurring revenue level (MRR or ARR weighted churn). Moreover, measuring SaaS churn can be complicated by low churn rates, high churn rates, high growth rates, variety of customer types, variety of subscription contract renewal periods, variety of contract MRR values, and changes in the SaaS churn rate itself over time. In it’s most complicated form, SaaS churn is the result of a Poisson process which statisticians would employ survival analysis in place of the simple formulas we generally use to calculate churn rates. So, if you get confused when you attempt to turn theory into practice, don’t worry, you are not alone. In the SaaS Metrics FAQ #3 below, I’ll provide some shortcuts for calculating accurate SaaS churn rates, while keeping the math to a minumum (really!).

SaaS Metrics FAQ #2 | Why is churn such an important SaaS metric?

The reason the SaaS churn rate dominates over virtually all other SaaS metrics is that SaaS churn is in direct opposition to growth; the primary objective of most SaaS businesses. As the limiting factor to growth, the SaaS churn rate has a very negative impact on both SaaS profitability and SaaS company valuation. Moreover, SaaS churn increases with the size of the customer base, so it is essentially negative virality, and as such is incredibly difficult to overcome. Graphically, SaaS churn tends to follow what is called a negative exponential distribution (shown below, it is the opposite of the positive exponential distribution associated with viral growth).

saas churn rate lifetime

SaaS churn tends to follow a distribution where the bulk of customers
fall off within one customer lifetime, but some customers hang around for a very long time.

In plain English, you spend an awful lot of money, time and energy acquiring customers in SaaS. You recover this investment over time, so you want your customers to stick around as long as possible. The longer they stay, the stronger your business. This is why the value of one divided by the SaaS churn rate is often quoted as the average customer lifetime; lower SaaS churn equals longer customer lifetimes equals larger customer lifetime value.

SaaS Metrics FAQ #3 | How do I calculate churn in practice?

Well, it depends. In order to calculate churn accurately, you should make some attempt to achieve the following ideal SaaS churn calculation requirements.

  1. Uniform Customer Population: Calculate churn across a uniform population of customers; uniform meaning they all have the same probability of cancelling during the measurement interval.
  2. Matched Customer Population: Calculate churn by matching the population of customers that actually do cancel (ΔC) to the original population of customers that might possibly cancel (C).
  3. The Right Measurement Interval: Calculate churn using a time measurement interval (Δt) that isn’t so short that you don’t get enough cancellations, or so long that you get too many. Otherwise, simple churn calculation formulas can yield statistically insignificant, biased, and random results.
  4. MRR Uncorrelated to Churn: If MRR gets mixed up with churn, such as big customers cancelling more frequently than small ones, then revenue churn may differ dramatically from customer churn, and in the end, it’s revenue that counts!
  5. Stable Business Process: Most SaaS businesses are constantly tinkering with their business processes to improve them. A SaaS startup may not have achieved a stable business model or recurring revenue stream. Measuring SaaS churn across dramatic business process changes will yield poor results. Ideally, you will measure SaaS churn before and after important changes in your business to understand their impact on churn.

What does this mean in practice? Most people begin to calculate churn by subtracting the number of customers remaining at the end of a month from the number of customers at the beginning of a month and divide by the number of customers at the beginning of the month.

Monthly Churn Rate Calculation = Cbegin – Cend
Cbegin

And, then they multiply the monthly churn rate by twelve to get the annual churn rate.

Annual Churn Rate Calculation = Monthly Churn Rate x 12

(note: Cend is number of customers remaining at the end of the month that were in the original Cbegin. It is not the total number of customers at the end of the month, which might include new customer acquisition. New customer acquisition during the measurement interval should always be excluded from your churn calculation. Thanks to Peter Cohen for pointing out this lack of clarity in the comments below.)

This is OK, provided you don’t have any of the following common churn calculation problems.

  • a small number of customers (measurement interval too short)
  • a very low monthly churn rate (measurement interval too short)
  • a very high monthly churn rate (measurement interval too long)
  • a high monthly growth rate (population not matched)
  • contract renewal periods longer than one month (population not matched)
  • mixed contract renewal periods (population not uniform)
  • distinctly different customer types and behaviors (population not uniform)
  • high early dropout rates leaving behind loyal customers (population not uniform)
  • a wide variety of MRR per contract (population not uniform)
  • upgrades or downgrades (MRR correlated to churn)
  • changing contract renewal periods (MRR correlated to churn)

Just to name a few! The careful observer will note that each of the above situations creates problems by violating the respective ideal churn calculation assumption identified in parenthesis. Here are some SaaS churn calculation tips that will help you avoid many of the SaaS churn calculation pitfalls above without calling in a statistician or overly complicating your churn calculations.

SaaS Churn Calculation Tip #1 | Choose a measurement interval with churn < 1%-10%

When the churn rate is small, so many math things work out better for SaaS churn rate calculation accuracy, as well as in your SaaS business! However, even if your churn rate is large, you can improve the accuracy of your SaaS churn rate calculation by choosing a measurement interval where the total churn within the interval is small. Consider a SaaS business with 25% monthly churn and 100 customers. At the end of months 1, 2, and 3 there will be 75 = 100 * .75, 56 = 75*.75, 42 = 56 * .75 customers respectively. If you use a measurement interval of one quarter, you will likely calculate a churn rate of 19% = (100 – 42)/3 instead of 25%. When churn within the measurement interval is too high, your churn calculation will consistently underestimate the true churn rate.

SaaS Churn Calculation Tip #2 | Use a measurement interval close to the average contract renewal period

Your customers can’t churn unless their contracts are up. If you use annual contracts, only 1 in 12 of your customers can cancel in any given month. On the other hand, for those 1 in 12 that can cancel, you are actually measuring the annual churn rate, because they’ve been around for a full year already. If you customer population is super duper big and uniform and you have zero growth, these two biases will cancel each other out. But, a safer bet is simply to choose a measurement interval that is close to your average contract renewal period. One frequent source of churn calculation frustration comes from reconciling Tip #1 above which entails a shorter churn measurement interval with Tip #2 which usually entails a longer churn measurement interval. The solution to this problem requires a little more complex math and is given in Tip #7 below.

SaaS Churn Calculation Tip #3 | Only look at contracts that are up for renewal

If you can’t seem to find a happy medium between a low churn rate in your measurement interval (Tip #1) and a measurement interval equal to your average contract renewal period (Tip #2), then your best bet is to stop aggregating over the measurement time interval and base your SaaS churn rate calculation only on contracts that are up for renewal. The trick here is that since you are selectively only looking at contracts up for renewal and they may have many different renewal periods, the correct measurement interval to use in your SaaS churn rate calculation is the average contract renewal period of all the contracts in your renewal sample for the month.

SaaS churn rate calculation

When only looking at contracts up for renewal, the correct measurement interval
to use in your SaaS churn rate calculation is the average contract renewal period.

The formula is the same, but the denominator only counts the number of contracts up for renewal in the month and the numerator counts the number of contracts up for renewal in the month that cancel.

Monthly Churn Rate = ΔCcontracts cancelled in month
Δtaverage contract renewal period x Ccontracts up for renewal in month

This is one of the most accurate ways to calculate churn provided you have enough contracts up for renewal each month. It is also the only approach that completely disentangles churn from growth, so it is particularly relevant in high growth situations.

SaaS Churn Calculation Tip #4 | Separate different customers into churn cohorts

Too much aggregation over non-uniform customer populations can distort your SaaS churn rate calculation. Whereas separating different types of customers into churn cohorts and calculating churn separately for each churn cohort can identify important levers you can push to improve your business.

saas churn cohorts

Aggregating over customers with dramatically different churn rates
can hide problems and untapped opportunities for improvement in your SaaS business.

Churn among customers frequently varies by contract MRR, renewal period, tire kickers vs. loyalists, and a host of customer attributes that you are already collecting in your CRM system that are just waiting to be analyzed.

SaaS Churn Calculation Tip #5 | Measure recurring revenue churn

Recurring revenue churn is calculated by substituting monthly recurring revenue or annual recurring revenue (MRR or ARR) into the standard customer churn calculation. It is essentially a recurring revenue weighted version of simple customer churn, i.e., big customers count more than smaller ones.

Monthly MRR Churn Rate Calculation = MRRbegin – MRRend
MRRbegin

The customer churn calculation can hide significant financial problems, such as downgrades or higher churn rates among larger customers. Conversely, it might make things look worse than they really are from a business viability point of view. Routinely measuring and comparing customer churn and MRR churn will help you detect nuances within your customer base that have a direct financial impact on your SaaS business.

SaaS Churn Calculation Tip #6 | Segment MRR churn into upgrades, downgrades and cancels

Perhaps the most useful aspect of MRR churn is the insight it provides into upgrades and downgrades, two important financial metrics that are not measured by the simple customer churn calculation. The calculation is essentially similar to calculating churn cohorts, one need merely identify those subscriptions that increased, decreased or disappeared altogether during the measurement interval and calculate MRR churn (MRR growth in the case of upgrades) separately for each category.

SaaS Churn Calculation Tip #7 | In high churn situations, use accurate conversion formulas

OK, the math will get a little harder here, but keep in mind that your next step is to call in a statistician. ;) It turns out that the annual churn rate is only approximately equal to 12X the monthly churn rate, and this approximation fails for large churn scenarios. The true relationship between the annual churn rate and monthly churn rate is given by the following formula:

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

Or, if you find that monthly churn fluctuates a lot from month to month, then you can calculate annual churn as follows:

Annual Churn Rate = 1 – (1 – m1) x (1 – m2) x … x (1 – m11) x (1 – m12)

Where mi is the monthly churn rate for month i. The reason this is the true formula is that the number of customers hanging around at the end of 12 months is calculated thus.

Cend = Cbegin x (1 – m1) x (1 – m2) x … x (1 – m11) x (1 – m12)

For example, suppose your monthly churn rate measurement comes out to be 10%. Multiplying by 12 would give an annual churn rate of 120%!? Which is clearly not possible, as a churn rate cannot exceed 100%. The correct answer is 72% = 1 – ( 1 – .1 )^12.

The reason you can often simply multiply by 12 to convert the monthly churn rate into the annual churn rate is that is just so happens that for time intervals less than about 10% of the average customer lifetime (or total churn in interval < 10%) the following approximation applies.

(1 – Monthly Churn Rate)^12 ≈ 1 – Monthly Churn Rate x 12

Unfortunately, this approximation can really mess up your numbers in high churn situations. I say 10% because 2 x 10% = 20% whereas the exact formula gives 19% = 1 – ( 1 – 10% )^2, which is more accurate than most businesses care about or the SaaS churn model in the first place. More than 10%, however, and calculations become pretty inaccurate. The inverse of this formula is also useful.

Monthly Churn Rate = 1 – (1 – Annual Churn Rate)^(1/12)

Recall the example from Tip #1 above, where a quarterly measurement interval caused us to miscalculate the monthly churn rate as 19% instead of 25%. In this example, we had 100 customers to start and only 42 left at the end of a quarter. Had we used the correct formula to calculate monthly churn from quarterly in this example we would have done the following.

Monthly Churn Rate = 25% = 1 – ( 42 / 100 )^(1/3)

If you are willing to do the math above, then you can use longer measurement intervals even when churn is high and there is no need to follow Tip #1.

Comment on Facebook!

21 More Comments at Chaotic Flow:

  1. Dave, 4. September 2012, 16:11

    After working for a start-up SaaS company, I can testify that this is the scariest metric to know… especially for the owners. The owners of my SaaS company relied on the old head-in-sand method of dealing to deal with a high churn. That is NOT the way to do it. I like your method much better.

     
  2. Alan Gleeson, 5. September 2012, 2:30

    Fantastic Analysis as always Joel, Would be great to get your views on the different approaches to managing this from a management point of view. Via excel or through dashboard type products like Totango, Kissmetrics etc Any others you’d recommend? Alan

     
  3. Joel,

    Excellent insights, as always.

    You might want to clarify the formula for the most common method of calculating churn: Monthly Churn Rate Calculation = (C begin – C end)/ C begin

    It might help if the formula explicitly backs out the number of new customers, those who subscribed during the period, from the C end. That may eliminate potential confusion.

    ((C begin -(C end – C new))/C begin

    Though still subject to some flaws, that would at least partially disentangle churn from growth. SaaS companies shouldn’t be masking high churn with high growth.

     
  4. Joel York, 5. September 2012, 8:19

    Hi Peter,

    Thanks for the comment. You are absolutely correct! My Cend is meant to be only those customers that were originally left over from Cbegin and should exclude any new customers (cnew) booked in the measurement interval from the calculation altogether. Upon re-reading the post, this is not clear…so, I will make some edits.

    This also gives a good opportunity to explain in more detail exactly how growth becomes entangled with churn (outside of including new customers in the numerator, ΔC, which as you point out should simply never be done. However, growth can still be a problem in calculating churn, because it is all but impossible to exclude it from the denominator, (Cbegin). For example, if you book 50 new customers in month 1 and you have contract renewal periods longer than one month, how do you handle them in month 2, 3, etc? If you include them in month 2 in (Cbegin), but they cannot actually cancel their contracts for say 3, 6, 12, or 24 months, then you will systematically underestimate churn. If you have lots of different contract lengths, then when exactly do you include them?

    The above is the rationale behind tip #2 and tip #3. Tip #2 averages over the problem to a degree, but it does not solve it entirely. Tip #3 eliminates this problem altogether by measuring only contracts that are up for renewal. This is why tip #3 is the most accurate approach of all for disentangling growth. However, all approaches are subject to accuracy issues in very high churn scenarios (tip #7).

    Thanks again for the constructive feedback!

    Cheers,

    Joel

     
  5.  

    [...] SaaS Metrics FAQs #1. What is SaaS churn? Why is SaaS churn important? And, what is the best SaaS churn rate calculation method?chaotic-flow.com/saas-metrics-faqs-what-is-churn/ [...]

     
  6. John Stoddart, 19. September 2012, 0:12

    Hi Joel,

    This is an extremely interesting piece of work – much greater detail than I was expecting (it took me back to maths exams a great deal of time ago). I’m currently writing a piece about the marginal additional profitability of a customer if you can extend their average length of stay by +6 months / +12 months.

    Going to look over this again tonight, especially the examples.

    Thanks,

    John

     
  7. SaaS Metrics FAQs | What is Churn? | WikiCloud (Pingback), 29. September 2012, 19:18
     

    [...] (Cross-posted @ Chaotic Flow by Joel York) [...]

     
  8. David Szabo @SaaSinCloud, 22. November 2012, 6:03

    Brilliant summary – very practical, thanks Joel!

     
  9. Astria, 10. December 2012, 14:44

    Good job! Love your post! Very helpful.

     
  10. What is MRR Churn? | SaaS Metrics FAQs Part 2 (Pingback), 15. January 2013, 10:32
     

    [...] all your SaaS customer churn formulas. For this reason, SaaS MRR churn is subject to all the same measurement problems of SaaS customer churn arising from low churn rates, high churn rates, variable contract lengths, and so forth. If you [...]

     
  11. S. Sinclair, 20. January 2013, 4:51

    Joel,

    this is a nice article.
    But woulnt you calculate the annual churn ( 1.05 ^ 12 ) * ( 1 / 1.20)
    where 1.20 is a 20% growth in my revenues.

    As chur should be discounted to the growth of my revenue.

    Or did I get that wrong?

     
  12. Joel York, 20. January 2013, 8:56

    Not sure exactly what you are asking, but I think the example above means you are assuming a 5% monthly churn rate and a 20% annual growth rate….yes?
    In which case, I think you meant (.95 ^12)*(1/1.20).

    You are absolutely correct that you need to adjust for growth when you have it to calculate the correct value of churn. The formula I use in the post assumes either zero growth or that you are separating out growth customers and only dealing with original customers and the subset of those that churn.

    The formula in your example is close, but not quite correct. I’ll provide the correct formula to adjust for growth below, but here are a couple of calculation tips to help keep things clear. First, it’s good practice to separate churn from growth cleanly in your data and calculations. Also, it’s generally clearer to stick to a single time interval, i.e., monthly or annual, but not both, in your calculations…then convert from monthly to annual after the fact.

    It makes more sense if you lay out the entire formula for change in customers over time, including both churn and growth.

    Ctotal at end of month = Cbegin of month x (1 – monthly churn) x (1 + monthly growth)

    or more compactly

    Ctotal end = Cbegin x (1 – a) x (1 + g)

    solving for a = monthly churn gives

    a = [ Ctotal end / ( 1 + g ) - Cbegin ] / Cbegin

    In the formula above, you can see that the entire churn rate is NOT divided by ( 1 + g ), but only the total customers at the end of the month, Ctotal end. This is the essence of Peter Cohen’s comment above and the explanation in the “note” under the main churn formula that Cend in the formula refers to ONLY those customers that are left from the original Cbegin. Or rather….

    Churn only…
    Cend = Cbegin x ( 1 – a )

    Churn and growth…
    Ctotal end = Cend x ( 1 + g ) = Cbegin x (1 – a) x (1 + g)

    My reason for not including growth in the primary churn formula was just to keep it simple.

    Hope this helps.

    Cheers,
    Joel

    PS For the mathematically inclined, it’s worth pointing out that this multiplicative build up of churn, then growth, implicitly assumes they are independent of one another. In truth, they are only independent when your measurement interval is ZERO. Much of the churn calculation issues arise from this and the tips above are very much about ensuring that growth and churn can be treated independently as a good approximation.

     
  13. 5 More Lessons From a $213,000 Launch — Think Traffic (Pingback), 14. February 2013, 5:45
     

    [...] This isn’t an easy number to calculate, especially when you first launch, but it’s probably the most important number for any subscription type [...]

     
  14.  

    [...] been discussed quite a bit. But many first time SaaS merchants overlook churn or don’t even know what churn is. We will explore the ins and outs of churn and tell you how to fight [...]

     
  15.  

    [...] churn is hard. Articles like Joel’s What is Churn? makes you feel you are never going to get it right. There are so many things that you need to take [...]

     
  16.  

    [...] Use short time periods rather than long ones, as you’ll get more actionable numbers. Preferably, you should use the period of your average renewal. If you’re a SaaS business that charges monthly, then use monthly churn as your go-to statistic. Joel York gets into detail on why this is more accurate in his post discussing what churn is all about. [...]

     
  17.  

    [...] out Joel’s churn tip #7 for more [...]

     
  18.  

    [...] its simplest, least useful form is equal to the revenue churn divided by the recurring revenue.  Revenue Churn is defined as the amount of recurring revenue lost from churn versus the total recurring revenue earned during [...]

     
  19. Confluence: Administration (Trackback), 15. July 2014, 17:29
     

    Food for Thought….SaaS related blogs and readings…

    Click through some of these links to learn about S…

     

Dont use Facebook? Write a comment anyway!