What Is Activation Rate?
Activation rate is the percentage of new users who complete a defined first-value action within a given time window after signup, and it is one of the strongest leading indicators of long-term retention in product-led growth companies. Most teams track it from event export data that requires aggregation by cohort before the metric becomes meaningful.
See which event export columns to pull, how to define the activation event, and the exact formula to calculate it by cohort in a spreadsheet.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| user_id |
| signup_date |
| first_value_event |
| event_date |
| days_to_activate |
| plan_type |
| acquisition_channel |
| activated_flag |
| cohort_week |
| feature_used |
What usually goes wrong with it
Activation event definition varies by product
The first_value_event column may contain dozens of distinct event names — without a clear definition of which event counts as activation, any metric calculated from it will be wrong.
DataMimi Datamimi lets you specify which first_value_event values count as activation and filters the dataset to those events before calculating the rate.
Signup and activation in different exports
User signups live in the CRM or auth export while activation events live in the product analytics export — joining the two on user_id requires matching ID formats across systems.
DataMimi It joins auth and product analytics exports on user_id with fuzzy ID matching so activation events are correctly linked to signup records.
Time window inconsistency
Some teams calculate activation within 7 days; others within 14 or 30 days — using different time windows across reports makes trend data incomparable period to period.
DataMimi It applies a consistent days_to_activate window across all cohort calculations so the metric is comparable across reporting periods.
Common questions
What is activation rate?
Activation rate is the percentage of new users who complete your defined first-value action within a set time window — for example, the share of signups who create their first project within 7 days.
What is a good benchmark for this metric?
Consumer apps often target 25–40% within 7 days; B2B SaaS products with longer onboarding may target 50–70% within 14 days for self-serve users.
How do I calculate it in a spreadsheet?
Divide the count of users with an activated_flag who completed the key event within the window by total signups in the same cohort period.
How does it differ from retention?
This metric measures whether new users reach their first value moment; retention measures whether those users return over time — improving the former is the prerequisite for improving the latter.
How much does Datamimi cost?
Datamimi offers a Free plan at $0/month (40 credits, no credit card required), Lite at $9/month (400 credits), Starter at $24/month (1,500 credits, up to 3 simultaneous files), Pro at $59/month (5,000 credits with rollover), and Team at $199/month (20,000 credits, 5 users).
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file