Release Status Released Supported By Stitch
Availability Free Status Page Facebook Ads Status Page
Default Historical Sync 1 year Default Replication Frequency 30 minutes
Whitelisting Tables and columns Destination Incompatibilities None

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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Facebook Ads icon.

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

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 Sync

The Sync Historical Data setting will define the starting date for your Facebook Ads integration. This means that:

  • For tables using Incremental Replication, data equal to or newer than this date will be replicated to your data warehouse.
  • For tables using Full Table Replication, all data - including records that are older, 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

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.

Stitch offers two methods of creating a replication schedule:

  • Replication Frequency: This method requires selecting the interval you want replication to run for the integration. Start times of replication jobs are based on the start time and duration of the previous job. Refer to the Replication Frequency documentation for more information and examples.
  • Anchor scheduling: Based on the Replication Frequency, or interval, you select, this method “anchors” the start times of this integration’s replication jobs to a time you select to create a predictable schedule. Anchor scheduling is a combination of the Anchor Time and Replication Frequency settings, which must both be defined to use this method. Additionally, note that:

    • A Replication Frequency of at least one hour is required to use anchor scheduling.
    • An initial replication job may not begin immediately after saving the integration, depending on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

To help prevent overages, 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

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

  2. Click Okay to advance through these steps.
  3. 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.

  4. 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 tables and columns to replicate

To complete the setup, you’ll need to select tables and columns you want to replicate to your data warehouse.

Check out the Schema section to learn more about the available tables in Facebook Ads and how they replicate.

  1. In the list of tables that displays - or in the Tables to Replicate tab, if you skipped this step during setup - locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A green checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Note: If you change these settings while a replication job is still in progress, they will not be used until the next job starts.

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.

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.


Facebook Ads Replication

Attribution windows and data extraction

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.

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, will define the minimum date Stitch should query for when extracting historical data. This is calculated as:

Start Date - Attribution Window = Minimum Extraction Date

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

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 help prevent overages or unnecessary re-replication, consider setting the integration to replicate less frequently. For example: every 12 or 24 hours.


Facebook Ads Table Schemas

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.

Replication Method: Full Table API Endpoint: adCreative - Reading
Primary Key : id

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

This is a Core Object table.

id
STRING

The ID of the creative.

body
STRING

The body of the ad.

image_url
STRING

The URL for the image for the creative.

account_id
STRING

The ID of the account associated with the creative.

actor_id
STRING

The actor ID (page ID) of the creative.

adLabels

Details about the ad labels applied to the creative.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named adcreative__adLabels and may contain the following attributes:

_sdc_source_key_id
STRING

The ID of the creative.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ad label ID.

created_time
DATE-TIME

The time the ad label was created.

name
STRING

The name of the ad label.

updated_time
DATE-TIME

The last time the ad label was updated.

applink_treatment
STRING

The deep link fallback behavior for dynamic product ads if the app is not installed.

branded_content_sponsor_page_id
STRING

The sponsor page ID of the creative.

call_to_action_type
STRING

The call to action button text and header text of legacy ads.

effective_instagram_story_id
STRING

The ID of the Instagram post used in the ad.

effective_object_story_id
STRING

The ID of the page post used in an ad.

title
STRING

The title for an ad link.

name
STRING

The name of the creative in the creative library.

image_crops

Details about the crop specifications (aspect ratios) for images in different ad placements.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named adcreative__image_crops and may contain the following attributes:

_sdc_source_key_id
STRING

The ID of the creative.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

100x100

The crop specification for 100x100.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data. See the Singer schema for detail on possible attributes.

100x72

The crop specification for 100x72.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data. See the Singer schema for detail on possible attributes.

191x100

The crop specification for 191x100.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data. See the Singer schema for detail on possible attributes.

400x150

The crop specification for 400x150.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data. See the Singer schema for detail on possible attributes.

400x500

The crop specification for 400x500.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data. See the Singer schema for detail on possible attributes.

600x360

The crop specification for 600x360.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data. See the Singer schema for detail on possible attributes.

90x160

The crop specification for 90x160.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data. See the Singer schema for detail on possible attributes.

instagram_actor_id
STRING

The Instagram actor ID associated with the creative.

instagram_permalink_url
STRING

The Instagram permalink associated with the creative.

instagram_story_id
STRING

The ID of the Instagram post for creating ads.

link_og_id
STRING

The Open Graph (OG) ID for the link in the creative if the landing page has OG tags.

object_id
STRING

The ID of the promoted object or object that is relevant to the ad and ad type.

object_story_id
STRING

The ID of the page post that is used in the creative.

object_story_spec__instagram_actor_id
STRING

The Instagram user that the story will be posted to.

object_story_spec__link_data__additional_image_index
INTEGER

The index (zero based) of the image from the additional images array to use as the ad image for a dynamic product ad.

object_story_spec__link_data__app_link_spec

Details about the native deeplinks attached to the post.

Stitch will replicate data for the following deeplink types:

Note: Depending on your data warehouse, a subtable for each deeplink type may be created. For example: For a type of android, a table named adcreative__object_story_spec__link_data__app_link_spec__android will be created.

object_story_spec__link_data__attachment_style
STRING

The style of the attachment.

object_story_spec__link_data__branded_content_sponsor_page_id
STRING

The ID of the branded content sponsor page.

object_story_spec__link_data__branded_content_sponsor_relationship
STRING

The branded content sponsor relationship option.

object_story_spec__link_data__call_to_action

Details about the call to action button.

object_story_spec__link_data__caption
STRING

The link caption.

object_story_spec__link_data__child_attachments

Details about the link objects required for carousel ads.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__link_data__multi_share_optimized
BOOLEAN

Indicates if orders and links are automatically selected and ordered.

object_story_spec__link_data__link
STRING

The link URL.

object_story_spec__link_data__image_crops

Details how images should be cropped.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__link_data__description
STRING

The link description.

object_story_spec__link_data__event_id
STRING

The ID of a Facebook event.

object_story_spec__link_data__force_single_link
BOOLEAN

Indicates if a post is forced to render in a single link format.

object_story_spec__link_data__multi_share_end_card
BOOLEAN

Indicates if end cards that display the page icon should not be removed.

object_story_spec__link_data__message
STRING

The main body of the post.

object_story_spec__link_data__image_hash
STRING

The hash of an image in your image library with Facebook.

object_story_spec__link_data__picture
STRING

The URL of a picture to use in the post.

object_story_spec__link_data__name
STRING

The name of the link.

object_story_spec__link_data__offer_id
STRING

The ID of a Facebook native offer.

object_story_spec__link_data__page_welcome_message
STRING

The welcome text from page to user on Messenger after a user performs a send message action on an ad.

object_story_spec__link_data__retailer_item_ids

The product IDs provided by the advertiser for collections.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__link_data__show_multiple_images
BOOLEAN

