SQL pattern · P22 · 6 problems

Funnels and conversion

Graded problems on funnels and conversion, from easy to hard.

6 problems · about 1 h 30 min in all
Start with problem 01Users at each funnel step · 4 min
Learn it first · P22The funnel that counts the wrong orderCounting each stage independently credits users who did the steps out of sequence.Read the lesson →

Easy

1 problem · about 4 min
01Users at each funnel step4 min →

Medium

3 problems · about 41 min
02Minutes from first page view to checkout9 min →03A three-step funnel that has to finish within 7 days18 min →04Conversion by the channel that brought each user in14 min →

Hard

2 problems · about 43 min
05Ordered page_view → checkout funnel18 min →06How far each user got through onboarding, in order25 min →
Up next · P23

The retention rate above 100%

7 practice problems. Counting events instead of distinct users lets one active customer look like several.

Practise P23Read P23