Define metrics and data model for product features

You are interviewing for a full-stack/data-oriented role. For each of the following product areas, answer Product Sense and Data Modeling prompts.

Choose one scenario (or discuss all if time permits):

1. Private Account feature in a social app (users can make their profile private; follow requests may require approval).
2. Car Rental marketplace (users search, book cars; hosts list cars).
3. Carpool platform (drivers post trips; riders request seats).

Part 1 — Product sense

1. What is the primary user goal and business goal for the feature/product?
2. Define a small set of success metrics (pick 3 core metrics plus any guardrail metrics).
3. Describe how you would visualize those 3 metrics in a dashboard (chart types, key breakdowns).
4. A key metric suddenly drops (e.g., bookings, approvals, matches). Walk through how you would diagnose the problem using data.

Part 2 — Data modeling

Design a data model that supports the above analytics.

1. List the main entities and their key attributes .
2. Identify the main facts and dimensions you would use to “slice and dice” (time, geo, platform, user type, etc.).
3. Propose a relational (or warehouse) schema (tables, keys, and important relationships). Include notes on event logging/instrumentation needed to compute the metrics.