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
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.
CAMPAIGN_HOURLY_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 |
AD_HOURLY_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_SQUAD_HOURLY_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 |
CAMPAIGN_UNIQUE_IMPRESSION_HOURLY_REPORT & CAMPAIGN_UNIQUE_IMPRESSION_DAILY_REPORT
| COLUMN | REFERENCE |
|---|---|
| campaign_id 🔑 | campaign_history |
| date 🔑 | |
| attachment_frequency | |
| attachment_uniques | |
| frequency | |
| uniques |
AD_UNIQUE_IMPRESSION_HOURLY_REPORT & AD_UNIQUE_IMPRESSION_DAILY_REPORT
| COLUMN | REFERENCE |
|---|---|
| ad_id 🔑 | ad_history |
| date 🔑 | |
| attachment_frequency | |
| attachment_uniques | |
| frequency | |
| uniques |
AD_SQUAD_UNIQUE_IMPRESSION_HOURLY_REPORT & AD_SQUAD_UNIQUE_IMPRESSION_DAILY_REPORT
| COLUMN | REFERENCE |
|---|---|
| ad_squad_id 🔑 | ad_squad_history |
| date 🔑 | |
| attachment_frequency | |
| attachment_uniques | |
| frequency | |
| uniques |