Meta VO Interview Question: Carpooling Value Proposition, Metrics, and Data Model Design
A ride-share service allows customers to use an app to request a driver to pick the customer up and drop them off at their destination. To reduce costs and the frequency of required trips, customers can select a carpool option, which will overlap their route with other customers, resulting in an overall longer trip with multiple pick-ups and drop-offs.
Common considerations when a carpooling algorithm is deployed:
- Type of vehicle and maximum occupancy
- Historical demand of trips along the original route
- Customer ratings
- Value proposition to customer (how much is carpooling incentivized)
Let’s say we recently launched this carpool option in the last couple of months. The executives want to know if the option is increasing app usage, and if the value proposition passed along to the customer is high enough to encourage usage, without eating into the company’s profits.
Q1. What business questions would help us understand the value proposition offered by the carpooling option?
Q2. What metrics would you define to help answer the business questions from Q1?
Q3. What are the most important dimensions/cuts that would be relevant for your metrics and why?
We would like to design a data model to be able to answer our business questions, such as:
- How often is carpooling selected compared to regular rides?
- What is the average amount saved by the company through carpooling?
- What is the average cost passed on to the customer?
With this data model, we wish to track:
- Trips with carpool vs. all rides
- Costs saved by carpooling vs. price incentives to customers
Q1. What would be the key entities and attributes for each entity in this model?
Q2. How would you design the data model to support the entities and attributes? What are the key tables you would build and what type of relationship exists between them (1:1, 1:M, M:M)?
This Meta VO question is a product analytics and data modeling case about a ride-share carpool feature. You need to translate the business goal into metrics such as carpool adoption rate, usage lift, company cost savings, and customer incentive pass-through, then choose useful slices like time, city, vehicle type, and customer segment. The second part asks for a normalized data model with core entities such as trips, riders, drivers, vehicles, and carpool-related pricing or discount tables, along with their relationships. The key is to show how the model supports both business analysis and profitability tracking.
