If you're running paid campaigns on both Google Ads and Meta, you already know the pain: two platforms, two dashboards, two different ways of labeling the same thing. Pulling it all into one Google Sheet so you can see total spend, total revenue, and ROAS across both channels sounds simple. It's not, but it's very doable.
This guide shows you how to build a consolidated ad spend tracker in Google Sheets that gives you a clean cross-channel view without paying for a reporting tool.
The Data Structure That Makes This Work
The key is getting both platforms' data into the same format before you do anything else. Export from Google Ads and Meta separately, then paste both into one sheet with identical column headers: Date, Platform, Campaign, Ad Set, Impressions, Clicks, Spend, Conversions, Revenue.
The Platform column is what lets you filter and compare later. Every Google Ads row gets "Google" in that column, every Meta row gets "Meta." Keep this sheet as your raw data — don't touch it after you paste.
Calculating ROAS
Add a ROAS column to your raw data sheet:
=IF(H2=0, 0, I2/H2)
Where H2 is Spend and I2 is Revenue. ROAS is simply revenue divided by spend. A ROAS of 3 means you made $3 for every $1 spent.
Format this column as a number with 2 decimal places. You don't want percentages here — ROAS is a ratio, not a rate.
Building the Summary by Platform
Insert a pivot table from your raw data. Add Platform to Rows, then add Spend, Revenue, Clicks, and Conversions to Values (all set to SUM). This gives you a one-line comparison of Google vs. Meta: total spend, total revenue, total clicks.
ROAS won't calculate correctly as a pivot value (you can't divide two summed fields directly), so add it as a formula next to the pivot table:
=C4/B4
Where C4 is the Revenue total and B4 is the Spend total for that platform row.
Summarizing by Campaign
Add a second pivot table with Campaign in Rows, Platform in Columns, and Spend in Values. This shows you exactly how much you've spent on each campaign across both platforms, side by side. Sort by total spend descending to see where your budget is going.
Tracking Performance Over Time
Add Date to Rows and set the grouping to Week or Month. Now you have a time-series view of spend and revenue by platform. Add a line chart on top of this pivot to visualize trends — useful for spotting if one platform started underperforming after a creative refresh or a budget change.
The Easy Way: Using SheetXAI in Google Sheets
The manual version of this workflow involves exporting from two platforms, cleaning the data, aligning columns, and rebuilding the pivot tables every week. SheetXAI handles all of that inside Google Sheets.
Example 1: You already have the exports pasted into the sheet.
"I have Google Ads and Meta Ads data combined on Sheet 1 with columns for date, platform, campaign, spend, and revenue. Build a summary showing total spend, revenue, and ROAS by platform, and a campaign breakdown sorted by spend."
SheetXAI reads the data, calculates ROAS, builds both pivot summaries, and formats the report.
Example 2: You want to pull live data from both platforms.
"Connect to Google Ads and Meta Ads and pull last month's campaign performance. Build a consolidated report showing spend, revenue, and ROAS by platform and campaign."
SheetXAI pulls from both sources, aligns the data into one table, and builds the cross-channel report automatically.
Try SheetXAI free and see what it builds for you.
Published May 2026. See also: How to Build a Sales Pipeline Tracker in Google Sheets, SUMIFS in Google Sheets, and Google Sheets AI Guide.
