Version history

{
  "query_kind": "sql",
  "query_body": "WITH recent AS (\n  SELECT content\n  FROM artifacts\n  WHERE artifact_type = 'site_engagement_summary'\n    AND is_latest = 1\n    AND created_at::date = CURRENT_DATE - 1\n),\nprior AS (\n  SELECT content\n  FROM artifacts\n  WHERE artifact_type = 'site_engagement_summary'\n    AND is_latest = 1\n    AND created_at::date = CURRENT_DATE - 8\n)\nSELECT 'traffic_collapse' AS ref, 'pageviews' AS title\nFROM recent r, prior p\nWHERE (\n  (r.content->>'pageviews')::int < 0.5 * (p.content->>'pageviews')::int\n)\n",
  "query_params": {},
  "threshold": {
    "warning_at": 1,
    "critical_at": 1
  },
  "severity_default": "attention",
  "recommended_action_template": "{n} — 7d rolling pageviews have dropped >50% vs the prior 7d\nwindow. Check for broken integrations, search index issues, or\nsupply-chain problems. Current vs prior: {refs[:1]}.\n",
  "state": "active",
  "proposer_id": "system-senate"
}