Live Analytics Dashboards
Four production dashboards running on anonymized Shopify data. Executive KPIs, reconciliation, channel performance, and customer analytics — all from Shopify source of truth.
Anonymized dataset · Source: Shopify → BigQuery · Updated daily
See it in 90 seconds
Executive KPIs + Reconciliation layer — running on real anonymized Shopify data
Executive KPIs
Net revenue, margin, MER — from Shopify as source of truth
Phantom Revenue
€21,761 gap between what platforms claim and Shopify reality
Claimed vs True ROAS
Meta 2.91 → 2.36 · Google 3.12 → 2.63
KPI Command Center
Revenue, margin, orders, MER — all reconciled from Shopify source-of-truth data.
Executive Overview
Source of Truth: Shopify · Anonymized Dataset
Revenue vs Profit Trend
Revenue by Channel
| Country | Revenue (€) | Orders |
|---|---|---|
| DE | 3,191 | 25 |
| NL | 1,712 | 15 |
| GB | 1,543 | 18 |
| IE | 1,489 | 13 |
Platform Over-Reporting Exposed
See exactly how much Meta & Google inflate your revenue numbers compared to Shopify truth.
Reconciliation Overview
Source of Truth: Shopify vs Platform Reporting
Revenue gap between platform claims and Shopify reality
Platform Over-Reporting % vs Shopify
Claimed vs True ROAS
Platforms inflate ROAS by including view-throughs and cross-device estimates
| Day | Shopify (€) | Meta Rep (€) |
|---|---|---|
| 1 Feb | 1,557 | 770 |
| 31 Jan | 1,300 | 812 |
| 30 Jan | 2,197 | 1,037 |
| 29 Jan | 1,835 | 714 |
Channel Performance
Reconciliation at platform level — True ROAS, phantom revenue, and over-reporting per channel.
Channel Performance
Reconciliation, not attribution. Platform-level truth from Shopify.
Daily Spend
| Platform | Campaign | Spend | Claimed ROAS |
|---|---|---|---|
| Meta | Prospecting — Broad Interest | €7,288 | 2.97 |
| Meta | Retargeting — Website Visitors | €5,201 | 3.02 |
| Shopping — Feed Standard | €4,900 | 3.25 | |
| Search — Brand Terms | €3,542 | 2.90 |
Customer Analytics
New vs returning segmentation, repeat rate, AOV by segment, and geographic breakdown.
Customer Analytics
New vs returning. Revenue by segment. Unit economics.
Revenue by Segment
New vs Returning Customers
| Country | Customers | Revenue (€) | Repeat % |
|---|---|---|---|
| DE | 290 | 39,022 | 41.7% |
| NL | 169 | 21,839 | 45.0% |
| GB | 146 | 17,414 | 39.7% |
| BE | 132 | 16,214 | 40.9% |
What's inside
Executive Overview
Net Revenue, Margin, AOV, MER — with period-over-period comparison
Reconciliation Layer
Phantom Revenue, Over-reporting %, Claimed vs True ROAS
Channel Performance
Per-platform spend, True ROAS, CTR, CPC — reconciled against Shopify
Customer Analytics
New vs returning, repeat rate, AOV by segment, country breakdown
Want this for your agency?
Get a production-grade analytics pipeline connected to your clients' Shopify stores.