Magento Business Intelligence Help Center

Expected Facebook Ads data

BROUGHT TO YOU BY

Avatar

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

In this article, we'll give you a brief overview of the tables we recommend you sync to your data warehouse. Note that this isn't an exhaustive list, as there are quite a few subtables. We're only highlighting the core tables.

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 records is the core table of Ad 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 of the ads in a Facebook Ads account. Columns include the ad information including the Ad Set and Ad Campaign 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 all of the creatives that are used in Ads. These 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.

facebook_ads_insights_placement_and_device_{account-id}

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

Related:

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk