Something went wrong!
Hang in there while we get back on track
Subscription Marketplace with Channel Segmentation
Analyzes LTV across organic, paid search, and referral channels for a 12-month-old subscription marketplace, revealing referral as the highest-value channel with 28:1 LTV:CAC ratio and specific budget reallocation recommendations.
Input
What you provide to the skill
Subscription marketplace, 12 months in. $120/month ARPU, 4% monthly churn, 70% margin. Organic CAC $200 (3% churn), paid search $350 (5% churn), referral $150 (2% churn).
Output
What the skill generates for you
Business Context
- Business Model: Subscription marketplace
- Stage: Growth stage (12 months in market)
- Data Availability: Channel-specific churn rates available
Recommended Method: Simple LTV with Channel Segmentation
With 12 months of data and clear channel-specific retention patterns, Simple LTV with segmentation is appropriate.
Overall LTV Calculation
Using blended metrics:
- ARPU: $120/month
- Blended Churn Rate: 4% monthly
- Gross Margin: 70%
Overall LTV = ($120 / 0.04) x 0.70 = $2,100
Segmented LTV Analysis
Organic Channel
- Churn Rate: 3% monthly
- Customer Lifetime: 1 / 0.03 = 33.33 months
Organic LTV = ($120 / 0.03) x 0.70 = $2,800
Paid Search Channel
- Churn Rate: 5% monthly
- Customer Lifetime: 1 / 0.05 = 20 months
Paid Search LTV = ($120 / 0.05) x 0.70 = $1,680
Referral Channel
- Churn Rate: 2% monthly
- Customer Lifetime: 1 / 0.02 = 50 months
Referral LTV = ($120 / 0.02) x 0.70 = $4,200
LTV:CAC Ratio Analysis
| Channel | LTV | CAC | LTV:CAC | Assessment | Payback |
|---|---|---|---|---|---|
| Organic | $2,800 | $200 | 14.0:1 | Outstanding | 1.7 mo |
| Paid Search | $1,680 | $350 | 4.8:1 | Good | 2.9 mo |
| Referral | $4,200 | $150 | 28.0:1 | Exceptional | 1.3 mo |
Key Insights
-
Referral channel is a gold mine: 28:1 LTV:CAC ratio with $4,200 LTV - 50% better than organic and 2.5x better than paid search.
-
Retention varies dramatically by channel: 3% delta between referral (2%) and paid search (5%) creates 150% LTV difference ($4,200 vs $1,680).
-
All channels are profitable: Even paid search with the weakest unit economics delivers healthy 4.8:1 LTV:CAC.
-
Payback periods are excellent: All channels under 3 months. Referral pays back in 1.3 months.
Actionable Recommendations
Immediate Actions:
-
Build a systematic referral program: With 28:1 LTV:CAC, invest heavily here. Consider spending $500-800 per referral acquisition and still maintain 5:1+ unit economics.
-
Increase referral incentives aggressively: Current $150 CAC is far below what economics support. Test doubling rewards to accelerate this channel.
-
Study referral customer profile: Understand WHY referral customers have 2% churn. These are your ideal customer profile - use insights to improve other channels.
Strategic Considerations:
-
Scale organic 2-3x: 14:1 ratio with 1.7 month payback justifies significant investment in content, SEO, and community building.
-
Optimize paid search targeting: 5% churn suggests marginal fit. Tighten targeting to acquire customers more similar to organic/referral segments. A 2% churn reduction would increase LTV to $2,800 (+67%).
-
Create referral amplification campaigns: Launch “refer 3 friends, get X” campaigns. With economics this strong, aggressive incentives will pay off.
Red Flags to Monitor:
- Watch for referral channel saturation (if volume stalls, economics may deteriorate)
- Monitor paid search churn closely - 5% is acceptable but not stellar
- Track whether referral quality degrades as you scale incentives
About This Skill
Calculate customer lifetime value by channel, tier, and segment. Get LTV:CAC ratios, retention analysis, and actionable recommendations to optimize marketing spend and customer economics.
View Skill DetailsMore Examples
Early-Stage B2B SaaS with Limited Data
Calculates LTV for a 3-month-old B2B SaaS with only 30 customers, demonstrating appropriate caveats for limited data, scenario analysis, and guidance on when to scale marketing spend.
D2C Fitness App with Freemium Upgrade Funnel
Models LTV for a freemium fitness app with 40% Premium-to-Enterprise upgrade rate, revealing that the upgrade path yields 250:1 LTV:CAC compared to 13.75:1 for direct Enterprise acquisition - a significant acquisition arbitrage opportunity.