Visualize Netflix metric trends
Visualizing a Streaming Metric for Netflix
Prompt
Choose one streaming metric (for example, Daily Active Viewers or Average Watch Duration) and describe at least two effective ways to visualize it. For each visualization, explain why it best communicates insights to stakeholders and what decisions it can inform.
Assumptions/Context
-
Audience includes executives, product managers, and engineers who make decisions about content, marketing, and platform.
-
Data is event-level streaming telemetry (e.g., play events with user_id, timestamp, device, content_id, region).
Constraints & Assumptions
-
Preserve the scope, facts, inputs, and requested outputs from the prompt above.
-
If the prompt leaves a detail unspecified, state a reasonable assumption before relying on it.
-
Keep the answer interview-ready: concise enough to present, but concrete enough to implement or evaluate.
Clarifying Questions to Ask
-
Clarify the business objective, unit of analysis, time window, exposure definition, and primary metric.
-
State assumptions about instrumentation, randomization, sample size, and data quality.
-
Separate descriptive analysis from causal claims.
What a Strong Answer Covers
-
A metric framework with primary, guardrail, and diagnostic metrics.
-
A credible analysis or experiment design with clear assumptions and bias checks.
-
SQL/statistical logic for segmentation, variance, confidence, and data validation where relevant.
-
An actionable recommendation that explains trade-offs and next steps.
Follow-up Questions
-
What sanity checks would you run before trusting the result?
-
How would you handle novelty effects, seasonality, or selection bias?
-
What decision would you make if metrics disagree?