Facebook Ads (v1) | Stitch Documentation

Facebook Ads extraction is supported by Stitch
This integration is powered by Singer's Facebook Ads tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Stitch support.

Keep up with the latest Facebook Ads updates with the Facebook Ads Integration Changelog.

Facebook Ads integration summary

Stitch’s Facebook Ads integration replicates ad, campaign, and adcreative data using the Facebook Marketing API 10.0.

Note: This integration does not currently support replicating data for reviews, pages, etc.

Refer to the Schema section for a list of objects available for replication.

Facebook Ads feature snapshot

A high-level look at Stitch's Facebook Ads (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on September 11, 2017	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-facebook
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Unsupported
Table-level reset	Supported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Facebook Ads

Facebook Ads setup requirements

To set up Facebook Ads in Stitch, you need:

Verify your access in Facebook Ads. If the user who creates the integration has restricted permissions - meaning the user doesn’t have access to all campaigns or ads - Stitch may encounter issues replicating data.

Even if you only intend to sync certain pieces of data post-setup, the user completing the initial setup should still have full access.
Pause all ad-blocking software currently in use. Because Facebook authentication uses pop ups, you may encounter issues if ad blockers aren’t disabled during the setup.

Step 1: Add Facebook Ads as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Facebook Ads icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Facebook Ads” would create a schema called stitch_facebook_ads in the destination. Note: Schema names cannot be changed after you save the integration.

Step 1.1: Select an attribution window

An attribution window is the amount of time for attributing results to ads and the lookback period after those actions occur during which ad results are counted.

We recommend selecting the same attribution window you use in Facebook Ads to prevent discrepancies between Facebook’s UI and data replicated by Stitch. For example: If the attribution window in Facebook Ads is 7 days, you should define this setting as 7 days.

Then, during every replication job, Stitch will replicate the past seven days’ worth of data to account for result attribution. This will ensure that records updated during the attribution period are correctly captured by Stitch.

For more info, see the Attribution windows and data extraction section.

What if clicks and views have different windows in Facebook Ads?

In this case, you should select the greater of the two. For example: If clicks have a window of 7 days and views have a window of 1 day, you should select 7 days as the setting in Stitch. This will ensure that the values for clicks and views are correctly updated.

Step 1.2: Include deleted data

Check the Include data from deleted campaigns, ads, and adsets box to have Stitch replicate data for these deleted objects.

Note: Data for deleted campaigns, ads, and adsets will be included only in Core Object tables.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Facebook Ads integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Facebook Ads’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Facebook Ads integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Facebook Ads

After clicking the Authorize button, a small pop-up window will display.

You’ll be taken through a series of steps to allow Stitch to access data from your Public Profile, Facebook Ads, and related stats.
Click Okay to advance through these steps.
After you’ve finished authorizing Stitch, you’ll be prompted to select the Facebook Ad Account you want to pull data from. Select the desired account by clicking the checkbox in the Connect column.

If you don’t see the profiles that you would expect to, verify your Facebook Ads permissions before reaching out to support.
Click the Save Connections button.

After your credentials are validated, you’ll be directed back to Stitch (click the All Done button to wrap things up) and the Integration Details page will display.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Facebook Ads integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Facebook Ads, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Facebook Ads replication

Attribution windows and data extraction

The info in this section only applies to tables using Incremental Replication. Tables using Full Table Replication replicate fully during each replication job and don’t use attribution windows.

When Stitch runs a replication job for Facebook Ads, it will use the value of the Attribution Window setting to query for and extract data for Incremental tables. An attribution window is a period of time for attributing results to ads and the lookback period after those actions occur during which ad results are counted.

For example: If set to 7 days, Stitch will replicate the past seven days’ worth of data every time a replication job runs. While Stitch replicates data in this way to account for updates to records made during the attribution window, it can have a substantial impact on your overall row usage.

In the sections below are examples of how attribution windows impact how Stitch extracts data during historical and ongoing replication jobs.

Historical and full re-replications
Ongoing replications

For historical and full re-replications of Facebook Ads data, Stitch will query for and extract data newer than or equal to the date defined in the Start Date field in the Integration Settings page.

The Start Date, in conjunction with the Attribution Window, defines the minimum date Stitch should query for when extracting historical data. This is calculated as:

Start Date - Attribution Window = Minimum Extraction Date

Note: For the ads_insights stream, the Minimum Extraction Date cannot be more than 37 months ago.

Example

During the initial set up, the Attribution Window and Start Date settings are defined as:

Attribution Window: 28 days (default setting)
Start Date: 07/03/2017, or 2017-07-03 00:00:00

To account for the Attribution Window, Stitch would calculate the Minimum Extraction Date value as: 2017-07-03 00:00:00 - 28 days = 2017-06-05 00:00:00

If you were to write a SQL query using this date for the ads table, it might look like this:

  SELECT *
    FROM facebook_ads.ads
   WHERE updated_time >= '2017-06-05 00:00:00'   /* Min. Extraction Date */
ORDER BY updated_time

For ongoing replication jobs, Stitch will query for and extract data using the last saved maximum value in the table’s Replication Key column and the Attribution Window for the table.

Note: This applies to every replication job that takes place after the historical replication job.

Example

The last maximum saved Replication Key value for the ads table is 2017-10-01 00:00:00.

To account for the Attribution Window of 28 days, we’d subtract this from the last maximum saved Replication Key value:

2017-10-01 00:00:00 - 28 days = 2017-09-03 00:00:00

In this case, Stitch would query for and extract data that is newer than or equal to 2017-09-03 00:00:00 and older than or equal to 2017-10-01 00:00:00.

If this were a SQL query, it might look like this:

  SELECT *
    FROM ads
   WHERE updated_time >= '2017-09-03 00:00:00'
                              /* max Replication Key value - Attribution Window */
     AND updated_time <= '2017-10-01 00:00:00'
                              /* max Replication Key value from previous job */
ORDER BY updated_time

Attribution windows and row count impact

Due to the attribution window, a high Replication Frequency may not be necessary. Because Stitch will replicate data from the past N days during every replication job, recent data will be re-replicated and count towards your row quota.

To reduce your row usage and replicating redundant data, consider setting the integration to replicate less frequently. For example: every 12 or 24 hours.

Facebook Ads table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

This is the latest version of the Facebook Ads integration.

There are two types of tables in Stitch’s Facebook Ads integration: Core Object and Insights.

Core Object tables contain foundational data that’s useful for analysis. These are the adcreative, ads, adsets, and campaigns tables. To learn more about how Facebook Ads data is structured, we recommend checking out their API guide.
Insights tables contain performance data for every campaign/adset/ad combination, segmented by day and demographics specific to each table. For example: The ads_insights_age_and_gender table is segmented by day, age, and gender.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

adcreative

The adcreative table contains info about the creatives used in ads, in your Facebook Ads account.

This is a Core Object table.

Limits

Facebook’s API limits the number of ad creatives that can be retrieved through their API to 50,000, which is documented here. If you’re missing data from this table and have more than 50,000 ad creatives in your Facebook Ads account, this may be the cause of the discrepancy.

Replication Method

Full Table

Primary Key

Useful links

Facebook Ads documentation

adcreative schema on GitHub

Facebook Ads API method

adcreative table foreign keys

Join adcreative with	on
ads	adcreative.account_id = ads.account_id adcreative.adlabels.id = ads.id adcreative.id = ads.creative.creative_id
ads_insights	adcreative.account_id = ads_insights.account_id
ads_insights_age_and_gender	adcreative.account_id = ads_insights_age_and_gender.account_id
ads_insights_country	adcreative.account_id = ads_insights_country.account_id
ads_insights_dma	adcreative.account_id = ads_insights_dma.account_id
ads_insights_platform_and_device	adcreative.account_id = ads_insights_platform_and_device.account_id
ads_insights_region	adcreative.account_id = ads_insights_region.account_id
adsets	adcreative.adlabels.id = adsets.id adcreative.object_story_spec.link_data.offer_id = adsets.promoted_object.offer_id adcreative.object_story_spec.template_data.offer_id = adsets.promoted_object.offer_id adcreative.object_story_spec.video_data.offer_id = adsets.promoted_object.offer_id adcreative.object_story_spec.page_id = adsets.promoted_object.page_id adcreative.product_set_id = adsets.promoted_object.product_set_id

adcreative table schema

account_id

STRING

actor_id

STRING

adlabels

ARRAY

Click to expand adlabels

created_time

DATE-TIME

STRING

name

STRING

updated_time

DATE-TIME

applink_treatment

STRING

body

STRING

call_to_action_type

STRING

effective_instagram_story_id

