Instacart · Statistics & Data Analysis
How to debug an apparent D14 retention drop
TrueInterview
October 7, 2026 · 1 min read
Scenario
A dashboard displays D14 retention (users who remain active on day 14 after signup or first activity). Over the most recent week, the chart shows a sharp drop. Assume retention is calculated as a cohort metric:
- Each user is placed into a cohort based on first activity date.
- A cohort's D14 retention is evaluated 14 days after that date.
Task
Describe how you would decide whether this decline points to a genuine product problem or is a false alarm.
Requirements
Include:
- How metric “maturity” / delayed observation can produce misleading dips in the most recent week.
- Which plots or tables you would examine (cohort table, maturity curve, right-censoring).
- Data quality checks and definition checks.
- If the drop is real, how you would isolate the cause (segments, releases, funnel changes). Overview: This question assesses skill in cohort-based retention analysis, familiarity with metric maturity and right-censoring, running data quality and definition checks, and isolating genuine declines by segment, release, or funnel change.
Loading comments…