Meta and Google Ads

How to Build a Looker Studio Report for Google Ads and Meta Ads

By Sauravjit Singh · Updated 2026-11-15 · 7 min read

Short answer: To build a Looker Studio Google Ads report, connect Google Ads and GA4 with Looker Studio's free native connectors, bring Meta Ads data in through a Google Sheet, then build one page showing spend, leads or sales, cost per result, return and change versus last period. Share view-only access with the client.

Most Looker Studio templates you'll find are built by paid connector companies. They're fine, but you don't need a subscription to give a small business owner or your manager a clear monthly report.

This build-along uses only free tools. It also covers the harder part: deciding what to leave out.

What should a client ad report actually show?

Five numbers, compared with last period. A business owner should understand the page in two minutes without asking you what anything means.

  • Spend: total across Google and Meta, and per platform.
  • Results: leads or purchases, using the conversion that matters, not every tracked event.
  • Cost per result: CPL or CPA.
  • Return: revenue and ROAS for e-commerce, or qualified leads for lead-gen.
  • Change: each number against the previous period, shown as a percentage.

Impressions, CTR, CPM and frequency belong on a second page for whoever manages the account. If you're unsure how to calculate the return numbers, our guide to ROAS, CPL and CPA has the formulas.

What you need before you start

  • A Google account with access to the Google Ads account (read access is enough) and the GA4 property.
  • Admin or analyst access to the Meta ad account, to export data.
  • Conversion tracking that already works. A report built on broken tracking just presents wrong numbers neatly.
  • Key events configured in GA4; see GA4 key events with Google Tag Manager if not.

Agree the definition of a 'result' with the client before building anything. For a coaching centre it might be a demo-class booking, not a form fill; for an online store, a paid order net of cancellations. Writing that definition on the report page itself prevents most arguments later.

Step 1: connect Google Ads and GA4 with free connectors

  1. Go to lookerstudio.google.com and create a blank report.
  2. In 'Add data to report', choose the Google Ads connector, select the account and click Add.
  3. Click Add data again, choose Google Analytics, and select your GA4 property.
  4. Add a date range control at the top of the page and set the default to 'Last month' with comparison to the previous period.
  5. Add scorecards from the Google Ads source: Cost, Conversions, Cost / conv. Turn on comparison in the style panel to show the change.

As of November 2026, the Google Ads and GA4 connectors are free and built in. Connector names and fields occasionally change; check the field list if a metric looks missing.

From GA4, the most useful single chart for an ads report is a table with Session source / medium as the dimension and Sessions, Key events and Engagement rate as metrics. It shows how paid traffic behaves on the site compared with organic and direct, and it catches UTM problems: if you see 'facebook / referral' next to 'meta / paid', the tagging needs fixing.

Rename fields in the chart settings to plain words. 'Cost / conv.' means nothing to a shop owner; 'Cost per lead' does.

Step 2: bring Meta Ads data in through Google Sheets, at no cost

Looker Studio has no native Meta Ads connector; the options are a paid third-party connector or a Google Sheet as a free bridge. This build uses the Sheet. It takes about ten minutes a week, or less if you schedule exports.

  1. In Meta Ads Manager, open Reports, create a report broken down by day with the columns below, and export it as CSV. Many accounts can schedule the report to arrive by email.
  2. Create a Google Sheet named 'Meta Ads data' with fixed column headers, and paste each export underneath, never changing the headers.
  3. In Looker Studio, Add data, choose Google Sheets, select the sheet and tick 'Use first row as headers'.
  4. Check that Date is set to the Date type and that Spend is a currency field in INR.
DateCampaignSpend (₹)ImpressionsClicksLeadsPurchasesPurchase value (₹)
2026-11-01Prospecting – Reels1,4509,800112600
2026-11-01Retargeting – Site visitors6203,10058400
2026-11-02Prospecting – Reels1,48010,200121700

The rows above are a filled example for an illustrative lead-gen account, to show the format. Keep one row per campaign per day; Looker Studio sums them for you.

