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. Volumes are rounded and change as data lands.
| Domain | Data | Scale |
|---|---|---|
| Reputation (Reviews) | Public reviews and historical edits | Millions of reviews |
| Employee Recognition | Employee mentions in reviews and manual review status | Millions of mentions |
| Messaging & Engagement | Guest-business interactions and messages | Hundreds of millions of rows |
| Customer Retention | Saved revenue and visits from outreach | Hundreds of thousands of rows |
| Transactions | Point-of-sale transactions and line items | Hundreds of millions of rows |
| Location Performance | Pre-aggregated daily metrics | Millions of location days |
| Customer Exports | Daily file drops for configured customer data products | Customer-specific |
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 upstream but not exposed in ANALYTICS. | Requires access review |
| Review sentiment analysis | Review text exists upstream, but there is no NLP pipeline in BI. | Moderate |
| SMS Logs | Collection exists, but is not exposed in the ANALYTICS model. | Straightforward |
| Soft delete tracking | No distinction between archived and deleted records. | Moderate |
| Real-time data (< 1 hour) | Real-time streaming is not supported by the current architecture. | Significant |
| Real-time customer exports | Customer exports are daily file drops, not streaming feeds. | Significant |