Release Notes

October 2025

We've added the following columns to the TARGETING_GEOLOCATION_HISTORY table:

• geo_type
• geo_value
• fivetran_id

We've also discontinued support for the index column in the TARGETING_GEOLOCATION_HISTORY table.

We unified each connector’s pre-built dbt Core*–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.

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

June 2025

The Snapchat Ads connector now lets you select individual accounts to sync, instead of selecting entire organizations.

We have added a new Quickstart package for the Microsoft Dynamics 365 CRM connector.

We have updated the Quickstart packages for the following connectors:

• Connectors supporting the Ad Reporting data model to version 1.15.0.
• Connectors supporting the App Reporting data model to version 0.6.0.
• Connectors supporting the Shopify Holistic Reporting data model to version 0.8.0.
• Amazon Ads to version 0.5.0.
• Amplitude to version 0.7.0.
• Apple App Store to version 0.6.0.
• Apple Search Ads to version 0.6.0.
• Asana to version 0.9.0.
• Facebook Ads to version 0.10.0.
• Fivetran Platform to version 2.2.0.
• GitHub to version 0.9.0.
• Google Ads to version 0.14.0.
• Google Play to version 0.5.0.
• Greenhouse to version 0.9.0.
• HubSpot to version 0.24.0.
• Intercom to version 0.10.0.
• Jira to version 0.21.0.
• Klaviyo to version 0.9.0.
• Lever to version 0.8.0.
• LinkedIn Ad Analytics to version 0.12.0.
• Mailchimp to version 0.12.0.
• Microsoft Advertising to version 0.12.0.
• Mixpanel to version 0.13.0.
• NetSuite SuiteAnalytics to version 0.20.0.
• Pendo to version 0.6.0.
• Pinterest Ads to version 0.13.0.
• QuickBooks to version 0.20.0.
• Recurly to version 0.7.0.
• Reddit Ads to version 0.5.0.
• Sage Intacct to version 0.7.0.
• Salesforce to version 1.3.0.
• Snapchat Ads to version 0.10.0.
• Stripe to version 0.19.0.
• TikTok Ads to version 0.9.0.
• Twilio to version 0.5.0.
• Twitter Ads to version 0.10.0.
• Workday HCM to version 0.4.0.
• Zendesk Support to version 0.24.1.

April 2025

We now support the impression value for the Action report time parameter in custom reports. Previously, we only supported the conversion value.

February 2025

We have updated the Quickstart packages for the following connectors:

• Ad Reporting data model connectors to version 0.5.0
• Amplitude to version 0.6.0
• Apple App Store to version 0.5.0
• App reporting data model connectors to version 0.5.0
• Asana to version 0.8.3
• HubSpot to version 0.21.0
• Sage Intacct to version 0.6.0
• Shopify to version 0.17.0
• Snapchat Ads to version 0.8.0
• Stripe to version 0.16.1
• Zuora to version 0.3.2

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:

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 connection and Update a connection public API endpoints. Now you can authorize the following connections by adding the auth section to payloads:

• Microsoft Advertising
• Snapchat Ads

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.

Read our Snapchat Ads connector documentation.