Snapchat Ads integration summary

Stitch’s Snapchat Ads integration replicates data using the Snapchat Ads Marketing API. Refer to the Schema section for a list of objects available for replication.

Snapchat Ads feature snapshot

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

STITCH
Release status

Beta

Supported by

Stitch

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-snapchat-ads

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Snapchat Ads

Step 1: Add Snapchat 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 Snapchat 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 Snapchat Ads” would create a schema called stitch_snapchat_ads in the destination. Note: Schema names cannot be changed after you save the integration.

  5. If needed, set the following optional parameters:
    • Omit Empty: Use this parameter to omit records for a given date or entity if there is no data for any of the metrics. The value can be true or false. The default value is true.
    • Targeting Country Codes: Enter a comma-separated list of lowercase two-letter ISO country codes for ads targeting. The default value is us.
    • Swipe Up Attribution Window: Enter the attribution window for swipe-ups. The value can be 1_DAY, 7_DAY, or 28_DAY. The default value is 28_DAY.
    • View Attribution Window: Enter the attribution window for views. The value can be 1_HOUR, 3_HOUR, 6_HOUR, 1_DAY, 7_DAY, or 28_DAY. The default value is 1_DAY.

Step 2: Define the historical replication start date

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

Change this setting if you want to replicate data beyond Snapchat 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.

Snapchat Ads integrations support the following replication scheduling methods:

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

Step 4: Authorize Stitch

  1. Next, you’ll be prompted to log into your Snapchat account and approve Stitch’s access to your Snapchat Ads data. Note that we will only ever read your data.
  2. Click Authorize to connect.
  3. Sign in with your Snapchat account.
  4. After your credentials are validated, you’ll be directed back to Stitch and prompted to select the Snapchat Ads accounts you want to for which you want to run extractions.
  5. When finished, click Check and Save, then click All Done.

Step 5: Set objects to replicate

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

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

For Snapchat Ads integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue 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.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Snapchat 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.


Snapchat Ads table reference

ad_account_stats_daily

This endpoint retrieves the spend metric for the specified Ad Account at DAY granularity, the spend metric is the only metric available for the ad account entity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

ad_account_stats_daily schema on GitHub

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

granularity

STRING

id

STRING

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

type

STRING

view_attribution_window

STRING

ad_account_stats_hourly

This endpoint retrieves the spend metric for the specified Ad Account at HOUR granularity, the spend metric is the only metric available for the ad account entity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

ad_account_stats_hourly schema on GitHub

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

granularity

STRING

id

STRING

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

type

STRING

view_attribution_window

STRING

ad_accounts

This stream retrieves all ad accounts for the specified Organization.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

ad_accounts schema on GitHub

advertiser

STRING

advertiser_organization_id

STRING

agency_client_metadata

OBJECT

address_line_1

STRING

administrative_district_level_1

STRING

city

STRING

country

STRING

email

STRING

name

STRING

tax_id

STRING

zipcode

STRING

agency_representing_client

STRING

billing_type

STRING

client_based_in_country

STRING

client_paying_invoices

BOOLEAN

created_at

DATE-TIME

currency

STRING

funding_source_ids

ARRAY

id

STRING

lifetime_spend_cap_micro

INTEGER

name

STRING

organization_id

STRING

paying_advertiser_name

STRING

regulations

OBJECT

restricted_delivery_signals

BOOLEAN

status

STRING

timezone

STRING

type

STRING

updated_at

DATE-TIME

ad_squad_stats_daily

This stream retrieves stats for the specified Ad Squad at DAY granularity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

ad_squad_stats_daily schema on GitHub

android_installs

INTEGER

android_installs_app

INTEGER

android_installs_web

INTEGER

attachment_avg_view_time_millis

INTEGER

attachment_frequency

NUMBER

attachment_impressions

INTEGER

attachment_quartile_1

INTEGER

attachment_quartile_2

INTEGER

attachment_quartile_3

INTEGER

attachment_total_view_time_millis

INTEGER

attachment_uniques

INTEGER

attachment_view_completion

INTEGER

avg_screen_time_millis

INTEGER

avg_view_time_millis

INTEGER

conversion_achievement_unlocked

INTEGER

conversion_achievement_unlocked_app

INTEGER

conversion_achievement_unlocked_web

INTEGER

conversion_ad_click

INTEGER

conversion_ad_click_app

INTEGER

conversion_ad_click_web

INTEGER

conversion_ad_view

INTEGER

conversion_ad_view_app

INTEGER

conversion_ad_view_web

INTEGER

conversion_add_billing

INTEGER

conversion_add_billing_app

INTEGER

conversion_add_billing_web

INTEGER

conversion_add_cart

INTEGER

conversion_add_cart_app

INTEGER

conversion_add_cart_web

INTEGER

conversion_add_to_wishlist

INTEGER

conversion_add_to_wishlist_app

INTEGER

conversion_add_to_wishlist_web

INTEGER

conversion_app_opens

INTEGER

conversion_app_opens_app

INTEGER

conversion_app_opens_web

INTEGER

conversion_complete_tutorial

INTEGER

conversion_complete_tutorial_app

INTEGER

conversion_complete_tutorial_web

INTEGER

conversion_invite

INTEGER

conversion_invite_app

INTEGER

conversion_invite_web

INTEGER

conversion_level_completes

INTEGER

conversion_level_completes_app

INTEGER

conversion_level_completes_web

INTEGER

conversion_list_view

INTEGER

conversion_list_view_app

INTEGER

conversion_list_view_web

INTEGER

conversion_login

INTEGER

conversion_login_app

INTEGER

conversion_login_web

INTEGER

conversion_page_views

INTEGER

conversion_page_views_app

INTEGER

conversion_page_views_web

INTEGER

conversion_purchases

INTEGER

conversion_purchases_app

INTEGER

conversion_purchases_value

