Determine North-Star Metric for CloudTrucks Driver Platform
Overview
This question evaluates product analytics competencies including North-Star metric definition, funnel analysis, and SQL-based measurement within the Analytics & Experimentation domain for a data scientist role, combining conceptual metric design with practical data engineering and querying skills.
CloudTrucks
Aug 4, 2025, 10:55 AM
Data Scientist
Technical Screen
Analytics & Experimentation
0
0
Product Analytics Case: North-Star Metric and Booking Funnel (Driver Platform)
Context
You are evaluating the health of a trucking marketplace's driver platform. You have warehouse access to three core tables:
- drivers
- jobs
- loads
Assume each table has standard identifiers and timestamps. At minimum:
- drivers(driver_id, onboarded_at, status)
- jobs(job_id, posted_at, pickup_at, dropoff_at, origin, destination, payout_amount)
- loads(load_id, job_id, driver_id, status, requested_at, offered_at, accepted_at, picked_up_at, delivered_at, canceled_at, payout_amount)
Task
- Choose and justify a single North-Star Metric for the driver platform. Explain why it is actionable and leading.
- Given access to the three tables above, write SQL to calculate that metric weekly.
- Describe how you would perform a funnel analysis for the driver job-booking flow. Specify the key stages and the drop-offs you would measure, and how they connect to business outcomes.
Solution
Login required
Show