The Snapchat Ads connector supports the following prebuilt reports that contain every retrievable metric (* indicates a retrievable metric):
AD_DAILY_REPORT
AD_HOURLY_REPORT
AD_SQUAD_DAILY_REPORT
AD_SQUAD_HOURLY_REPORT
CAMPAIGN_DAILY_REPORT
CAMPAIGN_HOURLY_REPORT
We also sync prebuilt reports with the day granularity. These prebuilt reports are similar to the regular reports with the day granularity (those with the _daily_repot suffix). Each dimension report has an additional dimension column.
AD_HOURLY_REPORT and AD_DAILY_REPORT metrics
Expand for details
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
video_views_15s
view_completion
view_time_millis
AD_SQUAD_HOURLY_REPORT and AD_SQUAD_DAILY_REPORT metrics
Expand for details
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
video_views_15s
view_completion
view_time_millis
CAMPAIGN_HOURLY_REPORT and CAMPAIGN_DAILY_REPORT metrics
Expand for details
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
video_views_15s
view_completion
view_time_millis
CAMPAIGN prebuilt reports
Fivetran supports the following campaign prebuilt reports:
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
CAMPAIGN_GEO_COUNTRY_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the CAMPAIGN_DAILY_REPORT table
country 🔑
CAMPAIGN_GEO_REGION_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the CAMPAIGN_DAILY_REPORT table
region 🔑
CAMPAIGN_GEO_DMA_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the CAMPAIGN_DAILY_REPORT table
dma 🔑
CAMPAIGN_INTEREST_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the CAMPAIGN_DAILY_REPORT table
interest_category_id 🔑
interest_category_name
CAMPAIGN_DEVICE_OS_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the CAMPAIGN_DAILY_REPORT table
operating_system 🔑
CAMPAIGN_DEVICE_MAKE_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the CAMPAIGN_DAILY_REPORT table
make 🔑
CAMPAIGN_DEMOGRAPHIC_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the CAMPAIGN_DAILY_REPORT table
gender 🔑
age_bucket 🔑
AD prebuilt reports
Fivetran supports the following ad prebuilt reports:
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_GEO_COUNTRY_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_DAILY_REPORT table
country 🔑
AD_GEO_REGION_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_DAILY_REPORT table
region 🔑
AD_GEO_DMA_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_DAILY_REPORT table
dma 🔑
AD_INTEREST_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_DAILY_REPORT table
interest_category_id 🔑
interest_category_name
AD_DEVICE_OS_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_DAILY_REPORT table
operating_system 🔑
AD_DEVICE_MAKE_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_DAILY_REPORT table
make 🔑
AD_DEMOGRAPHIC_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_DAILY_REPORT table
gender 🔑
age_bucket 🔑
AD_SQUAD prebuilt reports
Fivetran supports the following ad squad prebuilt reports:
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
AD_SQUAD_GEO_COUNTRY_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_SQUAD_DAILY_REPORT table
country 🔑
AD_SQUAD_GEO_REGION_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_SQUAD_DAILY_REPORT table
region 🔑
AD_SQUAD_GEO_DMA_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_SQUAD_DAILY_REPORT table
dma 🔑
AD_SQUAD_INTEREST_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_SQUAD_DAILY_REPORT table
interest_category_id 🔑
interest_category_name
AD_SQUAD_DEVICE_OS_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_SQUAD_DAILY_REPORT table
operating_system 🔑
AD_SQUAD_DEVICE_MAKE_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_SQUAD_DAILY_REPORT table
make 🔑
AD_SQUAD_DEMOGRAPHIC_DAILY_REPORT metrics
Expand for details
COLUMN
REFERENCE
All columns from the AD_SQUAD_DAILY_REPORT table
gender 🔑
age_bucket 🔑
UNIQUE_IMPRESSION_DAILY_REPORT custom reports
The following custom reports contain only non-summable metrics for day granularity: