I've been tracking basic metrics but struggling with LTV calculation and optimization. Can the community help clarify?
My Questions:
1. What's the most accurate formula for calculating LTV in F2P games?
- Should I use average or cohort-based LTV?
- What time frame is standard (30/60/90/180 days)?
2. How do you balance LTV vs CAC (Customer Acquisition Cost)?
- What's a healthy LTV:CAC ratio?
- When should you increase marketing spend?
3. What factors improve LTV most effectively?
- Better onboarding?
- More content?
- Improved monetization mechanics?
- Community features?
4. How often should LTV predictions be recalculated?
- Daily? Weekly? Monthly?
5. Tools and methods you recommend?
- Excel templates?
- Built-in analytics platform features?
- Custom dashboards?
Current Context:
- Mobile puzzle game, F2P with IAP
- D1 retention: 45%, D7: 18%, D30: 8%
- Current LTV(180): $2.40
- Conversion rate: 3.2%
Any insights or resources would be incredibly helpful!