Intermediate · 30 min · 4 steps
Finding where customers drop out before they pay
Neha Deshmukh, Product Analytics Engineer at QuickPlate Logistics
It is Wednesday, 8:45 AM. Neha Deshmukh is a product analyst at QuickPlate, an app that delivers fast food and groceries and handles over 350,000 orders a day in 14 cities. Two days ago the team released version 4.2 of the mobile checkout. It has a new address pop-up and a new one-tap way to choose how to pay.
The question
At which step do customers leave: looking at food, adding it to the cart, or paying? What is the exact drop at each step?
- Funnel analysis
- Conditional aggregation
- Sessionization
- CTEs
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.