Release Notes
January 2024
We now support additional fields corresponding to separate "swipe-up" and "view" variants of selected metrics for custom reports. For more information, see our Custom Report Fields and Limitations documentation.
We have added the following new columns corresponding to separate "swipe-up" and "view" metric variants to the campaign reporting tables, ad reporting tables, and ad squad reporting tables:
Expand to see the full list of the added fields.
custom_event_1_swipe_up
custom_event_1_view
custom_event_1_value_swipe_up
custom_event_1_value_view
custom_event_2_swipe_up
custom_event_2_view
custom_event_2_value_swipe_up
custom_event_2_value_view
custom_event_3_swipe_up
custom_event_3_view
custom_event_3_value_swipe_up
custom_event_3_value_view
custom_event_4_swipe_up
custom_event_4_view
custom_event_4_value_swipe_up
custom_event_4_value_view
custom_event_5_swipe_up
custom_event_5_view
custom_event_5_value_swipe_up
custom_event_5_value_view
Learn more in our Snapchat Ads Report Tables documentation.
October 2023
We now support custom reports that allow you to select the following parameters and fields:
- Breakdown
- Granularity
- Dimension (optional)
- Breakout (optional)
- Base metrics fields (optional)
- SKAd metrics fields (optional)
See our Custom Reports and Limitations documentation page for details.
January 2023
We have added the following new columns to the AD_SQUAD_HISTORY
table:
bid_strategy
delivery_constraint
pacing_type
target_bid
We have added two new columns, targetable_status
and upload_status
, to the AUDIENCE_SEGMENT_HISTORY
table.
We have added the following new columns to the Campaign Reporting tables, Ad Reporting tables, and Ad Squad Reporting tables:
conversion_add_cart_swipe_up
conversion_add_cart_view
conversion_page_views_swipe_up
conversion_page_views_view
conversion_subscribe_swipe_up
conversion_subscribe_view
conversion_login
conversion_login_swipe_up
conversion_login_view
conversion_add_to_wishlist
conversion_add_to_wishlist_swipe_up
conversion_add_to_wishlist_value
conversion_add_to_wishlist_view
conversion_start_trial
conversion_start_trial_value
conversion_sign_ups_value
conversion_sign_ups_swipe_up
conversion_sign_ups_view
custom_event_1
custom_event_1_value
custom_event_2
custom_event_2_value
custom_event_3
custom_event_3_value
custom_event_4
custom_event_4_value
custom_event_5
custom_event_5_value
Learn more in our Snapchat Ads Report Tables documentation.
December 2022
We have added new columns to the campaign reporting, ad reporting, and ad squad reporting tables:
conversion_subscribe
conversion_purchases_swipe_up
conversion_purchases_view
Learn more in our Snapchat Ads Report Tables documentation.
August 2022
We have added a new column, video_views_15s
, to the campaign reporting tables, ad reporting tables, and ad squad reporting tables. Learn more in our Snapchat Ads Report Tables documentation.
November 2021
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 2021
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 2021
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 2021
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.
April 2021
We have expanded the Create a Connector and Modify a Connector public API endpoints. Now you can authorize the following connectors by adding the auth
section to payloads:
July 2020
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' worth of data from the reporting tables.
To learn more, see our priority-first sync documentation.
May 2020
You can now configure your Snapchat Ads connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
December 2019
When setting up your connector, you can now select which organizations you'd like to sync. Previously, Fivetran synced all organizations by default.
October 2019
You can now select how many months' worth 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 2019
We have added a new column, objective
, to the CAMPAIGN_HISTORY
table.
December 2018
We now fetch 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 2018
We have added a new column, operation
, to the AD_SQUAD_SEGMENT_HISTORY
table.
August 2018
Snapchat Ads is a multimedia messaging app.