Tim Lane

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

  1. In Shopify admin, open Orders and click Export.
  2. Choose All orders (or Orders by date) and CSV for Excel.
  3. Shopify emails you a link. Download the CSV and drop it here.

GA4

  1. In GA4, open Explore and start a Free form exploration.
  2. Import Date and Session source / medium as rows, and Ecommerce purchases and Purchase revenue as values. Use the same dates as your Shopify export.
  3. Click the download icon and choose CSV.

Meta Ads Beta

  1. In Ads Manager, pick your dates and set Breakdown, By time, Day.
  2. Columns, Customize columns: add Purchases and Purchases conversion value.
  3. Click Export (the download icon) for a CSV.

Also free: Where'd My ChatGPT Traffic Go? and Why'd My Post Flop? And every Monday, Blameless, my newsletter on marketing data incidents.