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.

HardTechnical

35 practiced

Explain uplift modeling and how it can be used to optimize acquisition spend and retention campaigns. Describe required data (treatment labels, outcomes), evaluation metrics (Qini coefficient, uplift curves), and one common implementation pitfall.

EasyTechnical

29 practiced

Explain the difference between Monthly Recurring Revenue (MRR) and Annual Recurring Revenue (ARR). Provide concrete examples of how you would compute each from a dataset of subscription invoices, list three edge cases that require special handling (proration, upgrades, refunds), and explain how you would document your assumptions for stakeholders.

Sample Answer

MRR vs ARR — short definition- MRR (Monthly Recurring Revenue): the normalized total of recurring revenue expected in a given month. Useful for short-term trends and churn/expansion analysis.- ARR (Annual Recurring Revenue): the normalized recurring revenue on a 12‑month basis. Often ARR = MRR × 12, but for contract-level annual billing you can also sum annualized contract values.

How to compute from subscription invoice dataset- Approach: convert each invoice/contract to a monthly recurring amount (monthly equivalent), then aggregate by month for MRR; ARR = MRR_for_month × 12 or sum annual equivalents.- Example logic (Python-like):

python

# invoices: rows with customer_id, invoice_amount, billing_period_days, start_date, end_date, is_recurring
def monthly_equivalent(row):
    if not row['is_recurring']:
        return 0
    # convert invoice amount to per-day then to monthly (30-day standard)
    per_day = row['invoice_amount'] / row['billing_period_days']
    return per_day * 30

invoices['mrr_contribution'] = invoices.apply(monthly_equivalent, axis=1)
MRR_month = invoices[invoices['month']==target_month]['mrr_contribution'].sum()
ARR = MRR_month * 12

Key points:- Use a consistent month normalization (30-day month is common) or exact calendar days depending on stakeholder preference.- For annual contracts, you can either: (a) invoice_amount / 12, or (b) treat ARR as full contract value if stakeholders expect committed ARR.

Three edge cases requiring special handling1. Proration (mid-cycle starts/stops): prorate by exact active days in the month. Don’t count full monthly amount if subscription started/stopped mid-month.2. Upgrades/downgrades within period: attribute expansion/contraction only for the period during which the new plan was active; compute delta MRR for the overlap days.3. Refunds/chargebacks: treat refunds that reverse recurring revenue as negative MRR in the month they occur; distinguish one-time refunds from contractual adjustments to recurring price.

Documenting assumptions for stakeholders- Explicitly state normalization convention (30-day month vs actual calendar days), treatment of annual invoices (annualized vs recognized when invoiced), and cut-off rules (which month includes a subscription start/end).- Describe how trials, discounts, and coupons are handled (e.g., include discounted price in MRR).- Provide examples: “Customer A invoiced $120 yearly on 2025-01-01 → monthly equivalent $10 if annualized; if stakeholder prefers committed ARR we record $120 ARR immediately; if revenue-recognition rules apply, we recognize $10/month.”- Supply reproducible code/notebook, test cases for edge scenarios, and sensitivity notes (how numbers change if using 30-day vs calendar days).

EasyTechnical

30 practiced

Given the subscriptions table:

sql

subscriptions(
  subscription_id bigint,
  customer_id bigint,
  plan_price_monthly numeric,
  start_date date,
  end_date date -- NULL if active
)

Write an ANSI SQL query to compute MRR per calendar month for 2024. Describe how you would handle proration for mid-month starts/ends and plan price changes recorded elsewhere.

Sample Answer

Approach: expand each subscription into the months it overlaps in 2024, prorate partial months by days active / days in month, then sum monthly MRR. If plan_price_monthly can change (recorded elsewhere), join a price history table and use price as of the active day range.

SQL (ANSI):

sql

WITH months AS (
  SELECT DATE '2024-01-01' + (n || ' months')::interval AS month_start
  FROM (SELECT 0 as n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
        UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
        UNION ALL SELECT 10 UNION ALL SELECT 11) t
),
subs AS (
  SELECT subscription_id, customer_id, plan_price_monthly,
         GREATEST(start_date, DATE '2024-01-01') AS s,
         LEAST(COALESCE(end_date, DATE '9999-12-31'), DATE '2024-12-31') AS e
  FROM subscriptions
  WHERE COALESCE(end_date, DATE '9999-12-31') >= DATE '2024-01-01'
    AND start_date <= DATE '2024-12-31'
)
SELECT to_char(m.month_start, 'YYYY-MM') AS month,
       ROUND(SUM(
         s.plan_price_monthly
         * (LEAST(s.e, m.month_start + INTERVAL '1 month' - INTERVAL '1 day') 
            - GREATEST(s.s, m.month_start) + 1) -- days active
         / (EXTRACT(day FROM (m.month_start + INTERVAL '1 month' - INTERVAL '1 day')) )::numeric
       ), 2) AS mrr
FROM months m
JOIN subs s
  ON s.s <= m.month_start + INTERVAL '1 month' - INTERVAL '1 day'
 AND s.e >= m.month_start
GROUP BY m.month_start
ORDER BY m.month_start;

Key points:- We generate 2024 months then intersect subscription ranges with each month.- Proration: days active in month / days-in-month * plan_price_monthly.- If prices change over time, replace plan_price_monthly in subs with a join to a price_history table and split each subscription-month further by price-effective-date ranges before prorating.- Edge cases: fully active month (full price), single-day subscriptions, NULL end_date (treat as active). Validate date arithmetic for your SQL dialect (days-in-month calculation).

EasyTechnical

36 practiced

What is Customer Acquisition Cost (CAC) and Customer Lifetime Value (LTV)? Describe at least two methods to estimate LTV (historical cohort average, discounted expected future revenue) and one common pitfall when comparing LTV to CAC across differing cohorts or channels.

EasyTechnical

40 practiced

Define Average Deal Size (ADS) and Average Revenue per Account (ARPA). Explain how each metric is computed and how they differ when applied to sales-led enterprise accounts versus high-volume SMB sales. Include notes on contract length and multi-year deals.

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.