Use Baremetrics to calculate LTV for Stripe customers

Timothy Ware on October 08, 2021

To run a business online, you probably need a customer relationship management (CRM) software package and/or payment processor to manage your customers and their invoices. This is because handling many customers across regions by hand is difficult, and in a competitive market there is no room for errors.

Stripe is often the payment processor of choice for SaaS businesses because it can handle recurring revenue streams.

However, the rudimentary analytics dashboard included in Stripe does not offer all of the functionality needed to maximize growth. Indeed, to get the most out of customer data, SaaS businesses often rely on a third-party analytics dashboard for everything from basic SaaS metrics to financial forecasting and customer segmentation. 

One of the most important metrics is customer lifetime value (LTV). The lifetime value of a customer is just what it says—the total amount of revenue earned by the average customer during the duration of their contract. While it might sound like a simple concept, calculating the average revenue per user (ARPU) and the customer churn, which are necessary components of the LTV calculation, is complicated because the information is coming from many sources.

This complication can only increase when your customers tend to change pricing tiers, purchase add-ons, or you implement usage-based pricing.

Thankfully, when it comes to calculating LTV for Stripe customers, along with all of the related metrics, Baremetrics excels. Baremetrics is a business metrics tool that provides 26 metrics about your business, such as MRR, ARR, LTV, ARPU, churn, total customers, and more.

Baremetrics integrates directly with your payment gateways, so information about your customers is automatically piped into the Baremetrics dashboards.

You should sign up for the Baremetrics free trial, and start monitoring your subscription revenue accurately and easily.

 

What is LTV?

LTV is simply the average amount of money a customer pays you before they churn. This can be calculated as follows:

LTV = ARPU × Customer Lifetime

 

For example, if your ARPU is $60/month and your average contract length is 20 months, then your LTV would be $60 × 20 = $1200. But how do you get to an ARPU of $60 or a contract length of 20 months?

While the definition is simple, the calculations aren’t. That’s because there’s a lot of guesswork that goes into calculating the average length of a contract—and a lot of math to improve that guesswork. 

Since it isn’t possible to know the lifetime of your customer until they quit your service, or the average lifetime of your customers until a statistically meaningful sample of them leave, LTV is often calculated with churn:

LTV = ARPU/Customer Churn

 

Customer churn is the percentage of customers that leave your platform during a specified period, usually monthly. It can be calculated as follows: 

Customer Churn = (Churned Customers/Total Customers) × 100

 

If you have 1000 customers and 50 customers leave your site over the course of a month, then your customer churn is: (50/1000) × 100 = 5%.

If your customers are paying the same amount monthly as above ($60), then your 5% churn gives you an LTV of 60/0.05 = $1200. Note that in the calculation you should use churn as a decimal not a percentage.

 

Why is it difficult to calculate LTV for Stripe customers?

LTV can be difficult to calculate because, whatever way you choose to calculate it, the numbers are not fixed. For example, if you have three pricing tiers and several add-ons, then your customers might be spending different amounts each month. This can make ARPU hard to pin down. 

That’s a pretty simple example, too. It could be that you offer discounts for the first few months of service or you give credit to paying customers if they recruit another client. Then there is the question of how to deal with permanent price increases or decreases. What if you have the enviable position of a very long average customer lifetime? In that case should you apply a discount rate to future ARPU?

Churn can similarly jump around. It is often the case that customers do not churn linearly over the lifetime of their contract. Most companies will find that there is a sharp drop off after the first billing period along with some customers—hopefully the ones that truly find the value you offer and not just those that forget about their monthly payments—that just never quit. In this case, is it better to use an exponential function, and how does one do that exactly?

These don’t even include the issues specific to calculating LTV for Stripe customers. For example, Stripe’s basic analytics dashboard might not differentiate between paid customers and trials when calculating MRR, MRR growth, and LTV. Although everyone in the industry would love it if every trial converted to a paid sign up, that’s an overly optimistic approach to forecasting!

 

How do you calculate LTV for Stripe customers?

It can be difficult to calculate all of your needed revenue, customer, churn, and MRR movement metrics including LTV for Stripe customers directly on Stripe’s limited analytics dashboard. That’s why it is important to use Baremetrics to get the most out of your data.

Baremetrics monitors subscription revenue for businesses that bring in revenue through subscription-based services. Baremetrics can integrate directly with your payment gateway, such as Stripe, and pull information about your customers and their behavior into a crystal-clear dashboard.

Baremetrics brings you metrics, dunning, engagement tools, and customer insights. Some of the things Baremetrics monitors are MRR, ARR, LTV, the total number of customers, total expenses, quick ratio, and more.

Sign up for the Baremetrics free trial and start managing your subscription business right.

 

Segment Your Client Population 

Get deep insights into MRR, churn, LTV and more to grow your business

 

Customer acquisition cost (CAC) and LTV

LTV is at its most valuable when it is combined with customer acquisition cost (CAC). CAC is the average cost of getting one new paid customer. LTV is often combined with CAC as the LTV to CAC ratio. An LTV to CAC ratio of 3 (i.e., you earn $3 in LTV for every $1 spent on CAC) is generally considered sustainable. 

If your LTV to CAC ratio is lower than 3, then you probably need to either find a way to onboard new clients for less or to increase your LTV. You can increase your LTV by improving your ARPU, i.e. increasing your prices or upselling to your customer pool, or decreasing your churn, i.e. increasing the length of your customer lifetime. 

To succeed here, you need to segment your client population and direct different actions to each group.

 

Knowing what your LTV is for each customer segment is critical

When trying to calculate your LTV for Stripe customers, as well as the other needed SaaS metrics, directly on their platform, it can be difficult getting the fine grain detail needed. For example, it is important to understand the variation in your LTV based on different segments of your customers. This is something that Baremetrics can do automatically. 

The obvious follow up question is: Why is this important?

Well, it helps you target your actions more effectively. For example, if your American customers are keeping their services three times longer than those in Canada, you might want to see what value Americans are getting out of your service that Canadians are not. For example, if your software has American but not Canadian tax compliance in mind, it could be time to look into developing that functionality for your international customers. 

If you have some customers paying annually while others paying monthly and see that annual customers tend to remain loyal to your business for a much longer period of time, then you might want to increase the discount you offer for paying on an annual basis. 

If you offer three tiers and notice that the bottom tier has a very low LTV compared to the others, then you might want to scrap it. It could be that the reduced functionality removes that magic element that makes your product worth using, and forcing clients to upgrade, possibly at the same price for an introductory period, would get them to see the true value of the platform you provide and increase their longevity. 

Summary

LTV is an important metric that is needed for decision making throughout the company. LTV is used to calculate your CAC budget, and its components ARPU and churn are used in many of your growth metrics. 

However, LTV is only part of the picture. Without a host of other metrics, it is hard to make optimal decisions. Calculating LTV for Stripe customers, along with all of these other metrics, directly in Stripe can be difficult. 

So, whatever payment processor or CRM you choose, use Baremetrics to monitor your sales data.

Baremetrics makes it easy to collect and visualize all of your sales data. When you have many clients, it can be difficult to calculate your MRR, ARR, LTV, and so much more. Indeed, Baremetrics does all of this for you, and more.

Baremetrics can even monitor your SaaS quick ratio. Integrating this innovative tool can make financial analysis seamless for your SaaS company, and you can start a free trial today.

Timothy Ware

Tim is a natural entrepreneur. He brings his love of all things business to his writing. When he isn’t helping others in the SaaS world bring their ideas to the market, you can find him relaxing on his patio with one of his newest board games. You can find Tim on LinkedIn.