Cohort Retention in iGaming: Definition, Formula and Why It Beats Aggregate Retention Every Time

Warehouse-level aggregationWITH cohorts AS (
SELECT player_id,
DATE_TRUNC('month', registration_date) AS cohort
FROM registrations
),
activity AS (
SELECT player_id,
DATE_TRUNC('month', bet_date) AS active_month
FROM bets
GROUP BY player_id, DATE_TRUNC('month', bet_date)
)
SELECT c.cohort,
a.active_month,
COUNT(DISTINCT a.player_id) * 1.0
/ NULLIF(COUNT(DISTINCT c.player_id), 0)
AS retention_pct
FROM cohorts c
LEFT JOIN activity a USING (player_id)
GROUP BY c.cohort, a.active_month;

• CRM uses cohort retention curves to evaluate lifecycle programme changes against control cohorts.
• Marketing reads cohort retention by acquisition channel as the highest-quality channel evaluation signal.
• Finance uses cohort curves as the input to LTV models and revenue forecasts.
• Executives compare cohort retention across markets and brands as a portfolio health signal.

• Cohort retention curves typically show steep drop-off in the first 7 to 14 days followed by gradual decay; the steepness of the early drop is one of the strongest cohort quality signals.
• Bonus-driven cohorts often show a characteristic shape: high early retention through bonus play-through, sharp drop-off when the bonus expires, low long-tail retention thereafter.
• Organic cohorts (direct, SEO) tend to retain more steadily through the first 30 to 60 days than paid acquisition.
• VIP-rich cohorts show flatter curves with much higher long-tail retention than mass-market cohorts.
• Cohort-over-cohort improvement (newer cohorts retaining better at the same age) is the cleanest signal of CRM and onboarding work paying off.