Used with force_single_link (true) to show a single dynamic item in carousel format using multiple images from the catalog.

object_story_spec__page_id
STRING

The ID of a Facebook page.

object_story_spec__photo_data__branded_content_sponsor_page_id
STRING

The ID of the branded content sponsor page ID.

object_story_spec__photo_data__branded_content_sponsor_relationship
STRING

The branded content sponsor relationship option.

object_story_spec__photo_data__caption
STRING

The description of the image.

object_story_spec__photo_data__image_hash
STRING

The hash of the image in your image library with Facebook.

object_story_spec__photo_data__page_welcome_message
STRING

The welcome text from page to user on Messenger once a user performs a send message action on an ad.

object_story_spec__photo_data__url
STRING

The URL of an image to use in the ad.

object_story_spec__template_data__additional_image_index
INTEGER

The index (zero based) of the image from the additional images array to use as the ad image for a dynamic product ad.

object_story_spec__template_data__app_link_spec

Details about the native deeplinks attached to the post.

Stitch will replicate data for the following deeplink types:

Note: Depending on your data warehouse, a subtable for each deeplink type may be created. For example: For a type of android, a table named adcreative__object_story_spec__template_data__app_link_spec__android will be created.

object_story_spec__template_data__attachment_style
STRING

The style of the attachment.

object_story_spec__template_data__branded_content_shared_to_sponsor_status
STRING

The branded content shared to sponsor option.

object_story_spec__template_data__branded_content_sponsor_page_id
STRING

The ID of the branded content sponsor page.

object_story_spec__template_data__branded_content_sponsor_relationship
STRING

The branded content sponsorship option.

object_story_spec__template_data__call_to_action

Details about the call to associated with the link object.

object_story_spec__template_data__caption
STRING

The link caption.

object_story_spec__template_data__child_attachments

Details about the link objects required for carousel ads.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__template_data__description
STRING

The link description.

object_story_spec__template_data__event_id
STRING

The ID of a Facebook event.

object_story_spec__template_data__force_single_link
BOOLEAN

Indicates if the post will be forced to render in single link format.

object_story_spec__template_data__image_crops

Details about the crop specifications (aspect ratios) for images in different ad placements.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__template_data__image_hash
STRING

The hash of an image in your image library with Facebook.

object_story_spec__template_data__link
STRING

The link URL.

object_story_spec__template_data__message
STRING

The main body of the post.

object_story_spec__template_data__multi_share_end_card
BOOLEAN

Indicates if end cards that display the page icon should not be removed.

object_story_spec__template_data__multi_share_optimized
BOOLEAN

Indicates if orders and links are automatically selected and ordered.

object_story_spec__template_data__name
STRING

The name of the link.

object_story_spec__template_data__offer_id
STRING

The ID of a Facebook native offer.

object_story_spec__template_data__page_welcome_message
STRING

The welcome text from page to user on Messenger after a user performs a send message action on an ad.

object_story_spec__template_data__picture
STRING

The URL of a picture to use in the post.

object_story_spec__template_data__retailer_item_ids

The product IDs provided by the advertiser for collections.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__template_data__show_multiple_images
BOOLEAN

Used with force_single_link (true) to show a single dynamic item in carousel format using multiple images from the catalog.

object_story_spec__text_data__message
STRING

The text of the page post.

object_story_spec__video_data__branded_content_shared_to_sponsor_status
STRING

The branded content shared to sponsor option.

object_story_spec__video_data__branded_content_sponsor_page_id
STRING

The ID of the branded content sponsor page.

object_story_spec__video_data__branded_content_sponsor_relationship
STRING

The branded content sponsorship option.

object_story_spec__video_data__call_to_action

Details about the call to associated with the link object.

object_story_spec__video_data__force_single_link
BOOLEAN

Indicates if the post will be forced to render in single link format.

object_story_spec__video_data__image_hash
STRING

The hash of an image in your image library with Facebook.

object_story_spec__video_data__image_url
STRING

The URL of the image to use as a thumbnail.

object_story_spec__video_data__link_description
STRING

The link description of the video.

object_story_spec__video_data__message
STRING

The main body of the post.

object_story_spec__video_data__name
STRING

The name of the link.

object_story_spec__video_data__offer_id
STRING

The ID of a Facebook native offer.

object_story_spec__video_data__page_welcome_message
STRING

The welcome text from page to user on Messenger after a user performs a send message action on an ad.

object_story_spec__video_data__retailer_item_ids

The product IDs provided by the advertiser for collections.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__video_data__targeting

The post gating for the video.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

Refer to the Singer schema for info on what attributes this table may contain.

object_story_spec__video_data__video_id
STRING

The ID of the video that the user has permission to or a video in the ad account video library.

object_type
STRING

The type of object being advertised. Possible values are:

  • APPLICATION - For apps on Facebook.
  • DOMAIN
  • EVENT
  • INVALID - Returned when invalid object_ids are supplied or the authorizing user doesn’t have permission to see the object.
  • PAGE
  • PHOTO
  • SHARE
  • STATUS
  • STORE_ITEM - For iTunes and Google Play store destinations.
  • VIDEO
object_url
STRING

The destination URL for link ads not connected to a page.

product_set_id
STRING

The ID of the product set for the creative.

status
STRING

The status of the creative. Possible values are ACTIVE or DELETED.

template_url
STRING

The tracking URL for dynamic product ads.

template_url_spec__android__app_name
STRING

The name of the Android app.

template_url_spec__android__package
STRING

The fully qualified package name for intent generation and store linking.

template_url_spec__android__url
STRING

The custom URL scheme for the Android app.

template_url_spec__config__app_id
STRING

The ID of the Facebook app where the deeplink information is stored.

template_url_spec__ios__app_name
STRING

The display name of the iOS app.

template_url_spec__ios__app_store_id
STRING

The app ID for the App Store.

template_url_spec__ios__url
STRING

The custom URL scheme for the iOS app.

template_url_spec__ipad__app_name
STRING

The display name of the iOS app.

template_url_spec__ipad__app_store_id
STRING

The app ID for the App Store.

template_url_spec__ipad__url
STRING

The custom URL scheme for the iOS app.

template_url_spec__iphone__app_name
STRING

The display name of the iOS app.

template_url_spec__iphone__app_store_id
STRING

The app ID for the App Store.

template_url_spec__iphone__url
STRING

The custom URL scheme for the iOS app.

template_url_spec__web__should_fallback
STRING

Indicates if the web URL should be used as a fallback. If false, the content is only meant to be viewed on a native app.

template_url_spec__web__url
STRING

The web URL.

template_url_spec__windows_phone__app_id
STRING

The app ID as a GUID for the app store.

template_url_spec__windows_phone__app_name
STRING

The display name of the app.

template_url_spec__windows_phone__url
STRING

The custom URL scheme for the Windows Phone app.

