How would you choose the key metrics for a food delivery app?

What the interviewer wants to hear

• Start from business goals and user value
• Pick a north star metric such as weekly completed orders
• Support with input metrics across the funnel
• Include quality and guardrail metrics such as delivery time and cancellations
• Make metrics clearly defined and actionable

Model answer

I start with what value the app gives users and what the business needs. For food delivery, a good north star is completed orders per week, because it reflects real value for customers, restaurants and riders. Under it I track input metrics the teams can move: app opens, menu views, add-to-cart rate, checkout conversion, and repeat order rate for retention. Then I add quality and guardrail metrics: average delivery time, late delivery percentage, cancellation rate, and customer ratings, so growth does not come at the cost of experience. Each metric gets a precise definition, for example whether cancelled orders count and which timezone a day uses. I also check that each metric is actionable, meaning a team knows what levers change it, and I keep the list short so people actually look at it.

More medium Data Analyst questions

• Daily orders dropped 20% yesterday. Walk me through how you would investigate.
• The product team wants to test a new checkout button. How would you design the A/B test?
• What are SQL window functions and when have you used them?
• When would you use Excel, SQL or Python for an analysis task?
• What is cohort analysis and when would you use it instead of looking at overall totals?
• Three managers send you urgent data requests on the same morning. How do you decide what to do first?
• Checkout conversion has fallen. How would you analyse the funnel to find where users are dropping off?
• How do you decide what to do with outliers in your data?
• How would you design the data model for a new Power BI sales report?