Facebook Marketing is an extension of Facebook’s online social networking service. Making strategic use of its gigantic user base, Facebook has partnered with AXA Group to leverage the power of people connections (over 1.32 billion active users monthly) for extraordinarily efficient digital marketing and commercial collaboration. Through Facebook’s huge user base, Facebook Marketing is able to reach unprecedented numbers of people with personalized sales and marketing advertisements, making it a huge addition to the world of marketing.
BigQuery is an enterprise data warehouse that draws on the processing power of Google Cloud Storage to enable fast processing of SQL queries through massive datasets. BigQuery helps businesses select the most appropriate software provider to assemble their data, based on the platforms the business uses. Once a business’ data is acculumated, it is moved into BigQuery. The company controls access to the data, but BigQuery stores and processes it for greater speed and convenience.
![](https://cdn.prod.website-files.com/605e01bc25f7e19a82e74788/64aeb8af6351d4930c019cb5_Set%20up%20a%20source.jpg)
1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
2. Click on the "Facebook Marketing" source connector and select "Create new connection."
3. Enter a name for your connection and click "Next."
4. Enter your Facebook Marketing credentials, including your Facebook account ID, access token, and app secret.
5. Click "Test connection" to ensure that your credentials are correct and that Airbyte can connect to your Facebook Marketing account.
6. Once your connection is successful, select the data you want to replicate from Facebook Marketing, such as ad campaigns, ad sets, or ads.
7. Choose the frequency at which you want Airbyte to replicate your data, such as hourly, daily, or weekly.
8. Click "Create connection" to save your settings and start replicating your Facebook Marketing data to your destination of choice.
![](https://cdn.prod.website-files.com/605e01bc25f7e19a82e74788/64aeb8b079061e146f038ab9_Set%20up%20a%20destination.jpg)
1. First, navigate to the Airbyte dashboard and select the "Destinations" tab on the left-hand side of the screen.
2. Scroll down until you find the "BigQuery" destination connector and click on it.
3. Click the "Create Destination" button to begin setting up your BigQuery destination.
4. Enter your Google Cloud Platform project ID and service account credentials in the appropriate fields.
5. Next, select the dataset you want to use for your destination and enter the table prefix you want to use.
6. Choose the schema mapping for your data, which will determine how your data is organized in BigQuery.
7. Finally, review your settings and click the "Create Destination" button to complete the setup process.
8. Once your destination is created, you can begin configuring your source connectors to start syncing data to BigQuery.
9. To do this, navigate to the "Sources" tab on the left-hand side of the screen and select the source connector you want to use.
10. Follow the prompts to enter your source credentials and configure your sync settings.
11. When you reach the "Destination" step, select your BigQuery destination from the dropdown menu and choose the dataset and table prefix you want to use.
12. Review your settings and click the "Create Connection" button to start syncing data from your source to your BigQuery destination.
![](https://cdn.prod.website-files.com/605e01bc25f7e19a82e74788/64aeb8afa62171f49ab6c6c5_Set%20up%20a%20connection.jpg)
With Airbyte, creating data pipelines take minutes, and the data integration possibilities are endless. Airbyte supports the largest catalog of API tools, databases, and files, among other sources. Airbyte's connectors are open-source, so you can add any custom objects to the connector, or even build a new connector from scratch without any local dev environment or any data engineer within 10 minutes with the no-code connector builder.
We look forward to seeing you make use of it! We invite you to join the conversation on our community Slack Channel, or sign up for our newsletter. You should also check out other Airbyte tutorials, and Airbyte’s content hub!
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
Facebook Ads is an advertising platform that allows businesses to place paid ads on Facebook, Instagram, Messenger and the Audience network. Facebook Ads provides basic reporting features. When marketing teams need to create customized reporting, it’s common to download Facebook ads data and move it to a cloud data warehouse, where it can be combined with other marketing data sources and analyzed using modern BI tools.
Furthermore, the day you need to combine Facebook Ads data with other marketing data sources (Analytics, Google Ads, LinkedIn Ads, …) you want to load all your marketing data to a data warehouse. Google BigQuery is a popular data warehouse that integrates easily with other Google marketing data sources like Google Analytics and Google Ads. You can use Google BigQuery to build up your marketing data warehouse.
Airbyte Cloud makes it easy to move all your marketing data, including Facebook Ads data to cloud data warehouses. Airbyte is an open-source data integration platform that you can deploy yourself, or use directly through Airbyte Cloud. This tutorial will take you through the steps to set up Airbyte Cloud and copy over your data from Facebook Ads to BigQuery.
Prerequisites
- A Facebook Business Manager account with Facebook ads.
- A Google Cloud Platform with access to Google BigQuery.
- An Airbyte Cloud account to do the data replication for you.
Step 1: Set up Facebook Ads as the Airbyte Source
For Airbyte Cloud to be able to extract data from Facebook Ads you will need to give Airbyte Cloud access to your Facebook account and find your Facebook ads account ID as specified in the Airbyte Facebook Ads source docs.
Go to the Facebook menu and search for Facebook Ad Manager. You will then be redirected to the Ad Manager site, where you will see all your accounts and their corresponding IDs.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f98f8a460826f7eac35e_624d6e57b713550fc2549642_7f_p2r8n6d7Bcra_2o5r31rKLbOupWeeJ0Y52AxPKMYKSqLkb5ntcs-wuUVGDZyM_hHjti7oYMS7Q05IpxNHDtZMa2dvo0iiwnXj3uEG4iw1Uq3sZsdF0VUmgfe1zENWzYfByzDS.png)
Next, go to Airbyte Cloud and create a new source. Give the source a name and select Facebook Marketing as the source type.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f9908a460826f7eac375_624d6e573fd8cce58be8d639_O6Chy20xuUO14PS05x4JyHa8zKlTbE56WBrC7CqEy040PX7Npj6yT3WrYk052rklPj_23fyjDLrIe4dqFG54LSGWn49vIg05gK1xZWVoyTA1ztSNejkuROLCQ5aTpvG78N8ZAZ2r.png)
Click on the Authenticate your account button. You will be prompted to sign in to your Facebook account in a popup. Once signed in, you will be asked to give Airbyte access. Grant Airbyte Cloud the permissions to Facebook Ads.
Now enter the start and end dates for when Airbyte should copy the data. Also, enter the Account ID from Step 1 and click on Set up source.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f9908a460826f7eac38b_624d6e57d722e5299debffac_FuN-03n1De_-S1BDcVz6evbOxRje0qnsAAsuaKTOB-3LegI5jzjClekzbE3IdjFwX7iyNnMe5iS8TwXfqzx6OgEkufl6HLT5UOANKVtl2V_j-Qa6CRg5-JADPFQSNWgaC_DHB_pk.png)
Step 2: Set up BigQuery as the Airbyte destination
For Airbyte Cloud to be able to sync Facebook ads data to BigQuery you will need to create a BigQuery dataset, a service account and a service account key as specified in the Airbyte BigQuery destination docs.
Then create a new destination and select BigQuery as the destination type. Enter the project id, dataset id, and dataset location you configured while creating the dataset. Use the contents of the credentials JSON service account and click on Set up destination.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f9908a460826f7eac397_624d6e7c9012735931ce97a4_XL87b9QJaAuckZ7PGziqhhYMJMax4vkKlZrDZLJJPqk-6w9TnhJACLn6ueYHOnjE_ZgY9rSpn2GX88adrLwsUFTl7iea8e1EosZLZR5-R6nuAP5Uig86ajvjrrN5KfKUELcczjBG.png)
Step 3: Set up a Facebook Ads to BigQuery connection
Once the source and destination are configured, you can access your connection settings. You should be able to see the various data sources (Airbyte streams) from Facebook Ads. You can set the sync frequency to sync data from Facebook Ads to BigQuery and the sync mode for each stream. In this example, we will select the ads data.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f9908a460826f7eac391_624d6ebdc0ed6b251e2f4757_ixAjGtxcZNeMLsa15oVNkrAdfPYbWqzXQ8p2lA_GBciZNTQ6NTkbLbzvgl5N68lqbMclSI_0k7b93Oso8NCm0MxL953SjyHaf5Tv5IVWTaASECOJjEjIQ6nKLokpwBLaCUaRVYuB.png)
You can also change the sync mode. In this case, we change it below to Incremental | Append sync mode for the ads steam. This mode will append only new data to the destination tables in BigQuery. You can also choose between using Raw Data or Basic normalization with normalization set by default. You can read more about these all connection settings in the Airbyte Cloud getting started guide. Once configured, click on the Set up connection button.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f9908a460826f7eac394_624d6ebee5e86fb8e2487aba_cxqzpsJ34RGJ-wroTsln6fCfWw7SxEneL4mTlhH92VmVXVFp1LoQ2irPeSqP7_49SVqVMqKHx8DPW9_Ep7TPo-Nq2hkAoswEAASrA3BFTafYG8DcEiUWvQ_YuMCi5iW_bxseYDON.png)
After creating a connection, you can start a sync by selecting Sync Now.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f98f8a460826f7eac365_624d6ebd922d52338e466904_kCMLp-jlciHSS5yWxhlk8PQifnrswdI2m5adJynDTa9Bmvu2ssOrQZgzg0pESEFOlOBbX9OH0sTrmWnCNCLyDDvSMrKhsSBvaVau2NRHAFZj5NP9fO78L0DB2DtVuHRJSlY3R2Tq.png)
Once the sync is complete, go to your Cloud Console BigQuery page. You should now be able to see the tables created by Airbyte Cloud in your dataset. You will find one table with raw data (_airbyte_raw_ads) in JSON, and other tables created by Airbyte normalization. When Airbyte finds JSON data inside a field, it will normalize it and split it into multiple tables with foreign keys to the ads table.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f9908a460826f7eac378_624d6ebd12433aeb4d06a700_CPtS8XA5iecY8XC_cuUIf9MPjdWIN64WoxUuhgIBUVvjkV0hTHuPaGDT8Zni69fVdKk15-S4DXpObX2qxuT75skfQ5j9FlRxIXfo_mM0xgpQcniti8cwlnKqZrbKEx8TpFg_aiUg.png)
You can select the tables to view their schema. The following image shows the schema of the ads table.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f9908a460826f7eac38e_624d98bfadaefe384446eb9f_WcFH3gBpYWz0vHNC8jxXjKk1UzF7ZU2bUvoQ-cA8nGAiXg2EnJI46es6U4ufSn8k6Z6TxNNrj6K75myGOjdJZ7MrLxek4pbdQvCaeqEHHWpHezwzAPutQ2UFTwWWh-TrYwkUUtUL.png)
You can test out the incremental sync for your table by adding another ad to your Facebook page and running another sync.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f98f8a460826f7eac361_624d6ebd7c1a5360e7fe1f2a_vpT38nlMKmtDzKMNCyYY_-ecAm40kcZJiZCA92lS-ZDQs9T9wEpKLSMK90nLKXlriNCT7ZPFpkQG5m0lGtOjPKKj8-jlXsPjf0cx27Eeh5Fzx35DJYB3Bq31SRysf4kRlogzLOfJ.png)
In this example, we added one more ad. After adding another ad, you can run the following query on BigQuery to see the count.
![](https://cdn.prod.website-files.com/6064b31ff49a2d31e0493af1/66d6f98f8a460826f7eac368_624d6ebd74a0181d22f88f2d_OXxE5dcYfPXBAE9LWckSI5V3krsbg6iAx2qUB_KlsUsSob1J99bGUTihOp_-7kZV5CrMexd-Y06AcnXbLflx9r_qo0Jeisisngny4-sPzs-CcaF82k-s95plirZRjtsl6-CqsvjQ.png)
Conclusion
This tutorial illustrates how easy it is to set up a connection between Facebook Ads and BigQuery using Airbyte Cloud. You can then use other Airbyte marketing sources to create a marketing data warehouse and plug in a BI tool like Google Data Studio, Tableau or Metabase to create custom marketing reports.
You can get started moving data to your data warehouse in minutes with the Airbyte Cloud free trial.
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
Ready to get started?
Frequently Asked Questions
Facebook Marketing's API provides access to a wide range of data that can be used for advertising and marketing purposes. The types of data that can be accessed through the API include:
1. Ad performance data: This includes metrics such as impressions, clicks, conversions, and cost per action.
2. Audience data: This includes information about the demographics, interests, and behaviors of the people who engage with your ads.
3. Campaign data: This includes information about the campaigns you have run, such as budget, targeting, and ad creative.
4. Page data: This includes information about your Facebook Page, such as the number of likes, followers, and engagement metrics.
5. Insights data: This includes data about how people are interacting with your content on Facebook, such as reach, engagement, and video views.
6. Custom audience data: This includes information about the custom audiences you have created, such as their size and composition.
7. Ad account data: This includes information about your ad account, such as billing and payment information.
Overall, the Facebook Marketing API provides a wealth of data that can be used to optimize your advertising campaigns and improve your marketing efforts on the platform.