Ledger

WEB-037

DB analytics: cookie-less events + web vitals (site_server ingest, allow-listed names, daily-salted visitor hash), funnel/sources/vitals reports, prune + pgTAP

← Ledger

donestatus · web-db

1✓ tests passed / failed

829.0ktokens · 4 min

0evidence files

Evidence

From logs/evidence/WEB-037/. Click a thumbnail for the full image.

No evidence files in logs/evidence/WEB-037/.

Tests

pass pgTAP all: + analytics ingest/reports · 25.2 s · raw log$ pnpm db:test

Notes

2026-10-04 14:38 UTC · Migration 20261004140600_analytics: events (allow-listed names, path/utm/device/props ≤2 KB) + web_vitals (LCP/CLS/INP/FCP/TTFB), site_server-only api.track_events (batch ≤25, visitor = daily sha256(ip|ua|salt|date), 300/min rate limit) and api.report_web_vitals; analytics.funnel (visitors→engaged→CTA→started→completed), sources (utm/referrer/direct with sign-ups), vitals (p75 per metric/device), prune (90 d, worker). pgTAP 070 7 checks (83 total).