Tricky~23min
The Phantom Conversion
A/B test shows treatment beating control by a 16% relative lift. Engineering wants to ship immediately. But the experiment ran for 30 days and something feels off — the numbers are too clean. Before you declare victory, check who was actually in each arm.
Tables you'll query
usersexperiment_assignmentsconversions
What you'll learn
SubqueriesJOINsAggregations & GROUP BY