Course contentsShow
← Data Science
Lesson 1647 of 2,14540. Customer and Product AnalyticsFree lesson

Building a Cohort Table

Construct a cohort analysis table showing user counts or metrics across cohorts and time periods after entry.

Building a Cohort Table

You'll learn: How to construct a cohort analysis table that displays user counts or key metrics across cohorts and time periods after their entry event.

Core Idea

A cohort table is a structured grid where rows represent different cohorts (groups who joined in the same time period) and columns represent time periods after entry (Day 0, Week 1, Month 2, etc.). Each cell shows how many users (or what percentage) from that cohort remained active or performed a key action at that point in their lifecycle.

Think of it like a class reunion tracker: each row is a graduating class (2020, 2021, 2022), and each column shows how many attended reunions 1 year out, 2 years out, 3 years out, etc. This lets you see not just overall attendance, but whether newer or older classes have better long-term engagement.

Structure of a Cohort Table

Rows: Each cohort (e.g., users who signed up in January 2024, February 2024)
Columns: Time periods after cohort start (Week 0, Week 1, Week 2, ... Week N)
Cells: Metrics like user count, retention rate, cumulative revenue, or conversion rate

What You're Measuring

The cells can contain:

  • Absolute counts: 500 users from Jan cohort were active in Week 3
  • Retention rates: 45% of Jan cohort returned in Week 3
  • Cumulative metrics: $12,500 total revenue from Jan cohort by Week 3
  • Event frequencies: Average 2.3 purchases per user by Month 2

The table reveals patterns across cohorts: Are newer cohorts retaining better? Is revenue per cohort accelerating or declining over time?

Key Takeaway: A cohort table organizes users by entry period (rows) and lifecycle stage (columns), letting you compare retention, behavior, or value metrics both within cohorts over time and across cohorts at the same lifecycle stage.