INTEGER

conversion_purchases_value_app

INTEGER

conversion_purchases_value_web

INTEGER

conversion_purchases_web

INTEGER

conversion_rate

INTEGER

conversion_rate_app

INTEGER

conversion_rate_web

INTEGER

conversion_reserve

INTEGER

conversion_reserve_app

INTEGER

conversion_reserve_web

INTEGER

conversion_save

INTEGER

conversion_save_app

INTEGER

conversion_save_web

INTEGER

conversion_searches

INTEGER

conversion_searches_app

INTEGER

conversion_searches_web

INTEGER

conversion_share

INTEGER

conversion_share_app

INTEGER

conversion_share_web

INTEGER

conversion_sign_ups

INTEGER

conversion_sign_ups_app

INTEGER

conversion_sign_ups_web

INTEGER

conversion_spend_credits

INTEGER

conversion_spend_credits_app

INTEGER

conversion_spend_credits_web

INTEGER

conversion_start_checkout

INTEGER

conversion_start_checkout_app

INTEGER

conversion_start_checkout_web

INTEGER

conversion_start_trial

INTEGER

conversion_start_trial_app

INTEGER

conversion_start_trial_web

INTEGER

conversion_subscribe

INTEGER

conversion_subscribe_app

INTEGER

conversion_subscribe_web

INTEGER

conversion_view_content

INTEGER

conversion_view_content_app

INTEGER

conversion_view_content_web

INTEGER

custom_event_1

INTEGER

custom_event_1_app

INTEGER

custom_event_1_web

INTEGER

custom_event_2

INTEGER

custom_event_2_app

INTEGER

custom_event_2_web

INTEGER

custom_event_3

INTEGER

custom_event_3_app

INTEGER

custom_event_3_web

INTEGER

custom_event_4

INTEGER

custom_event_4_app

INTEGER

custom_event_4_web

INTEGER

custom_event_5

INTEGER

custom_event_5_app

INTEGER

custom_event_5_web

INTEGER

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

frequency

NUMBER

granularity

STRING

id

STRING

impressions

INTEGER

ios_installs

INTEGER

ios_installs_app

INTEGER

ios_installs_web

INTEGER

quartile_1

INTEGER

quartile_2

INTEGER

quartile_3

INTEGER

screen_time_millis

INTEGER

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

swipe_up_percent

INTEGER

swipes

INTEGER

total_installs

INTEGER

total_installs_app

INTEGER

total_installs_web

INTEGER

type

STRING

uniques

INTEGER

video_views

INTEGER

video_views_15s

INTEGER

video_views_time_based

INTEGER

view_attribution_window

STRING

view_completion

INTEGER

view_time_millis

INTEGER

ad_squad_stats_hourly

This stream retrieves stats for the specified Ad Squad at HOUR granularity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

ad_squad_stats_hourly schema on GitHub

android_installs

INTEGER

android_installs_app

INTEGER

android_installs_web

INTEGER

attachment_avg_view_time_millis

INTEGER

attachment_frequency

NUMBER

attachment_impressions

INTEGER

attachment_quartile_1

INTEGER

attachment_quartile_2

INTEGER

attachment_quartile_3

INTEGER

attachment_total_view_time_millis

INTEGER

attachment_uniques

INTEGER

attachment_view_completion

INTEGER

avg_screen_time_millis

INTEGER

avg_view_time_millis

INTEGER

conversion_achievement_unlocked

INTEGER

conversion_achievement_unlocked_app

INTEGER

conversion_achievement_unlocked_web

INTEGER

conversion_ad_click

INTEGER

conversion_ad_click_app

INTEGER

conversion_ad_click_web

INTEGER

conversion_ad_view

INTEGER

conversion_ad_view_app

INTEGER

conversion_ad_view_web

INTEGER

conversion_add_billing

INTEGER

conversion_add_billing_app

INTEGER

conversion_add_billing_web

INTEGER

conversion_add_cart

INTEGER

conversion_add_cart_app

INTEGER

conversion_add_cart_web

INTEGER

conversion_add_to_wishlist

INTEGER

conversion_add_to_wishlist_app

INTEGER

conversion_add_to_wishlist_web

INTEGER

conversion_app_opens

INTEGER

conversion_app_opens_app

INTEGER

conversion_app_opens_web

INTEGER

conversion_complete_tutorial

INTEGER

conversion_complete_tutorial_app

INTEGER

conversion_complete_tutorial_web

INTEGER

conversion_invite

INTEGER

conversion_invite_app

INTEGER

conversion_invite_web

INTEGER

conversion_level_completes

INTEGER

conversion_level_completes_app

INTEGER

conversion_level_completes_web

INTEGER

conversion_list_view

INTEGER

conversion_list_view_app

INTEGER

conversion_list_view_web

INTEGER

conversion_login

INTEGER

conversion_login_app

INTEGER

conversion_login_web

INTEGER

conversion_page_views

INTEGER

conversion_page_views_app

INTEGER

conversion_page_views_web

INTEGER

conversion_purchases

INTEGER

conversion_purchases_app

INTEGER

conversion_purchases_value

INTEGER

conversion_purchases_value_app

INTEGER

conversion_purchases_value_web

INTEGER

conversion_purchases_web

INTEGER

conversion_rate

INTEGER

conversion_rate_app

INTEGER

conversion_rate_web

INTEGER

conversion_reserve

INTEGER

conversion_reserve_app

INTEGER

conversion_reserve_web

INTEGER

conversion_save

INTEGER

conversion_save_app

INTEGER

conversion_save_web

INTEGER

conversion_searches

INTEGER

conversion_searches_app

INTEGER

conversion_searches_web

INTEGER

conversion_share

INTEGER

conversion_share_app

INTEGER

conversion_share_web

INTEGER

conversion_sign_ups

INTEGER

conversion_sign_ups_app

INTEGER

