Prebuilt Reports The Snapchat Ads connector supports the following prebuilt reports that contain every retrievable metric (* indicates a retrievable metric):
AD_DAILY_REPORTAD_HOURLY_REPORTAD_SQUAD_DAILY_REPORTAD_SQUAD_HOURLY_REPORTCAMPAIGN_DAILY_REPORTCAMPAIGN_HOURLY_REPORTWe 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.
NOTE: We include prebuilt reports by default. You can enable or disable prebuilt report tables on the Schema tab to avoid syncing data you don't need.
AD_HOURLY_REPORT and AD_DAILY_REPORT metrics Expand for details COLUMN REFERENCE ad_id 🔑ad_history date 🔑android_installsattachment metrics*avg_screen_time_millisavg_view_time_millisconversion metrics*impressionsios_installsquartile_1quartile_2quartile_3screen_time_millisspendstory_completesstory_opensswipe_up_percentswipestotal_installsvideo_viewsvideo_views_15sview_completionview_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_installsattachment metrics*avg_screen_time_millis avg_view_time_millisconversion metrics*impressions ios_installs quartile_1quartile_2 quartile_3 screen_time_millisspend story_completesstory_opensswipe_up_percentswipestotal_installsvideo_viewsvideo_views_15sview_completionview_time_millis
CAMPAIGN_HOURLY_REPORT and CAMPAIGN_DAILY_REPORT metrics Expand for details COLUMN REFERENCE campaign_id 🔑campaign_history date 🔑android_installsattachment metrics*avg_screen_time_millisavg_view_time_millisconversion metrics*impressionsios_installsquartile_1quartile_2quartile_3screen_time_millisspendstory_completesstory_opensswipe_up_percentswipestotal_installsvideo_viewsvideo_views_15sview_completionview_time_millis
CAMPAIGN prebuilt reports Fivetran supports the following campaign prebuilt reports:
CAMPAIGN_GEO_COUNTRY_DAILY_REPORTCAMPAIGN_GEO_REGION_DAILY_REPORTCAMPAIGN_GEO_DMA_DAILY_REPORTCAMPAIGN_INTEREST_DAILY_REPORTCAMPAIGN_DEVICE_OS_DAILY_REPORTCAMPAIGN_DEVICE_MAKE_DAILY_REPORTCAMPAIGN_DEMOGRAPHIC_DAILY_REPORTCAMPAIGN_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_REPORTAD_GEO_REGION_DAILY_REPORTAD_GEO_DMA_DAILY_REPORTAD_INTEREST_DAILY_REPORTAD_DEVICE_OS_DAILY_REPORTAD_DEVICE_MAKE_DAILY_REPORTAD_DEMOGRAPHIC_DAILY_REPORTAD_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_REPORTAD_SQUAD_GEO_REGION_DAILY_REPORTAD_SQUAD_GEO_DMA_DAILY_REPORTAD_SQUAD_INTEREST_DAILY_REPORTAD_SQUAD_DEVICE_OS_DAILY_REPORTAD_SQUAD_DEVICE_MAKE_DAILY_REPORTAD_SQUAD_DEMOGRAPHIC_DAILY_REPORTAD_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:
CAMPAIGN_UNIQUE_IMPRESSION_DAILY_REPORTAD_UNIQUE_IMPRESSION_DAILY_REPORTAD_SQUAD_UNIQUE_IMPRESSION_DAILY_REPORTCAMPAIGN_UNIQUE_IMPRESSION_DAILY_REPORT metrics Expand for details COLUMN REFERENCE campaign_id 🔑campaign_history date 🔑attachment_frequency attachment_uniquesfrequencyuniques
AD_UNIQUE_IMPRESSION_DAILY_REPORT metrics Expand for details COLUMN REFERENCE ad_id 🔑 ad_history date 🔑attachment_frequencyattachment_uniquesfrequency uniques
AD_SQUAD_UNIQUE_IMPRESSION_DAILY_REPORT metrics Expand for details COLUMN REFERENCE ad_squad_id 🔑 ad_squad_history date 🔑attachment_frequencyattachment_uniquesfrequencyuniques
