Determine North-Star Metric for CloudTrucks Driver Platform
Company: CloudTrucks
Role: Data Scientist
Category: Analytics & Experimentation
Difficulty: medium
Interview Round: Technical Screen
##### Scenario
Panel interview on product analytics for a trucking marketplace dashboard.
##### Question
Choose and justify a North-Star metric for CloudTrucks’ driver platform. Given access to jobs, loads, and drivers tables, write SQL to calculate that metric weekly. Walk through how you would perform a funnel analysis for the driver job-booking flow. What stages and drop-offs would you measure?
##### Hints
Explain why the metric is actionable and leading, outline clear funnel stages, and tie SQL to business outcomes.
Quick Answer: 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.