conversion_sign_ups_web

INTEGER

conversion_spend_credits

INTEGER

conversion_spend_credits_app

INTEGER

conversion_spend_credits_web

INTEGER

conversion_start_checkout

INTEGER

conversion_start_checkout_app

INTEGER

conversion_start_checkout_web

INTEGER

conversion_start_trial

INTEGER

conversion_start_trial_app

INTEGER

conversion_start_trial_web

INTEGER

conversion_subscribe

INTEGER

conversion_subscribe_app

INTEGER

conversion_subscribe_web

INTEGER

conversion_view_content

INTEGER

conversion_view_content_app

INTEGER

conversion_view_content_web

INTEGER

custom_event_1

INTEGER

custom_event_1_app

INTEGER

custom_event_1_web

INTEGER

custom_event_2

INTEGER

custom_event_2_app

INTEGER

custom_event_2_web

INTEGER

custom_event_3

INTEGER

custom_event_3_app

INTEGER

custom_event_3_web

INTEGER

custom_event_4

INTEGER

custom_event_4_app

INTEGER

custom_event_4_web

INTEGER

custom_event_5

INTEGER

custom_event_5_app

INTEGER

custom_event_5_web

INTEGER

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

frequency

NUMBER

granularity

STRING

id

STRING

impressions

INTEGER

ios_installs

INTEGER

ios_installs_app

INTEGER

ios_installs_web

INTEGER

quartile_1

INTEGER

quartile_2

INTEGER

quartile_3

INTEGER

screen_time_millis

INTEGER

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

swipe_up_percent

INTEGER

swipes

INTEGER

total_installs

INTEGER

total_installs_app

INTEGER

total_installs_web

INTEGER

type

STRING

uniques

INTEGER

video_views

INTEGER

video_views_15s

INTEGER

video_views_time_based

INTEGER

view_attribution_window

STRING

view_completion

INTEGER

view_time_millis

INTEGER

ad_squads

This stream retrieves all ad squads within a specified ad account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

ad_squads schema on GitHub

ad_account_id

STRING

auto_bid

BOOLEAN

bid_micro

INTEGER

bid_strategy

STRING

billing_event

STRING

campaign_id

STRING

cap_and_exclusion_config

OBJECT

created_at

DATE-TIME

daily_budget_micro

INTEGER

delivery_constraint

STRING

end_time

DATE-TIME

id

STRING

impression_goal

STRING

lifetime_budget_micro

INTEGER

name

STRING

optimization_goal

STRING

pacing_type

STRING

pixel_id

STRING

placement

STRING

placement_v2

OBJECT

config

STRING

exclusion

OBJECT

content_types

ARRAY

inclusion

OBJECT

content_types

ARRAY

platforms

STRING

product_properties

OBJECT

reach_and_frequency_micro

INTEGER

reach_and_frequency_status

STRING

reach_goal

STRING

start_time

DATE-TIME

status

STRING

target_bid

BOOLEAN

targeting

OBJECT

demographics

ARRAY

devices

ARRAY

enable_targeting_expansion

BOOLEAN

geos

ARRAY

interests

ARRAY

regulated_content

BOOLEAN

segments

ARRAY

targeting_reach_status

STRING

type

STRING

updated_at

DATE-TIME

ad_stats_daily

This stream retrieves stats for the specified Ad at DAY granularity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

ad_stats_daily schema on GitHub

android_installs

INTEGER

android_installs_app

INTEGER

android_installs_web

INTEGER

attachment_avg_view_time_millis

INTEGER

attachment_frequency

NUMBER

attachment_impressions

INTEGER

attachment_quartile_1

INTEGER

attachment_quartile_2

INTEGER

attachment_quartile_3

INTEGER

attachment_total_view_time_millis

INTEGER

attachment_uniques

INTEGER

attachment_view_completion

INTEGER

avg_screen_time_millis

INTEGER

avg_view_time_millis

INTEGER

conversion_achievement_unlocked

INTEGER

conversion_achievement_unlocked_app

INTEGER

conversion_achievement_unlocked_web

INTEGER

conversion_ad_click

INTEGER

conversion_ad_click_app

INTEGER

conversion_ad_click_web

INTEGER

conversion_ad_view

INTEGER

conversion_ad_view_app

INTEGER

conversion_ad_view_web

INTEGER

conversion_add_billing

INTEGER

conversion_add_billing_app

INTEGER

conversion_add_billing_web

INTEGER

conversion_add_cart

INTEGER

conversion_add_cart_app

INTEGER

conversion_add_cart_web

INTEGER

conversion_add_to_wishlist

INTEGER

conversion_add_to_wishlist_app

INTEGER

conversion_add_to_wishlist_web

INTEGER

conversion_app_opens

INTEGER

conversion_app_opens_app

INTEGER

conversion_app_opens_web

INTEGER

conversion_complete_tutorial

INTEGER

conversion_complete_tutorial_app

INTEGER

conversion_complete_tutorial_web

INTEGER

conversion_invite

INTEGER

conversion_invite_app

INTEGER

conversion_invite_web

INTEGER

conversion_level_completes

INTEGER

conversion_level_completes_app

INTEGER

conversion_level_completes_web

INTEGER

conversion_list_view

INTEGER

conversion_list_view_app

INTEGER

conversion_list_view_web

INTEGER

conversion_login

INTEGER

conversion_login_app

INTEGER

conversion_login_web

INTEGER

conversion_page_views

INTEGER

conversion_page_views_app

INTEGER

conversion_page_views_web

INTEGER

conversion_purchases

INTEGER

conversion_purchases_app

INTEGER

conversion_purchases_value

INTEGER

conversion_purchases_value_app

INTEGER

conversion_purchases_value_web

INTEGER

conversion_purchases_web

INTEGER

conversion_rate

INTEGER

conversion_rate_app

INTEGER

conversion_rate_web

