Uber’s core ride-hailing product serves ~25M daily trips globally. Customer Satisfaction (CSAT) is a top-level KPI reviewed weekly by the GM because it predicts rider retention and complaint volume, and it influences marketplace health (driver supply) through support load and refunds. Over the last 6 weeks, CSAT for completed trips dropped from 4.72 to 4.58 (-0.14) in the US and Canada, while trips are flat (+1%) and on-time pickup rate is only slightly down (-0.6pp).
A cross-functional incident review is underway. Product suspects a recent pickup-pin UX change increased confusion. Operations suspects airport queues and driver cancellations. Support suspects a policy change reduced goodwill credits, increasing negative sentiment. You are the analytics lead asked to analyze survey results and recommend improvement efforts that can be executed in the next quarter.
After each completed trip, ~8% of riders receive a CSAT survey within 30 minutes. The survey includes:
You also have event logs for the trip funnel (request → match → pickup → dropoff), pricing, ETA accuracy, cancellations, and support contacts. Stakeholders want a clear diagnosis: Is the CSAT drop real, where is it coming from, and what should we do first?
| Source | Description | Grain |
|---|---|---|
csat_surveys | survey_id, rider_id, trip_id, sent_ts, response_ts, rating_1_5, reasons[], free_text, locale | Survey response |
trips | trip_id, rider_id, city_id, product (X/Comfort/XL), request_ts, pickup_ts, dropoff_ts, pickup_latlng, dropoff_latlng, surge_multiplier, upfront_fare, final_fare | Trip |
marketplace_events | trip_id, driver_cancel_flag, rider_cancel_flag, cancel_stage, reassign_count, driver_eta_at_match, pickup_eta_error | Trip |
app_events | rider_id, trip_id, event_ts, event_name (pin_adjust, call_driver, chat_driver, “can’t find driver”), platform, app_version | Event |
support_tickets | ticket_id, trip_id, created_ts, issue_type, refund_amount, credit_amount, resolution_time | Ticket |
driver_quality | driver_id, city_id, acceptance_rate, cancellation_rate, driver_rating, tenure_days | Driver-day |