InterviewStack.io LogoInterviewStack.io

Growth Metrics and Key Performance Indicators Questions

Comprehensive knowledge of growth metrics and key performance indicators used to measure user acquisition, engagement, retention, and revenue. Candidates should understand definitions, business meaning, and how to calculate metrics from raw event and transaction data. Core metrics include customer acquisition cost, lifetime value, lifetime value to customer acquisition cost ratio, conversion rate, churn rate, retention rate, monthly active users, daily active users, cohort retention, activation, engagement, average revenue per user, payback period, viral coefficient, and growth rate over time. Candidates should be able to choose appropriate leading and lagging indicators, explain unit economics, and reason about tradeoffs across acquisition, activation, retention, revenue, and referral stages. Practical skills include designing instrumentation and tracking for events and transactions, selecting attribution windows, avoiding sampling and attribution pitfalls, cleaning and deduplicating event streams, and calculating metrics by cohort and segment. Candidates must be able to perform funnel analysis and cohort analysis to diagnose problems, prioritize optimization levers, set metric baselines and success criteria for controlled experiments and split tests, assess sensitivity to seasonality pricing changes and growth initiatives, and communicate metric driven recommendations and dashboards to stakeholders. They should also identify which metrics matter for different business models such as business to business versus business to consumer and subscription versus transactional models.

EasyTechnical
76 practiced
Define ARPU and ARPPU and explain when each is the right metric. Given this revenue table:
sql
revenue(user_id, amount, occurred_at, is_paid)
Write SQL to compute monthly ARPU and ARPPU for March 2024 and describe how refunds or gift cards might affect these numbers.
HardTechnical
143 practiced
You believe prioritizing retention over acquisition will improve long-term unit economics, but the CEO wants rapid top-line growth. As a senior analyst, prepare a 6-month plan to align product, marketing, and leadership: include KPIs, experiments, resource allocation, success criteria, and a communication strategy to persuade leadership.
MediumSystem Design
99 practiced
Design a growth KPI dashboard in Tableau for product managers tracking acquisition, activation, retention, and revenue. Describe specific charts, KPI tiles, cohort visualizations, filters, alerting, and how to make the dashboard actionable during weekly and monthly reviews.
EasyTechnical
75 practiced
Define retention rate and churn rate and explain their business implications. Given the subscriptions table below, write an SQL query to compute monthly customer churn rate and monthly retention rate for Jan–Mar 2024. Discuss edge cases such as multiple overlapping subscriptions and trial periods.
sql
subscriptions(user_id, plan, start_date, end_date)
HardTechnical
99 practiced
For enterprise B2B with multi-year contracts, seat-based pricing, and expansion revenue, design an approach to compute LTV. Explain handling of churn triggers, contract cancellations, variable seat counts, discounts, one-time onboarding fees, and discounting future cash flows. Provide SQL/pseudocode and explain key assumptions.

Unlock Full Question Bank

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

Sign in to Continue

Join thousands of developers preparing for their dream job.