Snapchat Ads Overview

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	check	Column level
Column hashing	check
Re-sync	check	Connector level
History	check	All tables
API configurable	check
Priority-first sync	check	Reporting tables
Private networking
Fivetran data models	check	Get the models: 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 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

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.