Revenue Metrics and Key Performance Indicators Questions
Comprehensive understanding of revenue oriented and financial metrics used to assess business health, growth efficiency, go to market performance, and operational effectiveness. Includes recurring revenue measures such as Monthly Recurring Revenue and Annual Recurring Revenue, revenue run rate, gross and net revenue retention, churn and retention metrics, Customer Acquisition Cost and Customer Lifetime Value, average deal size and win rate, pipeline coverage, conversion rates by stage, deal velocity, and sales cycle length. Also covers finance and cash metrics such as Days Sales Outstanding, collections, contribution margin, unit economics, revenue growth rates, sales efficiency ratios including the magic number, and other RevOps indicators. Candidates should be able to define each metric, explain why it matters, compute it reliably across time windows and cohorts, handle attribution and edge cases, translate definitions into queries and dashboards, and articulate interdependencies among metrics. Includes building KPI frameworks that align to commercial goals, distinguishing leading versus lagging indicators, prioritizing metrics by company stage and business model such as land and expand versus enterprise sales, using metrics for forecasting and prioritization, and communicating frameworks to leadership and go to market teams while balancing incentives to avoid gaming.
MediumSystem Design
37 practiced
Design a revenue KPI dashboard for executive leadership at a $50M ARR SaaS company. Specify the top 8 KPIs to show on the landing page (with brief rationales), the required data sources and refresh cadence, latency/SLA requirements, access controls, and processes for metric reconciliation and auditability to ensure numbers are trusted in board presentations.
MediumTechnical
41 practiced
DSO has increased from 30 to 55 over six months. Outline a data-driven root-cause analysis plan listing datasets to pull (e.g., AR aging, invoices, dispute reasons, payment terms, customer credit limits), three specific SQL queries or KPI drills you'd run, and the hypotheses you'd test to explain the spike in DSO.
HardTechnical
61 practiced
You have invoice-level data in invoices(invoice_id, subscription_id, invoice_date, amount, invoice_type ['charge','credit'], recognized_date) and subscription metadata in subscriptions(subscription_id, customer_id, start_date, end_date, plan_id). Write a robust SQL approach (describe or provide query skeleton) that computes, for each annual cohort, a breakdown of ARR movement into starting ARR, new, expansion, contraction, and churn for a 12-month window. Include handling of refunds/credits, proration, and customers with multiple subscriptions.
EasyTechnical
36 practiced
Describe the SaaS 'magic number' used to measure sales & marketing efficiency. Provide the formula, show how to compute it using quarterly net new ARR and prior quarter S&M spend, explain what different ranges (e.g., <0.5, 0.5-0.75, 0.75-1.0, >1.0) imply, and list common caveats when interpreting it.
EasyTechnical
31 practiced
Define Gross Revenue Retention (GRR) and Net Revenue Retention (NRR). Given a cohort starting ARR of $1,000,000, contractions of $50,000, churned ARR of $30,000, and expansions of $120,000 over one year, compute the GRR and NRR and explain what each number tells leadership about product-market fit and expansion effectiveness.
Unlock Full Question Bank
Get access to hundreds of Revenue Metrics and Key Performance Indicators interview questions and detailed answers.
