Expected Facebook Ads data

Last update: 2023-07-25
  • Created for:
  • Beginner
    Intermediate
    Admin
    Developer
    User

After you have connected your Facebook Ads account, you can use the Data Warehouse Manager to easily track relevant data fields for analysis.

This topic gives you a brief overview of the tables Adobe recommends you sync to your Data Warehouse. This only highlights the core tables, as there are quite a few subtables.

Core ad campaign tables

These tables contain data about core ad campaign components.

facebook _campaigns_ (account-id)

This table is the core table of campaigns in a Facebook Ads account. Columns include campaign id, name, status (active/paused), objective.

facebook _adsets_ (account-id)

This table record is the core table of Facebook Ads Sets in a Facebook Ads account. Columns include the Ad Campaign id/name the Ad Set belongs to, the budgeting, bid type, scheduling, and audience-targeting information.

facebook _ads_ (account-id)

This table records all ads in a Facebook Ads account. Columns include the ad information including the Ad Set and Ad Campaign that it belongs to, the ad bidding, ad targeting, and reference to specific creative (image/text) that the ad uses.

facebook _adcreative_ (account-id)

This table records creatives that are used in Facebook Ads. Creatives includes creative name, description, and relevant image urls where appropriate.

Segmented campaign tables

The following tables contain an entry for each campaign/set/ad combination for each day, segmented by dimensions such as age, gender, and country.

facebook _ads insights_ (account-id)

This table includes an entry for each campaign/set/ad combination for each day, along with statistics including impressions, clicks, cost, cpc, cpm, cpp, ctr, reach, social reach, and spend.

facebook _ads insights_ (account-id)_~\_actions

This is a subtable of the facebook_ads_insights_{account_id} table. It includes conversion data for actions that happen based on different campaigns.

facebook _ads insights country_ (account-id)

This table includes the same information as the facebook_ads_insights_{account_id} table and segments it by country.

facebook ads insights age and gender (account-id)

This table includes the same information as the facebook_ads_insights_{account_id} table and segments it by age and gender.

On this page