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