Founders Journey - Baremetrics

Use Baremetrics to calculate LTV for Stripe customers - Baremetrics

Written by Timothy Ware | October 08, 2021

Key takeaways:

  • Customer lifetime value (LTV) is a critical metric that helps you understand the average revenue clients bring in during their contract, and can be broken down based by audience segments
  • Calculating LTV manually can be complicated, but integrating Stripe with reporting analytics platforms like Baremetrics can do this automatically 
  • Tracking LTV alongside customer acquisition costs and churn allows for strategic decision-making when looking for ways to improve the customer experience or choose which audience segments to target

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.

Calculating 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!

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 integrates directly with your payment gateways, pulling data from your billing history so information about your customers is automatically piped into the Baremetrics dashboards.

Our software monitors subscription revenue for businesses that generate revenue through subscription-based services. It 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.

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.

See how to calculate CAC for Stripe customers to get started. 

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. 

Use Baremetrics to Calculate LTV

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. It is hard to make optimal decisions without a host of other metrics. 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 and track other essential metrics like customer churn

We have the best Stripe analytics dashboard, which 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.

Tired of wasting time on spreadsheets? Get a free trial of Baremetrics today!