INTEGER

conversion_reserve

INTEGER

conversion_reserve_app

INTEGER

conversion_reserve_web

INTEGER

conversion_save

INTEGER

conversion_save_app

INTEGER

conversion_save_web

INTEGER

conversion_searches

INTEGER

conversion_searches_app

INTEGER

conversion_searches_web

INTEGER

conversion_share

INTEGER

conversion_share_app

INTEGER

conversion_share_web

INTEGER

conversion_sign_ups

INTEGER

conversion_sign_ups_app

INTEGER

conversion_sign_ups_web

INTEGER

conversion_spend_credits

INTEGER

conversion_spend_credits_app

INTEGER

conversion_spend_credits_web

INTEGER

conversion_start_checkout

INTEGER

conversion_start_checkout_app

INTEGER

conversion_start_checkout_web

INTEGER

conversion_start_trial

INTEGER

conversion_start_trial_app

INTEGER

conversion_start_trial_web

INTEGER

conversion_subscribe

INTEGER

conversion_subscribe_app

INTEGER

conversion_subscribe_web

INTEGER

conversion_view_content

INTEGER

conversion_view_content_app

INTEGER

conversion_view_content_web

INTEGER

custom_event_1

INTEGER

custom_event_1_app

INTEGER

custom_event_1_web

INTEGER

custom_event_2

INTEGER

custom_event_2_app

INTEGER

custom_event_2_web

INTEGER

custom_event_3

INTEGER

custom_event_3_app

INTEGER

custom_event_3_web

INTEGER

custom_event_4

INTEGER

custom_event_4_app

INTEGER

custom_event_4_web

INTEGER

custom_event_5

INTEGER

custom_event_5_app

INTEGER

custom_event_5_web

INTEGER

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

frequency

NUMBER

granularity

STRING

id

STRING

impressions

INTEGER

ios_installs

INTEGER

ios_installs_app

INTEGER

ios_installs_web

INTEGER

quartile_1

INTEGER

quartile_2

INTEGER

quartile_3

INTEGER

screen_time_millis

INTEGER

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

swipe_up_percent

INTEGER

swipes

INTEGER

total_installs

INTEGER

total_installs_app

INTEGER

total_installs_web

INTEGER

type

STRING

uniques

INTEGER

video_views

INTEGER

video_views_15s

INTEGER

video_views_time_based

INTEGER

view_attribution_window

STRING

view_completion

INTEGER

view_time_millis

INTEGER

ad_stats_hourly

This stream retrieves stats for the specified Ad at HOUR granularity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

ad_stats_hourly schema on GitHub

android_installs

INTEGER

android_installs_app

INTEGER

android_installs_web

INTEGER

attachment_avg_view_time_millis

INTEGER

attachment_frequency

NUMBER

attachment_impressions

INTEGER

attachment_quartile_1

INTEGER

attachment_quartile_2

INTEGER

attachment_quartile_3

INTEGER

attachment_total_view_time_millis

INTEGER

attachment_uniques

INTEGER

attachment_view_completion

INTEGER

avg_screen_time_millis

INTEGER

avg_view_time_millis

INTEGER

conversion_achievement_unlocked

INTEGER

conversion_achievement_unlocked_app

INTEGER

conversion_achievement_unlocked_web

INTEGER

conversion_ad_click

INTEGER

conversion_ad_click_app

INTEGER

conversion_ad_click_web

INTEGER

conversion_ad_view

INTEGER

conversion_ad_view_app

INTEGER

conversion_ad_view_web

INTEGER

conversion_add_billing

INTEGER

conversion_add_billing_app

INTEGER

conversion_add_billing_web

INTEGER

conversion_add_cart

INTEGER

conversion_add_cart_app

INTEGER

conversion_add_cart_web

INTEGER

conversion_add_to_wishlist

INTEGER

conversion_add_to_wishlist_app

INTEGER

conversion_add_to_wishlist_web

INTEGER

conversion_app_opens

INTEGER

conversion_app_opens_app

INTEGER

conversion_app_opens_web

INTEGER

conversion_complete_tutorial

INTEGER

conversion_complete_tutorial_app

INTEGER

conversion_complete_tutorial_web

INTEGER

conversion_invite

INTEGER

conversion_invite_app

INTEGER

conversion_invite_web

INTEGER

conversion_level_completes

INTEGER

conversion_level_completes_app

INTEGER

conversion_level_completes_web

INTEGER

conversion_list_view

INTEGER

conversion_list_view_app

INTEGER

conversion_list_view_web

INTEGER

conversion_login

INTEGER

conversion_login_app

INTEGER

conversion_login_web

INTEGER

conversion_page_views

INTEGER

conversion_page_views_app

INTEGER

conversion_page_views_web

INTEGER

conversion_purchases

INTEGER

conversion_purchases_app

INTEGER

conversion_purchases_value

INTEGER

conversion_purchases_value_app

INTEGER

conversion_purchases_value_web

INTEGER

conversion_purchases_web

INTEGER

conversion_rate

INTEGER

conversion_rate_app

INTEGER

conversion_rate_web

INTEGER

conversion_reserve

INTEGER

conversion_reserve_app

INTEGER

conversion_reserve_web

INTEGER

conversion_save

INTEGER

conversion_save_app

INTEGER

conversion_save_web

INTEGER

conversion_searches

INTEGER

conversion_searches_app

INTEGER

conversion_searches_web

INTEGER

conversion_share

INTEGER

conversion_share_app

INTEGER

conversion_share_web

INTEGER

conversion_sign_ups

INTEGER

conversion_sign_ups_app

INTEGER

conversion_sign_ups_web

INTEGER

conversion_spend_credits

INTEGER

conversion_spend_credits_app

INTEGER

conversion_spend_credits_web

INTEGER

conversion_start_checkout

INTEGER

conversion_start_checkout_app

