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

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

Following are the list of report tables synced by Snapchat Ads connector. CAMPAIGN_HOURLY_REPORT, AD_HOURLY_REPORT and AD_SQUAD_HOURLY_REPORT will contain all the metrics which can be summed up. UNIQUE_IMPRESSION report tables contain only non-summable metrics for both Hour and Day granularity.