EU premium fashion brand, multi-currency
37/37
37 of 37 orders delivered to Meta once, matching amount and currency across 9 presentment currencies; Purchase EMQ 7.7 → 8.1.
Data, reconciliation & reportingClient work
Shopify, Meta, Google and Pinterest Disagree: Order-by-Order Reconciliation
Order-by-order reconciliation that separates lost tracking from attribution modelling — Shopify against Meta, Google Ads and Pinterest.
- For
- Owners and finance leads who need one number
- Checked
Sounds familiar?
Tick what applies to you
How I solve it
What I build
I build an order-by-order reconciliation: every real order against what each platform claims, using the click signal stored on the order itself rather than a dashboard’s summary. Then I separate the two things that get mixed together: orders where the signal never arrived (a tracking loss, fixable) and orders where the platforms simply disagree about credit (attribution modelling, not a bug). Each gap is explained in writing, order by order, so the reconciliation can be checked instead of believed.
The process
How it works
6 steps. Scope and a fixed price are agreed before the first one.
-
Pull every order and its stored signal
From Shopify, including the click id and browser id written onto the order.
-
Pull each platform's claim
Meta, Google Ads and Pinterest through their APIs, not screenshots.
-
Join order by order
Match on the identifiers and the value, and mark the ones that do not join.
-
Split the gap
Separate tracking loss from attribution modelling — window length, view-through and credit rules.
-
Explain it in writing
Each gap gets a plain-language reason your finance lead can follow.
-
Optionally, keep it running
Daily reconciliation, upload alerts and a live read, so a drift is caught the same week it starts.
Handover
What you get
- An order-level reconciliation across the platforms you actually run.
- A written explanation per gap: tracking loss or modelling, with the evidence.
- A decision-ready view — one number, defended, not four numbers argued about.
- An optional daily watch: reconciliation, upload alerts and a live report on a Technical Partnership.
Built with
- Shopify Admin API
- Meta Marketing API
- Google Ads API
- Pinterest API
- GA4
- PostgreSQL or SQLite
- Python reconciliation tooling
Proof
Done before, with dates and numbers
Client work Done for real clients. Client details are anonymised.
Before → after
Pinterest reported 289 conversions at its 7/1 window and 959 at 30/30 for the identical period and the identical events — the tracking never changed; the window did. Of the 289, 27 were verified Pinterest clicks and 262 were view-through. Read 2026-07-03.
-
-
EU multi-store group, 9 stores
Pinterest's own number tripled with the attribution window while the events sent were identical.
-
UK online marketplace
120/120
Google Ads counted about 2.9 conversions for every real submission; 120 of 120 transaction ids matched after the event contract; server sign-up session attach 48–58% → 85%.
I was previously paying $70 per month for a reporting tool... This means in just 2 hrs work, [he] has saved me in excess of $800 per year.
What you can look at
A redrawn waterfall that takes one period’s Shopify orders and shows how each platform’s total is built, plus a redacted order-join table on synthetic data. Both are rebuilt for this page; the figures below are live reads.
Client details anonymised. Figures read from live platform APIs in June–September 2026.
Price and timeline
What it costs and how it runs
A one-store reconciliation is a Tracking Health Check: USD 395, read-only, with a written verdict two working days after the kickoff and confirmed access. Continuous daily reconciliation is Tracking Watch on a Technical Partnership at USD 1,000 per month, which includes the alerts and the live read.
QuoteFixed before work starts
- Price
- Tracking Health Check USD 395 for a one-store reconciliation. Continuous daily reconciliation is Tracking Watch on a Technical Partnership, USD 1,000 per month.
- Timeline
- Health Check verdict two working days after kickoff and confirmed access; daily reconciliation runs once it is set up.
- First step
- Describe the task. I reply within one working day, free, and tell you which option fits — or that you can fix it yourself.
A note from Daniilbefore you decide
When you don’t need this
If one platform is your single source of truth and it agrees with Shopify within the tolerance your finance lead accepts, a reconciliation adds little. And if the entire gap turns out to be attribution windows and view-through, I will tell you that plainly — that is modelling, not lost tracking, and no capture fix will move it.
— Daniil
Questions
What people ask about this
Which number is "right"?
Shopify's orders are the ground truth for what happened. The platforms are right about credit, within their own rules. The reconciliation shows both without pretending they are the same question.
Why does Pinterest or Meta over-report?
Usually the attribution window and view-through, applied to the same events you sent once. Widening the window inflates the count without any change in tracking.
Do you need access to my ad accounts?
Read access to the platforms you want reconciled, plus Shopify. Read-only is enough for the audit.
How fast is the verdict?
Two working days after the kickoff and confirmed access for a Health Check; the daily watch starts once it is set up.
Can it run automatically?
Yes. Daily reconciliation, upload alerts and a live report are the Tracking Watch part, on a monthly Technical Partnership.
More like this
All situations
Have a task like this?
Describe your taskThe first answer is free, within one working day. Or write directly: next@taskfordaniel.com