What is activation rate, and how do you measure it in Metabase?

Activation rate is the share of new signups who reach your product's value moment — created a first project, invited a teammate — within a defined window. It's the bridge metric between marketing and product: signups measure what marketing delivered, activation measures whether those users got anywhere. Measure it in Metabase from event data synced from Amplitude, PostHog, or Mixpanel.

What activation rate measures

Whether new users cross from signed up to getting value — the step where most funnels quietly leak. Defined well, it's the earliest reliable predictor of retention: the activation event should be a behavior that demonstrably separates users who stay from users who churn, found by correlating early actions against retention, not chosen in a meeting. Time-in-app and session counts don't qualify — activity isn't value.

Segmented by acquisition channel, it becomes marketing's quality metric. Two channels with identical CAC and very different activation rates have very different real costs — and the channel review that includes activation stops rewarding cheap signups that go nowhere.

What data does it need?

• A stable user ID and a signup_at timestamp — the cohort anchor.
• An activated_at timestamp: the first occurrence of the activation event per user, materialized from the product-events stream.
• Acquisition channel on the user record, captured at signup from UTM parameters or an attribution tool.
• Identity resolution that survives the anonymous-to-identified merge, so pre-signup events attach to the right user.

SQL patterns

SELECT
  date_trunc('week', signup_at) AS signup_week,
  COUNT(*) AS signups,
  COUNT(*) FILTER (
    WHERE activated_at IS NOT NULL
      AND activated_at <= signup_at + INTERVAL '7 days'
  ) AS activated,
  ROUND(
    100.0 * COUNT(*) FILTER (
      WHERE activated_at IS NOT NULL
        AND activated_at <= signup_at + INTERVAL '7 days'
    ) / COUNT(*), 2
  ) AS activation_rate_pct
FROM users
WHERE signup_at >= CURRENT_DATE - INTERVAL '6 months'
  AND signup_at <= CURRENT_DATE - INTERVAL '7 days'
GROUP BY 1
ORDER BY 1;

SELECT
  acquisition_channel,
  COUNT(*) AS signups,
  COUNT(*) FILTER (
    WHERE activated_at IS NOT NULL
      AND activated_at <= signup_at + INTERVAL '7 days'
  ) AS activated,
  ROUND(
    100.0 * COUNT(*) FILTER (
      WHERE activated_at IS NOT NULL
        AND activated_at <= signup_at + INTERVAL '7 days'
    ) / COUNT(*), 2
  ) AS activation_rate_pct
FROM users
WHERE signup_at >= CURRENT_DATE - INTERVAL '90 days'
  AND signup_at <= CURRENT_DATE - INTERVAL '7 days'
GROUP BY 1
ORDER BY signups DESC;

Pitfalls

Where this metric applies

• Amplitude + Metabase — event streams and cohort exports for activation analysis
• PostHog + Metabase — product events with identity resolution
• Mixpanel + Metabase — user profiles and first-occurrence event timestamps
• AppsFlyer + Metabase — acquisition channel attribution joined to signup cohorts

Related

Metrics

Dashboards

FAQ