Attribution & Tracking
Platform Reporting Reconciliation Tool
The Platform Reporting Reconciliation Calculator measures the revenue gap between what a single ad platform reports and what Shopify actually recorded, then diagnoses why. It returns the absolute discrepancy, the discrepancy as a percentage of real revenue, platform versus actual ROAS, whether the gap is within an acceptable range, a likely root cause, and a step-by-step reconciliation checklist. This is built for producing numbers a CFO can trust.
Who it's for: Finance and marketing teams at DTC brands who need defensible, reconciled revenue numbers for board and CFO reporting rather than raw platform figures.
How the Platform Reporting Reconciliation works
You enter the revenue one platform claims (Meta, Google, or TikTok), your actual Shopify revenue, your ad spend, and which platform you are reconciling. The tool calculates the absolute discrepancy and its percentage relative to Shopify revenue, plus platform ROAS and actual ROAS so you can see how the gap distorts your return numbers.
It compares your discrepancy against a platform-specific benchmark (Meta typically over-reports 20 to 30 percent, Google 15 to 25 percent, TikTok 15 to 20 percent) and assigns an acceptable-range label: under 10 percent is excellent, 10 to 20 percent is normal, 20 to 30 percent is a warning, and over 30 percent signals serious tracking problems.
Based on how far the gap exceeds the platform benchmark, the tool diagnoses a likely root cause (deduplication issues, attribution-window mismatch, broken tracking, or just normal model variance) and outputs a reconciliation checklist plus a trust hierarchy that ranks Shopify above GA4 above client-side ad platforms.
The formula
Discrepancy = absolute value of (platform revenue - Shopify revenue). Discrepancy % = (discrepancy / Shopify revenue) x 100. Platform ROAS = platform revenue / ad spend. Actual ROAS = Shopify revenue / ad spend.
Frequently asked questions
What discrepancy percentage is considered acceptable?+
Under 10 percent is excellent alignment, and 10 to 20 percent is normal because attribution models legitimately differ across systems. Once you cross 20 percent you are in warning territory, and above 30 percent usually points to deduplication failures or broken tracking rather than expected variance. The acceptable threshold also depends on the platform benchmark shown in the tool.
Why should Shopify be the source of truth over GA4 or the ad platform?+
Shopify records the actual transaction at checkout, so it reflects money that genuinely hit your account. GA4 is generally more reliable than ad platforms because it can use server-side data, while ad platforms report client-side and tend to inflate via attribution overlap and view-through. That ordering is the trust hierarchy the calculator recommends for reporting.
My gap is well above the platform benchmark. What are the most likely causes?+
When the discrepancy exceeds the benchmark by a wide margin, the usual culprits are double-firing tags (both GA4 and the Ads pixel counting the same event), mismatched attribution windows between platforms, or a broken tracking implementation. The reconciliation checklist in the tool walks through checking deduplication rules, aligning windows, and testing tags with Tag Assistant.
Does reconciling mean I should stop using platform data entirely?+
No. Platform data is still essential for in-platform optimization and creative decisions, but it should not be the single source for board-level revenue. The goal of reconciliation is to know the consistent gap so you can report Shopify-based actuals while still using platform signals to manage campaigns day to day.