Complex~37min
The Healthy Cohort
Retention is 54% and the board is happy. The VP of Growth is pitching SMB expansion. One thing worth checking before you spin up a new sales motion: where exactly is that 54% coming from?
Tables you'll query
organizationsusersmonthly_active_usersorg_tiers
What you'll learn
CTEs (WITH clause)Window FunctionsCohort AnalysisAggregations & GROUP BY