Funnel by platform
Build a 3 step funnel per platform, counting users (not events):
viewed, users with at least oneview_itemcarted, users who had anadd_to_cartstrictly after their firstview_itempurchased, users who had apurchasestrictly after their first add_to_cart that counted in step 2
Steps have to happen in order. Adding to cart before ever viewing an item doesn't count for step 2, and buying before that qualifying add to cart doesn't count for step 3.
Use the platform from users. Only include platforms that have at least one viewer.
output columns
platformviewedcartedpurchaseduses ,
ctrl + enter to run on the sample data · ctrl + shift + enter to submit
run your query to see the output here. Submit checks it against the sample data, hidden test cases, random data and a large dataset.