Your app telemetry, next to your business data.

WITH tokens AS (
  SELECT
    attributes:user_id::TEXT AS user_id,
    SUM(value) AS total
  FROM metrics
  WHERE metric_name = 'llm.tokens.total'
  GROUP BY 1
)
SELECT
  COUNT(c.user_id)        AS converted,
  AVG(t.total) * 0.000002 AS cost_per_conv_usd
FROM conversions c
JOIN tokens t ON t.user_id = c.user_id
WHERE c.converted_at > NOW() - INTERVAL '7d';

SELECT
  t.attributes:build_sha::TEXT  AS build,
  COUNT(DISTINCT o.order_id)    AS orders,
  AVG(o.amount)                 AS avg_order,
  SUM(CASE WHEN o.status = 'failed'
           THEN 1 ELSE 0 END)   AS failures
FROM traces t
JOIN orders o ON o.trace_id = t.trace_id
WHERE t.operation = 'checkout.submit'
  AND t.start_time > NOW() - INTERVAL '24h'
GROUP BY 1
ORDER BY orders DESC;

SELECT
  l.service,
  l.body                       AS error,
  COUNT(DISTINCT u.user_id)    AS users,
  SUM(u.lifetime_value)        AS at_risk_revenue
FROM logs l
JOIN sessions s ON s.trace_id = l.trace_id
JOIN users u    ON u.user_id  = s.user_id
WHERE l.severity = 'ERROR'
  AND l.timestamp > NOW() - INTERVAL '7d'
GROUP BY 1, 2
ORDER BY at_risk_revenue DESC
LIMIT 20;