Per-day reconciliation: per-event scrape sum vs Glooko closed-day TDI. Flagged when Δtdi > 0.5 U or coverage < 90 %.
| Date SGT | Glooko TDI | Per-event Σ | Δtdi | Δbolus | Δbasal | μbol n | Coverage | Last scrape | Status | |
|---|---|---|---|---|---|---|---|---|---|---|
| No reconciled days in this window. | ||||||||||
Each row compares two independent views of the same SGT day: per-event scrape sum (canonical production_events.kind='microbolus' + 'user_bolus')
vs Glooko's authoritative closed-day TDI from glooko_web_stats_snapshots (window_days=1).
Δtdi within ±0.5 U (one OP5 pulse) means the per-event scrape captured every dose. Larger gaps indicate either scraper coverage holes (the Pixel monitor wasn't foregrounded during a SmartAdjust burst) or late-arriving scrape rows that haven't promoted to canonical yet. The Recompute button on a row covers the latter; Refresh scrape targets pushes the still-flagged dates into the KV scrape config so the next Pixel Auto run walks back to them.
Coverage % is the share of 288 five-minute slots in the SGT day where SmartAdjust delivered AND the scrape captured a microbolus row (or the slot is explained by a non-Auto pump mode). < 90 % flags as needing attention.