Who This Helps
This is for the Junior Analyst who just saw a key number dip and needs to explain it fast. It uses the core method from the Finance Basics for Operators course: building a simple, one-page snapshot that tells the real story.
Mini Case
Your weekly report shows customer acquisition cost (CAC) jumped 15% last week. Panic? Not yet. Last month, your average CAC was $50. This week it's $57.50. Revenue per user stayed flat at $80. Your contribution margin just shrank from $30 to $22.50. That's the real problem to diagnose.
Do This Now (5 Steps)
- Isolate the one KPI. Is it CAC, churn rate, or conversion? Pick one. Write it down.
- Grab last week's and this week's number. Get the exact values. No ranges.
- Check its partner metric. If CAC moved, look at revenue per user. If churn moved, look at new signups. Did the partner move too?
- Calculate the unit impact. Like in the mini-case: $80 revenue minus $57.50 new CAC = $22.50 margin. Last week it was $30. You found a $7.50 leak per customer.
- Ask one 'why' for the change. Did we use a new ad channel? Did a key landing page go down? Name one probable cause.
Avoid These Traps
- Don't try to diagnose three KPIs at once. You'll get tangled.
- Don't present just the percentage change. Show the actual dollar or unit impact.
- Don't blame 'market trends' first. Look for an internal change you can actually control.
- Don't skip the partner metric check. A solo moving KPI is a red herring.
- Don't write a novel. Your diagnosis should fit on a sticky note. Really.
Your Win by Friday
By Friday, you can walk into a standup and say: "CAC is up 15%. The root cause is likely the new video ad campaign, which lowered our signup quality. It cut our per-customer margin by $7.50. I recommend we pause it and test a different audience for 7 days." That's shipping clean analysis with a clear recommendation. You've just turned a confusing drop into a clear action plan. Nice work.