← Google Interview Insights

Google·Software Engineer·Technical Phone Screen·Intermediate

Intermediate
Jun 2026

Summary

Product analyst interview at Google with what seemed like a classic metrics investigation prompt. One question, straightforward setup, but the depth expected underneath it was not obvious at first.

Questions Asked (1)

Q1

Engagement is flat despite new user growth. What questions would you ask and what data would you pull to investigate?

Product Analytics & MetricsRoot Cause AnalysisAdaptability & Ambiguity
Author's notes

I went straight to 'engagement per user is dropping' which is the obvious read, but I should've slowed down and questioned the metric definition first.

Create a free account to read the full note

AI HintsAI Generated

Suggested Approach

Start by clarifying what 'engagement' means (e.g., DAU/MAU, session duration, actions per user) and the time frame. Then systematically break down the user journey to identify where engagement drops, using data to segment by cohort, acquisition channel, and user behavior. Finally, propose hypotheses and suggest experiments to validate root causes.

Pro tip: Show that you think like an engineer by considering data pipeline integrity and metric definitions first—flat engagement might be a measurement artifact. Also, emphasize the importance of cohort analysis to separate new user behavior from existing user trends.

1. Clarify the metric and goal

Ask what 'engagement' specifically refers to (e.g., DAU/MAU, sessions per user, time spent) and what 'flat' means (no growth, slight decline). Confirm the time period and whether the goal is to increase engagement or understand the cause.

2. Segment the data

Break down engagement by user cohorts (new vs. existing), acquisition channels, geography, device, and feature usage. Look for disparities that might indicate where the problem lies.

3. Analyze the user journey

Map out key engagement milestones (e.g., first session, first action, return visit) and measure conversion rates at each step. Identify drop-off points and compare across cohorts.

4. Form and test hypotheses

Based on data, propose possible causes (e.g., new users are low-quality, onboarding is broken, feature changes hurt engagement). Suggest A/B tests or further data pulls to validate.

5. Recommend next steps

Summarize findings and propose actionable experiments or product changes. Emphasize iterative investigation and monitoring.

Key Points to Mention

  • Define engagement metrics precisely (e.g., DAU/MAU, stickiness, session length).
  • Cohort analysis to compare new vs. existing users and track retention over time.
  • Segmentation by acquisition channel, geography, device, and user demographics.
  • Funnel analysis of key user actions (e.g., signup, first action, repeat usage).
  • Data quality checks: ensure logging is correct and metrics are not affected by pipeline issues.
  • Hypothesis-driven approach: propose specific causes and how to test them (e.g., A/B tests, user surveys).

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