Dashboard Pack Implementation

North Star Metric: Weekly Active Objects

The North Star should capture value delivery, not just activity. For a dashboard tool, it's "Weekly Active Dashboards" (dashboards viewed by ≥1 user in 7 days).

-- Weekly Active Dashboards (North Star)
SELECT
  DATE_TRUNC('week', event_timestamp) AS week,
  COUNT(DISTINCT dashboard_id) AS weekly_active_dashboards
FROM events
WHERE
  event_name = 'dashboard_viewed'
  AND event_timestamp >= CURRENT_DATE - INTERVAL '12 weeks'
GROUP BY 1
ORDER BY 1 DESC;

Activation Funnel Query

-- Activation Funnel (7-day cohorts)
WITH signups AS (
  SELECT
    user_id,
    DATE_TRUNC('week', event_timestamp) AS cohort_week
  FROM events
  WHERE event_name = 'user_signed_up'
    AND event_timestamp >= CURRENT_DATE - INTERVAL '8 weeks'
),
funnel AS (
  SELECT
    s.user_id,
    s.cohort_week,
    MAX(CASE WHEN e.event_name = 'onboarding_completed'
      AND e.event_timestamp <= s.cohort_week + INTERVAL '1 day'
      THEN 1 ELSE 0 END) AS setup_complete,
    MAX(CASE WHEN e.event_name = 'dashboard_created'
      AND e.event_timestamp <= s.cohort_week + INTERVAL '2 days'
      THEN 1 ELSE 0 END) AS first_object,
    MAX(CASE WHEN e.event_name = 'dashboard_shared'
      AND e.event_timestamp <= s.cohort_week + INTERVAL '7 days'
      THEN 1 ELSE 0 END) AS value_action,
    MAX(CASE WHEN e.event_name = 'user_activated'
      AND e.event_timestamp <= s.cohort_week + INTERVAL '7 days'
      THEN 1 ELSE 0 END) AS activated
  FROM signups s
  LEFT JOIN events e ON s.user_id = e.user_id
  GROUP BY 1, 2
)
SELECT
  cohort_week,
  COUNT(*) AS signups,
  SUM(setup_complete) AS setup_complete,
  SUM(first_object) AS first_object,
  SUM(value_action) AS value_action,
  SUM(activated) AS activated,
  ROUND(100.0 * SUM(activated) / COUNT(*), 1) AS activation_rate
FROM funnel
GROUP BY 1
ORDER BY 1 DESC;