How to import Facebook Ads data into Google Sheets with Catchr

Google Sheets is a powerful tool to work on your marketing data, but to gather this data, you need an add-on that connects your Facebook Ads account to Google Sheets.

Catchr provides an add-on on the marketplace, allowing you to connect to almost all social media platforms.

I'll show you how to install it and use it today!

How to install the Catchr add-on for Google Sheets?

From the Marketplace : 

Follow this link to go the Google Sheet Add-ons marketplace.

From a Sheets :

Open a new blank Google Sheet, then go to Extension → Add-ons → Get Add-ons. You are now in the Google Sheet marketplace. Search for Catchr in the search box, and click on the Catchr Add-on.

Installation :

Click on Install.

If you are a Google Account administrator, you have two buttons, Admin Install and Personal Install. You can install the Add-on for all your domains with the Admin Install.

You must allow the Add-on to access and manage your Google document. It is mandatory to bring data from the tierce platform to your Google Sheets.

How to create a new request to bring data into the Google Sheets:

First, launch the Catchr's Add-on: 

Once the add-on is installed, a new row will appear in the Extensions menu Catchr Data-Connector. Put your cursor over it and select Launch in the new panel.

You just launched the Catchr Add-on for Google Sheets. Now, let's create a request to bring your data into the sheets.

Then create your request:

Once launched, you should see a panel at the right of your Google Sheets. It is the Catchr panel to configure requests and indicate how you want the data to be brought in.

The first thing is to create a new request and configure it.

Here's how to do so :

1. Clicks on Add new.
2. Choose a Source. If you still need to create Sources on Catchr, follow this link to learn how to do so.
3. Choose one or more accounts. If you choose multiple accounts, the data will be aggregated.
4. Choose the metrics to display.
5. Choose the dimension to break down your metrics. If you only want aggregated data, leave it blank.
6. Choose the date range. You can preselect one or use the custom date range at the end of the list.
7. Set up filters if necessary.
8. Choose an option if you plan to re-use the request :
9. Appends rows will add all rows brought by the refresh at the end of the existing table.
10. Combining new rows with the old ones will check if a row already exists and will update it if necessary. New rows will be added a the end.
11. Choose a schedule to refresh the request automatically (it will automatically refresh the request, even if the Google Sheet is not open in a navigator, this can be convenient if you link your Google Sheet to a Looker Studio report).
12. Hit Get Data and wait for the data to be brought in.

This step can take several minutes, depending on the volume of data to be brought in.

If the return is empty, try to segment your request on multiple date ranges.