Step 3: build the one-page layout

  1. Top row: five scorecards for total spend, total results, cost per result, return and the period comparison.
  2. To combine platforms, use Blend data: join the Google Ads and Meta sheet sources on Date, then create calculated fields such as Total spend = Cost + Spend (₹) and Total leads = Conversions + Leads.
  3. Create a calculated CPL with the formula SUM(Total spend) / SUM(Total leads). Calculate ratios from sums like this; averaging daily CPLs gives the wrong answer.
  4. Middle: a time series chart of spend and results by week.
  5. Bottom: a table by campaign with spend, results and cost per result, sorted by spend.
  6. Add a text box with three lines of your own commentary: what happened, why, and what you'll change next month.

That commentary box is the part clients read most. Numbers without an explanation invite worried phone calls.

Keep the page to a fixed size, roughly the height of one laptop screen, and use your client's brand colour sparingly for the scorecards only. On cost scorecards, use the style option that reverses the positive and negative colours, so a rising cost per lead shows red. By default an increase shows as good, which confuses people.

Step 4: share it without breaking it

  • Share with 'Can view' access, not edit.
  • In each data source, check Data credentials. Owner's credentials let viewers see the data without their own Google Ads or GA4 access; make sure that's what you intend.
  • Use Schedule email delivery to send the report as a PDF on the first working day of each month.
  • Make a copy for each client rather than one report with a client filter, so nobody sees another client's data by mistake.

What should the commentary say? A filled example

Say you're reporting for an illustrative physiotherapy clinic in Punjabi Bagh. The scorecards show spend up 8%, leads up 15% and cost per lead down 6% versus last month. The commentary box might read:

What happened: leads rose to 46 from 40 on a budget 8% higher, mainly from the new Google Search ad group for back pain. Meta leads were flat.

Why: the back pain landing page added a clear price for the first session and a WhatsApp button, and Meta creative is now six weeks old and showing fatigue.

Next month: move about ₹4,000 from Meta prospecting to the back pain Search ad group, launch three new Meta Reels, and start marking which leads booked a session so we can report cost per patient, not just cost per lead.

That's about 100 words, every claim ties to a number on the page, and the client knows what you'll do next. Write it before sending the report, not after the client calls.

Mistakes that make ad reports misleading

  • Adding Google and Meta conversions and calling it total leads. Both platforms can claim the same person; where you can, report leads from your own CRM or lead sheet too.
  • Mixing conversion types, such as counting WhatsApp clicks as leads in one month and not the next.
  • Showing 30 charts. If a number doesn't change a decision, move it off the main page.
  • Forgetting the date range comparison, which leaves clients unable to tell good from bad.

Looker Studio is one piece of a wider toolkit; our list of tools a performance marketer uses covers the rest, and what performance marketing involves explains how reporting closes the loop.

Building a combined Google and Meta report from scratch is one of the projects in the Advanced Digital Marketing & Performance Ads course at Spettro School.

Frequently asked questions

Is Looker Studio free?

Yes, the standard version of Looker Studio is free, as are its Google Ads, GA4 and Google Sheets connectors as of November 2026. Third-party connectors for platforms like Meta usually charge a subscription.

How do I add Meta Ads data to Looker Studio for free?

Export a daily report from Meta Ads Manager, paste it into a Google Sheet with fixed headers, and connect that sheet to Looker Studio. Scheduled email exports reduce the manual work.

Is Looker Studio the same as Google Data Studio?

Yes. Google renamed Data Studio to Looker Studio in 2022. Older tutorials that say Data Studio still mostly apply, though menus have moved.

What should a monthly ad report include?

Spend, results, cost per result, return (ROAS or qualified leads) and the change versus the previous month, plus a short written explanation of what happened and what's next.

Can clients see my Looker Studio report without Google Ads access?

Yes, if the data sources use owner's credentials and you share the report with view access. Check this setting deliberately, since it controls who can see the underlying data.

Want to learn this with a trainer?

Leave your details and our counsellor will call you within one working day with batch dates, fees and the right course for you.

  • Free counselling call, no obligation to join
  • Weekday and weekend batches, online or offline
  • Small batches of 15 to 20 students

Or chat on WhatsApp

Enter a 10-digit mobile number.

We use your details only to contact you about Spettro School courses.

Chat on WhatsApp