easy · ~8 min
Growth wants to measure how quickly new users make their first purchase, broken down by acquisition channel.
channel
Write a query that reports per-channel conversion speed:
purchases
signup_time
purchase_time
converted_users
avg_hours_to_convert
Input contract: user_id is unique and non-null in signups; purchase_id is unique and non-null in purchases; channel, signup_time, and purchase_time are non-null. A user may have zero, one, or many rows in purchases, and every purchase occurs at or after that user's signup_time.
user_id
signups
purchase_id