Complex~40min
The Successful Failure
A/B test showed ~8% better 7-day activation. You shipped to 100% of users. Three months later, 30-day revenue per user is down ~60%. The test said ship it. Why is it failing?
Tables you'll query
userseventspaymentsab_test_config
What you'll learn
Window FunctionsCTEs (WITH clause)Aggregations & GROUP BYDate & Time FunctionsCASE Statements