INTEGER

conversion_start_checkout_web

INTEGER

conversion_start_trial

INTEGER

conversion_start_trial_app

INTEGER

conversion_start_trial_web

INTEGER

conversion_subscribe

INTEGER

conversion_subscribe_app

INTEGER

conversion_subscribe_web

INTEGER

conversion_view_content

INTEGER

conversion_view_content_app

INTEGER

conversion_view_content_web

INTEGER

custom_event_1

INTEGER

custom_event_1_app

INTEGER

custom_event_1_web

INTEGER

custom_event_2

INTEGER

custom_event_2_app

INTEGER

custom_event_2_web

INTEGER

custom_event_3

INTEGER

custom_event_3_app

INTEGER

custom_event_3_web

INTEGER

custom_event_4

INTEGER

custom_event_4_app

INTEGER

custom_event_4_web

INTEGER

custom_event_5

INTEGER

custom_event_5_app

INTEGER

custom_event_5_web

INTEGER

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

frequency

NUMBER

granularity

STRING

id

STRING

impressions

INTEGER

ios_installs

INTEGER

ios_installs_app

INTEGER

ios_installs_web

INTEGER

quartile_1

INTEGER

quartile_2

INTEGER

quartile_3

INTEGER

screen_time_millis

INTEGER

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

swipe_up_percent

INTEGER

swipes

INTEGER

total_installs

INTEGER

total_installs_app

INTEGER

total_installs_web

INTEGER

type

STRING

uniques

INTEGER

video_views

INTEGER

video_views_15s

INTEGER

video_views_time_based

INTEGER

view_attribution_window

STRING

view_completion

INTEGER

view_time_millis

INTEGER

ads

This stream retrieves all Ads under a specified Ad account

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

ads schema on GitHub

ad_account_id

STRING

ad_squad_id

STRING

created_at

DATE-TIME

creative_id

STRING

id

STRING

name

STRING

paying_advertiser_name

STRING

render_type

STRING

review_status

STRING

review_status_reasons

ARRAY

status

STRING

third_party_paid_impression_tracking_urls

ARRAY

expanded_tracking_url

STRING

tracking_url

STRING

tracking_url_metadata

OBJECT

third_party_swipe_tracking_urls

ARRAY

expanded_tracking_url

STRING

tracking_url

STRING

tracking_url_metadata

OBJECT

type

STRING

updated_at

DATE-TIME

audience_segments

This stream retrieves all Customer List segments within a specified ad account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

audience_segments schema on GitHub

ad_account_id

STRING

approximate_number_users

INTEGER

created_at

DATE-TIME

description

STRING

id

STRING

name

STRING

organization_id

STRING

retention_in_days

INTEGER

source_type

STRING

status

STRING

targetable_status

STRING

updated_at

DATE-TIME

upload_status

STRING

visible_to

ARRAY

billing_centers

Billing Centers allow Businesses to have multiple invoicing locations to choose from. A Billing Center is the contact that will be receiving invoices.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

billing_centers schema on GitHub

address_line_1

STRING

administrative_district_level_1

STRING

alternative_email_addresses

STRING

country

STRING

created_at

DATE-TIME

email_address

STRING

id

STRING

locality

STRING

name

STRING

organization_id

STRING

postal_code

STRING

updated_at

DATE-TIME

campaign_stats_daily

This stream retrieves stats for the specified Campaign at DAY granularity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

campaign_stats_daily schema on GitHub

android_installs

INTEGER

android_installs_app

INTEGER

android_installs_web

INTEGER

attachment_avg_view_time_millis

INTEGER

attachment_frequency

NUMBER

attachment_impressions

INTEGER

attachment_quartile_1

INTEGER

attachment_quartile_2

INTEGER

attachment_quartile_3

INTEGER

attachment_total_view_time_millis

INTEGER

attachment_uniques

INTEGER

attachment_view_completion

INTEGER

avg_screen_time_millis

INTEGER

avg_view_time_millis

INTEGER

conversion_achievement_unlocked

INTEGER

conversion_achievement_unlocked_app

INTEGER

conversion_achievement_unlocked_web

INTEGER

conversion_ad_click

INTEGER

conversion_ad_click_app

INTEGER

conversion_ad_click_web

INTEGER

conversion_ad_view

INTEGER

conversion_ad_view_app

INTEGER

conversion_ad_view_web

INTEGER

conversion_add_billing

INTEGER

conversion_add_billing_app

INTEGER

conversion_add_billing_web

INTEGER

conversion_add_cart

INTEGER

conversion_add_cart_app

INTEGER

conversion_add_cart_web

INTEGER

conversion_add_to_wishlist

INTEGER

conversion_add_to_wishlist_app

INTEGER

conversion_add_to_wishlist_web

INTEGER

conversion_app_opens

INTEGER

conversion_app_opens_app

INTEGER

conversion_app_opens_web

INTEGER

conversion_complete_tutorial

INTEGER

conversion_complete_tutorial_app

INTEGER

conversion_complete_tutorial_web

INTEGER

conversion_invite

INTEGER

conversion_invite_app

INTEGER

conversion_invite_web

INTEGER

conversion_level_completes

INTEGER

conversion_level_completes_app

INTEGER

conversion_level_completes_web

INTEGER

conversion_list_view

INTEGER

conversion_list_view_app

INTEGER

conversion_list_view_web

INTEGER

conversion_login

INTEGER

conversion_login_app

INTEGER

conversion_login_web

INTEGER

conversion_page_views

INTEGER

conversion_page_views_app

INTEGER

conversion_page_views_web

INTEGER

conversion_purchases

INTEGER

conversion_purchases_app

INTEGER

conversion_purchases_value

INTEGER

conversion_purchases_value_app

INTEGER

conversion_purchases_value_web

INTEGER

conversion_purchases_web

INTEGER

conversion_rate

INTEGER

conversion_rate_app

INTEGER

conversion_rate_web

INTEGER

conversion_reserve

INTEGER

conversion_reserve_app

INTEGER

conversion_reserve_web

INTEGER

conversion_save

INTEGER

conversion_save_app

INTEGER

conversion_save_web

INTEGER

conversion_searches

INTEGER

conversion_searches_app

INTEGER

conversion_searches_web

INTEGER

conversion_share

INTEGER

conversion_share_app

INTEGER

conversion_share_web

INTEGER

conversion_sign_ups

INTEGER

conversion_sign_ups_app

INTEGER

conversion_sign_ups_web

INTEGER

conversion_spend_credits

INTEGER

conversion_spend_credits_app

INTEGER

conversion_spend_credits_web

INTEGER

conversion_start_checkout

INTEGER

conversion_start_checkout_app

INTEGER

conversion_start_checkout_web

INTEGER

conversion_start_trial

INTEGER

conversion_start_trial_app

INTEGER

conversion_start_trial_web

INTEGER

conversion_subscribe

INTEGER

conversion_subscribe_app

INTEGER

conversion_subscribe_web

INTEGER

conversion_view_content

INTEGER

conversion_view_content_app

INTEGER

conversion_view_content_web

INTEGER

custom_event_1

INTEGER

custom_event_1_app

INTEGER

custom_event_1_web

INTEGER

custom_event_2

INTEGER

custom_event_2_app

INTEGER

custom_event_2_web

INTEGER

custom_event_3

INTEGER

custom_event_3_app

INTEGER

custom_event_3_web

INTEGER

custom_event_4

INTEGER

custom_event_4_app

INTEGER

custom_event_4_web

INTEGER

custom_event_5

INTEGER

custom_event_5_app

INTEGER

custom_event_5_web

INTEGER

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

frequency

NUMBER

granularity

STRING

id

STRING

impressions

INTEGER

ios_installs

INTEGER

ios_installs_app

INTEGER

ios_installs_web

INTEGER

quartile_1

INTEGER

quartile_2

INTEGER

quartile_3

INTEGER

screen_time_millis

INTEGER

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

swipe_up_percent

INTEGER

swipes

INTEGER

total_installs

INTEGER

total_installs_app

INTEGER

total_installs_web

INTEGER

type

STRING

uniques

INTEGER

video_views

INTEGER

video_views_15s

INTEGER

video_views_time_based

INTEGER

view_attribution_window

STRING

view_completion

INTEGER

view_time_millis

INTEGER

campaign_stats_hourly

This stream retrieves stats for the specified Campaign at HOUR granularity

Replication Method

Key-based Incremental

Primary Keys

id

start_time

Replication Key

end_time

Useful links

Snapchat Ads documentation

campaign_stats_hourly schema on GitHub

android_installs

INTEGER

android_installs_app

INTEGER

android_installs_web

INTEGER

attachment_avg_view_time_millis

INTEGER

attachment_frequency

NUMBER

attachment_impressions

INTEGER

attachment_quartile_1

INTEGER

attachment_quartile_2

INTEGER

attachment_quartile_3

INTEGER

attachment_total_view_time_millis

INTEGER

attachment_uniques

INTEGER

attachment_view_completion

INTEGER

avg_screen_time_millis

INTEGER

avg_view_time_millis

INTEGER

conversion_achievement_unlocked

INTEGER

conversion_achievement_unlocked_app

INTEGER

conversion_achievement_unlocked_web

INTEGER

conversion_ad_click

INTEGER

conversion_ad_click_app

INTEGER

conversion_ad_click_web

INTEGER

conversion_ad_view

INTEGER

conversion_ad_view_app

INTEGER

conversion_ad_view_web

INTEGER

conversion_add_billing

INTEGER

conversion_add_billing_app

INTEGER

conversion_add_billing_web

INTEGER

conversion_add_cart

INTEGER

conversion_add_cart_app

INTEGER

conversion_add_cart_web

INTEGER

conversion_add_to_wishlist

INTEGER

conversion_add_to_wishlist_app

INTEGER

conversion_add_to_wishlist_web

INTEGER

conversion_app_opens

INTEGER

conversion_app_opens_app

INTEGER

conversion_app_opens_web

INTEGER

conversion_complete_tutorial

INTEGER

conversion_complete_tutorial_app

INTEGER

conversion_complete_tutorial_web

INTEGER

conversion_invite

INTEGER

conversion_invite_app

INTEGER

conversion_invite_web

INTEGER

conversion_level_completes

INTEGER

conversion_level_completes_app

INTEGER

conversion_level_completes_web

INTEGER

conversion_list_view

INTEGER

conversion_list_view_app

INTEGER

conversion_list_view_web

INTEGER

conversion_login

INTEGER

conversion_login_app

INTEGER

conversion_login_web

INTEGER

conversion_page_views

INTEGER

conversion_page_views_app

INTEGER

conversion_page_views_web

INTEGER

conversion_purchases

INTEGER

conversion_purchases_app

INTEGER

conversion_purchases_value

INTEGER

conversion_purchases_value_app

INTEGER

conversion_purchases_value_web

INTEGER

conversion_purchases_web

INTEGER

conversion_rate

INTEGER

conversion_rate_app

INTEGER

conversion_rate_web

INTEGER

conversion_reserve

INTEGER

conversion_reserve_app

INTEGER

conversion_reserve_web

INTEGER

conversion_save

INTEGER

conversion_save_app

INTEGER

conversion_save_web

INTEGER

conversion_searches

INTEGER

conversion_searches_app

INTEGER

conversion_searches_web

INTEGER

conversion_share

INTEGER

conversion_share_app

INTEGER

conversion_share_web

INTEGER

conversion_sign_ups

INTEGER

conversion_sign_ups_app

INTEGER

conversion_sign_ups_web

INTEGER

conversion_spend_credits

INTEGER

conversion_spend_credits_app

INTEGER

conversion_spend_credits_web

INTEGER

conversion_start_checkout

INTEGER

conversion_start_checkout_app

INTEGER

conversion_start_checkout_web

INTEGER

conversion_start_trial

INTEGER

conversion_start_trial_app

INTEGER

conversion_start_trial_web

INTEGER

conversion_subscribe

INTEGER

conversion_subscribe_app

INTEGER

conversion_subscribe_web

INTEGER

conversion_view_content

INTEGER

conversion_view_content_app

INTEGER

conversion_view_content_web

INTEGER

custom_event_1

INTEGER

custom_event_1_app

INTEGER

custom_event_1_web

INTEGER

custom_event_2

INTEGER

custom_event_2_app

INTEGER

custom_event_2_web

INTEGER

custom_event_3

INTEGER

custom_event_3_app

INTEGER

custom_event_3_web

INTEGER

custom_event_4

INTEGER

custom_event_4_app

INTEGER

custom_event_4_web

INTEGER

custom_event_5

INTEGER

custom_event_5_app

INTEGER

custom_event_5_web

INTEGER

end_time

DATE-TIME

finalized_data_end_time

DATE-TIME

frequency

NUMBER

granularity

STRING

id

STRING

impressions

INTEGER

ios_installs

INTEGER

ios_installs_app

INTEGER

ios_installs_web

INTEGER

quartile_1

INTEGER

quartile_2

INTEGER

quartile_3

INTEGER

screen_time_millis

INTEGER

spend

INTEGER

start_time

DATE-TIME

swipe_up_attribution_window

STRING

swipe_up_percent

INTEGER

swipes

INTEGER

total_installs

INTEGER

total_installs_app

INTEGER

total_installs_web

INTEGER

type

STRING

uniques

INTEGER

video_views

INTEGER

video_views_15s

INTEGER

video_views_time_based

INTEGER

view_attribution_window

STRING

view_completion

INTEGER

view_time_millis

INTEGER

campaigns

This stream retrieves all campaigns within a specified ad account

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

campaigns schema on GitHub

ad_account_id

STRING

buy_model

STRING

created_at

DATE-TIME

daily_budget_micro

INTEGER

end_time

DATE-TIME

id

STRING

lifetime_spend_cap_micro

INTEGER

measurement_spec

OBJECT

name

STRING

objective

STRING

regulations

OBJECT

start_time

DATE-TIME

status

STRING

updated_at

DATE-TIME

creatives

This endpoint retrieves all creatives associated with an ad account

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

creatives schema on GitHub

ad_account_id

STRING

ad_product

STRING

ad_to_lens_properties

OBJECT

ad_to_message_properties

OBJECT

app_install_properties

OBJECT

brand_name

STRING

call_to_action

STRING

collection_properties

OBJECT

composite_properties

OBJECT

created_at

DATE-TIME

deep_link_properties

OBJECT

dynamic_render_properties

OBJECT

forced_view_eligibility

STRING

headline

STRING

id

STRING

longform_video_properties

OBJECT

name

STRING

packaging_status

STRING

playback_type

STRING

preview_creative_id

STRING

preview_properties

OBJECT

render_type

STRING

review_status

STRING

shareable

BOOLEAN

top_snap_crop_position

STRING

top_snap_media_id

STRING

type

STRING

updated_at

DATE-TIME

web_view_properties

OBJECT

funding_sources

An Funding Source is owned by an Organization and defines the financial instrument/terms responsible for the ad spend. Funding sources are assigned to an Ad Account in order to pay for the activity within that Ad Account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

funding_sources schema on GitHub

available_credit_micro

INTEGER

budget_spent_micro

INTEGER

card_type

STRING

created_at

DATE-TIME

currency

STRING

daily_spend_limit_currency

STRING

daily_spend_limit_micro

INTEGER

email

STRING

end_date

DATE-TIME

expiration_month

STRING

expiration_year

STRING

id

STRING

last_4

STRING

name

STRING

organization_id

STRING

start_date

DATE-TIME

status

STRING

total_budget_micro

INTEGER

type

STRING

updated_at

DATE-TIME

value_micro

INTEGER

media

This stream retrieves all media entities associated with an ad account

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

media schema on GitHub

ad_account_id

STRING

created_at

DATE-TIME

download_link

STRING

file_name

STRING

file_size_in_bytes

INTEGER

hash

STRING

id

STRING

image_metadata

OBJECT

height_px

INTEGER

image_format

STRING

width_px

INTEGER

is_demo_media

BOOLEAN

lens_package_metadata

OBJECT

media_status

STRING

name

STRING

type

STRING

updated_at

DATE-TIME

video_metadata

OBJECT

visibility

STRING

members

This stream retrieves the information of all Members of an Organization

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

members schema on GitHub

created_at

DATE-TIME

display_name

STRING

email

STRING

id

STRING

member_status

STRING

organization_id

STRING

updated_at

DATE-TIME

organizations

This stream retrieves all organizations.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

organizations schema on GitHub

accepted_term_version

STRING

address_line_1

STRING

administrative_district_level_1

STRING

configuration_settings

OBJECT

notifications_enabled

BOOLEAN

contact_email

STRING

contact_name

STRING

contact_phone

STRING

contact_phone_optin

BOOLEAN

country

STRING

created_at

DATE-TIME

id

STRING

locality

STRING

my_display_name

STRING

my_invited_email

STRING

my_member_id

STRING

name

STRING

postal_code

STRING

roles

ARRAY

state

STRING

type

STRING

updated_at

DATE-TIME

phone_numbers

This stream retrieves all verified phone numbers for an Ad Account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

phone_numbers schema on GitHub

ad_account_id

STRING

country_code

STRING

created_at

DATE-TIME

id

STRING

name

STRING

numerical_country_code

STRING

