QBR Planner

Prior-month KPI dashboard sourced from KPI Central (bspnxzsxy) Months table (bspnx3ppg). Headline ROI, hours saved, full operational breakdown, and trend charts. Filtered to Lagging Month = true (FID 74).

Project management timeline and task grid sourced from the PM app (Projects bppg3pigs, Tasks bn2g2dva9). Currently a placeholder pending migration into the BCFP shell.

Buyer team KPI scoreboard (Tanner Robertson, Matt Jones + team aggregate) across Daily / Weekly / Monthly / Annual. Sourced from Offers (bm9w27rni), Owners (bmnjhesri) and Acquisitions (bnvrm94hq); Daily column + deltas served from MySQL caches refreshed by the worker.

Claude Code & CoWork adoption, cost-efficiency, and model mix from the Dev Library Claude Usage Daily table (bv488cd4u), alongside org API spend from the Anthropic Admin API. Exec / team / per-user drill-down in one view.

Quickbase Development KPI data. Requires QB_KPI_USER_TOKEN and QB_KPI_APP_TOKEN.

Project and task data from the PM app. Requires QB_GANTT_USER_TOKEN and QB_GANTT_APP_TOKEN.

Buyer team scoreboard data. Requires QB_BUYER_OVERVIEW_USER_TOKEN / QB_BUYER_OVERVIEW_APP_TOKEN; Daily column + deltas additionally need JAWSDB_URL (MySQL) and the worker dyno.

Creates the buyer_overview_* MySQL caches if absent and fills any missing rows (daily Calls Made history, baselines, previous-period deltas) from Quickbase. Warm & Repair fills gaps only — it won't overwrite existing rows. Hard Reset wipes all three tables first, then re-derives every row (use this to clear stale/corrupted data).

Claude usage & spend data. Code/CoWork telemetry needs QB_DEV_LIBRARY_USER_TOKEN / QB_DEV_LIBRARY_APP_TOKEN (Dev Library read); API spend needs ANTHROPIC_ADMIN_KEY (an Anthropic Admin API key).

Liveness probe. Returns status and a timestamp.