thumbnail_url
STRING

The URL to a thumbnail used for the creative.

image_hash
STRING

The image has for an image used in the creative.

url_tags
STRING

The query string parameters which will replace or be appended to URLs clicked from page post ads, messages of the post, and canvas app install creatives.

video_id
STRING

The ID of the video in the creative.

link_url
STRING

Used to identify a specific landing tab on the page by the page’s tab URL.


Replication Method: Key-based Incremental Replication Key : updated_time
Primary Key : id : updated_time API Endpoint: ad - Reading

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

This is a Core Object table.

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

id
STRING

The ad ID.

updated_time
DATE-TIME

The last time the ad was updated.

account_id
STRING

The ID of the ad account that the ad belongs to.

campaign_id
STRING

The ID of the ad campaign that contains this ad.

Reference: campaigns.id
adset_id
STRING

The ID of the ad set that contains this ad.

Reference: adsets.id
adLabels

Details about the ad labels applied to the ad.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads__adLabels and may contain the following attributes:

_sdc_source_key_id
STRING

The ad ID.

_sdc_source_key_updated_time
DATE-TIME

The last time the ad was updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ad label ID.

created_time
DATE-TIME

The time the ad label was created.

name
STRING

The name of the ad label.

updated_time
DATE-TIME

The last time the ad label was updated.

bid_type
STRING

The bid type of the ad. According to Facebook’s documentation, possible values include:

  • CPC
  • CPM
  • MULTI_PREMIUM
  • ABSOLUTE_OCPM
  • CPA
bid_amount
INTEGER

The bid amount for the ad that will be used in auction instead of the ad set bid_amount, if specified.

bid_info__clicks
INTEGER

The clicks you placed on your bid.

bid_info__actions
INTEGER

The actions you placed on your bid.

bid_info__reach
INTEGER

The reach you placed on your bid.

bid_info__impressions
INTEGER

The impressions you placed on your bid.

bid_info__social
INTEGER

The social value you placed on your bid.

status
STRING

The configured status of the ad. Possible values include:

  • ACTIVE
  • PAUSED
  • DELETED
  • ARCHIVED
creative__creative_id
INTEGER

The ID of the creative used by the ad.

created_time
DATE-TIME

The time the ad was created.

name
STRING

The name of the ad.

effective_status
STRING

The effective status of the ad. According to Facebook’s documentation, possible values include:

  • ACTIVE
  • PAUSED
  • DELETED
  • PENDING_REVIEW
  • DISAPPROVED
  • PREAPPROVED
  • PENDING_BILLING_INFO
  • CAMPAIGN_PAUSED
  • ARCHIVED
  • ADSET_PAUSED
targeting__age_max
STRING

The maximum age of the targeted audience.

targeting__age_min
INTEGER

The minimum age of the targeted audience.

targeting__app_install_state
STRING

The app install state of the targeted audience.

targeting

Targeting specs are ad set attributes that define who sees an ad.

Stitch may create subtables named ads__targeting__[spec_name] for each targeting spec type that is applied to the ad set. For example: ads__targeting__life_events

Read more about the subtables that may be created here.

last_updated_by_app_id
STRING

The ID of the app that last updated the ad.

recommendations

Details about the recommendations for the ad, if there are any.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads__recommendations and may contain the following attributes:

_sdc_source_key_id
STRING

The ad ID.

_sdc_source_key_updated_time
DATE-TIME

The last time the ad was updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

code
INTEGER

The recommendation code.

blame_field
STRING

Field to associate the recommendation with.

confidence
STRING

Indicates how reliable the recommendation is. Possible values are HIGH, MEDIUM, and LOW.

importance
STRING

Indicates how important the recommendation is. Possible values are HIGH, MEDIUM, and LOW.

message
STRING

The content of the recommendation message.

title
STRING

The title of the recommendation.

tracking_specs

Tracking specs are actions taken by people interacting with the ad. Note: tracking specs only track - they don’t optimize or charge based on that action occurring.

Stitch may create subtables named named ads__tracking_specs__[spec_type] for any tracking spec type applied to the ad. Subtables are created for any tracking spec type.

If you have applied many tracking specs to your ads, this will result in a large number of subtables in your data warehouse. Refer to Facebook’s documentation for a full list of tracking specs.

Subtables created for tracking specs will, in general, have the following schema:

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads__tracking_specs and may contain the following attributes:

_sdc_source_key_id
STRING

The ad ID.

_sdc_source_key_updated_time
DATE-TIME

The last time the ad was updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

_sdc_level_1_id
INTEGER

This column functions the same as the _sdc_level_0_id column.

value
STRING

The value for the tracking spec.

conversion_specs

Conversion specs allow Facebook to surface the ad to users most likely to perform a desired decision. For example: adding to a shopping cart, viewing a particular page, or completing a form.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads__conversion_specs and may contain the following attributes:

_sdc_source_key_id
STRING

The ad ID.

_sdc_source_key_updated_time
DATE-TIME

The last time the ad was updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

_sdc_level_1_id
INTEGER

This column functions the same as the _sdc_level_0_id column.

value
STRING

Depending on the conversion specs you’ve applied to the ad, if any, Stitch may create subtables for each spec type. Subtables that are created will be named ads__conversion_specs__[spec_type]

Aside from the columns listed in this subtable (_sdc_level_0_id, _sdc_source_key_id, etc), these tables will contain a field named value.

Stitch will create a subtable for any conversion spec type. If you have applied many conversion specs, this will result in a large number of subtables in your data warehouse.

Refer to Facebook’s documentation for a full list of conversion specs.


Replication Method: Key-based Incremental Replication Key : date_start
Primary Key : ad_id : adset_id : campaign_id : date_start Documentation: Official Docs

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 option in the integration’s settings is enabled.

Segmented ads_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:

ad_id
STRING

The ID of the ad.

Reference: ads.id
adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

Reference: adsets.id
campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

Reference: campaigns.id
date_start
DATE-TIME

The start date.

date_stop
DATE-TIME

The end date.

ad_name
INTEGER

The name of the ad.

adset_name
STRING

The name of the adset.

campaign_name
INTEGER

The name of the campaign.

clicks
INTEGER

The number of clicks on your ads.

website_ctr

The percentage of times people saw the ad and performed a link click.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights__website_ctr and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

action_target_id
STRING

The ID of the destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

value
NUMBER

The metric value of the default attribution window.

action_destination
STRING

The destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

unique_inline_link_click_ctr
NUMBER

The percentage of times people saw the ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window.

frequency
NUMBER

The average number of times each person saw your ad.

total_actions
INTEGER

The total number of actions people took that are attributed to the ad. Actions may include engagement, clicks, or conversions.

account_id
STRING

The ID number of your ad account.

account_name
STRING

The name of your ad account.

canvas_avg_view_time
NUMBER

