Funnels and retention
Follow a game's players from signup to first purchase, measure who comes back in week one, and stop a LEFT JOIN hiding the non-buyers.
- The skill
- Measure how many people get through each step of a product, and how many come back, with one flag per person built in steps.
- You make
- A funnel and a week-one retention report for a puzzle game's first four months.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 37 Pivots, rows into columns. Free to try: SQL Foundations and the playground.
Passed
You can now
You have what you need for a project: Shop analytics dashboard Premium 4 hours
Step 1 of 7
exercise_1.sql
You've reached the good stuff.
4 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite