Snapchat Ads Release Notes

November 2021link

We now sync the following reporting tables:

• CAMPAIGN_DAILY_REPORT
• CAMPAIGN_UNIQUE_IMPRESSION_DAILY_REPORT
• CAMPAIGN_DEMOGRAPHIC_DAILY_REPORT
• CAMPAIGN_DEVICE_MAKE_DAILY_REPORT
• CAMPAIGN_DEVICE_OS_DAILY_REPORT
• CAMPAIGN_GEO_COUNTRY_DAILY_REPORT
• CAMPAIGN_GEO_DMA_DAILY_REPORT
• CAMPAIGN_GEO_REGION_DAILY_REPORT
• CAMPAIGN_INTEREST_DAILY_REPORT
• AD_DAILY_REPORT
• AD_UNIQUE_IMPRESSION_DAILY_REPORT
• AD_DEMOGRAPHIC_DAILY_REPORT
• AD_DEVICE_MAKE_DAILY_REPORT
• AD_DEVICE_OS_DAILY_REPORT
• AD_GEO_COUNTRY_DAILY_REPORT
• AD_GEO_DMA_DAILY_REPORT
• AD_GEO_REGION_DAILY_REPORT
• AD_INTEREST_DAILY_REPORT
• AD_SQUAD_DAILY_REPORT
• AD_SQUAD_UNIQUE_IMPRESSION_DAILY_REPORT
• AD_SQUAD_DEMOGRAPHIC_DAILY_REPORT
• AD_SQUAD_DEVICE_MAKE_DAILY_REPORT
• AD_SQUAD_DEVICE_OS_DAILY_REPORT
• AD_SQUAD_GEO_COUNTRY_DAILY_REPORT
• AD_SQUAD_GEO_DMA_DAILY_REPORT
• AD_GEO_REGION_DAILY_REPORT
• AD_INTEREST_DAILY_REPORT

September 2021link

We have removed the following tables:

• AD_SQUAD_UNIQUE_IMPRESSION_HOURLY_REPORT
• AD_UNIQUE_IMPRESSION_HOURLY_REPORT
• CAMPAIGN_UNIQUE_IMPRESSION_HOURLY_REPORT

because the Snapchat Marketing API has deprecated the following fields for HOUR granularity:

• attachment_uniques
• attachment_frequency
• frequency
• uniques

August 2021link

Our Snapchat Ads connector now supports multithreading. We now use multiple parallel API requests to sync data from your Snapchat Ads account to your destination, which makes your syncs faster. The connector’s sync speed depends on your Snapchat Ads API quota and account metadata.

May 2021link

We have released pre-built, dbt Core-compatible data models for Snapchat Ads. Find the models in Fivetran’s dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

We have added Snapchat Ads to our ad reporting dbt model. Learn more in our ad reporting model documentation.

July 2020link

The Snapchat Ads connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it’s quickly ready for you to use. Snapchat Ads’s priority-first syncs fetch the most recent thirty days of data from the reporting tables.

To learn more, see our priority-first sync documentation.

May 2020link

You can now configure your Snapchat Ad Analytics connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

December 2019link

When setting up your connector, you can now select which organizations you’d like to sync. Previously, Fivetran synced all organizations by default.

October 2019link

You can now select how many months of reporting data you’d like to include in your initial sync. Choose from the following options:

• Three months
• Six months
• 12 months (default)
• 24 months
• All time

January 2019link

We have added the new column objective to the CAMPAIGN_HISTORY table.

December 2018link

Fivetran now fetches data with HOUR granularity for some reports. For the campaign, ad, and ad squad reports, there will be three new tables per report:

• All summable metrics with HOUR granularity
• Non-summable metrics with HOUR granularity
• Non-summable metrics with DAY granularity

October 2018link

We have added a new field, operation, to the AD_SQUAD_SEGMENT_HISTORY table.

August 2018link

Snapchat Ads is a multimedia messaging app.

Link to Snapchat Ads documentation