Analytics traffic collapse (>50% drop in 7d rolling)

Details

query_kind: sql
severity_default: attention
recommended_action_template: {n} — 7d rolling pageviews have dropped >50% vs the prior 7d window. Check for broken integrations, search index issues, or supply-chain problems. Current vs prior: {refs[:1]}.
state: active
proposer_id: system-senate

Raw fields (3)

query_body

WITH recent AS (
  SELECT content
  FROM artifacts
  WHERE artifact_type = 'site_engagement_summary'
    AND is_latest = 1
    AND created_at::date = CURRENT_DATE - 1
),
prior AS (
  SELECT content
  FROM artifacts
  WHERE artifact_type = 'site_engagement_summary'
    AND is_latest = 1
    AND created_at::date = CURRENT_DATE - 8
)
SELECT 'traffic_collapse' AS ref, 'pageviews' AS title
FROM recent r, prior p
WHERE (
  (r.content->>'pageviews')::int < 0.5 * (p.content->>'pageviews')::int
)

query_params

{}

threshold

{
  "warning_at": 1,
  "critical_at": 1
}

Analytics traffic collapse (>50% drop in 7d rolling)

Details

Replication

Discussion