If you run campaigns on both Google Ads and Meta, you know the Monday morning ritual. Log into Google Ads, export. Log into Meta Business Manager, export. Paste it all into a spreadsheet and hope the columns line up. By the time the numbers make sense, it is Tuesday.

This is not just tedious. It is expensive. Marketers spend more than six hours a week compiling reports by hand, and automating that reporting can cut the time by up to 80%, turning ten hours a week into two. The reason is simple: when your numbers live in separate dashboards, you make decisions on fragments instead of facts.

In this walkthrough, we will connect both platforms to a single dashboard using Make (formerly Integromat). You will pull campaign data from both APIs every night, normalise it, and feed it into Looker Studio for a dashboard that refreshes on its own. A free Make account and a couple of hours are all you need.

What you need before starting

Step 1

Connect Google Ads to Make

In your Make dashboard, add a new scenario. Search for the Google Ads Reports app and select the Run a Campaign Report module. Authenticate with your Google Ads account and select the campaign fields you want to track: campaign name, impressions, clicks, cost, conversions, conversion value, and date.

Make's Google Ads Reports integration supports campaign, custom, and account-level reports. For a daily dashboard, set the date range to yesterday and schedule the scenario to run each morning.

Step 2

Connect Meta Ads to Make

Add a second module to the same scenario using the Facebook Ads Campaign Management app. Select the Get Campaign Insights action and authenticate your Meta Business Manager. Choose the fields that match what you pulled from Google: campaign name, impressions, clicks, spend, conversions.

Make has a pre-built template for syncing Facebook Ads data to Google Sheets daily if you prefer to start from a template rather than build from scratch.

Step 3

Normalise the data in Make

Here is where the magic happens. Google Ads calls it "cost" and Meta calls it "spend." Google counts conversions in one window, Meta in another. Use Make's Set Variable module to rename fields into a common schema:

Platform: "Google Ads" or "Meta Ads"
Date: same format (YYYY-MM-DD)
Campaign: campaign name from source
Spend: cost (Google) or spend (Meta)
Impressions: from source
Clicks: from source
Conversions: from source
Cost per conversion: calculated field

This normalisation step is what makes the dashboard useful. Without it, you are comparing apples to slightly different-shaped apples.

Step 4

Write to Google Sheets

Add a Google Sheets module set to Add a Row. Create a sheet with columns that match your normalised schema. Each time the scenario runs, Make appends one row per campaign from both platforms.

Use a separate sheet as a raw data store and another sheet with SUMIF formulas for your weekly and monthly aggregates. This keeps your dashboard fast even as data grows.

Step 5

Connect to Looker Studio

Open Looker Studio and create a new report. Add your Google Sheet as a data source. Build a dashboard with:

  • Total spend across both platforms (single number card)
  • Spend by platform (bar chart)
  • Cost per conversion by platform (comparison chart)
  • Week-over-week trend (line chart)
  • Campaign-level performance table

Looker Studio is free and refreshes automatically from the sheet. Your Make scenario runs every morning, updates the sheet, and the dashboard reflects the latest numbers by the time you open it.

Step 6

Add alerts and optional extras

Once the base dashboard is running, you can extend it with Make's scheduling and notification modules. Set up a Slack message when spend exceeds a threshold, or a weekly email summary to stakeholders. The data is already flowing -- adding outputs is just dragging a new module. For a deeper look at how attribution changes when you connect those dots, read our guide to unified ad attribution across Meta, LinkedIn and Google Ads.

What changes when it is automated

Before automation, your Monday morning was spent exporting, reconciling, and hoping nothing got misfiled. After, it looks like this:

As the Cometly guide to unified marketing analytics puts it, the real cost of fragmented data is not just the wasted hours. It is the revenue you never capture because you are too slow to identify what is working and scale it.

How much does this cost?

Make's pricing starts free for 1,000 operations per month, which handles daily reporting for a single ad account. The Core plan at $10.59 per month covers 10,000 operations for multiple accounts. Looker Studio is free. Total cost for a functional multi-platform dashboard: roughly $10 per month and an afternoon of setup.

Compared to paid connectors like Supermetrics at $50 to $300 per month, the Make-plus-Sheets approach gives you more control for less. The trade-off is that you configure the normalisation logic yourself, which is what this guide covers.

Frequently asked questions

Can I connect both Google Ads and Meta to one dashboard?

Yes. Both platforms expose APIs that Make connects to natively. A Make scenario pulls data from both Google Ads Reports and Facebook Ads Campaign Management modules, normalises the fields, and writes to a single Google Sheet that feeds a Looker Studio dashboard.

How much does it cost to automate ad reporting?

Make's free plan handles up to 1,000 operations per month, enough for daily reporting on a single account. The Core plan at $10.59 per month covers 10,000 operations, which handles multiple accounts. The only other cost is Looker Studio, which is free.

How many hours does automated reporting save?

Automating report compilation can cut reporting time by up to 80%, turning roughly ten hours a week into two. An agency that built reports for 12 clients went from a full day per week to a dashboard that refreshes itself every Monday.

Is Looker Studio enough or do I need something more powerful?

Looker Studio with native connectors is free and enough if you only need to visualise Google Ads and Meta data. It falls short when you need to cross ad spend with real sales from your CRM or apply custom business rules. That is where a custom build adds value.

Do I need a developer to set this up?

No. The marketing team can set up Make scenarios using the visual drag-drop interface. Make has pre-built templates for syncing Facebook Ads data to Google Sheets. The steps in this guide walk through the entire setup with no coding required.

Unified ad reporting is one of those changes that looks small on paper but changes how your team operates. Instead of spending Monday morning assembling numbers, you start the week with a dashboard that already has everything, and you spend your time deciding what to do about it.

This is something we do at Supernodes. If a unified ad dashboard sounds like something your team could use, speak with us about a two-week pilot. We audit your current setup, connect the platforms, and leave you with a dashboard that refreshes itself.