#838

Measure the «saw pricing → bought» conversion

Marketing computes the classic conversion: «how many users first viewed the /pricing page and then clicked the buy button». Order matters: not «ever saw pricing and ever clicked buy», but precisely «the buy click happened after the very first /pricing view». Count the number of such users in the funnel. Hint: for every user you need two moments — the first /pricing view (event of type page, with payload key path equal to /pricing) and the first buy click (event of type click, with payload key target equal to buy); the user is counted when the second moment is strictly later than the first.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

n
2

Your query result will appear here