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.

MediumTechnical

39 practiced

In Python (pandas), implement a function that consumes a DataFrame with columns (customer_id, date, revenue) and returns monthly cohort LTV up to month 12 for each signup cohort. Explain assumptions you make about missing months, active customers, and churn definition.

MediumTechnical

38 practiced

You are asked to report contribution margin per product line to support pricing decisions. Outline the data sources, transformation steps, and calculations you would perform to produce contribution margin. Describe one defensible method to apportion shared fixed costs across products.

MediumTechnical

30 practiced

Write an ANSI SQL query to compute 12-month cohort retention by signup month using the events table below. Define monthly retention as presence of any revenue in that month. Return a result with cohort_month and columns retention_month_0 through retention_month_11.

sql

events(user_id bigint, event_date date, revenue_amount numeric)

Describe your approach to handling missing months.

MediumTechnical

58 practiced

You must forecast next quarter's ARR for an enterprise-heavy company where large deals close infrequently. Which forecasting methods would you consider (historical growth, pipeline-weighted, win-rate-based, time-series), and propose an ensemble approach that combines bottom-up and top-down signals to improve accuracy and quantify uncertainty.

MediumTechnical

38 practiced

Write an SQL query to compute weighted pipeline value for the upcoming quarter using an opportunities table with columns: opportunity_id, amount, close_date, stage, stage_probability. Return total weighted pipeline and pipeline coverage against quota Q for the quarter, and explain any filtering assumptions.

Unlock Full Question Bank

Get access to hundreds of Revenue Metrics and Key Performance Indicators interview questions and detailed answers.

Join thousands of developers preparing for their dream job.