The average total time, in seconds, that people spent viewing a Facebook Canvas.

unique_inline_link_clicks
INTEGER

The number of people who performed an inline link click.

cost_per_unique_action_type

Details about the average cost of unique actions.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights__cost_per_unique_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

social_reach
INTEGER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_post_engagement
INTEGER

The total number of actions that people take involving the ad. Inline post engagements use a fixed 1-day-click attribution window.

relevance_score__status
STRING

The status of the ad’s relevance score.

Note: Relevance scores are shown after ads receive more than 500 impressions. In addition, relevance scores are only applicable to ads and will not appear for ad sets and campaigns.

relevance_score__negative_feedback
STRING

A string that indicates the level of negative feedback received about the ad. Ex: LOW

relevance_score__positive_feedback
STRING

A string that indicates the level of positive feedback received about the ad. Ex: HIGH

relevance_score__score
NUMBER

A 1-10 rating that estimates how well the target audience is responding to the ad.

Facebook’s documentation states that: “10 means we (Facebook) estimate the ad is highly relevant and 1 means we (Facebook) estimate it’s not very relevant.”

social_clicks
INTEGER

The number of clicks (all) when the ad was displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_link_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

unique_social_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

cpc
NUMBER

The average cost for each click (all).

unique_social_clicks
INTEGER

The number of people who performed a click (all) on the ad when it was displayed with social information, which shows other Facebook friends who engaged with the Page or ad.

call_to_action_clicks
INTEGER

The number of times people clicked the call-to-action button on the ad.

cost_per_total_action
NUMBER

The average cost for a relevant action.

cost_per_unique_inline_link_click
NUMBER

The average cost of each unique inline link click.

cpm
NUMBER

The average cost for 1,000 impressions.

cost_per_inline_post_engagement
NUMBER

The average cost of each inline post engagement.

inline_link_click_ctr
NUMBER

The percentage of time people saw your ads and performed an inline link click.

cpp
NUMBER

The average cost to reach 1,000 people.

cost_per_action_type

Details about the average cost of a relevant action.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights__cost_per_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

unique_link_clicks_ctr
NUMBER

The percentage of people who saw the ad and performed a link click.

social_reach
NUMBER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

spend
NUMBER

The estimated total amount of money spent on the campaign, ad set, or ad during its schedule.

cost_per_unique_click
NUMBER

The average cost of each unique click (all).

total_action_value
NUMBER

The total value of all conversions contributed to the ad.

unique_clicks
INTEGER

The number of people who performed a click (all).

social_spend
NUMBER

The total amount spent so far for the ad showed with social information. Ex: Stitch Data likes this.

reach
INTEGER

The number of people who saw the ad at least once.

reach is different than impressions, which may include multiple views of the ads by the same people.

canvas_avg_view_percent
NUMBER

The average percentage of the Facebook Canvas that people saw.

social_impressions
INTEGER

The number of times the ad was viewed when displayed with social information, which shows Facebook friends who engaged with the Facebook Page or ad.

objective
STRING

The objective selected for the campaign. This reflects the goal you want to achieve with your advertising.

impressions
INTEGER

The number of times the ad was on screen.

unique_ctr
NUMBER

The percentage of people who saw your ad and performed a unique click (all).

cost_per_inline_link_click
NUMBER

The average cost of each inline link click.

ctr
NUMBER

The percentage of times people saw your ad and performed a click (all).

total_unique_actions
INTEGER

The number of people who took an action that was attributed to the ad.


ads_insights_age_and_gender

Replication Method: Key-based Incremental Replication Key : date_start
Primary Key : ad_id : adset_id : campaign_id : date_start : age : gender Documentation: Official Docs

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.

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

ad_id
STRING

The ID of the ad.

Reference: ads.id
adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

Reference: adsets.id
campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

Reference: campaigns.id
date_start
DATE-TIME

The start date.

age
INTEGER, STRING

The age by which the data is segmented.

gender
STRING

The gender by which the data is segmented.

date_stop
DATE-TIME

The end date.

ad_name
INTEGER

The name of the ad.

adset_name
STRING

The name of the adset.

campaign_name
INTEGER

The name of the campaign.

clicks
INTEGER

The number of clicks on your ads.

website_ctr

The percentage of times people saw the ad and performed a link click.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_age_and_gender__website_ctr and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date.

_sdc_source_key_age
INTEGER, STRING

The age by which the data is segmented.

_sdc_source_key_gender
STRING

The gender by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

action_target_id
STRING

The ID of the destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

value
NUMBER

The metric value of the default attribution window.

action_destination
STRING

The destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

unique_inline_link_click_ctr
NUMBER

The percentage of times people saw the ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window.

frequency
NUMBER

The average number of times each person saw your ad.

total_actions
INTEGER

The total number of actions people took that are attributed to the ad. Actions may include engagement, clicks, or conversions.

account_id
STRING

The ID number of your ad account.

account_name
STRING

The name of your ad account.

canvas_avg_view_time
NUMBER

The average total time, in seconds, that people spent viewing a Facebook Canvas.

unique_inline_link_clicks
INTEGER

The number of people who performed an inline link click.

cost_per_unique_action_type

Details about the average cost of unique actions.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_age_and_gender__cost_per_unique_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date.

_sdc_source_key_age
INTEGER, STRING

The age by which the data is segmented.

_sdc_source_key_gender
STRING

The gender by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

social_reach
INTEGER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_post_engagement
INTEGER

The total number of actions that people take involving the ad. Inline post engagements use a fixed 1-day-click attribution window.

relevance_score__status
STRING

The status of the ad’s relevance score.

Note: Relevance scores are shown after ads receive more than 500 impressions. In addition, relevance scores are only applicable to ads and will not appear for ad sets and campaigns.

relevance_score__negative_feedback
STRING

A string that indicates the level of negative feedback received about the ad. Ex: LOW

relevance_score__positive_feedback
STRING

A string that indicates the level of positive feedback received about the ad. Ex: HIGH

relevance_score__score
NUMBER

A 1-10 rating that estimates how well the target audience is responding to the ad.

Facebook’s documentation states that: “10 means we (Facebook) estimate the ad is highly relevant and 1 means we (Facebook) estimate it’s not very relevant.”

social_clicks
INTEGER

The number of clicks (all) when the ad was displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_link_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

unique_social_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

cpc
NUMBER

The average cost for each click (all).

unique_social_clicks
INTEGER

The number of people who performed a click (all) on the ad when it was displayed with social information, which shows other Facebook friends who engaged with the Page or ad.

call_to_action_clicks
INTEGER

The number of times people clicked the call-to-action button on the ad.

cost_per_total_action
NUMBER

The average cost for a relevant action.

cost_per_unique_inline_link_click
NUMBER

The average cost of each unique inline link click.

cpm
NUMBER

The average cost for 1,000 impressions.

