What's in BI (and What's Not)
Quick reference for what data is available in the BI analytics model and what's intentionally excluded.
What's IN the Box
The analytics model covers these business domains:
| Domain | Data | Volume |
|---|---|---|
| Reputation (Reviews) | Public reviews and historical edits | 5.8M reviews |
| Employee Recognition | Employee mentions in reviews and reward status | 2.7M mentions |
| Messaging & Engagement | Guest-business interactions and messages | 199M interactions, 249M messages |
| Customer Retention | Saved revenue and visits from outreach | 279K saved customers |
| Transactions | Point-of-sale transactions and line items | 443M transactions |
| Location Performance | Pre-aggregated daily metrics | 16M location-day records |
For detailed table contracts, see Data Contracts.
What's NOT in BI
| Missing Data | Why | Effort to Add |
|---|---|---|
| Google SEO Rankings | Requires manual search process (not in source systems) | N/A |
| Employee Earnings & Distributions | Out of scope for V1. Financial data with compliance considerations. | Straightforward |
| Scoreboard competition data | Out of scope for V1. | Straightforward |
| Customer profile details | Only customer IDs, not names/emails/demographics. Left off for compliance. | Requires tradeoffs |
| GBP context | Out of scope for V1. | Straightforward |
| Review text | Stored in BRONZE layer but not exposed in ANALYTICS. | Available on request |
| Review sentiment analysis | We store the text but don't analyze it. No NLP pipeline. | Moderate |
| SMS Logs | Collection exists, but ingestion disabled. | Straightforward |
| Soft delete tracking | No distinction between archived and deleted records. | Moderate |
| Real-time data (< 1 hour) | ETL runs every 4 hours. Current architecture doesn't support real-time. | Significant |