STRING

effective_object_story_id

STRING

image_crops

OBJECT

Click to expand image_crops

100x100

ARRAY

100x72

ARRAY

191x100

ARRAY

400x150

ARRAY

400x500

ARRAY

600x360

ARRAY

90x160

ARRAY

image_hash

STRING

image_url

STRING

instagram_actor_id

STRING

instagram_permalink_url

STRING

instagram_story_id

STRING

link_og_id

STRING

link_url

STRING

name

STRING

object_id

STRING

object_story_id

STRING

object_story_spec

OBJECT

Click to expand object_story_spec

instagram_actor_id

STRING

link_data

OBJECT

Click to expand link_data

additional_image_index

INTEGER

app_link_spec

OBJECT

Click to expand app_link_spec

android

ARRAY

Click to expand android

app_name

STRING

class

STRING

package

STRING

url

STRING

ios

ARRAY

Click to expand ios

app_name

STRING

app_store_id

STRING

url

STRING

ipad

ARRAY

Click to expand ipad

app_name

STRING

app_store_id

STRING

url

STRING

iphone

ARRAY

Click to expand iphone

app_name

STRING

app_store_id

STRING

url

STRING

attachment_style

STRING

branded_content_sponsor_page_id

STRING

branded_content_sponsor_relationship

STRING

call_to_action

OBJECT

Click to expand call_to_action

type

STRING

value

OBJECT

Click to expand value

app_destination

STRING

app_link

STRING

application

STRING

event_id

STRING

lead_gen_form_id

STRING

link

STRING

link_caption

STRING

link_format

STRING

page

STRING

product_link

STRING

caption

STRING

child_attachments

ARRAY

Click to expand child_attachments

call_to_action

OBJECT

Click to expand call_to_action

type

STRING

value

OBJECT

Click to expand value

app_destination

STRING

app_link

STRING

application

STRING

event_id

STRING

lead_gen_form_id

STRING

link

STRING

link_caption

STRING

link_format

STRING

page

STRING

product_link

STRING

caption

STRING

description

STRING

image_crops

OBJECT

Click to expand image_crops

100x100

ARRAY

100x72

ARRAY

191x100

ARRAY

400x150

ARRAY

400x500

ARRAY

600x360

ARRAY

90x160

ARRAY

image_hash

STRING

link

STRING

name

STRING

picture

STRING

static_card

BOOLEAN

video_id

STRING

description

STRING

event_id

STRING

force_single_link

BOOLEAN

image_crops

OBJECT

Click to expand image_crops

100x100

ARRAY

100x72

ARRAY

191x100

ARRAY

400x150

ARRAY

400x500

ARRAY

600x360

ARRAY

90x160

ARRAY

image_hash

STRING

link

STRING

message

STRING

multi_share_end_card

BOOLEAN

multi_share_optimized

BOOLEAN

name

STRING

offer_id

STRING

page_welcome_message

STRING

picture

STRING

retailer_item_ids

ARRAY

show_multiple_images

BOOLEAN

page_id

STRING

photo_data

OBJECT

Click to expand photo_data

branded_content_sponsor_page_id

STRING

branded_content_sponsor_relationship

STRING

caption

STRING

image_hash

STRING

page_welcome_message

STRING

url

STRING

template_data

OBJECT

Click to expand template_data

additional_image_index

INTEGER

app_link_spec

OBJECT

Click to expand app_link_spec

android

ARRAY

Click to expand android

app_name

STRING

class

STRING

package

STRING

url

STRING

ios

ARRAY

Click to expand ios

app_name

STRING

app_store_id

STRING

url

STRING

ipad

ARRAY

Click to expand ipad

app_name

STRING

app_store_id

STRING

url

STRING

iphone

ARRAY

Click to expand iphone

app_name

STRING

app_store_id

STRING

url

STRING

attachment_style

STRING

branded_content_sponsor_page_id

STRING

branded_content_sponsor_relationship

STRING

call_to_action

OBJECT

Click to expand call_to_action

type

STRING

value

OBJECT

Click to expand value

app_destination

STRING

app_link

STRING

application

STRING

event_id

STRING

lead_gen_form_id

STRING

link

STRING

link_caption

STRING

link_format

STRING

page

STRING

product_link

STRING

caption

STRING

child_attachments

ARRAY

Click to expand child_attachments

call_to_action

OBJECT

Click to expand call_to_action

type

STRING

value

OBJECT

Click to expand value

app_destination

STRING

app_link

STRING

application

STRING

event_id

STRING

lead_gen_form_id

STRING

link

STRING

link_caption

STRING

link_format

STRING

page

STRING

product_link

STRING

caption

STRING

description

STRING

image_crops

OBJECT

Click to expand image_crops

100x100

ARRAY

100x72

ARRAY

191x100

ARRAY

400x150

ARRAY

400x500

ARRAY

600x360

ARRAY

90x160

ARRAY

image_hash

STRING

link

STRING

name

STRING

picture

STRING

static_card

BOOLEAN

video_id

STRING

description

STRING

event_id

STRING

force_single_link

BOOLEAN

image_crops

OBJECT

Click to expand image_crops

100x100

ARRAY

100x72

ARRAY

191x100

ARRAY

400x150

ARRAY

400x500

ARRAY

600x360

ARRAY

90x160

ARRAY

image_hash

STRING

link

STRING

message

STRING

multi_share_end_card

BOOLEAN

multi_share_optimized

BOOLEAN

name

STRING

offer_id

STRING

page_welcome_message

STRING

picture

STRING

retailer_item_ids

ARRAY

show_multiple_images

BOOLEAN

text_data

OBJECT

Click to expand text_data

message

STRING

video_data

OBJECT

Click to expand video_data

additional_image_index

INTEGER

branded_content_sponsor_page_id

STRING

branded_content_sponsor_relationship

STRING

call_to_action

OBJECT

Click to expand call_to_action

type

STRING

value

OBJECT

Click to expand value

app_destination

STRING

app_link

STRING

application

STRING

event_id

STRING

lead_gen_form_id

STRING

link

STRING

link_caption

STRING

link_format

STRING

page

STRING

product_link

STRING

image_hash

STRING

image_url

STRING

link_description

STRING

message

STRING

offer_id

STRING

page_welcome_message

STRING

retailer_item_ids

ARRAY

targeting

OBJECT

Click to expand targeting

age_max

INTEGER

age_min

INTEGER

app_install_state

STRING

audience_network_positions

ARRAY

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

device_platforms

ARRAY

education_statuses

ARRAY

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

excluded_geo_locations

OBJECT

Click to expand excluded_geo_locations

cities

ARRAY

Click to expand cities

country

STRING

distance_unit

STRING

key

STRING

name

STRING

radius

INTEGER

region

STRING

region_id

STRING

countries

ARRAY

country_groups

ARRAY

custom_locations

ARRAY

Click to expand custom_locations

address_string

STRING

country

STRING

distance_unit

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

primary_city_id

INTEGER

radius

INTEGER

region_id

INTEGER

geo-markets

ARRAY

Click to expand geo-markets

key

STRING

name

STRING

location_types

ARRAY

regions

ARRAY

Click to expand regions

country

STRING

key

STRING

name

STRING

zips

ARRAY

Click to expand zips

country

STRING

key

STRING

name

STRING

primary_city_id

INTEGER

region_id

INTEGER

excluded_publisher_categories

ARRAY

excluded_user_device

ARRAY

exclusions

OBJECT

Click to expand exclusions

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

education_majors

ARRAY

Click to expand education_majors

STRING

name

STRING

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

generation

ARRAY

Click to expand generation

STRING

name

STRING

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

household_composition

ARRAY

Click to expand household_composition

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

interests

ARRAY

Click to expand interests

STRING

name

STRING

life_events

ARRAY

Click to expand life_events

STRING

name

STRING

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

relationship_statuses

ARRAY

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

work_employers

ARRAY

Click to expand work_employers

STRING

name

STRING

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

facebook_positions

ARRAY

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

flexible_spec

ARRAY

Click to expand flexible_spec

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

education_majors

ARRAY

Click to expand education_majors

STRING

name

STRING

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

generation

ARRAY

Click to expand generation

STRING

name

STRING

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

household_composition

ARRAY

Click to expand household_composition

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

interests

ARRAY

Click to expand interests

STRING

name

STRING

life_events

ARRAY

Click to expand life_events

STRING

name

STRING

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

relationship_statuses

ARRAY

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

work_employers

ARRAY

Click to expand work_employers

STRING

name

STRING

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

genders

ARRAY

generation

ARRAY

Click to expand generation

STRING

name

STRING

geo_locations

