easy · ~8 min
Growth tracks site visits and user signups in two separate event tables, each tagged with an acquisition channel.
channel
Write a query that reports per-channel funnel metrics:
visits
signups = 0
conversion_pct = 0.00
signups
conversion_pct = ROUND(signups * 100.0 / visits, 2)
conversion_pct
Input contract: visit_id is unique and non-null in visits; signup_id is unique and non-null in signups; channel is non-null in both tables. A channel can have many visits and many signups.
visit_id
signup_id