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.

MediumTechnical
44 practiced

Your data shows SMB segment has significantly higher churn than mid-market. Create a hypothesis-driven experiment plan (A/B test or pilot) to reduce SMB churn, including hypotheses, key metrics, sample sizing considerations, and risk controls.

MediumTechnical
45 practiced

Write a SQL approach to compute reactivation rate: percentage of users who were inactive for 30+ days and then return within 30 days of an outreach campaign. Use schemas:

sql
users(user_id bigint)
events(user_id bigint, occurred_at date, event_type text)
campaigns(user_id bigint, sent_at date)

Describe the SQL steps, edge cases, and how to handle multiple campaign exposures.

HardTechnical
48 practiced

A marketing team claims a re-engagement email produced a 10% lift in DAU the next day. Provide a comprehensive checklist to validate the claim: statistical tests to run, how to check for proper randomization or holdout, seasonality and holiday effects, sample size and power adequacy, bot/fraud detection, and business sanity checks.

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.

EasyTechnical
45 practiced

Suppose a product has low WAU/MAU ratio. Propose three hypotheses (product, acquisition, or data issues) to explain low ratio, and for each hypothesis describe a diagnostic metric or query you would run to validate it.

Unlock Full Question Bank

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

Sign in to Continue

Join thousands of developers preparing for their dream job.