Skip to main content
Documentation
Troubleshooting
Feature Requests Status

Snapchat Ads Overview

Edit on GitHub
  • Updated
Fivetran System User Fivetranner

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.

Featureslink

Feature Name     Supported Notes
Capture Deletes
Custom Data check Only in CAMPAIGN_HISTORY table. All fields prefixed with measurement_spec_.
Data Blocking
Column Hashing
Re-sync check Connector level
History check All tables
API Configurable check
Priority-first sync check Reporting tables
dbt Package check Get the package: source / transform

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 ticket 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

Noteslink

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

Related articles

Didn’t find what you need?

Contact support