How many orders did our ad platforms actually drive?
Three platforms claimed 8,412 conversions but described 4,318 orders. 2,580 of the claims were the same order counted again.
What went in
- Files
- 4
- Rows
- 15,737
- Period
- Jan 1 – Jun 30
- Verification
- 17 checks passed
Source files
- google_ads_jan_jun.csv4,281 rows
- meta_ads_export.xlsx3,904 rows
- tiktok_ads_export.csv1,622 rows
- orders_h1_2026.csv5,930 rows
What came back
- $92.26
- 1,514
- $60,519
The finished project
Three platforms claim 8,412 conversions. They describe 4,318 orders.
Nobody is lying and the numbers still do not add up: each platform counts a conversion inside its own attribution window, so a customer who saw two ads is claimed by both. 2,580 of the claims are the same order counted again, and a further 1,514 match no order at all. Reconciled, the cheapest channel becomes the most expensive: TikTok reports $39.34 a conversion and costs $128.40 an order. Set against contribution rather than revenue it loses $35,714 over the six months, because a quarter of what it sells comes back.
What each platform claimed, and what it can be traced to
8,412 claimed against 4,318 distinct orders
- 012,580 of the 8,412 claims are the same order counted again.
- 02TikTok is the cheapest channel on its own numbers and the most expensive on yours.
- 03TikTok loses $35,714 once returns and product cost are taken off.
Filed under
Closest to this one
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.