OKR and Metric Definition Questions

Covers translating strategic objectives into measurable key results and operational metrics that drive the right behaviors. Topics include writing clear objectives and specific, measurable key results, distinguishing leading and lagging indicators, defining primary metrics versus guardrail metrics, selecting absolute versus relative targets, avoiding perverse incentives, and ensuring metric hygiene through reliable instrumentation and data quality checks. Also addresses setting appropriate targets and time horizons, monitoring cadence, dashboard design and alerting for metric deviations, and using metrics to inform prioritization and continuous improvement without encouraging gaming.

MediumTechnical

0 practiced

Write an SQL query to compute category-weighted revenue per active user where categories have different user populations. Schema: revenue(trans_id, user_id, category, revenue_amount, trans_date) and users(user_id). Compute for a given month the weighted average revenue per user across categories where each category's per-user metric is weighted by the category's active user share. Handle NULL revenues and categories with zero active users.

HardTechnical

0 practiced

Metric definitions are drifting across reports: two dashboards compute Active Users differently. As the metrics owner, propose a governance plan with a metric catalog, metric contracts, versioning, review cadences, and migration strategy to consolidate definitions and avoid breaking downstream consumers.

MediumTechnical

0 practiced

When selecting a leading metric for product adoption, what properties make a metric effective (for example, predictive power, low latency, actionability)? Choose one candidate metric for early adoption and justify it with trade-offs and how you would monitor its predictive validity over time.

MediumTechnical

0 practiced

Write a SQL query to compute cohort retention rates for users who signed up in each week and their percent of users who returned at day 7 and day 30. Schema: users(user_id, signup_date date), events(user_id, event_date date, event_type). Show cohort_week_start, cohort_size, day_7_retention, day_30_retention. Explain assumptions about users with multiple events.

MediumTechnical

0 practiced

List a comprehensive metric hygiene checklist that you would apply to a new critical metric before it is published in dashboards or used for OKRs. Include technical checks, documentation requirements, ownership, and monitoring rules.

Unlock Full Question Bank

Get access to hundreds of OKR and Metric Definition interview questions and detailed answers.

Join thousands of developers preparing for their dream job.