Snapchat Ads provides a platform to create, manage and measure your campaigns. You can find more information on Snapchat documentation. Snapchat Ads connector provides a history of the settings and detailed reports of your Snapchat Ad Accounts, Campaigns, Ad Squads, and Media Creatives.
Setup Guidelink
Follow our step-by-step Snapchat Ads setup guide to connect Snapchat Ads with your destination using Fivetran connectors.
Sync overviewlink
The Snapchat Ads connector supports multithreading. Fivetran uses multiple parallel API requests to sync Ads data from your Snapchat Ads account to your destination. The connectorβs sync speed depends on your Snapchat Ads API quota and account metadata.
Snapchat takes around 48-72 hours to process finalised data. Following metrics will not be available in current and previous day reports:
- attachment_frequency
- attachment_uniques
- avg_screen_time_millis
- frequency
- uniques
- story_opens
- story_completes
Schema informationlink
This schema applies to all Snapchat Ads connectors
To zoom, open ERD in new window
We skip A/B Segment testing records in audience_segment_history
table since they arenβt created or manipulated via the API. Due to this fact, they donβt have the updated_at
property which we need as a part of our composite Primary Key.
Report Tableslink
The Snapchat Ads connector syncs the following report tables that contain all the metrics (indicated with *) that can be summed up:
CAMPAIGN_HOURLY_REPORT
AD_HOURLY_REPORT
AD_SQUAD_HOURLY_REPORT
CAMPAIGN_DAILY_REPORT
AD_DAILY_REPORT
AD_SQUAD_DAILY_REPORT
We also sync dimension report tables with the day
granularity. These report tables are similar to the regular tables with the day
granularity (those with the _daily_repot
suffix). Each dimension table has an additional dimension column.
Campaign dimension tables:
CAMPAIGN_GEO_COUNTRY_DAILY_REPORT
CAMPAIGN_GEO_REGION_DAILY_REPORT
CAMPAIGN_GEO_DMA_DAILY_REPORT
CAMPAIGN_INTEREST_DAILY_REPORT
CAMPAIGN_DEVICE_OS_DAILY_REPORT
CAMPAIGN_DEVICE_MAKE_DAILY_REPORT
CAMPAIGN_DEMOGRAPHIC_DAILY_REPORT
Ad dimension tables:
AD_GEO_COUNTRY_DAILY_REPORT
AD_GEO_REGION_DAILY_REPORT
AD_GEO_DMA_DAILY_REPORT
AD_INTEREST_DAILY_REPORT
AD_DEVICE_OS_DAILY_REPORT
AD_DEVICE_MAKE_DAILY_REPORT
AD_DEMOGRAPHIC_DAILY_REPORT
Ad squad dimension tables:
AD_SQUAD_GEO_COUNTRY_DAILY_REPORT
AD_SQUAD_GEO_REGION_DAILY_REPORT
AD_SQUAD_GEO_DMA_DAILY_REPORT
AD_SQUAD_INTEREST_DAILY_REPORT
AD_SQUAD_DEVICE_OS_DAILY_REPORT
AD_SQUAD_DEVICE_MAKE_DAILY_REPORT
AD_SQUAD_DEMOGRAPHIC_DAILY_REPORT
Tables with the UNIQUE_IMPRESSION_DAILY_REPORT
suffix contain only non-summable metrics for day
granularity.
CAMPAIGN_HOURLY_REPORT, CAMPAIGN_DAILY_REPORT
COLUMN |
REFERENCE |
campaign_id π |
campaign_history |
date π |
|
android_installs |
|
attachment metrics* |
|
avg_screen_time_millis |
|
avg_view_time_millis |
|
conversion metrics* |
|
impressions |
|
ios_installs |
|
quartile_1 |
|
quartile_2 |
|
quartile_3 |
|
screen_time_millis |
|
spend |
|
story_completes |
|
story_opens |
|
swipe_up_percent |
|
swipes |
|
total_installs |
|
video_views |
|
view_completion |
|
view_time_millis |
|
CAMPAIGN_GEO_COUNTRY_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the CAMPAIGN_DAILY_REPORT table |
|
country π |
|
CAMPAIGN_GEO_REGION_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the CAMPAIGN_DAILY_REPORT table |
|
region π |
|
CAMPAIGN_GEO_DMA_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the CAMPAIGN_DAILY_REPORT table |
|
dma π |
|
CAMPAIGN_INTEREST_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the CAMPAIGN_DAILY_REPORT table |
|
interest_category_id π |
|
interest_category_name |
|
CAMPAIGN_DEVICE_OS_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the CAMPAIGN_DAILY_REPORT table |
|
operating_system π |
|
CAMPAIGN_DEVICE_MAKE_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the CAMPAIGN_DAILY_REPORT table |
|
make π |
|
CAMPAIGN_DEMOGRAPHIC_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the CAMPAIGN_DAILY_REPORT table |
|
gender π |
|
age_bucket π |
|
AD_HOURLY_REPORT, AD_DAILY_REPORT
COLUMN |
REFERENCE |
ad_id π |
ad_history |
date π |
|
android_installs |
|
attachment metrics* |
|
avg_screen_time_millis |
|
avg_view_time_millis |
|
conversion metrics* |
|
impressions |
|
ios_installs |
|
quartile_1 |
|
quartile_2 |
|
quartile_3 |
|
screen_time_millis |
|
spend |
|
story_completes |
|
story_opens |
|
swipe_up_percent |
|
swipes |
|
total_installs |
|
video_views |
|
view_completion |
|
view_time_millis |
|
AD_GEO_COUNTRY_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_DAILY_REPORT table |
|
country π |
|
AD_GEO_REGION_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_DAILY_REPORT table |
|
region π |
|
AD_GEO_DMA_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_DAILY_REPORT table |
|
dma π |
|
AD_INTEREST_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_DAILY_REPORT table |
|
interest_category_id π |
|
interest_category_name |
|
AD_DEVICE_OS_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_DAILY_REPORT table |
|
operating_system π |
|
AD_DEVICE_MAKE_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_DAILY_REPORT table |
|
make π |
|
AD_DEMOGRAPHIC_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_DAILY_REPORT table |
|
gender π |
|
age_bucket π |
|
AD_SQUAD_HOURLY_REPORT, AD_SQUAD_DAILY_REPORT
COLUMN |
REFERENCE |
ad_squad_id π |
ad_squad_history |
date π |
|
android_installs |
|
attachment metrics* |
|
avg_screen_time_millis |
|
avg_view_time_millis |
|
conversion metrics* |
|
impressions |
|
ios_installs |
|
quartile_1 |
|
quartile_2 |
|
quartile_3 |
|
screen_time_millis |
|
spend |
|
story_completes |
|
story_opens |
|
swipe_up_percent |
|
swipes |
|
total_installs |
|
video_views |
|
view_completion |
|
view_time_millis |
|
AD_SQUAD_GEO_COUNTRY_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_SQUAD_DAILY_REPORT table |
|
country π |
|
AD_SQUAD_GEO_REGION_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_SQUAD_DAILY_REPORT table |
|
region π |
|
AD_SQUAD_GEO_DMA_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_SQUAD_DAILY_REPORT table |
|
dma π |
|
AD_SQUAD_INTEREST_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_SQUAD_DAILY_REPORT table |
|
interest_category_id π |
|
interest_category_name |
|
AD_SQUAD_DEVICE_OS_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_SQUAD_DAILY_REPORT table |
|
operating_system π |
|
AD_SQUAD_DEVICE_MAKE_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_SQUAD_DAILY_REPORT table |
|
make π |
|
AD_SQUAD_DEMOGRAPHIC_DAILY_REPORT
COLUMN |
REFERENCE |
All columns from the AD_SQUAD_DAILY_REPORT table |
|
gender π |
|
age_bucket π |
|
CAMPAIGN_UNIQUE_IMPRESSION_DAILY_REPORT
COLUMN |
REFERENCE |
campaign_id π |
campaign_history |
date π |
|
attachment_frequency |
|
attachment_uniques |
|
frequency |
|
uniques |
|
AD_UNIQUE_IMPRESSION_DAILY_REPORT
COLUMN |
REFERENCE |
ad_id π |
ad_history |
date π |
|
attachment_frequency |
|
attachment_uniques |
|
frequency |
|
uniques |
|
AD_SQUAD_UNIQUE_IMPRESSION_DAILY_REPORT
COLUMN |
REFERENCE |
ad_squad_id π |
ad_squad_history |
date π |
|
attachment_frequency |
|
attachment_uniques |
|
frequency |
|
uniques |
|