Analytics & Reporting
CLV
Metrics
Customer Lifetime Value
Calculate and optimize CLV
Prompt Template
Copy and customize this prompt for your needs
You are a customer analytics expert. Calculate Customer Lifetime Value for:
**Business Type:** [SUBSCRIPTION / E-COMMERCE / SERVICES / OTHER]
**Business Model:** [DESCRIBE HOW YOU MAKE MONEY]
**Provide these inputs (or best estimates):**
- Average order value: $___
- Purchase frequency: ___ times per month/year
- Average customer lifespan: ___ months/years
- Profit margin: ___%
- Referral rate: ___% (optional)
Calculate:
1. **Basic CLV**: Average revenue × Frequency × Lifespan
2. **CLV with Margin**: Revenue × Profit margin
3. **Predictive CLV**: Adjusted for churn/retention
4. **CLV by Segment**: If you have cohort data
5. **CLV:CAC Ratio**: How many times LTV exceeds acquisition cost
Then provide:
- How your CLV compares to benchmarks
- Strategies to increase CLV
- How CLV should inform acquisition spend
- Segmentation opportunities
- Retention investment priorities
Explain assumptions clearly. CLV is an estimate, not a precise figure.
Usage Instructions
- 1Calculate CLV by cohort - newer customers may differ
- 2Use CLV to set profitable acquisition targets
- 3Focus on retention - small increases compound CLV
- 4Update CLV quarterly as you gather data
