Facebook Ads to Google Sheets: Data export guide

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. 

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. 

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. 

‍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”. 

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. 

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. 

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. 

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. 

‍

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 :

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.