Who This Helps
This is for junior analysts in the Creative Economy Mission Pack. If your reach is down and you need one funnel-based diagnosis and a clear next action, this is your move.
Mini Case
Rafael saw his weekly reach drop 22%. He spent 45 minutes looking at everything. Then he built a simple funnel snapshot card. It showed his new video hooks were fine, but his share rate from week 1 to week 2 had fallen from 15% to 8%. The problem wasn't at the top—it was in keeping people engaged. He fixed one thing, not ten.
Do This Now (5 Steps)
- Block 60 minutes on your calendar. Close other tabs.
- Pick one KPI that dropped. Write it down. For example: 'Video completion rate down 18% this month.'
- Map the simple user journey for that KPI. Think: See, Start, Finish, Share.
- Pull the number for each step from last month and this month. Use just two data points.
- Find the single biggest percentage change between steps. That's your likely root cause. Circle it.
Avoid These Traps
- Don't jump to conclusions because one big number is red. Look at the flow between steps.
- Avoid checking more than three data sources. You'll get lost in the weeds.
- Don't try to diagnose two KPIs at once. Pick the most important one.
- Stop yourself from proposing five solutions. Your job is to find one cause.
- Never present a diagnosis without a specific, next-step recommendation.
- Don't let perfect data slow you down. Use the best you have right now.
- Avoid jargon when you explain it. Say 'fewer people are sharing' not 'viral coefficient degradation.'
- Don't skip writing it down. A messy back-of-napkin sketch is better than a perfect thought.
Your Win by Friday
You'll walk into your weekly check-in with a one-page funnel snapshot card. It will show the exact step where your audience is leaking. You'll have one clear, testable recommendation—like 'test two new call-to-actions in week 2 to boost shares.' No more data fog, just a clean path forward. You've got this.