OBJECT

Click to expand geo_locations

cities

ARRAY

Click to expand cities

country

STRING

distance_unit

STRING

key

STRING

name

STRING

radius

INTEGER

region

STRING

region_id

STRING

countries

ARRAY

country_groups

ARRAY

custom_locations

ARRAY

Click to expand custom_locations

address_string

STRING

country

STRING

distance_unit

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

primary_city_id

INTEGER

radius

INTEGER

region_id

INTEGER

geo-markets

ARRAY

Click to expand geo-markets

key

STRING

name

STRING

location_types

ARRAY

regions

ARRAY

Click to expand regions

country

STRING

key

STRING

name

STRING

zips

ARRAY

Click to expand zips

country

STRING

key

STRING

name

STRING

primary_city_id

INTEGER

region_id

INTEGER

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

instagram_positions

ARRAY

interested_in

ARRAY

interests

ARRAY

Click to expand interests

STRING

name

STRING

locales

ARRAY

messenger_positions

ARRAY

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

office_type

ARRAY

Click to expand office_type

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

publisher_platforms

ARRAY

relationship_statuses

ARRAY

targeting_optimization

STRING

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

user_device

ARRAY

user_os

ARRAY

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

title

STRING

video_id

STRING

object_type

STRING

object_url

STRING

product_set_id

STRING

status

STRING

template_url

STRING

template_url_spec

OBJECT

Click to expand template_url_spec

android

OBJECT

Click to expand android

app_name

STRING

package

STRING

url

STRING

config

OBJECT

Click to expand config

app_id

STRING

ios

OBJECT

Click to expand ios

app_name

STRING

app_store_id

STRING

url

STRING

ipad

OBJECT

Click to expand ipad

app_name

STRING

app_store_id

STRING

url

STRING

iphone

OBJECT

Click to expand iphone

app_name

STRING

app_store_id

STRING

url

STRING

web

OBJECT

Click to expand web

should_fallback

STRING

url

STRING

windows_phone

OBJECT

Click to expand windows_phone

app_id

STRING

app_name

STRING

url

STRING

thumbnail_url

STRING

title

STRING

url_tags

STRING

video_id

STRING

The ads table contains info about the ads in your Facebook Ads account.

This is a Core Object table.

updated_time and querying

Because this table uses 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_time timestamp.

Deleted ads

If the Include data from deleted campaigns, ads, and adsets box in the integration’s settings is checked, this table will include data for deleted ads.

Replication Method	Key-based Incremental
Primary Keys	id updated_time
Replication Key	updated_time
Useful links	Facebook Ads documentation ads schema on GitHub Facebook Ads API method

ads table foreign keys

Join ads with	on
adcreative	ads.account_id = adcreative.account_id ads.id = adcreative.adlabels.id ads.creative.creative_id = adcreative.id
ads_insights	ads.account_id = ads_insights.account_id ads.adset_id = ads_insights.adset_id ads.id = ads_insights.ad_id ads.campaign_id = ads_insights.campaign_id
ads_insights_age_and_gender	ads.account_id = ads_insights_age_and_gender.account_id ads.adset_id = ads_insights_age_and_gender.adset_id ads.id = ads_insights_age_and_gender.ad_id ads.campaign_id = ads_insights_age_and_gender.campaign_id
ads_insights_country	ads.account_id = ads_insights_country.account_id ads.adset_id = ads_insights_country.adset_id ads.id = ads_insights_country.ad_id ads.campaign_id = ads_insights_country.campaign_id
ads_insights_dma	ads.account_id = ads_insights_dma.account_id ads.adset_id = ads_insights_dma.adset_id ads.id = ads_insights_dma.ad_id ads.campaign_id = ads_insights_dma.campaign_id
ads_insights_platform_and_device	ads.account_id = ads_insights_platform_and_device.account_id ads.adset_id = ads_insights_platform_and_device.adset_id ads.id = ads_insights_platform_and_device.ad_id ads.campaign_id = ads_insights_platform_and_device.campaign_id
ads_insights_region	ads.account_id = ads_insights_region.account_id ads.adset_id = ads_insights_region.adset_id ads.id = ads_insights_region.ad_id ads.campaign_id = ads_insights_region.campaign_id
adsets	ads.id = adsets.id ads.adset_id = adsets.id
campaigns	ads.id = campaigns.ads.data.id ads.campaign_id = campaigns.id

ads table schema

account_id

STRING

adlabels

ARRAY

Click to expand adlabels

created_time

DATE-TIME

STRING

name

STRING

updated_time

DATE-TIME

adset_id

STRING

bid_amount

INTEGER

bid_info

OBJECT

Click to expand bid_info

ACTIONS

INTEGER

CLICKS

INTEGER

IMPRESSIONS

INTEGER

REACH

INTEGER

SOCIAL

INTEGER

bid_type

STRING

campaign_id

STRING

conversion_specs

ARRAY

Click to expand conversion_specs

action.type

ARRAY

application

ARRAY

conversion_id

ARRAY

creative

ARRAY

dataset

ARRAY

event

ARRAY

event.creator

ARRAY

event_type

ARRAY

fb_pixel

ARRAY

fb_pixel_event

ARRAY

leadgen

ARRAY

object

ARRAY

object.domain

ARRAY

offer

ARRAY

offer.creator

ARRAY

offsite_pixel

ARRAY

page

ARRAY

page.parent

ARRAY

post

ARRAY

post.object

ARRAY

post.object.wall

ARRAY

post.wall

ARRAY

question

ARRAY

question.creator

ARRAY

response

ARRAY

subtype

ARRAY

created_time

DATE-TIME

creative

OBJECT

Click to expand creative

creative_id

STRING

effective_status

STRING

last_updated_by_app_id

STRING

name

STRING

recommendations

ARRAY

Click to expand recommendations

blame_field

STRING

code

INTEGER

confidence

STRING

importance

STRING

message

STRING

title

STRING

source_ad_id

STRING

status

STRING

targeting

OBJECT

Click to expand targeting

age_max

INTEGER

age_min

INTEGER

app_install_state

STRING

audience_network_positions

ARRAY

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

device_platforms

ARRAY

education_statuses

ARRAY

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

excluded_geo_locations

OBJECT

Click to expand excluded_geo_locations

cities

ARRAY

Click to expand cities

country

STRING

distance_unit

STRING

key

STRING

name

STRING

radius

INTEGER

region

STRING

region_id

STRING

countries

ARRAY

country_groups

ARRAY

custom_locations

ARRAY

Click to expand custom_locations

address_string

STRING

country

STRING

distance_unit

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

primary_city_id

INTEGER

radius

INTEGER

region_id

INTEGER

geo-markets

ARRAY

Click to expand geo-markets

key

STRING

name

STRING

location_types

ARRAY

regions

ARRAY

Click to expand regions

country

STRING

key

STRING

name

STRING

zips

ARRAY

Click to expand zips

country

STRING

key

STRING

name

STRING

primary_city_id

INTEGER

region_id

INTEGER

excluded_publisher_categories

ARRAY

excluded_user_device

ARRAY

exclusions

OBJECT

Click to expand exclusions

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

education_majors

ARRAY

Click to expand education_majors

STRING

name

STRING

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

generation

ARRAY

Click to expand generation

STRING

name

STRING

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

household_composition

ARRAY

Click to expand household_composition

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

interests

ARRAY

Click to expand interests

STRING

name

STRING

life_events

ARRAY

Click to expand life_events

STRING

name

STRING

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

relationship_statuses

ARRAY

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

work_employers

ARRAY

Click to expand work_employers

STRING

name

STRING

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

facebook_positions

ARRAY

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

flexible_spec

ARRAY

Click to expand flexible_spec

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

education_majors

ARRAY

Click to expand education_majors

STRING

name

STRING

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

generation

ARRAY

Click to expand generation

STRING

name

STRING

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

household_composition

ARRAY

Click to expand household_composition

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

interests

ARRAY

Click to expand interests

STRING

name

STRING

life_events

ARRAY

Click to expand life_events

STRING

name

STRING

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

relationship_statuses

ARRAY

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

work_employers

ARRAY

Click to expand work_employers

STRING

name

STRING

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

genders

ARRAY

generation

ARRAY

Click to expand generation

STRING

name

STRING

geo_locations

OBJECT

Click to expand geo_locations

cities

ARRAY

Click to expand cities

country

STRING

distance_unit

STRING

key

STRING

name

STRING

radius

INTEGER

region

STRING

region_id

STRING

countries

ARRAY

country_groups

ARRAY

custom_locations

ARRAY

Click to expand custom_locations

address_string

STRING

country

STRING

