Changelog

Demo Settings is read-only

• Demo Settings no longer shows Edit / BigQuery save forms that fail with 403 — partner and BigQuery config are clearly locked with a banner.

Home activity follows Range

• Homepage installs, listing→install, and conversion use the toolbar Range (same window as MRR deltas).
• Cache rebuild precomputes activity for 7 / 30 / 90 / 365; churn rate and LTV stay last complete month.
• Subtitle matches the Range label; delta chips no longer show “vs previous …”.
• Rebuild note: home-metrics scans ~2 years of events (was 14 days) so longer Ranges work after the next cache rebuild.

Home Range matches toolbar

• Homepage Gross MRR, subscriptions, and ARPU deltas follow the toolbar Range (not a fixed 7-day window).
• Installs, listing→install, and conversion stay on 7 days; churn rate and LTV stay previous month.
• Default Range is Last 7 days; cards show their own vs-period so mixed windows are clear.
• Churn page: trend chart sits above source and uninstall-reason breakdowns.

Sync timestamps show timezone

• Synced / updated times include a short timezone label (e.g. WEST, GMT+1) across dashboard headers, Traffic, and customer detail.

Faster per-app filter on large accounts

• Large accounts serve per-app headlines from the all-apps D1 cache instead of a live Timescale scan (no rebuild cost).
• Shows the existing soft notice that per-app history isn’t precomputed; small accounts still live-compute full charts.

Quieter sync UX and churn delta colors

• Home churn rate deltas treat an increase as bad (red) and a decrease as good (green).
• Large accounts keep serving the last D1 cache during sync/rebuild with no blocking banner.
• Sync timestamp shows a muted “Updating…” while caches catch up after import.

Uninstall reasons on Churn

• Churn page shows Partner uninstall reason mix for the last complete month (primary survey reason per event).
• Reason breakdown is cached with analytics rebuild and available in demo mode.

Faster sync:refresh

• Timescale stream scans keep one DB connection per pass (no reconnect every 5k rows).
• Cache rebuild skips duplicate MRR/revenue history scans already covered by chart rebuild.
• `sync:refresh` runs import + rebuild in one process; skips rebuild when nothing was imported (`--force` to rebuild anyway).
• Partner page saves overlap the existing 500ms request gap; sync metadata queries run in parallel.

Churn currency and API cleanup

• Churn page formats MRR amounts in the partner currency (no longer hardcodes USD).
• Removed unused `/api/mrr` and `/api/installs` JSON endpoints.
• Descoped Customers churn-risk badge and CSV export from the product plan.

Customers hardening, Home deltas, and demo polish

• Customers list search matches prefix suggestions; shop detail keeps multi-app totals with safer partner/currency handling.
• Home Gross MRR and LTV show previous-period deltas again (including older caches that still stored Net MRR).
• Demo uses fake apps (Northwind / BrightCart); Revenue page renders; comparison % values are rounded.
• Toolbar no longer overwrites lookback when Range is hidden; sidebar nav preserves app/partner/days.