Connectors

/

Facebook Marketing

Facebook Marketing

Marketing Analytics

Sync Facebook Marketing data anywhere.

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.

  • Certified
  • Generally available
  • 32 streams
  • 13 entities
  • Read & write
Sync Facebook Marketing dataRead the docs
  • 32Streams
  • 13Entities
  • 6Actions
  • 50+Destinations
One connector

Everything Facebook Marketing can do in Airbyte

  • Sync to your warehouse

    Land 32 Facebook Marketing tables in 50+ destinations on a schedule you control.

  • Live entity actions

    Read, create and update Facebook Marketing records at runtime through typed entity actions.

  • Context store search

    Query synced Facebook Marketing data with filters, sorting and semantic search, without spending Facebook Marketing API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version6.0.2

Set up in 8 steps

  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.
32 streams

Every table you can sync from Facebook Marketing

  • activities

  • ad_account

  • ad_creatives

  • ad_creatives_from_ads

  • ad_sets

  • ads

  • ads_insights

  • campaigns

  • custom_conversions

  • custom_audiences

  • images

  • videos

6 actions

Supported Facebook Marketing actions

  • Get

    Fetch a single record by ID.

  • List

    Read live records straight from the Facebook Marketing API.

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

  • Create

    Write a new record back into Facebook Marketing.

  • Update

    Patch fields on an existing record.

  • Semantic Search

    Natural-language search across synced Facebook Marketing records.

Full parameter-level details live in the Facebook Marketing entity reference.

Authentication

Authenticate Facebook Marketing once

  • Authenticate via Facebook Marketing (Oauth)

    Recommended

  • Service Account Key Authentication

Use cases

What teams build with Facebook Marketing

  • List all active campaigns in my ad account

  • What ads are currently running in a recent campaign?

  • List all ad creatives in my account

  • What is the status of my campaigns?

  • List all custom conversion events in my account

  • Show me all ad images in my account

FAQ

Common questions

Do I need more than one Facebook Marketing connection?

No. One Facebook Marketing authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

Do Facebook Marketing entity actions need a sync to run first?

No. Entity actions read and write through the Facebook Marketing API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

What is ETL?

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

What data can you extract from Facebook Marketing?

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.

How do I transfer data from Facebook Marketing?

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.

What are top ETL tools to transfer data from Facebook Marketing?

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

What is ELT?

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

Difference between ETL and ELT?

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Explore
All connectors

Start moving Facebook Marketing data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Facebook Marketing actions.

Try it freeTalk to sales