distance_unit

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

primary_city_id

INTEGER

radius

INTEGER

region_id

INTEGER

geo-markets

ARRAY

Click to expand geo-markets

key

STRING

name

STRING

location_types

ARRAY

regions

ARRAY

Click to expand regions

country

STRING

key

STRING

name

STRING

zips

ARRAY

Click to expand zips

country

STRING

key

STRING

name

STRING

primary_city_id

INTEGER

region_id

INTEGER

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

instagram_positions

ARRAY

interested_in

ARRAY

interests

ARRAY

Click to expand interests

STRING

name

STRING

locales

ARRAY

messenger_positions

ARRAY

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

office_type

ARRAY

Click to expand office_type

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

publisher_platforms

ARRAY

relationship_statuses

ARRAY

targeting_optimization

STRING

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

user_device

ARRAY

user_os

ARRAY

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

tracking_specs

ARRAY

Click to expand tracking_specs

action.type

ARRAY

application

ARRAY

conversion_id

ARRAY

creative

ARRAY

dataset

ARRAY

event

ARRAY

event.creator

ARRAY

event_type

ARRAY

fb_pixel

ARRAY

fb_pixel_event

ARRAY

leadgen

ARRAY

object

ARRAY

object.domain

ARRAY

offer

ARRAY

offer.creator

ARRAY

offsite_pixel

ARRAY

page

ARRAY

page.parent

ARRAY

post

ARRAY

post.object

ARRAY

post.object.wall

ARRAY

post.wall

ARRAY

question

ARRAY

question.creator

ARRAY

response

ARRAY

subtype

ARRAY

updated_time

DATE-TIME

ads_insights

The ads_insights table contains entries for each campaign/set/ad combination for each day, along with detailed statistics.

Note: Data for deleted ads, adsets, and campaigns will not appear in this table even if the Include data from deleted campaigns, ads, and adsets option in the integration’s settings is enabled.

Segmented insights data

To analyze data that’s been segmented by various characteristics, consider tracking some of the other ads_insights tables in this integration. The following tables contain the same fields as this one (ads_insights), but include additional dimensions to segment the data:

ads_insights_age_and_gender - Data segmented by age and gender
ads_insights_country - Data segmented by country
ads_insights_dma - Data segmented by DMA (Designated Market Area)
ads_insights_platform_and_device - Data segmented by platform and device
ads_insights_region - Data segmented by region

Replication Method	Key-based Incremental
Primary Keys	ad_id adset_id campaign_id date_start
Replication Key	date_start
Useful links	Facebook Ads documentation ads_insights schema on GitHub

ads_insights table foreign keys

Join ads_insights with	on
adcreative	ads_insights.account_id = adcreative.account_id
ads	ads_insights.account_id = ads.account_id ads_insights.adset_id = ads.adset_id ads_insights.ad_id = ads.id ads_insights.campaign_id = ads.campaign_id
ads_insights_age_and_gender	ads_insights.account_id = ads_insights_age_and_gender.account_id ads_insights.adset_id = ads_insights_age_and_gender.adset_id ads_insights.ad_id = ads_insights_age_and_gender.ad_id ads_insights.campaign_id = ads_insights_age_and_gender.campaign_id
ads_insights_country	ads_insights.account_id = ads_insights_country.account_id ads_insights.adset_id = ads_insights_country.adset_id ads_insights.ad_id = ads_insights_country.ad_id ads_insights.campaign_id = ads_insights_country.campaign_id
ads_insights_dma	ads_insights.account_id = ads_insights_dma.account_id ads_insights.adset_id = ads_insights_dma.adset_id ads_insights.ad_id = ads_insights_dma.ad_id ads_insights.campaign_id = ads_insights_dma.campaign_id
ads_insights_platform_and_device	ads_insights.account_id = ads_insights_platform_and_device.account_id ads_insights.adset_id = ads_insights_platform_and_device.adset_id ads_insights.ad_id = ads_insights_platform_and_device.ad_id ads_insights.campaign_id = ads_insights_platform_and_device.campaign_id
ads_insights_region	ads_insights.account_id = ads_insights_region.account_id ads_insights.adset_id = ads_insights_region.adset_id ads_insights.ad_id = ads_insights_region.ad_id ads_insights.campaign_id = ads_insights_region.campaign_id
adsets	ads_insights.adset_id = adsets.id
campaigns	ads_insights.ad_id = campaigns.ads.data.id ads_insights.campaign_id = campaigns.id

ads_insights table schema

account_id

STRING

account_name

STRING

action_values

ARRAY

Click to expand action_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

actions

ARRAY

Click to expand actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMBER

canvas_avg_view_time

NUMBER

clicks

INTEGER

conversion_rate_ranking

STRING

conversion_values

ARRAY

Click to expand conversion_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

conversions

ARRAY

Click to expand conversions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_action_type

ARRAY

Click to expand cost_per_action_type

action_type

STRING

value

STRING

cost_per_inline_link_click

NUMBER

cost_per_inline_post_engagement

NUMBER

cost_per_unique_action_type

ARRAY

Click to expand cost_per_unique_action_type

action_type

STRING

value

STRING

cost_per_unique_click

NUMBER

cost_per_unique_inline_link_click

NUMBER

cpc

NUMBER

cpm

NUMBER

cpp

NUMBER

ctr

NUMBER

date_start

DATE-TIME

date_stop

DATE-TIME

engagement_rate_ranking

STRING

frequency

NUMBER

impressions

INTEGER

inline_link_click_ctr

NUMBER

inline_link_clicks

INTEGER

inline_post_engagement

INTEGER

objective

STRING

outbound_clicks

ARRAY

Click to expand outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

quality_ranking

STRING

reach

INTEGER

social_spend

NUMBER

spend

NUMBER

unique_actions

ARRAY

Click to expand unique_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

unique_clicks

INTEGER

unique_ctr

NUMBER

unique_inline_link_click_ctr

NUMBER

unique_inline_link_clicks

INTEGER

unique_link_clicks_ctr

NUMBER

unique_outbound_clicks

ARRAY

Click to expand unique_outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_30_sec_watched_actions

ARRAY

Click to expand video_30_sec_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p100_watched_actions

ARRAY

Click to expand video_p100_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p25_watched_actions

ARRAY

Click to expand video_p25_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p50_watched_actions

ARRAY

Click to expand video_p50_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p75_watched_actions

ARRAY

Click to expand video_p75_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_play_curve_actions

ARRAY

Click to expand video_play_curve_actions

action_type

STRING

value

ARRAY

website_ctr

ARRAY

Click to expand website_ctr

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ads_insights_age_and_gender

The ads_insights_age_and_gender table contains entries for each campaign/set/ad combination for each day, along with detailed statistics, segmented by age and gender.

This table contains the same fields as the ads_insights table, with the exception of age and gender.

Replication Method	Key-based Incremental
Primary Keys	ad_id adset_id campaign_id date_start age gender
Replication Key	date_start
Useful links	Facebook Ads documentation ads_insights_age_and_gender schema on GitHub

ads_insights_age_and_gender table foreign keys

Join ads_insights_age_and_gender with	on
adcreative	ads_insights_age_and_gender.account_id = adcreative.account_id
ads	ads_insights_age_and_gender.account_id = ads.account_id ads_insights_age_and_gender.adset_id = ads.adset_id ads_insights_age_and_gender.ad_id = ads.id ads_insights_age_and_gender.campaign_id = ads.campaign_id
ads_insights	ads_insights_age_and_gender.account_id = ads_insights.account_id ads_insights_age_and_gender.adset_id = ads_insights.adset_id ads_insights_age_and_gender.ad_id = ads_insights.ad_id ads_insights_age_and_gender.campaign_id = ads_insights.campaign_id
ads_insights_country	ads_insights_age_and_gender.account_id = ads_insights_country.account_id ads_insights_age_and_gender.adset_id = ads_insights_country.adset_id ads_insights_age_and_gender.ad_id = ads_insights_country.ad_id ads_insights_age_and_gender.campaign_id = ads_insights_country.campaign_id
ads_insights_dma	ads_insights_age_and_gender.account_id = ads_insights_dma.account_id ads_insights_age_and_gender.adset_id = ads_insights_dma.adset_id ads_insights_age_and_gender.ad_id = ads_insights_dma.ad_id ads_insights_age_and_gender.campaign_id = ads_insights_dma.campaign_id
ads_insights_platform_and_device	ads_insights_age_and_gender.account_id = ads_insights_platform_and_device.account_id ads_insights_age_and_gender.adset_id = ads_insights_platform_and_device.adset_id ads_insights_age_and_gender.ad_id = ads_insights_platform_and_device.ad_id ads_insights_age_and_gender.campaign_id = ads_insights_platform_and_device.campaign_id
ads_insights_region	ads_insights_age_and_gender.account_id = ads_insights_region.account_id ads_insights_age_and_gender.adset_id = ads_insights_region.adset_id ads_insights_age_and_gender.ad_id = ads_insights_region.ad_id ads_insights_age_and_gender.campaign_id = ads_insights_region.campaign_id
adsets	ads_insights_age_and_gender.adset_id = adsets.id
campaigns	ads_insights_age_and_gender.ad_id = campaigns.ads.data.id ads_insights_age_and_gender.campaign_id = campaigns.id

