Customers still active at period end
Enter values to see detailed analysis and insights.
How to Use
- 1Enter total customers at the start of the period
- 2Input number of customers retained at period end
- 3Add average revenue per customer
- 4Review retention rate and revenue impact
- 5Target: 85%+ retention for SaaS, 70%+ for e-commerce
Retention & Churn Formulas
Retention Rate = (Retained Customers ÷ Total Customers) × 100%
Churn Rate = 100% - Retention RateVariables:
Retention Rate% of customers retainedChurn Rate% of customers lostTotal CustomersCustomers at period startRetained CustomersCustomers at period endExample
Inputs:
Steps:
- 1.Retention Rate = (850 ÷ 1,000) × 100 = 85%
- 2.Churn Rate = 100% - 85% = 15%
- 3.Lost Customers = 1,000 - 850 = 150
- 4.Revenue Impact = 150 × $100 = $15,000/month lost
- 5.Annual impact = $15,000 × 12 = $180,000
