Determine North-Star Metric for CloudTrucks Driver Platform

Q: Determine North-Star Metric for CloudTrucks Driver Platform

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.

Q: How do I approach Analytics & Experimentation interview questions?

Analytics & Experimentation questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master analytics & experimentation interviews.

Question

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.

Determine North-Star Metric for CloudTrucks Driver Platform

Product Analytics Case: North-Star Metric and Booking Funnel (Driver Platform)

Context

Task

Solution

Comments (0)