ads_insights_age_and_gender table schema

account_id

STRING

account_name

STRING

action_values

ARRAY

Click to expand action_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

actions

ARRAY

Click to expand actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

age

INTEGER, STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMBER

canvas_avg_view_time

NUMBER

clicks

INTEGER

conversion_rate_ranking

STRING

conversion_values

ARRAY

Click to expand conversion_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

conversions

ARRAY

Click to expand conversions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_action_type

ARRAY

Click to expand cost_per_action_type

action_type

STRING

value

STRING

cost_per_inline_link_click

NUMBER

cost_per_inline_post_engagement

NUMBER

cost_per_unique_action_type

ARRAY

Click to expand cost_per_unique_action_type

action_type

STRING

value

STRING

cost_per_unique_click

NUMBER

cost_per_unique_inline_link_click

NUMBER

cpc

NUMBER

cpm

NUMBER

cpp

NUMBER

ctr

NUMBER

date_start

DATE-TIME

date_stop

DATE-TIME

engagement_rate_ranking

STRING

frequency

NUMBER

gender

STRING

impressions

INTEGER

inline_link_click_ctr

NUMBER

inline_link_clicks

INTEGER

inline_post_engagement

INTEGER

objective

STRING

outbound_clicks

ARRAY

Click to expand outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

quality_ranking

STRING

reach

INTEGER

social_spend

NUMBER

spend

NUMBER

unique_actions

ARRAY

Click to expand unique_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

unique_clicks

INTEGER

unique_ctr

NUMBER

unique_inline_link_click_ctr

NUMBER

unique_inline_link_clicks

INTEGER

unique_link_clicks_ctr

NUMBER

unique_outbound_clicks

ARRAY

Click to expand unique_outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_30_sec_watched_actions

ARRAY

Click to expand video_30_sec_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p100_watched_actions

ARRAY

Click to expand video_p100_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p25_watched_actions

ARRAY

Click to expand video_p25_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p50_watched_actions

ARRAY

Click to expand video_p50_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p75_watched_actions

ARRAY

Click to expand video_p75_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_play_curve_actions

ARRAY

Click to expand video_play_curve_actions

action_type

STRING

value

ARRAY

website_ctr

ARRAY

Click to expand website_ctr

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ads_insights_country

The ads_insights_country table contains entries for each campaign/set/ad combination for each day, along with detailed statistics, segmented by country.

This table contains the same fields as the ads_insights table, with the exception of country.

Replication Method	Key-based Incremental
Primary Keys	ad_id adset_id campaign_id date_start country
Replication Key	date_start
Useful links	Facebook Ads documentation ads_insights_country schema on GitHub

ads_insights_country table foreign keys

Join ads_insights_country with	on
adcreative	ads_insights_country.account_id = adcreative.account_id
ads	ads_insights_country.account_id = ads.account_id ads_insights_country.adset_id = ads.adset_id ads_insights_country.ad_id = ads.id ads_insights_country.campaign_id = ads.campaign_id
ads_insights	ads_insights_country.account_id = ads_insights.account_id ads_insights_country.adset_id = ads_insights.adset_id ads_insights_country.ad_id = ads_insights.ad_id ads_insights_country.campaign_id = ads_insights.campaign_id
ads_insights_age_and_gender	ads_insights_country.account_id = ads_insights_age_and_gender.account_id ads_insights_country.adset_id = ads_insights_age_and_gender.adset_id ads_insights_country.ad_id = ads_insights_age_and_gender.ad_id ads_insights_country.campaign_id = ads_insights_age_and_gender.campaign_id
ads_insights_dma	ads_insights_country.account_id = ads_insights_dma.account_id ads_insights_country.adset_id = ads_insights_dma.adset_id ads_insights_country.ad_id = ads_insights_dma.ad_id ads_insights_country.campaign_id = ads_insights_dma.campaign_id
ads_insights_platform_and_device	ads_insights_country.account_id = ads_insights_platform_and_device.account_id ads_insights_country.adset_id = ads_insights_platform_and_device.adset_id ads_insights_country.ad_id = ads_insights_platform_and_device.ad_id ads_insights_country.campaign_id = ads_insights_platform_and_device.campaign_id
ads_insights_region	ads_insights_country.account_id = ads_insights_region.account_id ads_insights_country.adset_id = ads_insights_region.adset_id ads_insights_country.ad_id = ads_insights_region.ad_id ads_insights_country.campaign_id = ads_insights_region.campaign_id
adsets	ads_insights_country.adset_id = adsets.id
campaigns	ads_insights_country.ad_id = campaigns.ads.data.id ads_insights_country.campaign_id = campaigns.id

ads_insights_country table schema

account_id

STRING

account_name

STRING

action_values

ARRAY

Click to expand action_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

actions

ARRAY

Click to expand actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMBER

canvas_avg_view_time

NUMBER

clicks

INTEGER

conversion_rate_ranking

STRING

conversion_values

ARRAY

Click to expand conversion_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

conversions

ARRAY

Click to expand conversions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_action_type

ARRAY

Click to expand cost_per_action_type

action_type

STRING

value

STRING

cost_per_inline_link_click

NUMBER

cost_per_inline_post_engagement

NUMBER

cost_per_unique_action_type

ARRAY

Click to expand cost_per_unique_action_type

action_type

STRING

value

STRING

cost_per_unique_click

NUMBER

cost_per_unique_inline_link_click

NUMBER

country

STRING

cpc

NUMBER

cpm

NUMBER

cpp

NUMBER

ctr

NUMBER

date_start

DATE-TIME

date_stop

DATE-TIME

engagement_rate_ranking

STRING

frequency

NUMBER

impressions

INTEGER

inline_link_click_ctr

NUMBER

inline_link_clicks

INTEGER

inline_post_engagement

INTEGER

objective

STRING

outbound_clicks

ARRAY

Click to expand outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

quality_ranking

STRING

reach

INTEGER

social_spend

NUMBER

spend

NUMBER

unique_actions

ARRAY

Click to expand unique_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

unique_clicks

INTEGER

unique_ctr

NUMBER

unique_inline_link_click_ctr

NUMBER

unique_inline_link_clicks

INTEGER

unique_link_clicks_ctr

NUMBER

unique_outbound_clicks

ARRAY

Click to expand unique_outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_30_sec_watched_actions

ARRAY

Click to expand video_30_sec_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p100_watched_actions

ARRAY

Click to expand video_p100_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p25_watched_actions

ARRAY

Click to expand video_p25_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p50_watched_actions

ARRAY

Click to expand video_p50_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p75_watched_actions

ARRAY

Click to expand video_p75_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_play_curve_actions

ARRAY

Click to expand video_play_curve_actions

action_type

STRING

value

ARRAY

website_ctr

ARRAY

Click to expand website_ctr

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ads_insights_dma

The ads_insights_dma table contains entries for each campaign/set/ad combination for each day, along with detailed statistics, segmented by DMA (Designated Market Area).

This table contains the same fields as the ads_insights table, with the exception of dma.

Replication Method	Key-based Incremental
Primary Keys	ad_id adset_id campaign_id dma date_start
Replication Key	date_start
Useful links	Facebook Ads documentation ads_insights_dma schema on GitHub

ads_insights_dma table foreign keys

