Who This Helps
This is for you, Junior Analyst. You just saw a key metric drop and your manager wants answers by Friday. No panic. You can diagnose the root cause in one focused session using the Metrics & Dashboards Basics approach.
Mini Case
Imagine your team’s North Star Metric—weekly active users—dropped 12% in 7 days. You have 20 numbers on your dashboard, but you need one clear answer. Using the course’s North Star Metric mission, you pick that primary metric and define it clearly. Then you check three supporting metrics: new sign-ups, returning users, and session length. The drop came from returning users falling 18%. Root cause found.
Do This Now (5 Steps)
- Pick your primary metric. Start with the one number that matters most. In Metrics & Dashboards Basics, that’s your North Star Metric. Define it in one sentence.
- List three supporting metrics. These are the drivers. For a KPI drop, look at acquisition, activation, and retention. Write them down.
- Set realistic targets. Use last month’s average or a simple benchmark. No guessing. If returning users were 5,000 last week, target 5,000 again.
- Compare actual vs. target. Calculate the gap. For returning users, actual was 4,100 vs. target 5,000. That’s an 18% gap—your biggest red flag.
- Write one recommendation. Based on the gap, suggest a fix. Example: “Run a re-engagement email campaign for users inactive 7+ days.” Keep it short and actionable.
Avoid These Traps
- Chasing every number. You don’t need all 20 metrics. Focus on the North Star and three supporting ones. Less noise, faster answer.
- Skipping the definition. If your metric is vague, your analysis is weak. Define it clearly: “Weekly active users = unique users who logged in at least once in the last 7 days.”
- Forgetting the target. Without a target, you can’t measure the gap. Use last week’s number or a simple goal.
- Overcomplicating the fix. Your recommendation doesn’t need a full plan. One clear action is better than three vague ideas.
- Waiting for perfect data. You have enough to start. Use what you have, note assumptions, and ship.
Your Win by Friday
By Friday, you’ll have a one-page analysis: the KPI drop, the root cause (returning users down 18%), and one recommendation. Your manager gets a clear answer, and you look like the analyst who can diagnose anything in one session. Plus, you’ll have a repeatable process for next time. That’s a win worth celebrating with a coffee break.