InterviewStack.io LogoInterviewStack.io

Metrics and Dashboard Design Questions

Knowledge and skills for defining, interpreting, and presenting key business and sales metrics through effective dashboard architecture. Candidates should demonstrate familiarity with common product and sales metrics such as daily active users, monthly active users, churn, retention, lifetime value, customer acquisition cost, and net revenue retention, and explain what those metrics measure and how they interact. They should be able to read and interpret dashboards, spot anomalous trends and red flags, and recommend tracking or metric improvements. On the architecture and design side, candidates should show how to structure data and dashboards to serve different audiences including sales leadership, individual sales representatives, and finance; balance leading indicators such as activity and pipeline metrics with lagging indicators such as revenue and bookings; consider tradeoffs between real time data and data accuracy; and apply dashboard design principles for clarity, actionability, and drill down from summary to detail. Topics include metric definition and calculation, data freshness and governance, audience segmentation and access, visual encoding and layout, alerting and thresholds, and recommendations for instrumentation and measurement improvements.

MediumSystem Design
0 practiced
Design KPIs and a prioritized dashboard for a customer success team focused on expansion (upsell/cross-sell) and retention. Include a scoring approach to rank accounts by expansion opportunity and one method to surface accounts at high risk of churn.
HardTechnical
0 practiced
Given transactions `transactions(account_id, transaction_date, amount)` and an `accounts(account_id, signup_date, status)` table, write a SQL-based approach to compute monthly cohort LTV including expansions and contractions, and include a simple discounting of future months at a company discount rate. Show the aggregation logic you'd use for a monthly cohort table.
MediumTechnical
0 practiced
Given tables `customers(customer_id, signup_date, acquisition_channel)`, `orders(order_id, customer_id, amount, occurred_at)`, and `marketing_spend(channel, spend_date, amount)`, describe and write pseudocode or SQL to compute 12-month cohort LTV per channel and the CAC per channel (total spend / acquired customers). Explain attribution window assumptions and cohort definitions.
EasyTechnical
0 practiced
How would you define an "Active User" metric for a mobile app product team that must serve product, growth and finance stakeholders? Describe edge cases (bots, test accounts, multi-device users), a proposed SQL definition using an `events` table, and how you'd document and version this metric.
MediumTechnical
0 practiced
A marketing dashboard shows a 30% week-over-week drop in MQL-to-SQL conversion in the past week. Describe the investigative steps you would take using dashboards, SQL queries, and segmentation to identify root causes and rule out data issues.

Unlock Full Question Bank

Get access to hundreds of Metrics and Dashboard Design interview questions and detailed answers.

Sign in to Continue

Join thousands of developers preparing for their dream job.