Who This Helps
Hey, junior analyst. You just saw the weekly activation rate drop 8%. The team is asking why. This is for you. It’s a core skill from the Product Metrics Basics course: moving from ‘something’s wrong’ to ‘here’s exactly where it broke.’
Mini Case
Priya’s team saw a 12% drop in new user activation last week. The main dashboard just showed the red arrow. She created one segment funnel snapshot for ‘users from social media ads.’ Boom. She saw a 40% drop-off at the ‘complete profile’ step. The problem wasn’t the whole funnel—it was one specific step for one group. She had her root cause in 30 minutes.
Do This Now (5 Steps)
- Grab the metric. What’s the one KPI that dropped? Write it down. For example, ‘Week 1 Activation Rate.’
- Pick one suspect segment. Don’t try all of them. Pick the most likely one. Think: ‘new users from email campaign’ or ‘users on mobile web.’
- Map their 3 key steps. What are the 3 main actions they take to reach your metric? Example: Visit landing page > Sign up > Complete first task.
- Pull the conversion rates. For last week vs. the week before. Just get the numbers for each step for your segment.
- Find the biggest delta. Where did the percentage drop the most? That’s your leak. That’s your diagnosis. Your data detective work is done.
Avoid These Traps
- Averaging everything. Looking at ‘all users’ hides the real story. One segment’s problem gets diluted.
- Too many steps. A 10-step funnel is overwhelming. Stick to the 3 core actions that define success.
- Chasing every segment. You only need one clear, guilty segment to explain most of the drop. Find it first.
- Forgetting the ‘before’. You must compare to a stable period. A 60% conversion rate is meaningless if it was 90% last week.
- No event taxonomy. If ‘Sign up’ is tracked three different ways in your data, you can’t trust your numbers. This is why the Product Metrics Basics mission on Event Taxonomy is so crucial.
Your Win by Friday
You walk into the weekly check-in. Instead of saying “Activation is down,” you say: “Activation dropped 12%. It’s primarily in our social media segment—their drop-off at the profile step doubled. Here’s my recommendation to fix it.” You’ve turned panic into a plan. Go get that win.