Cohort Analysis

intermediatedataMin 16K context

Builds retention and behavioral cohort analyses from event or transaction data. Defines cohorts by acquisition date or attributes, computes retention and churn curves, generates the SQL or pandas code to produce cohort tables, and interprets the results into actionable insights about engagement and lifecycle.

cohortretentionanalyticschurnmetricssql

Use Cases

  • Computing weekly/monthly retention cohorts
  • Building churn and engagement curves
  • Generating SQL or pandas for cohort tables
  • Comparing cohorts by acquisition channel
  • Interpreting cohort trends into recommendations

Example Prompt

I have an "events" table (user_id, event_name, event_time) and a "users" table
(user_id, signup_date, channel).

Produce a monthly signup cohort retention analysis:
1. SQL to build the cohort retention table
2. How to read the resulting matrix
3. Two hypotheses to investigate based on typical retention shapes

Recommended Models

gpt-5claude-opus-4-6deepseek-v4

Compatible Tools

claude-codecursorkiroany

Modalities

Input: text, code
→
Output: code, text

Related Skills

data-analysisab-test-setuptime-series-forecasting

Author

OpenModels Community

@openmodelsrun