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.
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:
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.
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.