Gold by MangoMagic

Cross-Functional · Framework · Advanced · Saves 40+ hours

Cohort Analysis Framework

A framework for conducting cohort analysis.

Get coached on this — free

What's included

  • Cohort definition
  • Analysis methodology
  • Visualization approach
  • Insight extraction
  • Action development

Best used when

  • Understanding retention patterns
  • Evaluating product changes
  • Analyzing customer lifetime value
  • Comparing acquisition channels

Why this is Gold

Averages hide the truth. Cohort analysis reveals how different customer groups actually behave over time.

The template

The Template

COHORT ANALYSIS

Cohort Definition Template

COHORT ANALYSIS SETUP

ANALYSIS GOAL: _______________
COHORT TYPE: _______________

COHORT DEFINITION:
Grouping dimension: _______________
Time period: _______________
Cohort size minimum: _____

METRIC TO TRACK:
Primary metric: _______________
Calculation: _______________
Time periods: Week 1, Week 2, Week 3...

COHORT GROUPS:
Cohort 1: _______________
Cohort 2: _______________
Cohort 3: _______________

Cohort Analysis Table

RETENTION COHORT TABLE

            | Week 0 | Week 1 | Week 2 | Week 4 | Week 8 | Week 12 |
------------|--------|--------|--------|--------|--------|---------|
Jan cohort  | 100%   |   %    |   %    |   %    |   %    |    %    |
Feb cohort  | 100%   |   %    |   %    |   %    |   %    |    %    |
Mar cohort  | 100%   |   %    |   %    |   %    |   %    |    %    |
Apr cohort  | 100%   |   %    |   %    |   %    |   %    |    %    |

INSIGHTS:
☐ Best performing cohort: _____
☐ Worst performing cohort: _____
☐ Key difference: _______________
☐ Action to take: _______________

Cohort Types

Type Grouping Use Case
Acquisition Sign-up month Retention analysis
Behavior First action taken Feature impact
Source Acquisition channel Channel quality
Segment Customer tier Segment comparison

Frequently asked questions

What is the Cohort Analysis Framework?

A framework for conducting cohort analysis.

Who is the Cohort Analysis Framework for?

It is built for Cross-Functionals and their teams working on Analytics. The AI coach adapts it to your company, stage, and goals.

How long does the Cohort Analysis Framework take to use?

It saves roughly 40+ hours versus building from scratch. Our AI coach can tailor the framework to your situation in minutes, then hand you a step-by-step plan.

Is the Cohort Analysis Framework free?

Yes. You can read the full framework and start getting coached through it for free. Sign in to save your tailored version and track your next steps.

How does the AI coach help with the Cohort Analysis Framework?

The coach teaches you the framework, asks a few questions about your business, tailors the framework to you, and gives you measurable next steps to execute.