The situation
It's Monday morning. The Slack channel for the growth team has 47 unread messages. The CEO posted at 7am:
"Why did signups drop 8% last week? Need an answer by EOD."
You're the analyst on point.
What you know
- Weekly signups: usually ~10,000. Last week: 9,200.
- The marketing team didn't change any campaigns.
- Engineering didn't ship anything to the signup flow.
- It was a normal week - no holiday, no outage anyone knows about.
Your job
Walk through the investigation step by step:
- Establish the magnitude (signal vs noise using trailing std).
- Decompose by source (channel shifts).
- Decompose by funnel step.
- Decompose by segment (device, geo, browser).
- Check for external events and tracking pixel regressions.