phone_number

STRING

updated_at

DATE-TIME

verification_status

STRING

pixel_domain_stats

This stream retrieves the domains that have fired the pixel in the past 7 days.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

pixel_domain_stats schema on GitHub

domains

ARRAY

domain_name

STRING

total_events

INTEGER

end_time

DATE-TIME

id

STRING

pixel_id

STRING

start_time

DATE-TIME

type

STRING

pixels

This stream retrieves the pixel associated with the specified Ad Account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

pixels schema on GitHub

ad_account_id

STRING

created_at

DATE-TIME

effective_status

STRING

id

STRING

name

STRING

organization_id

STRING

pixel_javascript

STRING

status

STRING

updated_at

DATE-TIME

visible_to

ARRAY

product_catalogs

This stream will retrieve a list of all the catalogs within an organization

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Snapchat Ads documentation

product_catalogs schema on GitHub

created_at

DATE-TIME

default_product_set_id

STRING

event_sources

ARRAY

id

STRING

type

STRING

id

STRING

name

STRING

organization_id

STRING

source

STRING

updated_at

DATE-TIME

product_sets

This stream will get all the Product Sets within the Catalog.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

product_sets schema on GitHub

catalog_id

STRING

created_at

DATE-TIME

filter

OBJECT

id

STRING

name

STRING

updated_at

DATE-TIME

roles

This stream retrieves all Roles assigned within an Organization

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

roles schema on GitHub

container_id

STRING

container_kind

STRING

created_at

DATE-TIME

id

STRING

member_id

STRING

organization_id

STRING

type

STRING

updated_at

DATE-TIME

targeting_advanced_demographics

This stream retrieves the list of Advanced Demographics targeting options

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_advanced_demographics schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_age_groups

This stream retrieves the list of age group targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_age_groups schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_android_versions

This stream retrieves the list of device OS version targeting options. These OS versions can then be used in targeting as os_version_min and os_version_max.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_android_versions schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_carriers

This stream retrieves the list of device carrier targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_carriers schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_connection_types

This stream retrieves the list of device connection type targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_connection_types schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_countries

This stream retrieves the list of country targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_countries schema on GitHub

city

OBJECT

id

STRING

name

STRING

continent

OBJECT

full_name

STRING

id

STRING

name

STRING

country

OBJECT

code

STRING

code2

STRING

id

STRING

name

STRING

country_code

STRING

id

STRING

metro

OBJECT

id

STRING

name

STRING

regions

STRING

name

STRING

parent_id

STRING

path

STRING

region

OBJECT

code

STRING

id

STRING

name

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_device_makes

This stream retrieves the list of device make targeting options. Please note that specifying a parent level make option like Apple/ in the targeting spec will include all devices of the kind Apple/* like Apple/iPad (3rd Gen)/, Apple/iPhone 4/, Apple/iPhone 7 Plus/ etc.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_device_makes schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_genders

This stream retrieves the list of gender targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_genders schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_interests_dlxc

This stream retrieves the list of Oracle Datalogix DLXC targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_interests_dlxc schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_interests_dlxp

This stream retrieves the list of Oracle Datalogix DLXP targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_interests_dlxp schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_interests_dlxs

This stream retrieves the list of Oracle Datalogix DLXS Interests targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_interests_dlxs schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_interests_nln

This stream retrieves the list of Nielsen interest targeting options

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_interests_nln schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_interests_plc

This stream retrieves the list of placed visitation segments targeting options by the specified country code

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_interests_plc schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_interests_scls

This stream retrieves the list of Snap Lifestyle Categories targeting options by the specified country code

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_interests_scls schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_ios_versions

This stream retrieves the list of device OS version targeting options. These OS versions can then be used in targeting as os_version_min and os_version_max.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_ios_versions schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_languages

This stream retrieves the list of language targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_languages schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_location_categories

Location targeting allows an advertiser to target users based on their location.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_location_categories schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_metros

This stream retrieves the list of metro/dma targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_metros schema on GitHub

city

OBJECT

id

STRING

name

STRING

continent

OBJECT

full_name

STRING

id

STRING

name

STRING

country

OBJECT

code

STRING

code2

STRING

id

STRING

name

STRING

country_code

STRING

id

STRING

metro

OBJECT

id

STRING

name

STRING

regions

STRING

name

STRING

parent_id

STRING

path

STRING

region

OBJECT

code

STRING

id

STRING

name

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_os_types

This stream retrieves the list of device OS type targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_os_types schema on GitHub

country_code

STRING

id

STRING

name

STRING

parent_id

STRING

path

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_postal_codes

This stream retrieves the list of zipcode targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_postal_codes schema on GitHub

city

OBJECT

id

STRING

name

STRING

continent

OBJECT

full_name

STRING

id

STRING

name

STRING

country

OBJECT

code

STRING

code2

STRING

id

STRING

name

STRING

country_code

STRING

id

STRING

metro

OBJECT

id

STRING

name

STRING

regions

STRING

name

STRING

parent_id

STRING

path

STRING

region

OBJECT

code

STRING

id

STRING

name

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING

targeting_regions

This stream retrieves the list of region/state targeting options.

Replication Method

Full Table

Primary Key

id

Useful links

Snapchat Ads documentation

targeting_regions schema on GitHub

city

OBJECT

id

STRING

name

STRING

continent

OBJECT

full_name

STRING

id

STRING

name

STRING

country

OBJECT

code

STRING

code2

STRING

id

STRING

name

STRING

country_code

STRING

id

STRING

metro

OBJECT

id

STRING

name

STRING

regions

STRING

name

STRING

parent_id

STRING

path

STRING

region

OBJECT

code

STRING

id

STRING

name

STRING

source

STRING

targeting_group

STRING

targeting_type

STRING


Questions? Feedback?

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