cost_per_inline_post_engagement
NUMBER

The average cost of each inline post engagement.

inline_link_click_ctr
NUMBER

The percentage of time people saw your ads and performed an inline link click.

cpp
NUMBER

The average cost to reach 1,000 people.

cost_per_action_type

Details about the average cost of a relevant action.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_age_and_gender__cost_per_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date.

_sdc_source_key_age
INTEGER, STRING

The age by which the data is segmented.

_sdc_source_key_gender
STRING

The gender by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

unique_link_clicks_ctr
NUMBER

The percentage of people who saw the ad and performed a link click.

social_reach
NUMBER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

spend
NUMBER

The estimated total amount of money spent on the campaign, ad set, or ad during its schedule.

cost_per_unique_click
NUMBER

The average cost of each unique click (all).

total_action_value
NUMBER

The total value of all conversions contributed to the ad.

unique_clicks
INTEGER

The number of people who performed a click (all).

social_spend
NUMBER

The total amount spent so far for the ad showed with social information. Ex: Stitch Data likes this.

reach
INTEGER

The number of people who saw the ad at least once.

reach is different than impressions, which may include multiple views of the ads by the same people.

canvas_avg_view_percent
NUMBER

The average percentage of the Facebook Canvas that people saw.

social_impressions
INTEGER

The number of times the ad was viewed when displayed with social information, which shows Facebook friends who engaged with the Facebook Page or ad.

objective
STRING

The objective selected for the campaign. This reflects the goal you want to achieve with your advertising.

impressions
INTEGER

The number of times the ad was on screen.

unique_ctr
NUMBER

The percentage of people who saw your ad and performed a unique click (all).

cost_per_inline_link_click
NUMBER

The average cost of each inline link click.

ctr
NUMBER

The percentage of times people saw your ad and performed a click (all).

total_unique_actions
INTEGER

The number of people who took an action that was attributed to the ad.


ads_insights_country

Replication Method: Key-based Incremental Replication Key : date_start
Primary Key : ad_id : adset_id : campaign_id : date_start : country Documentation: Official Docs

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.

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

ad_id
STRING

The ID of the ad.

Reference: ads.id
adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

Reference: adsets.id
campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

Reference: campaigns.id
date_start
DATE-TIME

The start date of the ad.

country
STRING

The country by which the data is segmented.

date_stop
DATE-TIME

The end date of the ad.

ad_name
INTEGER

The name of the ad.

adset_name
STRING

The name of the adset.

campaign_name
INTEGER

The name of the campaign.

clicks
INTEGER

The number of clicks on your ads.

website_ctr

The percentage of times people saw the ad and performed a link click.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_country__website_ctr and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_country
STRING

The country by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

action_target_id
STRING

The ID of the destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

value
NUMBER

The metric value of the default attribution window.

action_destination
STRING

The destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

unique_inline_link_click_ctr
NUMBER

The percentage of times people saw the ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window.

frequency
NUMBER

The average number of times each person saw your ad.

total_actions
INTEGER

The total number of actions people took that are attributed to the ad. Actions may include engagement, clicks, or conversions.

account_id
STRING

The ID number of your ad account.

account_name
STRING

The name of your ad account.

canvas_avg_view_time
NUMBER

The average total time, in seconds, that people spent viewing a Facebook Canvas.

unique_inline_link_clicks
INTEGER

The number of people who performed an inline link click.

cost_per_unique_action_type

Details about the average cost of unique actions.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_country__cost_per_unique_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_country
STRING

The country by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

social_reach
INTEGER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_post_engagement
INTEGER

The total number of actions that people take involving the ad. Inline post engagements use a fixed 1-day-click attribution window.

relevance_score__status
STRING

The status of the ad’s relevance score.

Note: Relevance scores are shown after ads receive more than 500 impressions. In addition, relevance scores are only applicable to ads and will not appear for ad sets and campaigns.

relevance_score__negative_feedback
STRING

A string that indicates the level of negative feedback received about the ad. Ex: LOW

relevance_score__positive_feedback
STRING

A string that indicates the level of positive feedback received about the ad. Ex: HIGH

relevance_score__score
NUMBER

A 1-10 rating that estimates how well the target audience is responding to the ad.

Facebook’s documentation states that: “10 means we (Facebook) estimate the ad is highly relevant and 1 means we (Facebook) estimate it’s not very relevant.”

social_clicks
INTEGER

The number of clicks (all) when the ad was displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_link_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

unique_social_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

cpc
NUMBER

The average cost for each click (all).

unique_social_clicks
INTEGER

The number of people who performed a click (all) on the ad when it was displayed with social information, which shows other Facebook friends who engaged with the Page or ad.

call_to_action_clicks
INTEGER

The number of times people clicked the call-to-action button on the ad.

cost_per_total_action
NUMBER

The average cost for a relevant action.

cost_per_unique_inline_link_click
NUMBER

The average cost of each unique inline link click.

cpm
NUMBER

The average cost for 1,000 impressions.

cost_per_inline_post_engagement
NUMBER

The average cost of each inline post engagement.

inline_link_click_ctr
NUMBER

The percentage of time people saw your ads and performed an inline link click.

cpp
NUMBER

The average cost to reach 1,000 people.

cost_per_action_type

Details about the average cost of a relevant action.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_country__cost_per_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_country
STRING

The country by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

unique_link_clicks_ctr
NUMBER

The percentage of people who saw the ad and performed a link click.

social_reach
NUMBER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

spend
NUMBER

The estimated total amount of money spent on the campaign, ad set, or ad during its schedule.

cost_per_unique_click
NUMBER

The average cost of each unique click (all).

total_action_value
NUMBER

The total value of all conversions contributed to the ad.

unique_clicks
INTEGER

The number of people who performed a click (all).

social_spend
NUMBER

The total amount spent so far for the ad showed with social information. Ex: Stitch Data likes this.

reach
INTEGER

The number of people who saw the ad at least once.

reach is different than impressions, which may include multiple views of the ads by the same people.

canvas_avg_view_percent
NUMBER

The average percentage of the Facebook Canvas that people saw.

social_impressions
INTEGER

The number of times the ad was viewed when displayed with social information, which shows Facebook friends who engaged with the Facebook Page or ad.

objective
STRING

The objective selected for the campaign. This reflects the goal you want to achieve with your advertising.

impressions
INTEGER

The number of times the ad was on screen.

unique_ctr
NUMBER

The percentage of people who saw your ad and performed a unique click (all).

cost_per_inline_link_click
NUMBER

The average cost of each inline link click.

ctr
NUMBER

The percentage of times people saw your ad and performed a click (all).

total_unique_actions
INTEGER

The number of people who took an action that was attributed to the ad.


ads_insights_platform_and_device

Replication Method: Key-based Incremental Replication Key : date_start
Primary Key : ad_id : adset_id : campaign_id : date_start : publisher_platform : platform_position : impression_device Documentation: Official Docs

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

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

