What percentage of your Shopify revenue comes from repeat customers?

WITH customer_order_history AS (
  SELECT
    customer_id,
    id            AS order_id,
    total_price,
    created_at,
    ROW_NUMBER() OVER (
      PARTITION BY customer_id
      ORDER BY created_at ASC
    )             AS order_sequence
  FROM shopify_orders
  WHERE financial_status IN ('paid', 'partially_refunded')
    AND customer_id IS NOT NULL
)
SELECT
  TO_CHAR(DATE_TRUNC('month', created_at), 'YYYY-MM')   AS order_month,
  COUNT(*) FILTER (WHERE order_sequence = 1)            AS new_customer_orders,
  COUNT(*) FILTER (WHERE order_sequence > 1)            AS repeat_customer_orders,
  COUNT(*)                                              AS total_orders,
  ROUND(SUM(total_price) FILTER (WHERE order_sequence = 1)::numeric, 2)  AS new_revenue,
  ROUND(SUM(total_price) FILTER (WHERE order_sequence > 1)::numeric, 2) AS repeat_revenue,
  ROUND(
    COUNT(*) FILTER (WHERE order_sequence > 1)::numeric * 100
    / NULLIF(COUNT(*), 0), 2
  )                                                     AS repeat_order_pct,
  ROUND(
    SUM(total_price) FILTER (WHERE order_sequence > 1)::numeric * 100
    / NULLIF(SUM(total_price)::numeric, 0), 2
  )                                                     AS repeat_revenue_pct
FROM customer_order_history
WHERE created_at >= NOW() - INTERVAL '12 months'
GROUP BY DATE_TRUNC('month', created_at)
ORDER BY 1 ASC