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.

HardTechnical

64 practiced

Write a robust SQL query to compute retention where users may have identity merges. Schemas: users(user_id, primary_user_id) where primary_user_id points to canonical id after merges, and events(user_id, event_date). Compute day 7 retention for cohorts by signup_date using primary_user_id to deduplicate merged accounts. Explain handling of nulls and late merges.

HardTechnical

82 practiced

You are responsible for defining OKRs across multiple teams that feed into the company KR for monthly active revenue. Design a metric hierarchy and mapping approach to ensure alignment, avoid double-counting revenue across teams, and allow roll-ups to the company KR. Provide a sample mapping for at least three teams and describe how you would validate the roll-up.

HardTechnical

79 practiced

Case study: a sudden surge in signups is observed, but downstream revenue and DAU do not rise proportionally. After investigation you suspect bot-driven signups. Describe detection techniques to identify bot accounts, remediation steps to clean historical metrics, and how you would quantify the impact on OKRs and dashboards.

MediumTechnical

134 practiced

You wake up to an alert: one key metric dropped 18% overnight. Outline your triage checklist as a Data Analyst to determine whether the issue is instrumentation, ETL/data pipeline, a product regression, or a real business change. Provide proposed quick checks you would run and the expected evidence each check would produce.

HardSystem Design

67 practiced

Architect a near-real-time metrics platform that supports event ingestion at 10M events per minute, serves dashboards with a 30s to 5min freshness SLA, supports historical backfills, and preserves metric lineage and versioning. Outline components (ingestion, storage, stream processing, aggregation, serving), trade-offs for storage formats, and how you would support correctable historical data without breaking dashboards.

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.