Back to Templates
SAAS METRICS
LTV & CAC Cohort Analysis
Track Customer Lifetime Value by cohort to determine the health of your subscription business.
LIVE PREVIEW
| Cohort Month | New Cust | CAC Spend | CAC per User | Month 1 Rev | Month 6 Rev | LTV (Proj) | LTV:CAC |
|---|---|---|---|---|---|---|---|
| Jan 2023 | 100 | $5,000 | $50 | $1,000 | $800 | $450 | 9.0x (Elite) |
| Feb 2023 | 150 | $10,000 | $66 | $1,500 | $1,100 | $400 | 6.0x (Great) |
| -- | -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Track Cohorts: Don't blend all users. Track users based on when they signed up.
- 2Include All Costs in CAC: Ad spend, sales commissions, and onboarding costs.
- 3Monitor Decay: Watch the retention rate drop off over time.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
The bible for SaaS growth. Prove your unit economics to investors.
Key Features
Cohort Grid: Visual retention tracking.
LTV Formula: Automated projection.
Common Use Cases
Fundraising: Essential for VC decks.
Ad Budgeting: Knowing your max CPA.
Frequently Asked Questions
What is a good LTV:CAC?
3:1 is the industry standard benchmark.