Mock interview. You're interviewing for a product analyst job on an online shop's mobile app team. The interviewer says: "Most of our traffic is on phones, but phones bring in fewer sales. Where are we losing people?" You have web_events for March 2026.
Shoppers move through four steps: view (a product page), add_to_cart, checkout and purchase. Count events at each step.
"Show March's funnel in one row: the number of events at each step, plus carts per 100 views, the checkout rate (checkouts / carts) and the purchase rate (purchases / checkouts)."
Expected output
Return: views, carts, checkouts, purchases, carts per 100 views, checkout rate and purchase rate (name the columns however you like)
carts_per_100_views and the two rates (percentages) rounded to 1 decimalExample of the shape (made-up values):
| views | carts | checkouts | purchases | carts_per_100_views | checkout_rate | purchase_rate |
|---|---|---|---|---|---|---|
| 5000 | 1000 | 700 | 420 | 20.0 | 70.0 | 60.0 |
Step 1 of 3
Write your query here. Ctrl + Enter submits.