How to Calculate LTV from Stripe Data

Customer Lifetime Value (LTV) tells you how much total revenue you can expect from a single customer over the entire duration of their relationship with your business. It is one of the most powerful metrics in SaaS because it determines how much you can afford to spend on acquisition, where to focus retention efforts, and whether your business model actually works.

If you process payments through Stripe, you already have the raw data needed to calculate LTV accurately. This guide walks through the formulas, shows how to pull the numbers from Stripe, and covers practical strategies to increase lifetime value over time.

The Basic LTV Formula

The most common LTV calculation for subscription businesses is:

LTV = ARPU / Customer Churn Rate

Where ARPU is Average Revenue Per User (per month) and Customer Churn Rate is your monthly churn rate expressed as a decimal. For example, if your ARPU is $80 and your monthly churn rate is 4%:

LTV = $80 / 0.04 = $2,000

This means the average customer will generate $2,000 in total revenue before they churn. Understanding your ARPU calculation from Stripe data is the first step to getting this number right.

Alternative LTV Formulas

The basic formula assumes a constant churn rate, which is a useful simplification but not always accurate. Here are more nuanced approaches:

LTV with Gross Margin

If you want LTV to reflect profit rather than revenue, factor in your gross margin:

LTV = (ARPU x Gross Margin %) / Churn Rate

With an 80% gross margin, the example above becomes: ($80 x 0.80) / 0.04 = $1,600. This is more useful for evaluating how much you can actually spend on acquisition.

Cohort-Based LTV

Instead of using a single churn rate, cohort analysis tracks actual revenue from groups of customers who signed up in the same period. You measure how much each cohort generates month by month, then extrapolate. This is more accurate because it captures changing behavior patterns over time, such as higher early churn that stabilizes after 6 months.

Predictive LTV

For businesses with enough historical data, statistical models can predict LTV based on customer attributes like plan type, industry, company size, and engagement level. This is advanced but increasingly accessible with modern analytics tools.

The LTV:CAC Ratio

LTV on its own is useful, but the LTV:CAC ratio is where the real decision-making happens. CAC (Customer Acquisition Cost) is the total cost of acquiring a new customer, including marketing spend, sales salaries, and tooling.

LTV:CAC Ratio = LTV / CAC

Here is how to interpret the ratio:

• Below 1:1: You are losing money on every customer. Your business is not viable at current economics.
• 1:1 to 3:1: You are breaking even or marginally profitable per customer. There is little room for error or investment.
• 3:1: The widely cited benchmark for a healthy SaaS business. You earn three dollars for every dollar spent on acquisition.
• Above 5:1: You may be under-investing in growth. If unit economics are this strong, there is likely room to spend more aggressively on acquisition.

Calculating LTV from Stripe Data

Stripe stores everything you need to calculate LTV, but the data is spread across multiple objects. Here is what you need to pull together:

Step 1: Calculate ARPU

Sum the MRR of all active subscriptions and divide by the number of unique customers. Remember to normalize annual plans to their monthly value and exclude one-time charges. Stripe's subscription objects contain the plan amount, interval, and quantity, which give you everything needed.

Step 2: Calculate Churn Rate

Count the subscriptions that moved to a cancelled or unpaid status during the period, divided by total active subscriptions at the start. You need to handle edge cases like trial expirations (which are not true churn if the customer never converted) and paused subscriptions. Our churn rate tracking guide covers these nuances in detail.

Step 3: Apply the Formula

Divide ARPU by churn rate. For gross-margin-adjusted LTV, multiply ARPU by your margin percentage first. For the LTV:CAC ratio, pull your acquisition costs from your marketing and sales tools and divide.

Step 4: Segment and Compare

A single company-wide LTV number hides important differences. Calculate LTV by plan tier, acquisition channel, customer size, and cohort. You will often find that one segment has 5x the LTV of another, which should dramatically change your acquisition strategy.

Strategies to Improve LTV

There are only two levers: increase ARPU or reduce churn. Here are the most effective approaches for each.

Increase ARPU

• Usage-based pricing: Add a variable component that grows with customer success. As customers get more value, they naturally pay more.
• Upsell paths: Create clear upgrade triggers tied to usage thresholds. When a customer hits 80% of their plan limit, prompt an upgrade.
• Add-ons and modules: Build complementary features that solve adjacent problems. Each add-on increases the average revenue per account without requiring a full plan change.
• Annual plan incentives: Offer a discount for annual billing. While the monthly rate is lower, the commitment reduces churn and improves cash flow.

Reduce Churn

• Nail onboarding: Get customers to value quickly. The first 14 days are make-or-break for most SaaS products.
• Proactive support: Reach out to customers showing declining usage before they make the cancellation decision.
• Fix failed payments: Involuntary churn from expired cards and payment failures is preventable. Implement dunning sequences and card updater services.
• Build integrations:The more connected your product is to a customer's workflow, the harder it is to rip out.

Automating LTV Tracking

Manually calculating LTV from raw Stripe API data every month is unsustainable. The calculations require joining subscription, invoice, and customer objects, handling edge cases, and maintaining historical data for cohort analysis.

StripeReport connects to your Stripe account with a read-only API key and calculates LTV alongside subscription analytics like MRR, churn, and ARPU automatically. You get the full picture of your unit economics in daily email and Slack reports, so you always know whether your LTV:CAC ratio is trending in the right direction.

Key Takeaways

• LTV equals ARPU divided by churn rate, but adjust for gross margin to get a more actionable number.
• Target an LTV:CAC ratio of at least 3:1 to ensure sustainable growth and healthy unit economics.
• Segment LTV by plan, channel, and cohort to uncover which customers are most valuable and allocate resources accordingly.
• Improve LTV by increasing ARPU through upsells and usage-based pricing, and by reducing churn through better onboarding and failed payment recovery.
• Automate the calculation with StripeReport to track LTV trends in real time without manual data wrangling.