Who This Helps
This is for Junior Analysts who get a Slack ping saying "revenue dropped 12% this week" and need to respond with a clear, actionable answer. You want to be the person who doesn't just report the number but explains why and what to do next.
Mini Case
You're working on GTM Strategy & Messaging. Your team just launched a new positioning statement and messaging house. But this week, demo requests dropped 12% compared to last week. Your manager wants a root cause diagnosis by end of day. No panic. Just data.
You pull the numbers. The drop is concentrated in one segment: mid-market companies that saw the new messaging. Their conversion from landing page to demo form fell from 8% to 3%. That's your clue.
Do This Now (5 Steps)
- Check the trend first – Is this a one-day blip or a sustained drop? Look at 7-day rolling average. If it's a single day, wait 24 hours. If it's a week, move to step 2.
- Segment the data – Break the drop by channel, region, buyer persona, and campaign. In our case, the drop was only in the mid-market segment that saw the new messaging. That narrows your search.
- Look for a change – What changed right before the drop? New messaging, new landing page, new pricing? In our mini case, the new messaging house went live 3 days before the drop.
- Talk to one customer – Pick one person from the affected segment. Ask: "What did you see? What confused you?" One 5-minute call can confirm your hypothesis faster than 3 hours of spreadsheet work.
- Write a one-page diagnosis – State the problem (12% drop in demo requests), the root cause (new messaging confused mid-market buyers), and one clear recommendation (revert to old messaging for that segment, test new messaging on enterprise only).
Avoid These Traps
- Don't blame the data. If the number dropped, it's real. Your job is to explain why, not argue with the tool.
- Don't overcomplicate. A 12% drop with one clear segment is a simple story. Don't add 5 charts when one bar chart tells the tale.
- Don't skip the recommendation. A diagnosis without a next step is just a complaint. Always ship a clear action.
- Don't forget the timeline. If you can't find the root cause in one focused session, escalate. Speed matters more than perfection.
Your Win by Friday
By Friday, you will have shipped a clean analysis that your manager can forward to the VP. You'll be known as the analyst who doesn't just report numbers but diagnoses problems and recommends fixes. And honestly, that's a superpower. Plus, you'll have saved the team from chasing a ghost — the real issue was messaging, not product quality. Feels good, right?