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 whether the whole system is working, not whether one dashboard's math looks good on its own. The overlap is the point: one customer can be claimed by every platform that touched the click path.
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.
Pixel Tracker is in development and not available to install. A saved G- measurement ID can send a GA4 purchase on paid orders. Other platform coverage and server delivery are still being verified. If you need tracking today, choose an available integration and verify its events. Join the waitlist for launch updates.
Choose an app whose confirmed plan limits cover every ad platform you need. Pixel Tracker's launch prices and plan limits are not confirmed. Check its Shopify listing when available; billing will be through Shopify.
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.
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.