Advanced Cohort Retention Analysis Calculator

Calculator Inputs

Cohort Name

Use a campaign, channel, or signup source label.

Cohort Start Period

Choose the month when this cohort was acquired.

Users Acquired

Total users in the original cohort base.

Marketing Spend

Total acquisition cost tied to this cohort.

Average Revenue per Active User

Expected revenue per retained user for each period.

Gross Margin %

Used to convert revenue into gross profit.

Retained Users Period 1

Active users remaining in period 1.

Retained Users Period 2

Active users remaining in period 2.

Retained Users Period 3

Active users remaining in period 3.

Retained Users Period 4

Active users remaining in period 4.

Retained Users Period 5

Active users remaining in period 5.

Retained Users Period 6

Active users remaining in period 6.

Reset

Example Data Table

Cohort	Start Users	Period 1	Period 2	Period 3	Period 4	Period 5	Period 6
January Email Campaign	1,200	840	690	600	510	450	395
February Paid Social	950	608	470	390	335	286	248
March Webinar	720	565	502	451	420	394	372

Formula Used

Retention Rate = Retained Users in Period / Users Acquired × 100
Period Churn Rate = (Previous Period Users − Current Period Users) / Previous Period Users × 100
Period Revenue = Retained Users × Average Revenue per Active User
Period Gross Profit = Period Revenue × Gross Margin
CAC = Marketing Spend / Users Acquired
LTV per Acquired User = Total Gross Profit / Users Acquired
ROI = (Total Gross Profit − Marketing Spend) / Marketing Spend × 100
Payback Period is the point where cumulative gross profit first covers marketing spend.
Retention Health Score uses weighted retention percentages to emphasize earlier and later period stability.

How to Use This Calculator

Enter the cohort name and start period.
Input the total users acquired in that cohort.
Add the full marketing spend used to acquire them.
Enter average revenue per active user for each period model.
Set the gross margin percentage to estimate gross profit.
Fill in retained users for Periods 1 through 6.
Press Analyze Cohort Retention to generate results.
Review retention, churn, CAC, LTV, ROI, payback, and the retention curve.
Use the CSV or PDF buttons to save and share the output.

Frequently Asked Questions

1. What is a cohort in retention analysis?

A cohort is a group of users acquired during the same period or through the same channel. Studying them together helps reveal how retention changes over time for a specific acquisition source.

2. Why does this calculator use six periods?

Six periods provide enough depth to spot early drop-off, mid-cycle stabilization, and long-term user value. You can treat each period as a week, month, or quarter based on your reporting setup.

3. Should retained users always decrease over time?

Usually yes, but not always. Reactivations, delayed event tracking, and billing cycles can create temporary increases. The calculator accepts those inputs, but you should confirm your tracking logic before interpreting the trend.

4. What does period churn mean here?

Period churn measures the percentage of users lost between two consecutive periods. It shows where engagement drops most sharply, helping marketers prioritize onboarding fixes, win-back flows, or product messaging changes.

5. Why include revenue and gross margin?

Retention alone does not show business value. Revenue estimates turn usage into income, while gross margin converts that income into contribution value, making ROI and payback far more useful for budgeting decisions.

6. How should I interpret the retention health score?

The score combines weighted retention percentages across periods. Higher values indicate more durable cohorts. Use it as a directional benchmark when comparing channels, campaigns, or onboarding experiments rather than as an absolute rule.

7. What if the payback period says not reached?

That means cumulative gross profit from retained users did not recover acquisition spend within the six modeled periods. Consider improving retention, increasing monetization, or extending the analysis horizon.

8. Can I use this for email, paid ads, or product cohorts?

Yes. The calculator works for channel-based, campaign-based, signup-month, or behavior-based cohorts. Just keep the time unit consistent so comparisons remain valid across reports and teams.