← Back to blog

Junior Analyst · Founder Finance Basics Mission Pack

Diagnose a KPI Drop: Junior Analyst Rescue Plan

Pinpoint root cause in one focused session. Ship clean analysis with clear recommendations.

Who This Helps

You're a junior analyst staring at a dashboard where revenue is up but cash is flat. Your boss wants answers, not excuses. This is for anyone in the Founder Finance Basics Mission Pack who needs to turn a confusing number into a crisp, actionable story.

Mini Case

Meet Ben, a founder who saw his monthly recurring revenue climb 12% but his bank account didn't budge. He spent 90 minutes digging into unit economics and found the culprit: his CAC payback period stretched from 5 months to 8 months because a new ad channel was burning cash. Ben used the CAC Payback Triage mission to flag the channel, pause spend, and save $4,000 in 7 days. You can do the same.

Do This Now (5 Steps)

  1. Pull your unit economics snapshot – Grab revenue, cost of goods sold, and customer acquisition cost for the last 3 months. You want a one-page truth.
  1. Find the KPI that broke – Look at your CAC payback period. If it jumped more than 20% (like Ben's 60% increase), you found your leak.
  1. Trace the channel – Break down spend by source. Which channel has the highest cost per customer? That's your prime suspect.
  1. Run a quick scenario – What if you cut that channel by 50%? Model the impact on cash and growth. Use the Pricing Scenario Guardrails mission to set stop rules.
  1. Write one recommendation – Ship a one-paragraph memo: what dropped, why, and one action (pause channel, adjust pricing, or reallocate budget).

Avoid These Traps

  • Chasing every number – Don't analyze all 12 KPIs. Pick the one that ties directly to cash.
  • Blinding with data – A 10-page report buries the story. Keep it to one page.
  • Ignoring the time lag – A KPI drop today might be from a decision 30 days ago. Check the timeline.
  • Forgetting the human – Your recommendation affects real people (like the ad team). Frame it as a test, not a blame.
  • Overcomplicating the fix – Sometimes the answer is just "pause channel X for 2 weeks." Don't overthink.

Your Win by Friday

By Friday, you'll have a one-page unit economics snapshot that shows exactly where cash is leaking. You'll ship a clean analysis with one clear recommendation (like "pause the Instagram ads channel to save $1,200 per week"). Your boss will nod, say "good work," and you'll feel like a data detective who cracked the case. Plus, you'll have a repeatable process for the next KPI drop—because there's always a next one.