Back to all posts
Ad Tracking July 14, 2026 6 min read

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.

ad trackingblended CACmulti-channel marketingShopify adspixel tracking

Frequently Asked Questions

What is blended CAC and why does it matter more than a single platform's reported ROAS?
Blended CAC is total ad spend across every platform for a period, divided by total new customers acquired store-wide in that same period, using your store's own first-time-customer count rather than any platform's attribution claim. It matters more than a single platform's ROAS because platforms attribute conversions using overlapping windows and each has an incentive to claim credit, so summing their individual numbers overcounts. Blended CAC is anchored to something that actually happened in your Shopify admin, not to a conversion event three platforms might each be claiming at once.
How often should I update my ad spend tracking spreadsheet?
Weekly works well for most solo and small-team merchants. Daily is usually 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 going sideways before it burns through real budget.
Why do Facebook, Google, and TikTok report different conversion numbers for the same period?
Each platform uses its own attribution window and logic, and each has an incentive to claim credit for a sale. A customer who saw ads on all three before buying can be counted as a conversion by all three at once, so adding up each platform's own reported number overcounts your actual customer base.
Do I need every platform's pixel connected even if I'm only actively running paid ads on two of them right now?
You only need pixels firing for platforms where you're actually spending money, but the moment you add a new ad platform to the mix, connect its pixel before or alongside launching the campaign. The common failure is adding TikTok or Pinterest spend months after initial setup and forgetting to connect that platform's pixel, which leaves that channel's numbers unreliable in your tracker.
Does Pixel Tracker calculate blended CAC or ROAS for me?
No. Pixel Tracker connects tracking pixels for Meta, Google Ads, TikTok, Snapchat, Pinterest, X, and LinkedIn from one Shopify dashboard, and adds server-side tracking for Facebook and TikTok through Conversions API and Events API. It doesn't calculate a blended CAC or ROAS figure or provide a cross-platform dashboard, so you still build the weekly spreadsheet yourself using the numbers each connected platform reports.