Export Facebook Ads Data To Google Sheets

Export Facebook Ads Data To Google Sheets
Reading Time: 5 minutes

Quick guide
How to use Amigo Data to export Facebook Ads data to Google Sheets in 3 simple steps:
1. Connect Facebook Ads account to Amigo Data
2. Choose the date range, dimensions and metrics to export
3. Click IMPORT and set an automatic refresh schedule

Facebook is one of the biggest digital marketing platforms. So, it’s safe to assume that you’re not just familiar with it but have run ads on it. If you have, you must have dreaded the task of creating reports of the ad campaigns. The task of reporting is not just mundane and tedious, it’s time-consuming and error-prone. And the Facebook Ads Managers’ interface isn’t the most intuitive and user-friendly, which doesn’t help.

The good news is that all these tasks can be automated using our Google Sheets add-on Amigo Data which can pull all the data and export the Facebook Ads data to Google Sheets in a matter of seconds. And the best thing is that you don’t even have to run a single line of code.

Why connect Facebook Ads to Google Sheets

With the Facebook Ads data exported to Google Sheets, you can track and monitor the performance from anywhere, on any device.

Benefits of connecting Facebook Ads to Google Sheets

Why use Amigo Data to export Facebook Ads data to Google Sheets

Running a successful ad campaign is just half of the job of digital marketers. You need also to create a good report that is easy to understand, has the crucial details, sort and filter the metrics, and ideally add visual data representation for better analysis.

Export Facebook Ads data to Google Sheets with Amigo Data

You may also need to

  • Create marketing reports combining Facebook Ads and Google Ads
  • Create a business report combining marketing spending with revenue data
  • Run some additional calculations on your campaign performance

Using Amigo Data you can automatically pull data from Facebooks Ads to Google Sheets. You can choose which metrics to export, filter metrics and sort the data based on the criteria you want.

Staying up-to-date Amigo Data

If you’d like to know more, let me guide you through how to use Amigo Data to export Facebook Ads data to Google Sheets using a very simple exercise.

Export Facebooks Ads data to Google Sheets using Amigo Data

Getting things started

You’ll need to install the Amigo Data addon in your Google Sheets to export Facebook Ads data to Google Sheets (obviously). 

You can get the addon from Google Workspace Marketplace. Click install and give the necessary permissions.

Getting Amigo Data from Google Workspace Marketplace
Install Amigo Data add-on to export Facebook Ads data to Google Sheets

Another way to get the addon is to open a new Google Sheets document. Then go to Extensions→Add-ons→Get add-ons. Search for Amigo Data and install.

Connecting Facebook Ads to Amigo Data

Once the installation is complete, the Amigo Data add-on should appear in your Extensions menu.

Go to Extensions→Amigo Data→Connect. Then choose Facebook Ads from the list of sources, name your connection (or leave the default as it is; you can change it later) and click Authorize. You’ll be redirected to the Facebook login page. Enter the credentials.

Importing Facebook Ads data to Google Sheets

We can now begin importing Facebook Ads data to Google Sheets.

Launch Amigo Data by going to Extensions→Amigo Data→Connect. Click the connection that you have created. Then follow the steps given below to extract data from Facebook Ads to Google Sheets.

Guide to how to export Facebook Ads data to Google Sheets with Amigo Data
Steps to export Facebook Ads data to Google Sheets

Setting automatic refresh schedule

Amigo can refresh to report periodically–hourly, daily, weekly or on certain days of your choice–so that you do not have to export the report each time you want to share it with someone or save it to a spreadsheet. To do so, select or customize the time period and click Yes, set the refresh timing.

Setting alert

Amigo can also send you alerts on your email or Slack channel with snapshots of the report so that you don’t even have to open the spreadsheet to keep up to date with the performance of your ad campaign.

To set up alert, click Get Alerts→Add data alert and customise the alert, add the email(s) to which you want the alert sent and/or Slack channel(s). Once done, click Set Alert.

Amigo will send you a snapshot of the report periodically, and you always have the latest information wherever you are.

Alert of the report received on Slack

Conclusion

Amigo Data makes it super easy to export Facebook Ads data to Google Sheets. With the mundane and time-consuming activities of your marketing campaign handled by Amigo Data, you can concentrate on running the ad campaign and analyzing the data. And you can rest assured knowing that you’ll always have the latest data instantly.

If you’re still here and haven’t had the add-on installed, get it here.

Your questions answered

How do I export data from Facebook Ads?

Using Amigo Data you can export Facebook Ads data to Google Sheets by following the steps below:

  1. Install the Amigo Data add-on in Google Sheets
  2. Launch Amigo Data and connect it to the Facebook Ads account
  3. Choose the date range, dimensions and metrics to export
  4. Click IMPORT and set an automatic refresh schedule

How do I automate a Facebook Ads report?

To automatically refresh and update the Facebook Ads report, click View Reports, then click the reports you want to automate. Set the refresh schedule and save the settings.

What types of Facebook Ads metrics can I export?

You can export any type of metrics from Facebook Ads to Google Sheets using Amigo Data, such as impressions, reach, clicks, click-through rates (CTR), etc. and then measure and track them individually or collectively to optimise the performance of your ad campaigns.

See also

You can use Amigo Data not just to export Facebook Ads data to Google Sheets but also from various other sources such as Google Ads, MySQL, Snowflake, and Google Analytics among others. For tutorials on them and other Google Sheets guides, you can find them here.

Similar articles that you may be interested in:

https://blog.tryamigo.com/export-google-ads-data-to-google-sheets-2/

https://blog.tryamigo.com/export-data-from-snowflake-to-google-sheets/

https://blog.tryamigo.com/importing-mysql-data-to-google-sheets/