How to Track Ad Spend Across Multiple Platforms
When ad spend and conversions live in five different ad dashboards, none of them agree, and that's not an accident. Here's a practical, spreadsheet-based way to build one honest number for what your ads are actually doing.
By The Appnary Team
If you run ads on more than one platform, you already know the feeling: five browser tabs open, five different ways of counting a "conversion," and no single number you actually trust. Facebook Ads Manager says one thing, Google Ads says another, and TikTok's dashboard tells a third story entirely. None of them are lying exactly, they're just each grading their own homework.
Each platform attributes conversions using its own window and its own logic, and each platform has an incentive to claim as much credit as possible for a sale. Meta's reported conversions typically use a 7-day click / 1-day view window by default. Google Ads counts a conversion if it falls within its own lookback period. TikTok has its own rules too. A single customer who saw a TikTok ad, clicked a Google ad two days later, and then clicked a Facebook retargeting ad before buying can show up as a "conversion" on all three platforms at once. Add up what each platform claims, and you've overcounted your own customer base without touching a spreadsheet.
This isn't just a theoretical accuracy problem, it changes what a merchant actually decides to do. Store owners scale up campaigns that look profitable on one platform's dashboard and pause ones that look expensive on another, all while comparing numbers that were never meant to sit side by side in the first place. The fix isn't finding a smarter dashboard. It's building a second, boring, platform-agnostic view that sits above all of them.
That view can be as simple as a spreadsheet, and for most small stores it should be. Once a week, at the same time, pull four numbers from each ad platform you're running spend on: the platform name, total spend for the week, reported conversions for the week, and reported revenue for the week. One row per platform per week. Facebook, Google, TikTok, Snapchat, Pinterest, whatever you're actually running, all logged the same way in the same sheet. It takes maybe fifteen minutes if you do it consistently, and it turns five disconnected dashboards into one table you can actually scroll through.
Weekly is the right cadence for most solo and small-team merchants. Daily is too noisy, since ad platforms revise their own numbers for a day or two after the fact, and monthly is too slow to catch a channel drifting off course. Add a fifth column for total store revenue and total orders for the same week, pulled straight from Shopify, so the sheet has both what each platform claims and what actually happened in the business. That combination is what makes the next step possible.
With that data sitting in one place, you can calculate the number that matters more than anything a single ad platform reports: blended customer acquisition cost. Blended CAC is total ad spend across every platform for the period, divided by total new customers acquired store-wide in that same period, using Shopify's own first-time-customer count rather than any platform's attribution claim. Say you spent $4,000 across Facebook, Google, and TikTok combined last month and picked up 160 new customers store-wide. Your blended CAC would be $25. No attribution model, no click windows, no platform grading its own work.
Blended CAC is a more honest sanity check precisely because it doesn't care which platform gets the credit. It's anchored to something that actually happened, a new customer record in your Shopify admin, rather than to a conversion event that three different platforms might each be independently claiming. A platform-reported return that looks strong in isolation can coexist with a store that's barely breaking even once you account for the overlap between platforms. Blended CAC compared against your average order value and margin tells you, in plain terms, whether the whole system is working, not whether one dashboard's math looks good on its own. For a deeper look at why platform-level attribution disagrees with itself and how different attribution models handle the overlap, the multi-channel attribution guide covers the theory side of this in more detail.
None of this works, though, if half your platforms aren't reporting real numbers in the first place. This is the part that trips up most merchants running ads on more than one or two channels: they set up a Facebook pixel and a Google Ads tag when they first started running ads, and that's where pixel setup stopped. Six months later they're running TikTok and Pinterest campaigns too, spending real money, but nobody went back and connected pixels for those platforms. The result is a weekly tracker with a blank or unreliable reported-conversions column for exactly the channels that are newest and least understood, which is backwards. You end up with your best data on your oldest, most familiar channel and next to nothing on the ones you actually need visibility into.
Getting every pixel connected, not just the first one or two set up back at launch, is a prerequisite for this whole exercise, not an optional nice-to-have. This is the specific problem Pixel Tracker is built around: connecting tracking pixels for Meta (Facebook), Google Ads (the conversion tag, not GA4), TikTok, Snapchat, Pinterest, X, and LinkedIn from one Shopify dashboard, with pixels injected automatically through Shopify ScriptTags so there's no theme code to touch. It's worth being clear about what it does and doesn't do: it connects the pixels, and for Facebook and TikTok it adds server-side tracking through Conversions API and Events API so the numbers those two platforms report are less dented by browser tracking loss. It does not calculate a blended CAC or ROAS for you, and there's no cross-platform dashboard built in. You still need the weekly spreadsheet described above. What it fixes is the step before that: making sure every platform you're spending money on is actually reporting real numbers to log in the first place.
That distinction matters for picking a plan, too. The free tier covers one pixel, which is fine if you're only running Facebook ads and nothing else. The moment you're running ads on three or more platforms, which is exactly the situation this tracking exercise assumes, you're looking at Starter at $7 a month for three pixels, Growth at $15 a month for ten, or Pro at $29 a month for unlimited pixels on a single store. Growth and Pro exist specifically for merchants who've moved past one or two ad channels and need every platform they're actually spending on connected at once, not just the ones they got around to first.
If you're comparing options for pixel management on Shopify, it's worth looking at more than one tool before committing, since setups and pricing structures vary more than you'd expect for what sounds like a simple task. The roundup of Shopify ad tracking tools is a reasonable place to start that comparison.
Pixel Tracker itself is currently pre-launch and taking waitlist signups rather than live installs, so if the pixel-connection side of this is what you're after, that's the way to get notified when it opens up.
None of this requires new software to start, though. The spreadsheet, the weekly fifteen minutes, and the blended CAC formula work today with whatever platforms you're already running, using numbers you can pull by hand. Getting every pixel connected just determines how much you can trust the numbers you're plugging into it.