TrueROAS

How do I reconcile GA4, Meta and Shopify numbers each month?

What does a monthly reconcile look like?

One table, filled in on the same day each month, with the same definitions every time. The point is not to find the "right" number. It is to know how far each tool usually is from your orders, so you notice the month it drifts.

The 7 steps

  1. Fix the period, time zone and revenue definition. Use the calendar month in your store's time zone. Pick net sales or total sales and never switch.
  2. Pull Shopify. Orders and net sales from the sales report. Shopify counts a refund as a negative amount on the day it is processed (Shopify Help Center), so a big return early in the month lowers that month, not the month of the order.
  3. Pull GA4. Purchases and purchase revenue for the same dates. If GA4 shows more purchases than you have orders, check transaction IDs: GA4 deduplicates purchases that share one, and it needs a unique ID per order to do so (Google Analytics Help).
  4. Pull Meta. Purchases and purchase value, and write down the attribution setting you used. Meta can date a sale on the day of the ad impression or of the purchase (Meta Marketing API), so use the same choice every month.
  5. Pull Google Ads. Add the "Conversions (by conv. time)" and "Conv. value (by conv. time)" columns. The standard columns count a sale on the click date (Google Ads Help), so late sales would otherwise land in the previous month.
  6. Pull your order-level view. Sales matched to real orders per channel from an attribution tool, or as a free stand-in, Shopify's "Sales attributed to marketing" report grouped by UTM campaign (Shopify Help Center).
  7. Compute the ratios and compare with last month. Write one line for every ratio that moved, with the cause you found and what you changed.

A worked example

A made-up example. A store has 1,000 orders and $80,000 of net sales in October. The order-level view credits $32,800 of those sales to Meta ads and $18,400 to Google Ads.

Made-up store, October: each source against the store's orders
SourceOctoberCompared withRatio
Shopify1,000 orders, $80,000Itself1.00
GA4780 purchases1,000 orders0.78
Meta Ads Manager$37,700 purchase value$32,800 matched to Meta1.15
Google Ads (by conv. time)$15,300 conv. value$18,400 matched to Google0.83
Meta plus Google$53,000 claimed$80,000 net sales0.66

Nothing here needs action. GA4 sees about three in four orders, Meta claims a bit more than its matched sales and Google a bit less. That is close to what we see across stores: a median 76% for GA4, 1.12x for Meta and 0.81x for Google Ads.

Now say November shows Meta at $74,000 against $33,000 of matched sales, a ratio of 2.24. That is not a better month for Meta. In my experience a jump like that means something changed in tracking: a second app sending purchases, old pixel code back in the theme, or a new checkout setup. Start with why Shopify sends duplicate purchases to Meta.

Which gaps are normal, and which are not?

Reading the ratios (reference points from stores using TrueROAS, 5 Oct to 1 Nov 2026)
RatioMedian in our dataCheck tracking when
GA4 purchases / orders0.76 (16 stores)It drops sharply, or goes above 1
Meta's reported sales / matched sales1.12 (91 stores)It goes above 2 or under 0.5
Google's reported sales / matched sales0.81 (65 stores)It goes above 2 or under 0.5

Meta and Google figures: stores with at least about $1,000 of spend on the channel in the 4 weeks; stores where one side saw under half of the other are left out as broken tracking. GA4: stores with at least 20 orders in the period. No store is named.

The 2x and 0.5x lines are the ones we use to flag broken tracking. Inside them, what matters is change: a Meta ratio that sat at 1.1 for six months and is now 1.5 tells you more than any single month.

What should go in the report?

Three lines are enough for a founder or a client: total sales from Shopify, total ad spend and the ratio between them, and sales per channel from the order-level view with the platform's own number beside it. For why each source belongs where it does, see which numbers to trust. Agencies sending this to clients will find a report layout in agency reporting clients trust.

Usually $300/hour • Free for a limited time

Find Out What's Holding Your Ads Back

30 minutes, 1-on-1 with the founder of TrueROAS.

✓Live review of your Meta & Google ad performance

✓Find the tracking gaps eating your profit

✓Leave with a clear plan to scale


Marius T.
"TrueROAS finally showed me the conversions Meta was missing. We scaled spend 2.3x in 30 days without guessing."

Marius T. • Senior Media Buyer