ad_id
STRING

The ID of the ad.

Reference: ads.id
adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

Reference: adsets.id
campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

Reference: campaigns.id
date_start
DATE-TIME

The start date of the ad.

publisher_platform
STRING

The publishing platform by which the data is segmented. Ex: facebook or instagram

platform_position
STRING

The platform position by which the data is segmented.

impression_device
STRING

The type of device by which the data is segmented.

date_stop
DATE-TIME

The end date of the ad.

ad_name
INTEGER

The name of the ad.

adset_name
STRING

The name of the adset.

campaign_name
INTEGER

The name of the campaign.

clicks
INTEGER

The number of clicks on your ads.

website_ctr

The percentage of times people saw the ad and performed a link click.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_platform_and_device__website_ctr and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_publisher_platform
STRING

The publishing platform by which the data is segmented. Ex: facebook or instagram

_sdc_source_key_platform_position
STRING

The platform position by which the data is segmented.

_sdc_source_key_impression_device
STRING

The type of device by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

action_target_id
STRING

The ID of the destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

value
NUMBER

The metric value of the default attribution window.

action_destination
STRING

The destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

unique_inline_link_click_ctr
NUMBER

The percentage of times people saw the ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window.

frequency
NUMBER

The average number of times each person saw your ad.

total_actions
INTEGER

The total number of actions people took that are attributed to the ad. Actions may include engagement, clicks, or conversions.

account_id
STRING

The ID number of your ad account.

account_name
STRING

The name of your ad account.

canvas_avg_view_time
NUMBER

The average total time, in seconds, that people spent viewing a Facebook Canvas.

unique_inline_link_clicks
INTEGER

The number of people who performed an inline link click.

cost_per_unique_action_type

Details about the average cost of unique actions.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_platform_and_device__cost_per_unique_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_publisher_platform
STRING

The publishing platform by which the data is segmented. Ex: facebook or instagram

_sdc_source_key_platform_position
STRING

The platform position by which the data is segmented.

_sdc_source_key_impression_device
STRING

The type of device by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

social_reach
INTEGER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_post_engagement
INTEGER

The total number of actions that people take involving the ad. Inline post engagements use a fixed 1-day-click attribution window.

relevance_score__status
STRING

The status of the ad’s relevance score.

Note: Relevance scores are shown after ads receive more than 500 impressions. In addition, relevance scores are only applicable to ads and will not appear for ad sets and campaigns.

relevance_score__negative_feedback
STRING

A string that indicates the level of negative feedback received about the ad. Ex: LOW

relevance_score__positive_feedback
STRING

A string that indicates the level of positive feedback received about the ad. Ex: HIGH

relevance_score__score
NUMBER

A 1-10 rating that estimates how well the target audience is responding to the ad.

Facebook’s documentation states that: “10 means we (Facebook) estimate the ad is highly relevant and 1 means we (Facebook) estimate it’s not very relevant.”

social_clicks
INTEGER

The number of clicks (all) when the ad was displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_link_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

unique_social_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

cpc
NUMBER

The average cost for each click (all).

unique_social_clicks
INTEGER

The number of people who performed a click (all) on the ad when it was displayed with social information, which shows other Facebook friends who engaged with the Page or ad.

call_to_action_clicks
INTEGER

The number of times people clicked the call-to-action button on the ad.

cost_per_total_action
NUMBER

The average cost for a relevant action.

cost_per_unique_inline_link_click
NUMBER

The average cost of each unique inline link click.

cpm
NUMBER

The average cost for 1,000 impressions.

cost_per_inline_post_engagement
NUMBER

The average cost of each inline post engagement.

inline_link_click_ctr
NUMBER

The percentage of time people saw your ads and performed an inline link click.

cpp
NUMBER

The average cost to reach 1,000 people.

cost_per_action_type

Details about the average cost of a relevant action.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_platform_and_device__cost_per_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_publisher_platform
STRING

The publishing platform by which the data is segmented. Ex: facebook or instagram

_sdc_source_key_platform_position
STRING

The platform position by which the data is segmented.

_sdc_source_key_impression_device
STRING

The type of device by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

unique_link_clicks_ctr
NUMBER

The percentage of people who saw the ad and performed a link click.

social_reach
NUMBER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

spend
NUMBER

The estimated total amount of money spent on the campaign, ad set, or ad during its schedule.

cost_per_unique_click
NUMBER

The average cost of each unique click (all).

total_action_value
NUMBER

The total value of all conversions contributed to the ad.

unique_clicks
INTEGER

The number of people who performed a click (all).

social_spend
NUMBER

The total amount spent so far for the ad showed with social information. Ex: Stitch Data likes this.

reach
INTEGER

The number of people who saw the ad at least once.

reach is different than impressions, which may include multiple views of the ads by the same people.

canvas_avg_view_percent
NUMBER

The average percentage of the Facebook Canvas that people saw.

social_impressions
INTEGER

The number of times the ad was viewed when displayed with social information, which shows Facebook friends who engaged with the Facebook Page or ad.

objective
STRING

The objective selected for the campaign. This reflects the goal you want to achieve with your advertising.

impressions
INTEGER

The number of times the ad was on screen.

unique_ctr
NUMBER

The percentage of people who saw your ad and performed a unique click (all).

cost_per_inline_link_click
NUMBER

The average cost of each inline link click.

ctr
NUMBER

The percentage of times people saw your ad and performed a click (all).

total_unique_actions
INTEGER

The number of people who took an action that was attributed to the ad.


ads_insights_region

Replication Method: Key-based Incremental Replication Key : date_start
Primary Key : ad_id : adset_id : campaign_id : date_start : region Documentation: Official Docs

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.

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

ad_id
STRING

The ID of the ad.

Reference: ads.id
adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

Reference: adsets.id
campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

Reference: campaigns.id
date_start
DATE-TIME

The start date of the ad.

region
STRING

The region by which the data is segmented.

date_stop
DATE-TIME

The end date of the ad.

ad_name
INTEGER

The name of the ad.

adset_name
STRING

The name of the adset.

campaign_name
INTEGER

The name of the campaign.

clicks
INTEGER

The number of clicks on your ads.

website_ctr

The percentage of times people saw the ad and performed a link click.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_region__website_ctr and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_region
STRING

The region by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

action_target_id
STRING

The ID of the destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

value
NUMBER

The metric value of the default attribution window.

action_destination
STRING

The destination where people go after clicking on the ad. This could be your Facebook Page, an external URL for your conversion pixel, or an app configured with the Facebook SDK.

unique_inline_link_click_ctr
NUMBER

The percentage of times people saw the ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window.

frequency
NUMBER

The average number of times each person saw your ad.

total_actions
INTEGER

The total number of actions people took that are attributed to the ad. Actions may include engagement, clicks, or conversions.

