What is activation rate and how do you measure it
Activation rate explained: measure the percentage of new users who reach your product's core value moment and drive long-term engagement.
What is activation rate and how do you measure it
Quick answers
What is activation rate? Activation rate is the percentage of new users who reach a defined "aha moment" within a given time window after signing up. It's the metric that separates signups who got value from your product from signups who didn't. Formula: (Users who completed the activation event / Total signups in period) × 100.
What is an activation event? The activation event is the specific action most correlated with long-term retention in your product. For a collaboration tool it might be inviting a teammate. For a BI tool, connecting a database or creating a first chart. For a project manager, creating a first project with an assigned task. There's no universal activation event — you find yours by analyzing what retained users did in their first week.
How do I find my product's activation event? Look at users who've been active for 90+ days and trace back what they did in their first 7 days that churned users didn't. The action that best separates retained from churned users in that first week is almost always your activation event. Save the query in Metabase's SQL editor and run it on your users table.
What time window should I use for activation rate? Track three windows: day 1, day 7, and day 30. Users who activate on day 1 retain better than those who activate on day 14. The gap between your day 1 and day 7 rates shows you how well your onboarding is working in the critical first week.
Why is my activation rate low? Three common causes: friction in onboarding (too many steps before the value moment), a wrong activation event definition (too easy = inflated rate that doesn't predict retention; too hard = most users never hit it), or acquisition-product mismatch (users from a certain channel sign up for the wrong reasons and never activate). Slice your rate by acquisition source in Metabase to diagnose the third.
How do I visualize the path to activation? Build a funnel chart in Metabase using the funnel analysis guide. Each step is a stage between signup and activation. The widest drop-off point is where to focus your onboarding work.
How do I make sure my activation event definition doesn't drift over time? Define it in Metabase Data Studio with documentation on what it means and why. When someone new joins and asks "what counts as activated?", there's one answer — in the tool, not in someone's head.
---
Activation is the moment a new user gets it. Not signed up — lots of people sign up. The moment they actually experienced the thing that makes your product worth using.
It's the most important metric most early-stage teams aren't tracking.
The definition
Activation rate: The percentage of new users who reach a defined "aha moment" within a given time window after signing up.
Activation Rate = (Users who completed activation event / Total signups in period) × 100
The hard part isn't the math. It's defining the activation event.
What counts as activation
The activation event is the action most correlated with long-term retention. For different products, that looks like:
- A collaboration tool: invited at least one teammate
If you don't know which event predicts retention for your product, look at users who stayed for 90+ days and trace back what they did in their first week. That action is usually your activation event.
The time window matters
Activation rate needs a time window — it's not just "did they ever activate?" It's "did they activate within N days of signing up?"
The tighter the window, the more useful the metric. Users who activate on day 1 retain better than users who activate on day 14. Track both:
The gap between these tells you whether your onboarding is doing its job quickly enough.
What drives activation down
Friction in onboarding. Too many steps before the first value moment. Every required field, every permission request, every tutorial screen is an exit opportunity.
Wrong activation event. If you've defined activation as something too easy (like confirming an email), your activation rate looks great but doesn't predict retention. If it's too hard, most users never get there.
Acquisition-product mismatch. Users from a certain channel or campaign sign up for the wrong reasons and never activate. Slice your activation rate by acquisition source.
Putting it in Metabase
Build a funnel visualization that shows the steps from signup to activation — and where people drop off. The Metabase learn guide on funnel analysis walks through exactly how to structure this query and visualize it.
Save the activation rate query, trend it over time as a line chart, and add it to your core dashboard. Use alerts to fire if activation drops week-over-week — that's an early signal before it shows up in churn.
Define your activation event in Data Studio and document what it means. Six months from now, when someone asks "what counts as activated?", there should be one answer.
---