blog post

How to Import Facebook Ads Data to Google Sheets: A Comprehensive Guide

Florian Cabirol
January 30, 2024
How to Import Facebook Ads Data to Google Sheets: A Comprehensive Guide

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.

The tutorial

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.

The tutorial

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.

The tutorial

By importing data from Facebook Ads to Google Sheets, you can make custom reports, see how your data looks, and make better marketing decisions. In this blog post, we will show you how to use the Catchr Add-on for Google Sheets to import your Facebook Ads data easily and efficiently.

How to work with the add-on to get data

Now that you have the Google Sheet Add-on installed, you can create your first query with it. But before that, we will review all the different configurations to which you have access when you create a query. 

Listing options for Google Sheets Catchr Add-on
All tabs available for Google Sheets

Source Listing

In the source listing, you could select any marketing platform you want to connect. In this case, we will use Facebook Ads, but you could also connect Microsoft Ads, Google Ads, etc. We have more than twenty marketing sources at the moment and plan to add a lot more.  

If you have no account for the source, you can click on the “+” button and add the source from app.catchr.io. 

Source selection for Catchr Google Sheets Add-on
Source selection for Catchr Google Sheets Add-on

Accounts

Once you have selected a source, you can select the account you want to work with. You can select one or more accounts and execute all your queries on them. 

Facebook Ads accounts selections from Google Sheets Add-on
Facebook Ads accounts selections from Google Sheets Add-on

Metrics

On the metrics tabs, you will find all the metrics accessible from the Facebook Ads API. It includes the basics, like “clicks”, “spend”, and “impressions”, but also more specific things like “mobile app checkouts” or “purchases”. 

Metric selection for Facebook Ads in Catchr Google Sheets Add-on
Metric selection for Facebook Ads in Catchr Google Sheets Add-on

Dimensions

Like the metrics tabs, the dimensions tabs gave you the power to select which dimension you wanted to work on. By way of example, if you want all the impressions by campaign and day, you need to put “Impressions” in the metrics tabs and “Day” and “campaign name” in the dimension fields. 

Dimensions selections for Facebook Ads in Google Sheets Add-on
Dimensions selections for Facebook Ads in Google Sheets Add-on

You could find all the metrics available for Facebook in the fields listing page.

Date range

In the date range tab, you can select the date range for your report. There are presets available, like "Last month" and "This year" but you can also add custom date range. 

Date range selection for Facebook Ads on Google Sheets Catchr Add-on
Date range selection for Facebook Ads on Google Sheets Catchr Add-on

Filters

The filters gave you a way to filter the data you wanted to work on. If you only need your branding campaign, you could easily put the name or the pattern of the campaign in the filter. 

Add filters for Facebook Ads Google Sheets Catchr Add-on
Add filters for Facebook Ads Google Sheets Catchr Add-on

Please, note that successive filters combine with a AND logical operator.

Options

Catchr Add-on provides several options to help work with data from Facebook Ads: 

  • Appends row: append the future data to the end of the range.
  • Combine rows: combine and update the new rows with the old ones.
  • Schedule : Schedule an automatic data refresh for your data. 
Options for Facebook Ads Google Sheets Catchr Add-on
Options for Facebook Ads Google Sheets Catchr Add-on

Now that you know how to create a query, let start creating your first report. 

An example of a data report you could build on Google Sheets with the Add-on for Facebook Ads

Using the Catchr Add-on for Google Sheets, you can create a custom report that provides insights into your Facebook Ads performance. For example, you could create a report that shows the top-performing ad sets in terms of conversions and return on ad spend (ROAS). 

To create this report, you would:

  1. Select the "Facebook Ads" Source
  2. Select the account you want to work one
  3. Import the following metrics: conversions, ad spend, and ROAS.
  4. Use the "dimensions" tab to group your data by ad set nam
  5. Select the date range you want to work one.
  6. Clicks on "Get data"

You will saw something like :

Data for Facebook Ads
Data for Facebook Ads

This report would give you a clear overview of which ad sets are driving the most conversions and delivering the best ROAS. You could then use this information to optimize your Facebook Ads campaigns and allocate your budget more effectively.

Bonus : Your free Template Meta Ads - Overview V2 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

Explore your Facebook Ads Marketing KPI in PowerBI : How-to, metrics and templates

Master the art of integrating Facebook Ads with PowerBI through Catchr with our in-depth tutorial. Learn to connect, transfer, and visualize crucial marketing metrics for enhanced analysis and strategy development. Transform your Facebook Ads data into insightful, actionable PowerBI reports today!

Florian Cabirol

Top 8 Facebook Ads KPIs Every Marketer Needs to Keep Up With in 2023

Discover the top 8 Facebook ads KPIs to optimize your marketing campaigns for better reach and enhanced performance. Read our latest blog to learn more!

Florian Cabirol

Connect Facebook Ads to Looker Studio : How-to, templates and metrics

Import your Facebook Ads data into Looker Studio and create a report with this step-by-step tutorial!

Johan Chemin

How to Import Facebook Ads Data to Google Sheets: A Comprehensive Guide

Learn how to import Facebook Ads data to Google Sheets using the Catchr Add-on. Analyze and visualize your marketing data with ease and efficiency.

Florian Cabirol