account_id
STRING

The ID number of your ad account.

account_name
STRING

The name of your ad account.

canvas_avg_view_time
NUMBER

The average total time, in seconds, that people spent viewing a Facebook Canvas.

unique_inline_link_clicks
INTEGER

The number of people who performed an inline link click.

cost_per_unique_action_type

Details about the average cost of unique actions.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_region__cost_per_unique_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_region
STRING

The region by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

social_reach
INTEGER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_post_engagement
INTEGER

The total number of actions that people take involving the ad. Inline post engagements use a fixed 1-day-click attribution window.

relevance_score__status
STRING

The status of the ad’s relevance score.

Note: Relevance scores are shown after ads receive more than 500 impressions. In addition, relevance scores are only applicable to ads and will not appear for ad sets and campaigns.

relevance_score__negative_feedback
STRING

A string that indicates the level of negative feedback received about the ad. Ex: LOW

relevance_score__positive_feedback
STRING

A string that indicates the level of positive feedback received about the ad. Ex: HIGH

relevance_score__score
NUMBER

A 1-10 rating that estimates how well the target audience is responding to the ad.

Facebook’s documentation states that: “10 means we (Facebook) estimate the ad is highly relevant and 1 means we (Facebook) estimate it’s not very relevant.”

social_clicks
INTEGER

The number of clicks (all) when the ad was displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

inline_link_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

unique_social_clicks
INTEGER

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.

cpc
NUMBER

The average cost for each click (all).

unique_social_clicks
INTEGER

The number of people who performed a click (all) on the ad when it was displayed with social information, which shows other Facebook friends who engaged with the Page or ad.

call_to_action_clicks
INTEGER

The number of times people clicked the call-to-action button on the ad.

cost_per_total_action
NUMBER

The average cost for a relevant action.

cost_per_unique_inline_link_click
NUMBER

The average cost of each unique inline link click.

cpm
NUMBER

The average cost for 1,000 impressions.

cost_per_inline_post_engagement
NUMBER

The average cost of each inline post engagement.

inline_link_click_ctr
NUMBER

The percentage of time people saw your ads and performed an inline link click.

cpp
NUMBER

The average cost to reach 1,000 people.

cost_per_action_type

Details about the average cost of a relevant action.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named ads_insights_region__cost_per_action_type and may contain the following attributes:

_sdc_source_key_ad_id
STRING

The ID of the ad.

_sdc_source_key_adset_id
STRING

The ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization, and targeting.

_sdc_source_key_campaign_id
STRING

The ID of the campaign. Campaigns contain ad sets and ads.

_sdc_source_key_date_start
DATE-TIME

The start date of the ad.

_sdc_source_key_region
STRING

The region by which the data is segmented.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The metric value of the default attribution window.

action_type
STRING

The kind of actions taken on the ad, Page, app, or event after your ad was served to someone, even if they didn’t click on it.

Action types include Page likes, app installs, conversions, event responses, and more.

unique_link_clicks_ctr
NUMBER

The percentage of people who saw the ad and performed a link click.

social_reach
NUMBER

The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad.

spend
NUMBER

The estimated total amount of money spent on the campaign, ad set, or ad during its schedule.

cost_per_unique_click
NUMBER

The average cost of each unique click (all).

total_action_value
NUMBER

The total value of all conversions contributed to the ad.

unique_clicks
INTEGER

The number of people who performed a click (all).

social_spend
NUMBER

The total amount spent so far for the ad showed with social information. Ex: Stitch Data likes this.

reach
INTEGER

The number of people who saw the ad at least once.

reach is different than impressions, which may include multiple views of the ads by the same people.

canvas_avg_view_percent
NUMBER

The average percentage of the Facebook Canvas that people saw.

social_impressions
INTEGER

The number of times the ad was viewed when displayed with social information, which shows Facebook friends who engaged with the Facebook Page or ad.

objective
STRING

The objective selected for the campaign. This reflects the goal you want to achieve with your advertising.

impressions
INTEGER

The number of times the ad was on screen.

unique_ctr
NUMBER

The percentage of people who saw your ad and performed a unique click (all).

cost_per_inline_link_click
NUMBER

The average cost of each inline link click.

ctr
NUMBER

The percentage of times people saw your ad and performed a click (all).

total_unique_actions
INTEGER

The number of people who took an action that was attributed to the ad.


Replication Method: Key-based Incremental Replication Key : updated_time
Primary Key : id : updated_time API Endpoint: adSet - Reading

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

This is a Core Object table.

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

id
STRING

The ID of the ad set.

updated_time
DATE-TIME

The last time the ad set was updated.

name
STRING

The name of the ad set.

end_time
DATE-TIME

The end time of the ad set.

promoted_object__custom_event_type
STRING

The event from an App event of a mobile app or tag of a conversion pixel.

promoted_object__pixel_id
STRING

The ID of a Facebook conversion pixel. Used with offsite conversion campaigns.

promoted_object__pixel_rule
STRING

The rule of a Facebook conversion pixel.

promoted_object__page_id
STRING

The ID of the Facebook page.

promoted_object__object_store_url
STRING

The URL of the mobile or digital store where the application can be bought or downloaded.

promoted_object__application_id
STRING

The ID of a Facebook application.

promoted_object__product_set_id
STRING

The ID of a product set within an ad set-level product catalog.

promoted_object__offer_id
STRING

The ID of an offer from a Facebook page.

account_id
STRING

The ad account ID.

daily_budget
NUMBER

The daily budget of the ad set.

budget_remaining
NUMBER

The remaining budget of the ad set.

effective_status
STRING

The effective status of the ad set. According to Facebook’s documentation, possible values include:

  • ACTIVE
  • PAUSED
  • DELETED
  • PENDING_REVIEW
  • DISAPPROVED
  • PREAPPROVED
  • PENDING_BILLING_INFO
  • CAMPAIGN_PAUSED
  • ARCHIVED
  • ADSET_PAUSED
campaign_id
STRING

The ID of the campaign containing this ad set.

Reference: campaigns.id
created_time
DATE-TIME

The time the ad set was created.

start_time
DATE-TIME

The start time of the ad set.

lifetime_budget
NUMBER

The lifetime budget of the ad set.

targeting

Targeting specs are ad set attributes that define who sees an ad.

Stitch may create subtables named adsets__targeting__[spec_name] for each targeting spec type that is applied to the ad set. For example: adsets__targeting__life_events

Read more about the subtables that may be created here.

bid_info__clicks
INTEGER

The clicks you placed on your bid.

bid_info__actions
INTEGER

The actions you placed on your bid.

bid_info__reach
INTEGER

The reach you placed on your bid.

bid_info__impressions
INTEGER

The impressions you placed on your bid.

bid_info__social
INTEGER

The social value you placed on your bid.

adLabels

