Who This Helps
This is for you, Junior Analyst. You just saw a key metric dip—maybe 12% in weekly active users. Your boss wants answers, not excuses. You need a fast, repeatable way to find the real cause and recommend a fix. The Product Portfolio Strategy course teaches you to size bets and sequence work, but first you have to know what broke.
Mini Case
Imagine you track a SaaS product. Last week, new sign-ups dropped 15%. You check the data: traffic is flat, but conversion fell from 8% to 6%. You dig into the funnel. The biggest leak? The pricing page. Users land, see the annual plan price, and leave. One change: the team raised the annual price by 20% two weeks ago. That’s your root cause. Now you can recommend a rollback or a better offer.
Do This Now (5 Steps)
- Grab the last 7 days of data for your KPI. Compare to the prior 7 days. Look for a clear drop point.
- Split the funnel into stages. For sign-ups, that’s visit, pricing page, checkout, confirmation. Find where the drop happens.
- Check for recent changes. Did marketing launch a new campaign? Did engineering push a code change? Did pricing update? Ask your team.
- Run a simple cohort analysis. Group users by the day they first visited. See if conversion dropped for all cohorts or just one.
- Write one recommendation. Example: “Roll back the annual price increase and test a 10% discount for 2 weeks.” Keep it short.
Avoid These Traps
- Blame the data. A drop might be a tracking bug. Verify your numbers before panicking.
- Chase every metric. Focus on one KPI per session. You can’t fix everything at once.
- Skip the context. A 12% drop during a holiday weekend might be normal. Check seasonality.
- Overcomplicate. You don’t need a dashboard. A simple spreadsheet with 3 columns works.
- Forget the recommendation. Analysis without action is just noise. Ship a clear next step.
Your Win by Friday
By Friday, you will have one root cause identified and one recommendation ready. Your boss sees you as the person who finds answers fast. You feel confident, not stuck. That’s a win. And hey, you might even get to leave early—no one will complain if you ship clean work before the weekend.