Join ads_insights_dma with	on
adcreative	ads_insights_dma.account_id = adcreative.account_id
ads	ads_insights_dma.account_id = ads.account_id ads_insights_dma.adset_id = ads.adset_id ads_insights_dma.ad_id = ads.id ads_insights_dma.campaign_id = ads.campaign_id
ads_insights	ads_insights_dma.account_id = ads_insights.account_id ads_insights_dma.adset_id = ads_insights.adset_id ads_insights_dma.ad_id = ads_insights.ad_id ads_insights_dma.campaign_id = ads_insights.campaign_id
ads_insights_age_and_gender	ads_insights_dma.account_id = ads_insights_age_and_gender.account_id ads_insights_dma.adset_id = ads_insights_age_and_gender.adset_id ads_insights_dma.ad_id = ads_insights_age_and_gender.ad_id ads_insights_dma.campaign_id = ads_insights_age_and_gender.campaign_id
ads_insights_country	ads_insights_dma.account_id = ads_insights_country.account_id ads_insights_dma.adset_id = ads_insights_country.adset_id ads_insights_dma.ad_id = ads_insights_country.ad_id ads_insights_dma.campaign_id = ads_insights_country.campaign_id
ads_insights_platform_and_device	ads_insights_dma.account_id = ads_insights_platform_and_device.account_id ads_insights_dma.adset_id = ads_insights_platform_and_device.adset_id ads_insights_dma.ad_id = ads_insights_platform_and_device.ad_id ads_insights_dma.campaign_id = ads_insights_platform_and_device.campaign_id
ads_insights_region	ads_insights_dma.account_id = ads_insights_region.account_id ads_insights_dma.adset_id = ads_insights_region.adset_id ads_insights_dma.ad_id = ads_insights_region.ad_id ads_insights_dma.campaign_id = ads_insights_region.campaign_id
adsets	ads_insights_dma.adset_id = adsets.id
campaigns	ads_insights_dma.ad_id = campaigns.ads.data.id ads_insights_dma.campaign_id = campaigns.id

ads_insights_dma table schema

account_id

STRING

account_name

STRING

action_values

ARRAY

Click to expand action_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

actions

ARRAY

Click to expand actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMBER

canvas_avg_view_time

NUMBER

clicks

INTEGER

conversion_rate_ranking

STRING

conversion_values

ARRAY

Click to expand conversion_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

conversions

ARRAY

Click to expand conversions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_action_type

ARRAY

Click to expand cost_per_action_type

action_type

STRING

value

STRING

cost_per_inline_link_click

NUMBER

cost_per_inline_post_engagement

NUMBER

cost_per_unique_action_type

ARRAY

Click to expand cost_per_unique_action_type

action_type

STRING

value

STRING

cost_per_unique_click

NUMBER

cost_per_unique_inline_link_click

NUMBER

cpc

NUMBER

cpm

NUMBER

cpp

NUMBER

ctr

NUMBER

date_start

DATE-TIME

date_stop

DATE-TIME

dma

STRING

engagement_rate_ranking

STRING

frequency

NUMBER

impressions

INTEGER

inline_link_click_ctr

NUMBER

inline_link_clicks

INTEGER

inline_post_engagement

INTEGER

objective

STRING

outbound_clicks

ARRAY

Click to expand outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

quality_ranking

STRING

reach

INTEGER

social_spend

NUMBER

spend

NUMBER

unique_actions

ARRAY

Click to expand unique_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

unique_clicks

INTEGER

unique_ctr

NUMBER

unique_inline_link_click_ctr

NUMBER

unique_inline_link_clicks

INTEGER

unique_link_clicks_ctr

NUMBER

unique_outbound_clicks

ARRAY

Click to expand unique_outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_30_sec_watched_actions

ARRAY

Click to expand video_30_sec_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p100_watched_actions

ARRAY

Click to expand video_p100_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p25_watched_actions

ARRAY

Click to expand video_p25_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p50_watched_actions

ARRAY

Click to expand video_p50_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p75_watched_actions

ARRAY

Click to expand video_p75_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_play_curve_actions

ARRAY

Click to expand video_play_curve_actions

action_type

STRING

value

ARRAY

website_ctr

ARRAY

Click to expand website_ctr

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ads_insights_hourly_advertiser

The ads_insights_hourly_advertiser table contains entries for each campaign/set/ad combination for each day, along with detailed statistics, segmented by audience and advertiser time zones. This table contains the same fields as the ads_insights table, with the exception of hourly_stats_aggregated_by_advertiser_time_zone.

Replication Method	Key-based Incremental
Primary Keys	hourly_stats_aggregated_by_advertiser_time_zone ad_id adset_id campaign_id date_start
Replication Key	date_start
Useful links	Facebook Ads documentation ads_insights_hourly_advertiser schema on GitHub

ads_insights_hourly_advertiser table schema

account_currency

STRING

account_id

STRING

account_name

STRING

action_values

ARRAY

Click to expand action_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

actions

ARRAY

Click to expand actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

attribution_setting

STRING

buying_type

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

STRING

canvas_avg_view_time

STRING

catalog_segment_value

ARRAY

Click to expand catalog_segment_value

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

clicks

STRING

conversion_rate_ranking

STRING

conversion_values

ARRAY

Click to expand conversion_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

conversions

ARRAY

Click to expand conversions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

converted_product_quantity

ARRAY

Click to expand converted_product_quantity

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

converted_product_value

ARRAY

Click to expand converted_product_value

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_action_type

ARRAY

Click to expand cost_per_action_type

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_conversion

ARRAY

Click to expand cost_per_conversion

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_estimated_ad_recallers

STRING

cost_per_inline_link_click

STRING

cost_per_inline_post_engagement

STRING

cost_per_outbound_click

ARRAY

Click to expand cost_per_outbound_click

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_thruplay

ARRAY

Click to expand cost_per_thruplay

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_unique_action_type

ARRAY

Click to expand cost_per_unique_action_type

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_unique_click

STRING

cost_per_unique_inline_link_click

STRING

cost_per_unique_outbound_click

ARRAY

Click to expand cost_per_unique_outbound_click

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cpc

STRING

cpm

STRING

cpp

STRING

ctr

STRING

date_start

DATE-TIME

date_stop

DATE-TIME

engagement_rate_ranking

STRING

estimated_ad_recall_rate

STRING

estimated_ad_recallers

STRING

frequency

STRING

full_view_impressions

STRING

hourly_stats_aggregated_by_advertiser_time_zone

STRING

impressions

STRING

inline_link_click_ctr

STRING

inline_link_clicks

STRING

inline_post_engagement

STRING

instant_experience_clicks_to_open

STRING

instant_experience_clicks_to_start

STRING

instant_experience_outbound_clicks

STRING

mobile_app_purchase_roas

ARRAY

Click to expand mobile_app_purchase_roas

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

objective

STRING

optimization_goal

STRING

outbound_clicks

ARRAY

Click to expand outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

outbound_clicks_ctr

ARRAY

Click to expand outbound_clicks_ctr

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

place_page_name

STRING

purchase_roas

ARRAY

Click to expand purchase_roas

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

qualifying_question_qualify_answer_rate

STRING

quality_ranking

STRING

reach

STRING

social_spend

STRING

spend

STRING

website_ctr

ARRAY

Click to expand website_ctr

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

website_purchase_roas

ARRAY

Click to expand website_purchase_roas

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ads_insights_platform_and_device

The ads_insights_country table contains entries for each campaign/set/ad combination for each day, along with detailed statistics, segmented by publisher platform, platform position, and device.

This table contains the same fields as the ads_insights table, with the exception of the following fields:

publisher_platform
platform_position
impression_device

Replication Method	Key-based Incremental
Primary Keys	ad_id adset_id campaign_id date_start publisher_platform platform_position impression_device
Replication Key	date_start
Useful links	Facebook Ads documentation ads_insights_platform_and_device schema on GitHub

ads_insights_platform_and_device table foreign keys

Join ads_insights_platform_and_device with	on
adcreative	ads_insights_platform_and_device.account_id = adcreative.account_id
ads	ads_insights_platform_and_device.account_id = ads.account_id ads_insights_platform_and_device.adset_id = ads.adset_id ads_insights_platform_and_device.ad_id = ads.id ads_insights_platform_and_device.campaign_id = ads.campaign_id
ads_insights	ads_insights_platform_and_device.account_id = ads_insights.account_id ads_insights_platform_and_device.adset_id = ads_insights.adset_id ads_insights_platform_and_device.ad_id = ads_insights.ad_id ads_insights_platform_and_device.campaign_id = ads_insights.campaign_id
ads_insights_age_and_gender	ads_insights_platform_and_device.account_id = ads_insights_age_and_gender.account_id ads_insights_platform_and_device.adset_id = ads_insights_age_and_gender.adset_id ads_insights_platform_and_device.ad_id = ads_insights_age_and_gender.ad_id ads_insights_platform_and_device.campaign_id = ads_insights_age_and_gender.campaign_id
ads_insights_country	ads_insights_platform_and_device.account_id = ads_insights_country.account_id ads_insights_platform_and_device.adset_id = ads_insights_country.adset_id ads_insights_platform_and_device.ad_id = ads_insights_country.ad_id ads_insights_platform_and_device.campaign_id = ads_insights_country.campaign_id
ads_insights_dma	ads_insights_platform_and_device.account_id = ads_insights_dma.account_id ads_insights_platform_and_device.adset_id = ads_insights_dma.adset_id ads_insights_platform_and_device.ad_id = ads_insights_dma.ad_id ads_insights_platform_and_device.campaign_id = ads_insights_dma.campaign_id
ads_insights_region	ads_insights_platform_and_device.account_id = ads_insights_region.account_id ads_insights_platform_and_device.adset_id = ads_insights_region.adset_id ads_insights_platform_and_device.ad_id = ads_insights_region.ad_id ads_insights_platform_and_device.campaign_id = ads_insights_region.campaign_id
adsets	ads_insights_platform_and_device.adset_id = adsets.id
campaigns	ads_insights_platform_and_device.ad_id = campaigns.ads.data.id ads_insights_platform_and_device.campaign_id = campaigns.id

