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.