The Leaky Checkout

Sprint planning tomorrow — Raj needs the leak

Raj (Product Manager): Checkout conversion dropped from 12% to 8%. Which step are users abandoning? No guesses — specific step, biggest drop-off.

Raw `checkout_events` logs are in your repo. Define the 4-step checkout funnel, enforce sequential steps per session, and build the drop-off report in `funnel_analysis.sql`.

Expected finding: 400 sessions lost between payment entry and place order (66.7% relative drop).

Book: funnel analysis, conversion metrics · Prod: PM says conversion is down — you define the funnel.