Purchase reconciliation
Reconciles analytics purchases with the order or billing system order by order, never total against total. Joins GA4 transaction IDs to orders, classifies every order as matched, missing, duplicate, value mismatch or late, traces each class to its cause (consent, blockers, payment redirects, reloads, legacy checkout scripts, currency, tax and shipping, time zones) and decides between a browser fix and server-confirmed sending. Ships BigQuery and portable SQL, gap thresholds and a report format.
Use when GA4 purchases or revenue do not match Shopify, Stripe, WooCommerce, the order database or billing system, "GA4 purchase discrepancy", "missing transactions", "GA4 conversions lower than orders", "GA4 shows fewer orders", "purchases double counted", "transaction_id does not match", "revenue is off", when checking the GA4 BigQuery export against orders, before moving purchases to server side or Measurement Protocol or a backfill, after a checkout or tag change, or when asked what gap is acceptable.
What the skill covers
- When to use
- Inputs
- Procedure
- 1. Write the comparison contract
- 2. Freeze the period and prove both sides are complete
- 3. Prove the transaction ID format on real orders
- 4. Pull the analytics side
- 5. Pull the order side
- 6. Classify every order
- 7. Find the cause of each class
- 8. Check senders and attribution
- 9. Decide where to fix
- 10. Apply thresholds and report
- 11. Re-run after the fix
- Worked example
- Acceptance checks
- Boundaries
- Live docs
This skill comes with a free account
Sign in with your email to read the full skill. No password: we send you a code. Sign in or create a free account
Book a Free Call
Thirty minutes on your stack and what it needs. Free, and no pitch.
Thirty minutes, and you leave with a plan
We look at what you have, what it is costing you and what to do about it first.
- 30 minutes
- Video call, link on booking
- No obligation
What we'll cover
- Your current stack and where it hurts
- Quick wins we can ship first
- An integration roadmap
- Timeline, scope and next steps
Calendar not loading? Open it in a new tab or email hello@martechdevs.com.