Skip to main content
Calcimator

Cohort Analysis Calculator

Analyze user cohort retention over time. Calculate monthly retention rates, churn rates, estimated customer lifetime value (LTV), and total cohort revenue.

Inputs

$

Results

Month 1 Retention

40%

Estimated LTV

$59.76

≈ 12 cups of coffee

Month 2 Retention25%
Month 3 Retention18%
Avg Retention Rate27.67%
Month 1 Churn60%
Month 2 Churn (period)37.5%
Month 3 Churn (period)28%
Observed Cohort Revenue$45,750.00
How to Use This Calculator
  1. Enter the cohort size at acquisition and retention counts at each time period.
  2. Set the time interval (weekly, monthly) and number of periods to analyze.
  3. Review retention rate and churn rate at each period.
  4. Identify which cohorts show higher retention to trace back to acquisition channel or product change.
  5. Use the lifetime value output to set customer acquisition cost targets.

How the result changes with Initial Users (Month 0)

Initial Users (Month 0)Month 1 RetentionEstimated LTV
1,000,0010.04%$45.33
3,500,0010.01%$45.32
6,500,0000.01%$45.32
9,000,0000%$45.32

What each input means

Initial Users (Month 0)
Number of users who joined in the cohort's starting month.
Month 1 Retained
Number of original cohort users still active in month 1.
Month 2 Retained
Number of original cohort users still active in month 2.
Month 3 Retained
Number of original cohort users still active in month 3.
Avg Revenue per User ($)
Average monthly revenue generated per active user (ARPU).

How this is calculated

Worked example, using the default values

  1. Identify Input Parameters
    4 parameters
    Initial Users (Month 0) = 1000, Month 1 Retained = 400, Month 2 Retained = 250, Month 3 Retained = 180 = 5 input(s) provided
  2. Calculate Month 1 Retention
    Month 1 Retention
    40 = 40
  3. Calculate Estimated LTV
    Estimated LTV
    59.76 = $59.76
  4. Calculate Month 2 Retention
    Month 2 Retention
    25 = 25
  5. Calculate Month 3 Retention
    Month 3 Retention
    18 = 18

Engine last updated . Checked against 1 independently-derived test how we verify calculators.

The questions that sit next to this one — chosen by subject, including calculators filed under a different category.

More in Math & Statistics.