Saas · Customers · Lifetime Value P1778698833
Executive Summary

Executive Summary

Executive summary of key LTV findings

Total Customers
2000
Mean LTV
2281.53
Median LTV
1421.75
LTV Std Dev
2238.28
LTV Range (Min-Max)
19-8476
High-Value Threshold
3852.95
Analysis of 2000 customers reveals a mean lifetime value of $2281.53 (median $1421.75) with substantial variation (SD $2238.28). Customer values range from $19 to $8476, with the top 25% of customers worth $3852.95 or more. Contract type and churn status are the primary drivers of customer value differences.
Interpretation

Analysis of 2000 customers reveals a mean lifetime value of $2281.53 (median $1421.75) with substantial variation (SD $2238.28). Customer values range from $19 to $8476, with the top 25% of customers worth $3852.95 or more. Contract type and churn status are the primary drivers of customer value differences.

Overview

Analysis Overview

Analysis configuration and data overview

Total Customers2000
Mean Ltv2281.53
Median Ltv1421.75
Ltv Std Dev2238.28
Ltv Range (Min-Max)19-8476
High-Value Threshold3852.95
Interpretation

This analysis examines customer lifetime value distribution and drivers across subscription customers, with focus on how contract type, tenure, and churn status predict customer value.

Data Preparation

Data Quality

Data quality and preprocessing summary

Total Customers2000
Mean Ltv2281.53
Median Ltv1421.75
Ltv Std Dev2238.28
Ltv Range (Min-Max)19-8476
High-Value Threshold3852.95
Interpretation

Analyzed 2000 customers with complete data. No rows removed during preprocessing. All required columns (customer_id, tenure_months, monthly_charges, lifetime_value, contract_type, churn_flag) are present and valid.

Data Table

LTV Summary Statistics

Descriptive statistics of customer lifetime value including central tendency, spread, and quartiles.

MetricValue
Count2000
Mean2282
Median1422
Std Dev2238
IQR3436
Min18.8
Max8476
25th Percentile416.5
75th Percentile3853
Interpretation

The 2000 customers in this dataset have a median LTV of $1421.75 and mean of $2281.53, indicating a right-skewed distribution with some high-value customers. The interquartile range is $2238.28, showing variation in value within the middle 50% of customers. Both the standard deviation and range (min $19 to max $8476) confirm substantial heterogeneity in customer worth.

Visualization

LTV Distribution

Distribution of lifetime value across all customers, showing the concentration of customer value.

Interpretation

The LTV distribution is strongly right-skewed, with most customers clustered at lower values and a long tail of high-value 'whale' customers. The median of $1421.75 is substantially below the mean of $2281.53, confirming the skew. This pattern is typical in SaaS and subscription businesses where a small percentage of committed, long-tenure customers generate disproportionate value. The distribution suggests segmentation strategies (e.g., specialized handling for high-LTV customers) could be particularly valuable.

Visualization

LTV by Contract Type

Average lifetime value by contract term length, showing the impact of commitment level on customer value.

Interpretation

Contract type is a strong predictor of customer lifetime value. Two year contracts deliver the highest mean LTV at $3705.45, compared to the shortest-term contracts which show substantially lower customer value. This reflects the reality that longer-term commitments attract and retain higher-value customers who are more confident in the service. The LTV difference by contract highlights the business value of converting month-to-month customers to longer-term arrangements.

Visualization

Customer Segments by LTV Tier

Distribution of customers across three LTV tiers (Low/Medium/High), based on 25th and 75th percentiles.

Interpretation

Customer value is distributed across three segments: 25.0% in the Low LTV tier, 49.9% in Medium, and 25.0% in High LTV. This segmentation reveals that the top quartile of customers (High LTV segment) represent a critical group for retention and upsell efforts. The concentration of customers in different tiers has direct implications for customer lifetime value management — targeting high-value segment needs differently from lower-value segments can improve profitability.

Visualization

Tenure vs Lifetime Value

Scatter plot of customer tenure (months) vs lifetime value, with points colored by contract type to reveal commitment-based growth patterns.

Interpretation

Tenure is a strong predictor of customer lifetime value, with correlation of 0.822. Customers who stay longer naturally accumulate higher lifetime value through continued monthly charges. The plot reveals that customers on longer-term contracts (One year and Two year) form distinct clusters with higher tenure and LTV values, while month-to-month customers show more variability and lower overall value. This pattern emphasizes the compounding value of customer retention — even a few additional months of tenure translates to measurable LTV gains.

Visualization

LTV Impact: Churn vs Retention

Average lifetime value for retained vs churned customers, demonstrating the business impact of customer churn.

Interpretation

Retained customers have substantially higher lifetime value ($2559.07) compared to customers who churned ($1506.44), representing a 69.9% difference. This gap underscores the critical importance of retention strategies — customers lost to churn have lower historical value both because they left early and because higher-value customers are less likely to churn. Investing in retention, particularly for medium and high-LTV segments, directly protects the customer value base.

Your data has more stories to tell. Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export. 2,000 free credits on signup.
Try Free — No Signup Sign Up Free

Report an Issue

Tell us what's wrong. You'll get a free re-run of this analysis so you can try again with different parameters. If the re-run still doesn't meet your expectations, we'll refund your credits.

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing