Blog post

Guide to connect your Facebook Ads data to Looker Studio (2025)

Catchr

Facebook Ads

Johan Chemin
March 30, 2023
| Lastest update
July 1, 2025

Quick steps to create a Facebook Ads report with Google Sheets:

You can easiliy create a Facebook Ads report following this step :

  1. Get informations from the data integration from our Facebook Ads connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Facebook Ads data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

Quick steps to create a Facebook Ads report with Looker Studio:

You can easiliy create a Facebook Ads report following this step :

  1. Get informations from the data integration from our Facebook Ads connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Facebook Ads at the end of the page.

Quick steps to create a Facebook Ads report with PowerBI:

You can easiliy create a Facebook Ads report following this step :

  1. Get informations from the data integration from our Facebook Ads connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Facebook Ads at the end of the page.

Looker Studio is a powerful free tool for creating dashboards and analyzing your data. However, it offers limited native connectors. If you’re reading this, chances are you want to connect your Facebook Ads data to Looker Studio. The good news? It’s absolutely possible! — and that's exactly what we'll walk through now.

There are two ways to connect your data: manually, by exporting a CSV file from Facebook Ads, or automatically, by using a connector developed by Catchr. We’ll focus on the second method in this guide.

How to connect your Facebook Ads data to Looker Studio?

Go to the Looker Studio homepage to begin, and then follow these steps.

1. Create a new data source on Looker Studio

Click on “Create” > “Data Source” in the top left corner of the page to start setting up a new data source. In the search bar, type “Facebook Ads” and select the Catchr connector.

Or simply follow this link to access the Facebook Ads connector directly.

Create a data source - Looker Studio
Search Facebook Ads connector - Looker Studio

2. Connect your Catchr account to Looker Studio

Click on “Authorize”, then sign up (or log in) to Catchr using your Gmail account.

Authorize to connect your Catchr account - Looker Studio

3. Connect your Facebook Ads account to Looker Studio

Click on “Authorize” to connect your Facebook Ads account. 

Authorize to connect your Facebook Ads account - Looker Studio

💡 You can find and manage all your sources on your Catchr account.

4. Select the account you want to display in your report

You can connect one or multiple accounts to a single Looker Studio report. To do this, select the account(s) you need and click on “Connect” at the top right corner.

Select your account(s) - Looker Studio

💡 You can configure the attribution windows and check the box to start with a template.

Once your data is connected, you’ll be taken to a page displaying all available metrics and dimensions. Here, you can manage fields, create calculated fields, and adjust formats to suit your needs. You can always return to this settings page later if needed.

Metrics & Dimensions - Looker Studio

We’ve already published a tutorial on how to create and configure a data source in Looker Studio. Feel free to check out our lesson for more details on the available settings.

5. Create a report

Now that you’ve created your data source, your Facebook Ads account is connected to Looker Studio! All that’s left is to create your report and start using it.

Click on “Create Report”.

Create a report button - Looker Studio

⭐️ Congrats! Your Facebook Ads data is now accessible on your Looker Studio report! 

To help you get started with Looker Studio, Catchr offers various resources like templates and lessons. Explore the full beginner’s guide to Looker Studio.

Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
Start your free trial!

All your marketing data on

Build dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!
Keep an eye on your data
No items found.
Need a clearer view of your marketing data?
Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?

Unlock your free Meta Ads Overview dashboard template for Power BI from a collection of stunning designs. Elevate your data visualization!

Get it for free
Need a clearer view of your marketing data?

Unlock your free Ads Performance dashboard template for Looker Studio from a collection of +50 stunning designs. Elevate your data visualization!

Get it for free

Bonus: Your free Ads Performance Template

In this Facebook Ads template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free Meta Ads OverviewTemplate for PowerBI

In this Facebook Ads template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Facebook Ads