Ask more of
your database.

SELECT DATE_TRUNC('month', created_at) AS month,
  COUNT(*) AS new_customers
FROM customers
WHERE created_at >= '2026-03-01'
GROUP BY 1
ORDER BY 1;

SELECT DATE_TRUNC('month', started_at) AS month,
  COUNT(*) AS new_subscriptions
FROM subscriptions
WHERE started_at >= '2026-03-01'
GROUP BY 1
ORDER BY 1;

SELECT DATE_TRUNC('month', created_at) AS month,
  COUNT(*) AS orders
FROM orders
WHERE created_at >= '2026-03-01'
GROUP BY 1
ORDER BY 1;

SELECT DATE_TRUNC('month', c.created_at) AS month,
  COUNT(*) AS new_customers,
  AVG(CASE WHEN s.customer_id IS NULL
    THEN 0 ELSE 1 END) AS share_subscribed
FROM customers c
LEFT JOIN (
  SELECT DISTINCT customer_id
  FROM subscriptions
  WHERE status = 'active'
) s ON s.customer_id = c.id
WHERE c.created_at >= '2026-03-01'
GROUP BY 1
ORDER BY 1;

SELECT DATE_TRUNC('month', o.created_at) AS month,
  COUNT(DISTINCT o.customer_id) AS ordering,
  COUNT(DISTINCT o.customer_id) FILTER (
    WHERE c.first_order_at
      < DATE_TRUNC('month', o.created_at)
  ) AS returning
FROM orders o
JOIN customers c ON c.id = o.customer_id
WHERE o.created_at >= '2026-03-01'
GROUP BY 1
ORDER BY 1;

SELECT DATE_TRUNC('month', o.created_at) AS month,
  COUNT(*) AS orders,
  AVG(o.total) AS avg_order_value
FROM orders o
WHERE o.customer_id IN (
  SELECT customer_id
  FROM subscriptions
  WHERE status = 'active'
)
AND o.created_at >= '2026-03-01'
GROUP BY 1
ORDER BY 1;

SELECT c.region,
  DATE_TRUNC('month', o.created_at) AS month,
  SUM(o.total) AS revenue
FROM orders o
JOIN customers c ON c.id = o.customer_id
WHERE o.customer_id IN (
  SELECT customer_id
  FROM subscriptions
  WHERE status = 'active'
)
AND o.created_at >= '2026-03-01'
GROUP BY 1, 2
ORDER BY 2, 3 DESC;