InterviewStack.io LogoInterviewStack.io

User Retention & Engagement Questions

Measuring and improving how users stick with a product after they first convert: retention rate and cohort retention curves (day 1, day 7, day 30, and longer horizons), churn rate, reactivation and resurrection of lapsed users, and engagement-depth signals such as DAU, WAU, MAU, and the DAU/MAU stickiness ratio. Covers defining and computing these metrics, including basic SQL and event-log implementations, diagnosing where and why a retention curve breaks (onboarding gaps, feature-adoption gaps, seasonal or cohort-specific effects), designing experiments and product interventions that deepen habitual usage, cohort-based lifetime value (LTV), and communicating retention findings to stakeholders. This is the post-acquisition, repeat-usage side of the user lifecycle: getting a first-time visitor through signup or first purchase is covered by the companion topic Conversion Funnel Optimization, and pure-SQL implementation depth at large scale (approximate-distinct computation, survival-curve modeling, multi-state subscription churn state machines, and standalone timezone-aware day bucketing) is covered by the companion topic Advanced SQL: Metric Monitoring, Anomaly Detection, and Data Correctness at Scale.

EasyTechnical
39 practiced

You inspect a retention curve that drops steeply in the first week, then hips slightly after week 8. List three plausible product or data causes for (a) the steep early drop and (b) the late bump around week 8. For each cause describe an experiment or analysis you would run to validate it.

EasyTechnical
63 practiced

You will run a reactivation email campaign. List the key short-term and long-term metrics you will track to determine success. Explain why open and click rates might be misleading and which downstream metrics better reflect long-term retention improvement.

MediumTechnical
46 practiced

You have a limited growth budget. Acquisition gives CAC = $30 with expected LTV = $45 per new user. A retention program costs $10k and is expected to raise 6-month LTV by $5 for 500k active users. Which investment gives higher ROI? Show the math and discuss non-financial factors to consider when choosing between acquisition and retention.

EasyTechnical
38 practiced

You're preparing a one-slide summary for product and executive stakeholders. Define the following core user metrics used in retention and engagement analysis: retention rate, churn rate, DAU, MAU, and stickiness (DAU/MAU). For each metric provide: 1) a clear formula, 2) recommended time-window choices (daily/weekly/monthly) and rationale, and 3) a numeric example using a cohort of 1,000 users where 350 were active in the 30-day window.

HardTechnical
36 practiced

A gamification initiative (badges, streaks, leaderboards) was launched to increase retention. Propose a measurement plan to evaluate ROI and potential negative side effects. List primary and guardrail metrics, recommended experiments, duration, segmentation, and post-launch monitoring to detect unintended behavior.

Unlock Full Question Bank

Get access to all 26 User Retention & Engagement interview questions and detailed answers.

Sign in to Continue

Join thousands of developers preparing for their dream job.