Когортный анализ игроков

Cohort analysis — группировка users по shared characteristic для tracking behavior over time.

Cohort types

Acquisition cohort: signup month. Behavioral cohort: first deposit month. Segment cohort: acquisition channel, geo. Time-based analysis: retention D1/D7/D30, revenue accumulation. Behavior-based: game preferences over time.

Метрики

Retention rate: % active из cohort в period N. Revenue per cohort member. Session frequency. Deposit patterns. Churn rate. LTV accumulation. Compare cohorts: A/B, seasonality, acquisition improvements.

Insights

Cohort retention curves: normal exponential decay vs surprising drop. Comparison acquisition channels: paid vs organic quality. Product changes impact: cohort после changes. Seasonal patterns: holiday acquisition cohort behavior. Segmentation opportunities.

Implementation

SQL: window functions для cohort assignment. Tools: Amplitude, Mixpanel built-in. Data warehouse: dbt models для cohort tables. Visualization: heatmaps common (cohort × period). Regular reviews: weekly cohort dashboards в product team.