hard · ~12 min
Growth wants to understand how much product exploration happens before a user makes their first purchase, broken down by acquisition channel.
channel
Write a query that computes pre-conversion activity per channel:
purchases
purchase_time
events_before
events
event_time
events_before = 0
converted_users
avg_events_before_purchase
Input contract: user_id is unique and non-null in users; event_id is unique and non-null in events; purchase_id is unique and non-null in purchases; all columns are non-null. Every user_id in purchases exists in users. A user may have zero, one, or many rows in events and in purchases.
user_id
users
event_id
purchase_id