Before changing the tracking stack again, I’d separate two different questions:
- How many Shopify orders were actually eligible to be attributed to Google Ads?
- Of the orders/conversions that should exist in the measurement layer, are any missing, duplicated, or carrying the wrong value?
Those are different problems. 80 Shopify orders vs 16 Google Ads conversions does not by itself prove that 64 conversions were lost, because not every order necessarily came from an eligible Google Ads click.
I’m building an open-source tool called ConversionGuard specifically to reconcile authoritative ecommerce orders against measured purchase records by transaction ID, value and currency.
It can flag:
- missing purchase records
- duplicate transaction IDs
- value/currency mismatches
- measured conversions with no corresponding order
For the first 3 Shopify stores I’m doing the audit free to validate it on real data. No production credentials are required for the first pass — sanitized CSV exports are enough.
Project:
https://github.com/othy19904-eng/conversionguard
Pilot:
https://github.com/othy19904-eng/conversionguard/issues/1
Top comments (0)