Cohort Analysis

СреднийdataМинимальный контекст: 16K

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

Варианты использования

  • 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

Пример промпта

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

Рекомендуемые модели

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

Совместимые инструменты

claude-codecursorkiroany

Модальности

Вход: text, code
→
Выход: code, text

Похожие Skills

data-analysisab-test-setuptime-series-forecasting

Автор

OpenModels Community

@openmodelsrun