Details about the ad labels applied to the ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named adsets__adLabels and may contain the following attributes:

_sdc_source_key_id
STRING

The ID of the ad set.

_sdc_source_key_updated_time
DATE-TIME

The last time the ad set was updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ad label ID.

name
STRING

The name of the ad label.

created_time
DATE-TIME

The time the ad label was created.

updated_time
DATE-TIME

The time the ad label was last updated.


Replication Method: Key-based Incremental Replication Key : updated_time
Primary Key : id API Endpoint: adCampaign - Reading

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

This is a Core Object table.

Facebook defines campaigns as “a grouping of ad sets organized by the same business objective.”

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.

id
STRING

The campaign ID.

updated_time
DATE-TIME

The last time the campaign was updated.

name
STRING

The name of the campaign.

objective
STRING

The objective of the campaign.

account_id
STRING

The ID of the ad account that owns the campaign.

effective_status
STRING

The effective status of the campaign. According to Facebook’s documentation, possible values include:

  • ACTIVE
  • PAUSED
  • DELETED
  • PENDING_REVIEW
  • DISAPPROVED
  • PREAPPROVED
  • PENDING_BILLING_INFO
  • CAMPAIGN_PAUSED
  • ARCHIVED
  • ADSET_PAUSED
buying_type
STRING

The campaign buying type. Possible values are:

spend_cap
NUMBER

The spend cap for the campaign.

start_time
DATE-TIME

The campaign’s start time.

end_time
DATE-TIME

The campaign’s end time.

ads

The IDs of the ads associated with the campaign.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named campaigns__ads and may contain the following attributes:

_sdc_source_key_id
STRING

The campaign ID.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of an ad associated with the campaign.


[ads/adsets]__targeting

Replication Method: Key-based Incremental Replication Key : updated_time
Primary Key : id : updated_time

For every applicable targeting spec, a subtable will be created.

Below are the targeting specs Stitch will create subtables for and the attributes each subtable can contain.

id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

behaviors

ID/name pairs of the behavior targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__behaviors and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the behavior.

name
STRING

The name of the behavior. Ex: All travelers

connections

ID/name pairs of the connection targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__connections and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the connection. Ex: fans of your Page.

name
STRING

The name of the connection. Ex: Stitch Data

custom_audiences

ID/name pairs of the custom audience targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__custom_audiences and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the audience.

name
STRING

The name of the audience. Ex: Outbound Email Leads

education_majors

ID/name pairs of the education major targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__education_majors and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the education major.

name
STRING

The name of the education major. Ex: Computer Science

excluded_connections

ID/name pairs of the excluded connection targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__excluded_connections and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the excluded connection. Ex: Target people who aren’t fans of your Page.

name
STRING

The name of the excluded connection. Ex: Stitch Data

excluded_custom_audiences

ID/name pairs of the excluded custom audience targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__excluded_custom_audiences and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the excluded custom audience.

name
STRING

The name of the excluded custom audience.

family_statuses

ID/name pairs of the family status targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__family_statuses and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the family status.

name
STRING

The name of the family status.

friends_of_connections

ID/name pairs of the friend of connections targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__friends_of_connections and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the friend connection. Ex: Friends of people who are fans of your Page

name
STRING

The name of the friend connection.

generation

ID/name pairs of the generation demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__generation and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the generation demographic.

name
STRING

The name of the generation demographic.

geo_locations__cities

Details about the city demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__geo_locations__cities and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

key
STRING

The city’s key.

distance_unit
STRING

The unit used to measure radius.

region
STRING

The region associated with the city.

name
STRING

The name of the city.

country
STRING

The country associated with the city.

region_id
STRING

The ID of the region associated with the city.

radius
INTEGER

The radius around the city that is included in the targeting. For example: if radius is 10 and distance_unit is mile, an area of 10 miles outside the given city will be targeted.

geo_locations__location_types

Details about the location types included in the targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__geo_locations__location_types and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
STRING

The type of location included in the targeting specs. Possible values are:

  • country
  • country_group
  • region
  • city
  • zip
  • geo_market
  • electoral_district - Only applicable in the United States.
geo_locations__regions

Details about the region demographics included in the targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__geo_locations__regions and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

name
STRING

The name of the region.

country
STRING

The name of the country associated with the region.

key
STRING

The key of the region.

geo_locations__zips

Details about zip codes included in the targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__geo_locations__zips and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

name
STRING

The name of the zip code. For example: 90210

country
STRING

The country associated with the zip code. For example: US

key
STRING

The key of the zip code. For example: US:90210

primary_city_id
STRING

The ID of the city associated with the zip code. For example: Beverly Hills

region_id
STRING

The region associated with the zip code. For example: California

geo_locations__geo-markets

Details about the geo market demographics included in the targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__geo_locations__geo-markets and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

key
STRING

The key of the geo market.

name
STRING

The name of the geo market.

home_ownership

ID/name pairs of the home ownership demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__home_ownership and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the home ownership demographic.

name
STRING

The name of the home ownership demographic.

home_type

ID/name pairs of the home type demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__home_type and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the home type demographic.

name
STRING

The name of the home type demographic.

household_composition

ID/name pairs of the home composition targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__household_composition and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the household composition type.

name
STRING

The name of the household composition type. Ex: Children in home

income

ID/name pairs of the income demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__income and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the income demographic.

name
STRING

The name of the income demographic.

industries

ID/name pairs of the industry targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__industries and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the industry type.

name
STRING

The name of the industry type.

interests

ID/name pairs of the interest targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__interests and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the interest.

name
STRING

The name of the interest. Ex: Movies, Music

life_events

ID/name pairs of the life event targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__life_events and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the life event.

name
STRING

The name of the life event. Ex: Recently moved

moms

ID/name pairs of the mother demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__moms and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the mom demographic.

name
STRING

The name of the mom demographic.

net_worth

ID/name pairs of the net worth demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__net_worth and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the net worth demographic.

name
STRING

The name of the net worth demographic.

office_type

ID/name pairs of the office type targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__office_type and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the office type.

name
STRING

The name of the office type.

politics

ID/name pairs of the political demographic targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__politics and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
STRING

The ID of the political demographic.

name
STRING

The name of the political demographic.

user_adclusters

ID/name pairs of the user adcluster targeting specs applied to the ad/ad set.

This data may be de-nested into a subtable if your data warehouse doesn't natively support nested data.

This subtable would be named [ads/adsets]__targeting__user_adclusters and may contain the following attributes:

_sdc_source_key_id
STRING

If the table name begins with ads, this column will contain the ad ID.

If the table name begins with adsets, this column will contain the ad set ID.

_sdc_source_key_updated_time
DATE-TIME

If the table name begins with ads, this column contain the time the ad was last updated.

If the table name begins with adsets, this column contain the time the ad set was last updated.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.