Ecommerce reportingShopifyGA4Attribution
Ecommerce reporting: connecting Shopify, GA4, and ads into one view
By The MB Data Automation team··6 min read
TL;DR
- →Shopify, GA4, and ad platforms count revenue and conversions differently - so they will never match exactly.
- →Pick a source of truth per metric and document why.
- →Reconcile with consistent definitions and windows, not by forcing the numbers to be identical.
Every ecommerce team hits the same wall: Shopify, GA4, and the ad platforms each report different revenue and conversion numbers. The goal is not to make them identical - it is to understand why they differ and present one trustworthy view.
Why the numbers disagree
| Source | Tends to be the source of truth for |
|---|---|
| Shopify | Actual orders and revenue (the books) |
| GA4 | On-site behavior and channel attribution |
| Ad platforms | Platform-attributed conversions (often over-counted) |
How to reconcile
- Choose a source of truth per metric (Shopify for revenue, GA4 for channel mix).
- Use the same attribution window everywhere you compare.
- Document the differences so clients understand why platform numbers run high.
- Report platform metrics as directional, and the books as actuals.
Make it repeatable
Once you have agreed which source owns which metric, put it in your KPI dictionary and dashboard blueprint so every ecommerce client report reconciles the same way - instead of re-litigating it each month.
The Agency Reporting Automation Kit is built for GA4, Shopify, and ad data - with the KPI definitions and dashboard structure to present one reconciled view.