Facebook Airtable Integration

What This Article Covers

  • Sync your Facebook and Instagram ads data to Airtable with no code
  • Sync Facebook page and post insights to Airtable
  • Sync that daily or hourly
  • Contact our support for fast help if you run into any issues
Follow along to get your Facebook ads data into Google Sheets:

Connecting to the Facebook API to Airtable

In this reference we’ll look at how to setup a Facebook Airtable integration for
  • Facebook ads and Instagram ads to Airtable
  • Facebook pages and post insights to Airtable

Don’t Have SyncWith?

  • SyncWith is a Google Sheets Add On
  • SyncWith allows you to move data from any API into Google Sheets
  • Learn more about why Marketers love SyncWith
  • ⭐️⭐️⭐️⭐️⭐️ Reviewed by hundreds of businesses
  • Check out our Airtable API Extension in the Airtable marketplace to install today, and see why 100,000s of users are using us to setup their data connections easily.

How Does SyncWith Work on Airtable?

notion image

Connecting Facebook Ads to Airtable

Connecting to a specific Facebook API to import to Airtable

Facebook has many APIs, and there are many marketing APIs available in SyncWith, so we must pick a specific API to connect to
  1. Open the SyncWith extension
  1. Click New report or one of the default services, eg Facebook Ads
notion image
  1. A new tab will open in your browser to configure your connector
  1. If you choose Facebook Ads you’ll come immediately to the configuration screen
  1. If you clicked New report you’ll come to a screen listing many api services as well as the ability to search
notion image

Connecting the Facebook Ads API to Airtable

You’ll see a configuration screen like the following:
notion image

Choose a Reporting Time Frame

You can choose from a wide range of default reporting time frames as well as dynamic ones. Some marketers and agencies might report on the last 21 weeks of data. You may or may not want to see the current day in the reporting period.
All are possible with the date range picker. Popular options include:
  • Last 30 days
  • Last 90 days
  • Last Month, Last 3 Months
  • Month to Date
You may create multiple connections with different date ranges, for instance if you’re building a dashboard you might want to know your total ad spend in the last month, 3 months and year. You can create 3 queries to pull each of these numbers.
notion image

Choosing Your Dimensions

Dimensions are important if you want to pivot your data to see how different groups of users perform, for example:
  • I want to see how my ad sets perform across gender, age and country so I can prune poorly performing ones
  • I want to differentiate between the performance of different ad types in my campaigns
  • I want to understand which countries have the best engagement in my videos
  • I want to group my daily ad spend by
notion image

Choosing Your Metrics

Now that you’ve selected the dimensions you want to report along - eg the things you’re interested in. Now you need to choose what you want to know about them. Eg you want to break things down by country, and now you need to know what you want to know about each Country. It’s important to note that some metrics are computed like CTR, CPM and Frequency are computed which means you won’t be able to roll them up directly - but you can if you compute them in a roll up. Eg if you have a data table with CTR by country you can’t just average all the CTRs to get your average CTR you need to sum all the link clicks and sum all the impressions and then calculate the average CTR.
 
notion image

Creating a Table

  1. Click the Save button
notion image
  1. SyncWith will begin creating the connection, creating a new table in the base and importing the requested data, you see the Save button grey out and change to Saving
notion image
  1. Once complete the configuration tab will close and your Airtable will be updated
notion image
  1. The extension will also add the new report to a list of existing reports, each report has a context menu allowing you to Edit or Delete the report
notion image

Refreshing the Facebook Airtable Connection

In order to refresh your facebook data and sync it to airtable click the Refresh button
notion image

Connecting the Facebook Page Insights API to Airtable

  1. Click New report
  1. Search for Facebook
  1. Select Facebook Page Insights
notion image
  1. Configure the Page Insights connector
  1. Click Save

Connecting the Facebook Post Insights API to Airtable

  1. Click New report
  1. Search for Facebook
  1. Select Facebook Post Insights
notion image
  1. Configure the Post Insights connector
  1. Click Save