Diagnose a KPI Drop: Junior Analyst Fix in 5 Steps

Who This Helps

You're a junior analyst who just saw a key number drop. Maybe revenue dipped 12% this week. Or user signups stalled. Your boss wants answers by Friday. This is for you.

This guide uses the Founder Finance Basics Mission Pack to show how to diagnose fast. No panic. No rabbit holes. Just a clear path to the root cause.

Mini Case

Imagine you work for a SaaS startup. Last month, new customer adds dropped 15%. Revenue stayed flat, but cash didn't grow. Your CEO is worried.

You grab the Unit Economics Snapshot mission from the Founder Finance Basics Mission Pack. You check customer acquisition cost (CAC) and lifetime value (LTV). You see CAC jumped 20% because a new ad channel underperformed. LTV stayed the same. The root cause: channel mix shifted to expensive traffic.

Now you have a story. Not a guess.

Do This Now (5 Steps)

1. Pick one KPI to diagnose. Don't chase three at once. Choose the one that matters most this week.
2. Pull the last 7 days of data. Compare to the prior 7 days. Look for the biggest change.
3. Break it down by channel or segment. Use the CAC Payback Triage mission logic. Find which slice moved.
4. Ask one question: Is this a volume or efficiency problem? Volume means fewer units. Efficiency means each unit costs more.
5. Write a one-paragraph recommendation. Example: "Shift 30% of ad spend from Channel X to Channel Y to lower CAC by 12%."

Avoid These Traps

• Don't blame the data first. Check for a tracking bug, but assume it's real until proven otherwise.
• Don't over-engineer. A simple table beats a fancy dashboard that takes three days.
• Don't skip the "so what." Numbers without a recommendation are just noise.
• Don't forget to check the calendar. A holiday or product launch can explain a drop.
• Don't work alone. Ask a teammate to sanity-check your logic.
• Don't wait for perfect data. Use what you have. Ship it.
• Don't ignore the runway. If cash is tight, a KPI drop matters more. The Runway Forecast mission helps here.
• Don't overthink the format. A short email with a table and one recommendation works.

Your Win by Friday

By end of week, you'll have:

• A clear root cause for the KPI drop (like "CAC spiked 20% due to Channel X").
• A one-page recommendation your boss can act on.
• Confidence that you didn't miss the real story.

And hey, you might even finish before lunch on Friday. That's a win worth celebrating with a coffee break.