Since publishing the original SaaS metics blog series and subsequent SaaS Metrics Guide to SaaS Financial Performance, I’ve received numerous inquiries on various details and hidden gotchas in SaaS metrics implementation. This new series of SaaS Metrics FAQs explores some of these finer SaaS metrics points in a simple Q&A format. In this second post, I examine SaaS MRR churn, a SaaS metric that extends from SaaS customer churn which was covered in the first installment.
SaaS Metrics FAQ #4 | What is MRR Churn?
SaaS MRR churn measures the erosion of SaaS monthly recurring revenue (MRR). Mathematically, the SaaS MRR churn rate is an extension of the SaaS customer churn rate calculated by substituting monthly recurring revenue in place of the number of customers. For example, if your SaaS business has 100 customers representing an MRR base of $1M at the beginning of the year, and 5 customers cancel a total of $100K in MRR during the year, then your annual MRR churn rate is 10%, while your annual customer churn rate is only 5%. The general formula for for SaaS MRR churn can be stated as the amount of MRR cancelled (ΔMRR) per time interval (Δt) divided by the total MRR at the beginning of the interval (MRRtotal).
|SaaS MRR Churn Rate||=||ΔMRR|
|Δt x MRRtotal|
In the formula above, the Δ is a common math symbol that means change or interval.
SaaS Metrics FAQ #5 | Why Measure MRR Churn?
The simple answer to this question is money. SaaS customer churn rate is important, particularly if you run a B2C SaaS business where revenue is generated by monetizing users through advertising or such. However, B2B SaaS companies generate revenue from direct subscription sales. SaaS customer churn is an interesting operations metric, but SaaS MRR churn is a critical financial metric. SaaS CFO’s always prefer MRR metrics.
The slightly more complex answer is that MRR metrics highlight two very important SaaS revenue drivers that customer metrics do not: upgrades and downgrades. SaaS MRR churn also tells you if SaaS customer churn is leaning more toward larger customers or smaller customers. In the example above, the MRR churn rate was double the customer churn rate, indicating that larger customers are churning. This quality of the SaaS MRR churn rate becomes more apparent when we expand the above formula to show off its individual components.
MRRtotal = C1 x MRR1 + C2 x MRR2 + … + CN-1 x MRRN-1 + CN x MRRN
In the expanded formula above, CN indicates the number of customers with a subscription value of MRRN. For example, if there are 100 customers with $10,000 MRR subscriptions and 10 customers with $100,000 subscriptions, then total MRR can be calcualated using the above formula as follows.
MRRtotal = $2M = 100 x $10,000 + 10 x $100,000
To this way of thinking, SaaS MRR churn can be viewed as recurring revenue weighted customer churn.
SaaS FAQ #5 | How Do I Analyze SaaS MRR Churn?
You can conduct all the same analyses on SaaS MRR churn that you do on SaaS customer churn from simple annual MRR churn rate calculations to complicated MRR churn cohort analysis. The main difference is in the interpretation of the results as recurring revenue weighted versions of the originals. Most importantly, MRR metrics provide the ability to separate the impact of downgrades and upgrades on changes to MRR from the impact of customer churn and growth, respectively.
SaaS MRR churn and growth analysis allows you to separate
the MRR impact of customer churn and new customer growth
from the MRR impact of downgrades and upgrades, repectively.
(A shout out to the Meltwater finance team for turning me on to
this nice MRR churn visual. Thanks Rik, Till and Ludwig!!)
SaaS Metric FAQ #5 | How Do I Calculate MRR Churn in Practice?
SaaS MRR churn is calculated by substituting MRR for the number of customers uniformly in 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 have any of these issues, you should refer to the previous post in this series which provides a number of SaaS churn calculation tips to mitigate them. If you decide to go measure MRR churn using only contracts up for renewal (Tip #3), then be sure to use the MRR weighted average contract renewal period.
|Monthly MRR Churn||=||ΔMRRcontracts cancelled or downgraded in month|
|ΔtMRR weighted average renewal period x MRRcontracts up for renewal|
In the formula above, the denominator only counts MRR from contracts up for renewal in the month and the numerator counts MRR of contracts up for renewal in the month that cancel or downgrade.
It’s also worth noting that there is zero difference between SaaS MRR churn and SaaS ARR churn, because all the formulas are percentages (monthly recurring revenue churn vs. annual recurring revenue churn, not monthly churn vs. annual churn). To convert any of the SaaS MRR churn formulas above so SaaS ARR, you simply multiply both the numerator and denominator by 12, cancelling the conversion out of the calculation. I could search and replace ARR for MRR throughout this entire blog post and it would still be 100% correct.
- Two SaaS Metrics That Actually Don’t Matter That Much: Churn and Sales Cycles (cloudave.com)
- Can We Ignore Churn Early On at a SaaS Company? (enterpriseirregulars.com)
(Cross-posted @ Chaotic Flow by Joel York)