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

• We’ll use the Syncwith Extension for Airtable (used by 100,000s of people across Google Sheets, Excel, Data Studio and more)

• Contact our support for fast help if you run into any issues

Connecting to the Facebook API to Airtable

• 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?

Connecting Facebook Ads to Airtable

Connecting to a specific Facebook API to import to Airtable

1. Open the SyncWith extension

2. Click New report or one of the default services, eg Facebook Ads

1. A new tab will open in your browser to configure your connector

2. If you choose Facebook Ads you’ll come immediately to the configuration screen

3. If you clicked New report you’ll come to a screen listing many api services as well as the ability to search

Connecting the Facebook Ads API to Airtable

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.

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

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.

 

Creating a Table

1. Click the Save button

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

1. Once complete the configuration tab will close and your Airtable will be updated

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

Refreshing the Facebook Airtable Connection

Connecting the Facebook Page Insights API to Airtable

1. Click New report

2. Search for Facebook

3. Select Facebook Page Insights

1. Configure the Page Insights connector

2. Click Save

Connecting the Facebook Post Insights API to Airtable

1. Click New report

2. Search for Facebook

3. Select Facebook Post Insights

1. Configure the Post Insights connector

2. Click Save