Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Facebook Ads Data

After Facebook is successfully connected to your Stitch account, you'll have the ability to select individual tables to sync to your data warehouse. In this article, we'll cover:

Replicating Facebook Ads Data

Historical Sync

By default, a historical sync of Facebook Ads data goes back one year from the Stitch connection date. 

Our integration has the ability to pull data back to January 1, 2013, however. If you would like Stitch to replicate data older than one year, please reach out to support. Note that this could bring in a large amount of data and will count towards your monthly quota.

Frequency

Stitch will replicate Facebook Ads data based on the frequency you define. The default setting is every 30 minutes, but you can change the interval to better suit your needs.

Replication Method

When Stitch replicates Facebook Ads data, it does so using Incremental Replication. This means that every time Facebook Ads data is queued for replication, only new and updated rows will be replicated to your data warehouse.

Noticing Large Amounts of Data?
Even though our Facebook integration uses Incremental Replication, each time Facebook data is queued for replication, data for the past 28 days will be replicated. This is done to account for updates made to insights information within the default 28 day of attribution window on campaigns.

Because of this, your initial sync will be far larger than any subsequent syncs. You may also see larger volumes of data being replicated on an incremental basis than what's being generated in Facebook Ads.

To adjust for this, many of our clients set their Replication Frequencies to a less frequent interval or only select a few tables to sync.

Facebook Ads Tables in Your Data Warehouse

Core Ad Campaign Tables

Facebook Ads' campaign structure contains three levels: campaigns, ad sets, and ads. There is also a fourth level for developers called creatives. The tables listed below contain data about the core ad components in your Facebook Ads account. To learn more about how Facebook Ads data is structured, we recommend checking out their API guide.

Note that this isn't an exhaustive list - we're only focusing on the core tables.

Click a table name to view a full list of that table's attributes in Facebook's documentation.

facebook_campaigns_{account-id}
Primary Key:
 _id

The campaigns table is the core table of campaigns in a Facebook Ads account.

Attributes include the campaign ID (id), name, status (active/paused), objective.

updated_at in Primary Keys
For tables that use updated_time as part of the Primary Key, query results might return various versions of the same adgroup.

To reflect the latest state of the adgroup, use the latest updated_at timestamp.

facebook_adsets_{account-id}
Primary Key:
 _id:updated_time

The adsets table is the core table of Ad Sets in a Facebook Ads account.

Attributes include the ad campaign ID, the name the Ad Set belongs to, and budgeting, bid type, scheduling and audience targeting information.

facebook_ads_{account-id}
Primary Key:
 _id:updated_time

The ads table contains data about all of the ads in a Facebook Ads account.

Attributes include the ad information - such as the Ad Set and Ad Campaign the ad belongs belongs to - the ad bidding, ad targeting and reference to specific creative (image/text) that the ad uses.

facebook_adcreative_{account-id}
Primary Key: _id

The adcreative table records all of the creatives that are used in ads.

Attributes include creative name and description.

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

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

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!