Skip to interview prep
Apexed

13. Daily active users dropped 10% yesterday. How would you investigate?

HardBusiness cases

Case
Show model answer

First check whether it is real: data pipeline delays, tracking changes or a definition change. Then compare against seasonality (day of week, holidays).

Segment the drop by platform, app version, country, acquisition channel and new vs returning users to localise it. Check recent releases, outages and marketing changes. Form hypotheses, confirm with data, and report the size and likely cause clearly.

What interviewers listen for

  • Validate the data first
  • Seasonality
  • Segment to localise
  • Recent changes
Daily active users dropped 10% yesterday. How would you investigate — Data & analytics interview question — Apexed