What is your DAU/MAU ratio — and is it improving?

WITH daily_active AS (
  SELECT
    DATE_TRUNC('month', event_date)::date  AS month,
    event_date::date                       AS day,
    COUNT(DISTINCT user_id)                AS dau
  FROM user_events
  WHERE event_date >= DATEADD('month', -6, CURRENT_DATE)
  GROUP BY 1, 2
),
monthly_active AS (
  SELECT
    DATE_TRUNC('month', event_date)::date  AS month,
    COUNT(DISTINCT user_id)                AS mau
  FROM user_events
  WHERE event_date >= DATEADD('month', -6, CURRENT_DATE)
  GROUP BY 1
),
avg_dau AS (
  SELECT month, ROUND(AVG(dau), 0) AS avg_dau
  FROM daily_active
  GROUP BY month
)
SELECT
  TO_CHAR(m.month, 'YYYY-MM')                           AS month,
  a.avg_dau,
  m.mau,
  ROUND(a.avg_dau * 100.0 / NULLIF(m.mau, 0), 1)      AS dau_mau_ratio_pct
FROM monthly_active m
JOIN avg_dau a ON a.month = m.month
ORDER BY month ASC