OpenAI·Data Scientist·Take-home Assignment
- Write a SQL query to measure the performance of a free-month promotion experiment. Given an experiment_users table and a subscription_events table, return one row per variant with counts for eligible users, signups within 30 days, paid conversions within 60 days, churn within 90 days of first paid start, and a churn rate column.
“The churn definition is what got me.”