Roadmap
Day 46 · Retention 50 min 40 XP
🔁Cohorts and retention basics
Yesterday you met the KPI. Today's question is the one every business asks: do people come back? A cohort groups customers by when they started, so you can compare like with like instead of blending old and new users into one flattering average.
What you'll learn
- Explain what a cohort and a retention rate are
- Build a cohort retention table in SQL
- Read the table and spot a weak month
A peek inside
Cohort, period and retention
The rest of Day 46 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Build a retention grid
- 3-question quiz, up to 45 XP
- 4 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in