Glossary · Analytics

Cohort Analysis

An analytical technique that groups users by a shared characteristic over time to identify behavioral patterns.

Cohort analysis is a subset of behavioral analytics that divides users into groups (cohorts) based on shared characteristics–typically the time of their first action (e.g., signup month)–and tracks their behavior over subsequent time periods. This reveals patterns that aggregate metrics obscure: for example, overall retention might appear stable while specific cohorts are churning faster. Cohort analysis is essential for understanding user lifecycle, measuring feature impact, evaluating marketing campaigns, and forecasting revenue. Common cohort types include acquisition cohorts (by signup date), behavioral cohorts (by actions taken), and segment cohorts (by demographics).

In practice

How AI for Database applies it

Ask AI for Database "Show me retention by signup month" and get an instant cohort analysis table with no SQL required.
Analytics · aifordatabase glossaryRead-only ✓

Fig — every answer ships with the tables, rows and SQL behind it.

See it on your own database

Connect read-only in minutes. Free models included.

Start free