Back to all posts
Ad Tracking Published July 14, 2026Updated September 30, 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 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.

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 is a prelaunch pixel-configuration app, not a ROAS calculator or attribution dashboard. Use store records and ad spend to do that calculation separately. Its launch tracking coverage and server delivery are not confirmed.