Who This Helps
This is for growth marketers who see a key number dip and need to know why—fast. It uses the core idea from the Metrics & Dashboards Basics course: building a dashboard you trust for calm weekly decisions.
Mini Case
Maya saw her weekly sign-ups drop 18%. Her old report showed 20 different numbers, making it impossible to see the root cause. She spent 3 days digging through data, feeling stressed. Her team started guessing—was it the ads, the landing page, or something else?
Do This Now (5 Steps)
- Open your main dashboard. If you don't have one, sketch your North Star metric and three supporting metrics on a blank slide right now.
- Look at last week's scoreboard. Find the one KPI that dropped the most. Circle it.
- Check the three metrics directly connected to that KPI. Did one of them move first? (This is your likely culprit).
- Note the exact day the supporting metric changed. Check your campaign calendar or release notes for that date.
- Write one sentence linking the change to the event. Example: 'Sign-ups dropped because trial starts fell 22% after we updated the pricing page on Tuesday.'
Avoid These Traps
- Don't jump into raw analytics tools without a hypothesis. You'll drown in data.
- Avoid checking more than five numbers. Focus is your superpower here.
- Don't blame 'external factors' until you've ruled out your own changes.
- Skip the vanity metrics. A dip in social likes likely didn't cause a sales drop.
- Resist the urge to call a meeting before you do these five steps. You'll have a clearer story.
- Don't rebuild your entire dashboard mid-crisis. Use what you have.
- Avoid making a second change before measuring the impact of the first.
- Never diagnose alone for more than 45 minutes. If you're stuck, grab one teammate to help.
Your Win by Friday
You'll move from 'Why did this happen?' to 'The drop was caused by X, which changed on Y day.' No more guesswork, just a clear, actionable reason. You'll have a calm answer for your team lead and can fix the real problem, not a symptom. You might even finish early and enjoy your coffee while it's still hot.