📅 BSP Monday 2 PM Standup Report

Closed window 2026-04-04 → 2026-04-10 · Every number below resolves through the Metrics Registry with a source receipt · No hand-typed numbers survived the render-time scanner

💰 The Money Picture

Ad spend (last 7 days, closed)
$2,457.48
📎 google_ads_api · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Big Sale tracker — this week's total
$52,443.34
📎 json_file · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Revenue — posted to QB (last 7 days)
$0.00
📎 quickbooks · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Ramp total card spend (last 7 days)
$6,472.07
📎 ramp · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Ramp materials/COGS spend (last 7 days)
$3,861.53
📎 ramp · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46

🎯 Ad Performance

Ad clicks (last 7 days, closed)
153
📎 google_ads_api · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Cost per click (last 7 days)
$16.06
📎 derived · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Google Ads real conversions (primary-counted only, ghosts excluded)
109
📎 google_ads_api · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46

📞 Bookings (ST)

Booked ad-sourced jobs (ST, last 7 days)
10
📎 postgres · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Booked jobs — all sources (ST, last 7 days)
33
📎 postgres · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Cost per real booking (last 7 days)
$245.75
📎 derived · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Completed jobs — all sources (ST, last 7 days)
0
📎 postgres · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46

☎️ 3CX Call Activity

Inbound calls (3CX, last 7 days)
141
📎 sqlite · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46
Outbound calls (3CX, last 7 days)
146
📎 sqlite · 2026-04-04→2026-04-10 · pulled 2026-04-11 21:46

📊 Revenue Cross-Source Reconciliation

Five sources should tell the same story within tolerance. If any diverge by more than 30% from Big Sale truth, flag for investigation.

SourceValueStatus
Big Sale tracker (Slack #big-sale-alert — truth per CLAUDE.md)$52,443.34PRIMARY
Big Sale latest EOW$70,180.34reference
QuickBooks posted invoices (last 7d)$0.00posted $0 — lag or broken sync
ServiceTitan completed jobs (last 7d)0pipeline broken — do not use as primary
Ramp total spend (last 7d, for sanity check)$6,472.07reference

📎 Full Receipt Trail (every number's source)

Generated by /opt/nexus/nexus/scripts/monday_2pm_report.py at 2026-04-11 21:46 · All metrics resolve through /opt/nexus/titan/metrics_registry.py · Fix #1 + #2 from the Apr 11 Phantom Numbers RCA enforced · Zero naked numbers passed the scanner