Help with query to measure page conversion

Hi everyone.

The metric is pretty simple, I have page A with 2 buttons to page B and C. I need the % of people that after page A, went to page B and same for C.
We are not measuring button clicks for now so I’m trying to do it just by using the page_urls of the pageview events but I can’t figure out how to write the query yet.

Any help would be appreciated.


I ended up using the LEAD window function and filtering users that went from A to B or C.