📊 BSP Unmapped Invoices Weekly Audit
Window: 2026-04-11 → 2026-04-12 · Generated 2026-04-11 23:09 UTC
🔍 Breakdown by Root Cause
| Bucket | Count | $ at risk | Explanation / Action |
|---|
| 📵NO_PHONE_IN_PAYLOAD |
0 |
$0 |
Data gap on ST — customer record has no phone field populated. Fix: Ashton verifies phone on job creation. |
| 👻PHONE_NO_CAPTURE_OR_OUTSIDE_WINDOW |
1 |
$11,300 |
Phone present but no Snippet #55 capture matched within 90 days. Fix: expand Snippet #55 to more landing pages, or revisit the 90-day window. |
| 🚫GOOGLE_API_REJECTED |
5 |
$46,050 |
Upload attempted but Google rejected the GCLID (expired, bad format, etc.). Fix: check shadow log for the exact error message. |
| ⏳NON_TERMINAL_ONLY |
3 |
$16,400 |
Invoice never reached Paid/Final status. Likely pending or canceled. No action needed unless a specific invoice should have terminated. |
📋 Sample Unmapped Invoices (top 20)
| Invoice ID | Total | Status | Bucket | Received |
|---|
| 88001 |
$7,500 |
Paid |
GOOGLE_API_REJECTED |
2026-04-11 22:20:27 |
| 9999201 |
$8,200 |
Posted |
NON_TERMINAL_ONLY |
2026-04-11 22:07:50 |
| 77002 |
$11,250 |
Paid |
GOOGLE_API_REJECTED |
2026-04-11 22:18:02 |
| 66001 |
$8,500 |
Paid |
GOOGLE_API_REJECTED |
2026-04-11 23:05:17 |
| 99001 |
$11,300 |
Paid |
PHONE_NO_CAPTURE_OR_OUTSIDE_WINDOW |
2026-04-11 22:28:54 |
| 99002 |
$11,300 |
Paid |
GOOGLE_API_REJECTED |
2026-04-11 22:29:33 |
| 9999101 |
$7,750 |
Posted |
NON_TERMINAL_ONLY |
2026-04-11 22:05:53 |
| 9999102 |
$450 |
Posted |
NON_TERMINAL_ONLY |
2026-04-11 22:05:54 |
| 99999 |
$7,500 |
Paid |
GOOGLE_API_REJECTED |
2026-04-11 22:38:55 |
Generated by /opt/nexus/titan/nexus_unmapped_invoices_audit.py · Runs every Friday 13:00 UTC (8 AM CT)