ads_insights_platform_and_device table schema

account_id

STRING

account_name

STRING

action_values

ARRAY

Click to expand action_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

actions

ARRAY

Click to expand actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMBER

canvas_avg_view_time

NUMBER

clicks

INTEGER

conversion_rate_ranking

STRING

conversion_values

ARRAY

Click to expand conversion_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

conversions

ARRAY

Click to expand conversions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_action_type

ARRAY

Click to expand cost_per_action_type

action_type

STRING

value

STRING

cost_per_inline_link_click

NUMBER

cost_per_inline_post_engagement

NUMBER

cost_per_unique_action_type

ARRAY

Click to expand cost_per_unique_action_type

action_type

STRING

value

STRING

cost_per_unique_click

NUMBER

cost_per_unique_inline_link_click

NUMBER

cpc

NUMBER

cpm

NUMBER

cpp

NUMBER

ctr

NUMBER

date_start

DATE-TIME

date_stop

DATE-TIME

engagement_rate_ranking

STRING

frequency

NUMBER

impression_device

STRING

impressions

INTEGER

inline_link_click_ctr

NUMBER

inline_link_clicks

INTEGER

inline_post_engagement

INTEGER

objective

STRING

outbound_clicks

ARRAY

Click to expand outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

placement

STRING

platform_position

STRING

publisher_platform

STRING

quality_ranking

STRING

reach

INTEGER

social_spend

NUMBER

spend

NUMBER

unique_actions

ARRAY

Click to expand unique_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

unique_clicks

INTEGER

unique_ctr

NUMBER

unique_inline_link_click_ctr

NUMBER

unique_inline_link_clicks

INTEGER

unique_link_clicks_ctr

NUMBER

unique_outbound_clicks

ARRAY

Click to expand unique_outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_30_sec_watched_actions

ARRAY

Click to expand video_30_sec_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p100_watched_actions

ARRAY

Click to expand video_p100_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p25_watched_actions

ARRAY

Click to expand video_p25_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p50_watched_actions

ARRAY

Click to expand video_p50_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p75_watched_actions

ARRAY

Click to expand video_p75_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_play_curve_actions

ARRAY

Click to expand video_play_curve_actions

action_type

STRING

value

ARRAY

website_ctr

ARRAY

Click to expand website_ctr

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ads_insights_region

The ads_insights_region table contains entries for each campaign/set/ad combination for each day, along with detailed statistics, segmented by region. This table enables you to view your data by the region (ex: state or province) where people live or were located when they saw your ads, depending on how the location targeting was set.

This table contains the same fields as the ads_insights table, with the exception of region.

Replication Method	Key-based Incremental
Primary Keys	ad_id adset_id campaign_id date_start region
Replication Key	date_start
Useful links	Facebook Ads documentation ads_insights_region schema on GitHub

ads_insights_region table foreign keys

Join ads_insights_region with	on
adcreative	ads_insights_region.account_id = adcreative.account_id
ads	ads_insights_region.account_id = ads.account_id ads_insights_region.adset_id = ads.adset_id ads_insights_region.ad_id = ads.id ads_insights_region.campaign_id = ads.campaign_id
ads_insights	ads_insights_region.account_id = ads_insights.account_id ads_insights_region.adset_id = ads_insights.adset_id ads_insights_region.ad_id = ads_insights.ad_id ads_insights_region.campaign_id = ads_insights.campaign_id
ads_insights_age_and_gender	ads_insights_region.account_id = ads_insights_age_and_gender.account_id ads_insights_region.adset_id = ads_insights_age_and_gender.adset_id ads_insights_region.ad_id = ads_insights_age_and_gender.ad_id ads_insights_region.campaign_id = ads_insights_age_and_gender.campaign_id
ads_insights_country	ads_insights_region.account_id = ads_insights_country.account_id ads_insights_region.adset_id = ads_insights_country.adset_id ads_insights_region.ad_id = ads_insights_country.ad_id ads_insights_region.campaign_id = ads_insights_country.campaign_id
ads_insights_dma	ads_insights_region.account_id = ads_insights_dma.account_id ads_insights_region.adset_id = ads_insights_dma.adset_id ads_insights_region.ad_id = ads_insights_dma.ad_id ads_insights_region.campaign_id = ads_insights_dma.campaign_id
ads_insights_platform_and_device	ads_insights_region.account_id = ads_insights_platform_and_device.account_id ads_insights_region.adset_id = ads_insights_platform_and_device.adset_id ads_insights_region.ad_id = ads_insights_platform_and_device.ad_id ads_insights_region.campaign_id = ads_insights_platform_and_device.campaign_id
adsets	ads_insights_region.adset_id = adsets.id
campaigns	ads_insights_region.ad_id = campaigns.ads.data.id ads_insights_region.campaign_id = campaigns.id

ads_insights_region table schema

account_id

STRING

account_name

STRING

action_values

ARRAY

Click to expand action_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

actions

ARRAY

Click to expand actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

ad_id

STRING

ad_name

STRING

adset_id

STRING

adset_name

STRING

campaign_id

STRING

campaign_name

STRING

canvas_avg_view_percent

NUMBER

canvas_avg_view_time

NUMBER

clicks

INTEGER

conversion_rate_ranking

STRING

conversion_values

ARRAY

Click to expand conversion_values

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

conversions

ARRAY

Click to expand conversions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

cost_per_action_type

ARRAY

Click to expand cost_per_action_type

action_type

STRING

value

STRING

cost_per_inline_link_click

NUMBER

cost_per_inline_post_engagement

NUMBER

cost_per_unique_action_type

ARRAY

Click to expand cost_per_unique_action_type

action_type

STRING

value

STRING

cost_per_unique_click

NUMBER

cost_per_unique_inline_link_click

NUMBER

cpc

NUMBER

cpm

NUMBER

cpp

NUMBER

ctr

NUMBER

date_start

DATE-TIME

date_stop

DATE-TIME

engagement_rate_ranking

STRING

frequency

NUMBER

impressions

INTEGER

inline_link_click_ctr

NUMBER

inline_link_clicks

INTEGER

inline_post_engagement

INTEGER

objective

STRING

outbound_clicks

ARRAY

Click to expand outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

quality_ranking

STRING

reach

INTEGER

region

STRING

social_spend

NUMBER

spend

NUMBER

unique_actions

ARRAY

Click to expand unique_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

unique_clicks

INTEGER

unique_ctr

NUMBER

unique_inline_link_click_ctr

NUMBER

unique_inline_link_clicks

INTEGER

unique_link_clicks_ctr

NUMBER

unique_outbound_clicks

ARRAY

Click to expand unique_outbound_clicks

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_30_sec_watched_actions

ARRAY

Click to expand video_30_sec_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p100_watched_actions

ARRAY

Click to expand video_p100_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p25_watched_actions

ARRAY

Click to expand video_p25_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p50_watched_actions

ARRAY

Click to expand video_p50_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_p75_watched_actions

ARRAY

Click to expand video_p75_watched_actions

1d_click

NUMBER

1d_view

NUMBER

28d_click

NUMBER

28d_view

NUMBER

7d_click

NUMBER

7d_view

NUMBER

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

video_play_curve_actions

ARRAY

Click to expand video_play_curve_actions

action_type

STRING

value

ARRAY

website_ctr

ARRAY

Click to expand website_ctr

action_destination

STRING

action_target_id

STRING

action_type

STRING

value

NUMBER

adsets

The adsets table contains info about the Ad Sets in your Facebook Ads account.

This is a Core Object table.

updated_time and querying

Because this table uses 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_time timestamp.

Deleted adsets

If the Include data from deleted campaigns, ads, and adsets box in the integration’s settings is checked, this table will include data for deleted adsets.

Replication Method	Key-based Incremental
Primary Keys	id updated_time
Replication Key	updated_time
Useful links	adsets schema on GitHub Facebook Ads API method

