← Google Interview Insights

Google·Software Engineer·Technical Phone Screen·Intermediate

Intermediate
Apr 2026

Summary

Interviewed for a business analyst role at Google and got hit with a retention-focused analytics question that was more open-ended than I expected.

Questions Asked (1)

Q1

How would you use cohort analysis to identify retention issues in a product?

Product Analytics & MetricsRoot Cause Analysis
Author's notes

I started talking about grouping users by signup date and tracking how many came back week over week, which felt right, but I fumbled when they pushed on what I'd actually do once I spotted a drop-off.

Create a free account to read the full note

AI HintsAI Generated

Suggested Approach

Start by defining cohort analysis and its purpose: grouping users by a shared characteristic (e.g., signup date) and tracking a metric (e.g., retention rate) over time. Then walk through a structured process: define cohorts, measure retention, identify patterns or drop-offs, and investigate root causes using additional data. Emphasize how this helps pinpoint when and where users disengage, enabling targeted fixes.

Pro tip: Mention that cohort analysis should be paired with qualitative insights (e.g., user feedback, session recordings) to avoid correlation-causation pitfalls and to understand the 'why' behind retention drops.

1. Define cohorts and retention metric

Choose a cohort definition relevant to the product (e.g., signup week, acquisition channel, feature adoption) and define what retention means (e.g., returning within 7 days, performing a key action).

2. Build cohort retention curves

For each cohort, calculate retention rate over time (e.g., day 1, day 7, day 30) and plot curves to visualize how retention decays across cohorts.

3. Compare cohorts to spot anomalies

Look for cohorts with significantly lower or faster-declining retention. Identify when the drop occurs (e.g., after onboarding) and which cohorts are affected.

4. Segment and drill down

Break down underperforming cohorts by dimensions like platform, geography, or user persona to isolate the issue. Use funnel analysis to see where users drop off.

5. Investigate root causes and act

Correlate retention drops with product changes, bugs, or external events. Validate hypotheses with A/B tests or user research, then implement and measure fixes.

Key Points to Mention

  • Cohort definition (time-based, behavior-based, acquisition channel)
  • Retention metric (classic, rolling, or N-day retention)
  • Cohort retention curves and heatmaps for visualization
  • Segmentation to isolate variables (e.g., device, geography, user type)
  • Correlation with product changes or releases
  • Complementary qualitative methods (surveys, interviews) to understand why

AI-generated suggestions, not part of the candidate's original notes. May be inaccurate — verify before relying on them.