Available Dashboards
The main operational and financial command center for Click Storage. Three tabs give each audience exactly what they need: Asset Manager — NOI trend, T12 revenue, ECR, delinquency buckets, and ECRI pipeline for investors and ownership. Property Manager — daily move-ins/outs, occupancy by unit type, vacant units 30+ days, rate increase schedule, and collections by agent. Operations — facility-by-facility stoplight scorecard with revenue MTD vs goal, net leasing, and lead conversion in a single view.
Daily performance tracker for the remote sales team. Tracks CSS quality scores, call answer rate, phone lead conversion, rentals closed, and collections — broken down by agent so managers can coach in real time.
Data Architecture & Documentation
Data Architecture Map
End-to-end pipeline diagram — Cubby PMS, QBO, and BigQuery layers with color-coded data lineage.
BigQuery Table Inventory
Full schema browser across all BQ projects — field names, types, and descriptions for every table.
Data Refresh Schedule
Dashboards refresh automatically every 6 hours (00:00, 06:00, 12:00, 18:00 UTC) via GitHub Actions. Data sourced from BigQuery / Cubby PMS, QuickBooks, and Google Sheets. To force a refresh, use the ↺ button inside each dashboard.