adsets table foreign keys

Join adsets with	on
adcreative	adsets.id = adcreative.adlabels.id adsets.promoted_object.offer_id = adcreative.object_story_spec.link_data.offer_id adsets.promoted_object.offer_id = adcreative.object_story_spec.template_data.offer_id adsets.promoted_object.offer_id = adcreative.object_story_spec.video_data.offer_id adsets.promoted_object.page_id = adcreative.object_story_spec.page_id adsets.promoted_object.product_set_id = adcreative.product_set_id
ads	adsets.id = ads.id adsets.id = ads.adset_id
ads_insights	adsets.id = ads_insights.adset_id
ads_insights_age_and_gender	adsets.id = ads_insights_age_and_gender.adset_id
ads_insights_country	adsets.id = ads_insights_country.adset_id
ads_insights_dma	adsets.id = ads_insights_dma.adset_id
ads_insights_platform_and_device	adsets.id = ads_insights_platform_and_device.adset_id
ads_insights_region	adsets.id = ads_insights_region.adset_id

adsets table schema

account_id

STRING

adlabels

ARRAY

Click to expand adlabels

created_time

DATE-TIME

STRING

name

STRING

updated_time

DATE-TIME

bid_info

OBJECT

Click to expand bid_info

ACTIONS

INTEGER

CLICKS

INTEGER

IMPRESSIONS

INTEGER

REACH

INTEGER

budget_remaining

NUMBER

campaign_id

STRING

created_time

DATE-TIME

daily_budget

NUMBER

effective_status

STRING

end_time

DATE-TIME

STRING

lifetime_budget

NUMBER

name

STRING

promoted_object

OBJECT

Click to expand promoted_object

application_id

STRING

custom_event_type

STRING

object_store_url

STRING

offer_id

STRING

page_id

STRING

pixel_id

STRING

pixel_rule

STRING

product_set_id

STRING

start_time

DATE-TIME

targeting

OBJECT

Click to expand targeting

age_max

INTEGER

age_min

INTEGER

app_install_state

STRING

audience_network_positions

ARRAY

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

device_platforms

ARRAY

education_statuses

ARRAY

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

excluded_geo_locations

OBJECT

Click to expand excluded_geo_locations

cities

ARRAY

Click to expand cities

country

STRING

distance_unit

STRING

key

STRING

name

STRING

radius

INTEGER

region

STRING

region_id

STRING

countries

ARRAY

country_groups

ARRAY

custom_locations

ARRAY

Click to expand custom_locations

address_string

STRING

country

STRING

distance_unit

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

primary_city_id

INTEGER

radius

INTEGER

region_id

INTEGER

geo-markets

ARRAY

Click to expand geo-markets

key

STRING

name

STRING

location_types

ARRAY

regions

ARRAY

Click to expand regions

country

STRING

key

STRING

name

STRING

zips

ARRAY

Click to expand zips

country

STRING

key

STRING

name

STRING

primary_city_id

INTEGER

region_id

INTEGER

excluded_publisher_categories

ARRAY

excluded_user_device

ARRAY

exclusions

OBJECT

Click to expand exclusions

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

education_majors

ARRAY

Click to expand education_majors

STRING

name

STRING

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

generation

ARRAY

Click to expand generation

STRING

name

STRING

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

household_composition

ARRAY

Click to expand household_composition

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

interests

ARRAY

Click to expand interests

STRING

name

STRING

life_events

ARRAY

Click to expand life_events

STRING

name

STRING

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

relationship_statuses

ARRAY

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

work_employers

ARRAY

Click to expand work_employers

STRING

name

STRING

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

facebook_positions

ARRAY

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

flexible_spec

ARRAY

Click to expand flexible_spec

behaviors

ARRAY

Click to expand behaviors

STRING

name

STRING

connections

ARRAY

Click to expand connections

STRING

name

STRING

custom_audiences

ARRAY

Click to expand custom_audiences

STRING

name

STRING

education_majors

ARRAY

Click to expand education_majors

STRING

name

STRING

excluded_connections

ARRAY

Click to expand excluded_connections

STRING

name

STRING

excluded_custom_audiences

ARRAY

Click to expand excluded_custom_audiences

STRING

name

STRING

family_statuses

ARRAY

Click to expand family_statuses

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

generation

ARRAY

Click to expand generation

STRING

name

STRING

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

household_composition

ARRAY

Click to expand household_composition

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

interests

ARRAY

Click to expand interests

STRING

name

STRING

life_events

ARRAY

Click to expand life_events

STRING

name

STRING

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

relationship_statuses

ARRAY

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

work_employers

ARRAY

Click to expand work_employers

STRING

name

STRING

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

friends_of_connections

ARRAY

Click to expand friends_of_connections

STRING

name

STRING

genders

ARRAY

generation

ARRAY

Click to expand generation

STRING

name

STRING

geo_locations

OBJECT

Click to expand geo_locations

cities

ARRAY

Click to expand cities

country

STRING

distance_unit

STRING

key

STRING

name

STRING

radius

INTEGER

region

STRING

region_id

STRING

countries

ARRAY

country_groups

ARRAY

custom_locations

ARRAY

Click to expand custom_locations

address_string

STRING

country

STRING

distance_unit

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

primary_city_id

INTEGER

radius

INTEGER

region_id

INTEGER

geo-markets

ARRAY

Click to expand geo-markets

key

STRING

name

STRING

location_types

ARRAY

regions

ARRAY

Click to expand regions

country

STRING

key

STRING

name

STRING

zips

ARRAY

Click to expand zips

country

STRING

key

STRING

name

STRING

primary_city_id

INTEGER

region_id

INTEGER

home_ownership

ARRAY

Click to expand home_ownership

STRING

name

STRING

home_type

ARRAY

Click to expand home_type

STRING

name

STRING

income

ARRAY

Click to expand income

STRING

name

STRING

industries

ARRAY

Click to expand industries

STRING

name

STRING

instagram_positions

ARRAY

interested_in

ARRAY

interests

ARRAY

Click to expand interests

STRING

name

STRING

locales

ARRAY

messenger_positions

ARRAY

moms

ARRAY

Click to expand moms

STRING

name

STRING

net_worth

ARRAY

Click to expand net_worth

STRING

name

STRING

office_type

ARRAY

Click to expand office_type

STRING

name

STRING

politics

ARRAY

Click to expand politics

STRING

name

STRING

publisher_platforms

ARRAY

relationship_statuses

ARRAY

targeting_optimization

STRING

user_adclusters

ARRAY

Click to expand user_adclusters

STRING

name

STRING

user_device

ARRAY

user_os

ARRAY

work_positions

ARRAY

Click to expand work_positions

STRING

name

STRING

updated_time

DATE-TIME

campaigns

The campaigns table contains info about the campaigns in your Facebook Ads account. Facebook defines campaigns as “a grouping of ad sets organized by the same business objective.”

This is a Core Object table.

Deleted campaigns

If the Include data from deleted campaigns, ads, and adsets box in the integration’s settings is checked, this table will include data for deleted campaigns.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_time
Useful links	Facebook Ads documentation campaigns schema on GitHub Facebook Ads API method

campaigns table foreign keys

Join campaigns with	on
ads	campaigns.ads.data.id = ads.id campaigns.id = ads.campaign_id
ads_insights	campaigns.ads.data.id = ads_insights.ad_id campaigns.id = ads_insights.campaign_id
ads_insights_age_and_gender	campaigns.ads.data.id = ads_insights_age_and_gender.ad_id campaigns.id = ads_insights_age_and_gender.campaign_id
ads_insights_country	campaigns.ads.data.id = ads_insights_country.ad_id campaigns.id = ads_insights_country.campaign_id
ads_insights_dma	campaigns.ads.data.id = ads_insights_dma.ad_id campaigns.id = ads_insights_dma.campaign_id
ads_insights_platform_and_device	campaigns.ads.data.id = ads_insights_platform_and_device.ad_id campaigns.id = ads_insights_platform_and_device.campaign_id
ads_insights_region	campaigns.ads.data.id = ads_insights_region.ad_id campaigns.id = ads_insights_region.campaign_id

campaigns table schema

account_id

STRING

adlabels

ARRAY

Click to expand adlabels

created_time

DATE-TIME

STRING

name

STRING

updated_time

DATE-TIME

ads

OBJECT

Click to expand ads

data

ARRAY

Click to expand data

STRING

buying_type

STRING

effective_status

STRING

name

STRING

objective

STRING

spend_cap

NUMBER

start_time

DATE-TIME

updated_time

DATE-TIME

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues