Free tool
Why don't my numbers match?
Meta says one thing, GA4 says another, and Shopify says a third. Drop in your exports and see exactly where the gap comes from, in words your CFO will accept.
Your files never leave your browser. Customer names, emails and addresses in the Shopify file are never kept or shown.
Drop in Shopify plus at least one more
Shopify orders Required
- In Shopify admin, open Orders and click Export.
- Choose All orders (or Orders by date) and CSV for Excel.
- Shopify emails you a link. Download the CSV and drop it here.
GA4
- In GA4, open Explore and start a Free form exploration.
- Import Date and Session source / medium as rows, and Ecommerce purchases and Purchase revenue as values. Use the same dates as your Shopify export.
- Click the download icon and choose CSV.
Meta Ads Beta
- In Ads Manager, pick your dates and set Breakdown, By time, Day.
- Columns, Customize columns: add Purchases and Purchases conversion value.
- Click Export (the download icon) for a CSV.
Your results
Where the gap comes from
What to check
Paste this into your report
Share your result
How this works
Everything is compared only on the dates all your files share. Shopify's line items are collapsed into orders, and orders from outside your online store (in-person, draft) are set aside, since GA4 and Meta never see them. GA4 and Meta record a purchase at checkout and keep it after a refund or cancellation, so they're compared with every online-store checkout, and refunds are listed separately. Up to 15% of checkouts missing from GA4 is treated as normal tracking loss from consent banners and ad blockers; anything beyond that, or GA4 counting more purchases than you had checkouts, is flagged. Revenue is matched per order, so GA4 missing a few orders doesn't look like a revenue problem. With fewer than 20 orders, we don't guess how much of a gap is normal. Meta's numbers are shown as Meta's own claims: it counts sales after clicks and views, dated to the ad, and other channels count the same sales, so it can take credit for more than 100% without anyone being wrong. The Meta part is in beta: if your file doesn't read correctly, tell me.
Also free: Where'd My ChatGPT Traffic Go? and Why'd My Post Flop? And every Monday, Blameless, my newsletter on marketing data incidents.