Which features are your newest users adopting — and which are they ignoring?

WITH user_cohorts AS (
  SELECT
    user_id,
    DATE_TRUNC('month', created_at)::date AS cohort_month
  FROM users
),
feature_usage AS (
  SELECT DISTINCT
    uc.cohort_month,
    ue.feature_name,
    ue.user_id
  FROM user_events ue
  JOIN user_cohorts uc ON uc.user_id = ue.user_id
  WHERE ue.event_type = 'feature_used'
    AND ue.event_date >= DATEADD('month', -6, CURRENT_DATE)
),
cohort_sizes AS (
  SELECT cohort_month, COUNT(DISTINCT user_id) AS cohort_size
  FROM user_cohorts
  WHERE cohort_month >= DATEADD('month', -6, CURRENT_DATE)
  GROUP BY cohort_month
)
SELECT
  TO_CHAR(fu.cohort_month, 'YYYY-MM')                 AS cohort,
  fu.feature_name,
  COUNT(DISTINCT fu.user_id)                           AS users_adopted,
  cs.cohort_size,
  ROUND(COUNT(DISTINCT fu.user_id) * 100.0
    / NULLIF(cs.cohort_size, 0), 1)                    AS adoption_pct
FROM feature_usage fu
JOIN cohort_sizes cs USING (cohort_month)
GROUP BY fu.cohort_month, fu.feature_name, cs.cohort_size
ORDER BY fu.cohort_month DESC, adoption_pct DESC