Executive Summary
Executive summary of key LTV findings
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.
Analysis Overview
Analysis configuration and data overview
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 Quality
Data quality and preprocessing summary
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.
LTV Summary Statistics
Descriptive statistics of customer lifetime value including central tendency, spread, and quartiles.
| Metric | Value |
|---|---|
| Count | 2000 |
| Mean | 2282 |
| Median | 1422 |
| Std Dev | 2238 |
| IQR | 3436 |
| Min | 18.8 |
| Max | 8476 |
| 25th Percentile | 416.5 |
| 75th Percentile | 3853 |
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.
LTV Distribution
Distribution of lifetime value across all customers, showing the concentration of customer value.
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.
LTV by Contract Type
Average lifetime value by contract term length, showing the impact of commitment level on customer value.
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.
Customer Segments by LTV Tier
Distribution of customers across three LTV tiers (Low/Medium/High), based on 25th and 75th percentiles.
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.
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.
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.
LTV Impact: Churn vs Retention
Average lifetime value for retained vs churned customers, demonstrating the business impact of customer churn.
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.