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

Schema: users(user_id BIGINT, signup_date DATE); events(user_id BIGINT, event_date DATE, event_type TEXT). Write Postgres SQL to compute cohort-based retention for users who signed up in the past 180 days: produce columns cohort_week_start, cohort_size, retention_7d, retention_30d, retention_90d. Explain assumptions about last-touch attribution and missing event days.

HardTechnical

0 practiced

You are the BI lead tasked with a company-wide initiative to move teams away from vanity metrics to actionable metrics. Draft a program including stakeholder engagement, training curriculum, pilots with measurable success criteria, changes to the metric catalog and dashboards, metrics for measuring the program's success, and executive sponsorship plan.

EasyTechnical

0 practiced

Propose a metric naming convention for your company (for example: domain.metric.aggregation.window). Apply it to name '7-day active users' for the mobile app and explain how consistent naming helps metric discovery, lineage, and prevents duplicate definitions across teams.

EasyTechnical

0 practiced

Given table events: event_id BIGINT PRIMARY KEY, user_id BIGINT, event_type TEXT, event_time TIMESTAMP, properties JSONB. Write a Postgres SQL query to (1) detect duplicate event_id, (2) compute percent of events with null event_time per day for the last 30 days, and (3) list top 5 event_types with highest null rates. Explain assumptions about late-arriving events and backfills.

MediumTechnical

0 practiced

Product plans to ship 'In-app Messaging'. As BI analyst, draft an instrumentation spec listing event names, required properties and types (e.g., message_id TEXT, sender_id INT, delivered BOOL), suggested user identifiers, and derived metrics (open rate, CTR, retention lift). Describe minimal events required to compute KRs and how you'd version the spec.

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.