Release Notes

October 2025

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.

August 2025

We have updated the Quickstart packages for the following connectors:

Amazon Ads to version 1.0.0.
Asana to version 1.0.0.
Facebook Pages to version 1.0.0.
Fivetran Platform to version 2.3.0.
GitHub to version 1.0.0.
Greenhouse to version 1.0.0.
Instagram Business to version 1.0.0.
Intercom to version 1.0.0.
Iterable to version 1.0.0.
Jira to version 1.0.0.
Klaviyo to version 1.0.0.
Lever to version 1.0.0.
LinkedIn Ad Analytics to version 1.0.0.
LinkedIn Company Pages to version 1.0.0.
Mailchimp to version 1.0.0.
Marketo to version 1.0.0.
Microsoft Advertising to version 1.0.0.
Mixpanel to version 0.14.0.
NetSuite SuiteAnalytics to version 1.0.0.
Pardot to version 1.0.0.
Pendo to version 1.0.0.
Pinterest Ads to version 1.0.0.
Qualtrics to version 1.0.0.
QuickBooks to version 0.21.0.
Recharge to version 1.0.0.
Recurly to version 1.0.0.
Reddit Ads to version 1.0.0.
Sage Intacct to version 1.0.0.
Salesforce Marketing Cloud to version 0.3.0.
ServiceNow to version 0.5.0.
Shopify to version 0.21.0.

June 2025

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.

May 2025

We've upgraded Bid Recommendation tables from version 3.0 to version 5.0. As part of the upgrade, we've made the following changes:

We've deprecated the following tables:

AD_GROUP_BID_RECOMMENDATION_CLICK
AD_GROUP_BID_RECOMMENDATION_ORDER
ASIN_BID_RECOMMENDATION_CLICK
ASIN_BID_RECOMMENDATION_ORDER

We've backed up the following tables and rebuilt them with new primary keys:

AD_GROUP_BID_RECOMMENDATION_VALUE
AD_GROUP_THEME_BASED_BID_RECOMMENDATION
ASIN_BID_RECOMMENDATION_VALUE
ASIN_THEME_BASED_BID_RECOMMENDATION

We've added the following tables:

AD_GROUP_BID_ANALYSIS
ASIN_BID_ANALYSIS

All changes will be gradually rolled out starting on May 13, 2025.

Until June 14, 2025, all usage generated by the *_ANALYSIS tables will count towards free MAR.

December 2024

The Amazon Ads connector now supports the Hybrid Deployment model. For more information, see our setup instructions

November 2024

We have deprecated the following Sponsored Display version 2 reporting tables in accordance with Amazon's deprecation calendar:

SD_AD_GROUP_REPORT
SD_ASIN_REPORT
SD_CAMPAIGN_REPORT
SD_MATCHED_TARGET_REPORT
SD_PRODUCT_AD_REPORT
SD_TARGET_REPORT

The tables listed above have stopped receiving new data. However, we've renamed these tables in your destination by adding the '_v_2' suffix to each of them. You still have access to old data.

We have added support for the following Sponsored Display version 3 reporting tables:

SD_AD_GROUP_REPORT_V_3
SD_CAMPAIGN_REPORT_V_3
SD_MATCHED_TARGET_REPORT_V_3
SD_PRODUCT_AD_REPORT_V_3
SD_PURCHASED_PRODUCTS_REPORTS
SD_TARGET_REPORT_V_3

Until November 15, 2024, all usage related to these new reports counts towards free MAR.

We've added the following columns to the AD_GROUP_LEVEL_REPORT and ADVERTISED_PRODUCT_REPORT tables:

add_to_list
qualified_borrows
royalty_qualified_borrows

We've added the following columns to the CAMPAIGN_LEVEL_REPORT, CAMPAIGN_PLACEMENT_REPORT_INCOMING, TARGETING_REPORT, and TARGETING_KEYWORD_REPORT tables:

add_to_list
qualified_borrows
royalty_qualified_borrows
top_of_search_impression_share

We've added the following columns to the ADVERTISED_PRODUCT_REPORT and PURCHASED_PRODUCT_TARGETING_REPORT tables:

add_to_list
add_to_list_from_clicks
purchases_other_sku14d
purchases_other_sku1d
purchases_other_sku30d
purchases_other_sku7d
qualified_borrows
qualified_borrows_from_clicks
royalty_qualified_borrows
royalty_qualified_borrows_from_clicks

For more information, see Amazon's reporting documentation.

We have extended the free MAR period for the CAMPAIGN_PLACEMENT_REPORT_INCOMING prebuilt report. All usage for this report will count towards free MAR until January 15, 2025.

September 2024

We have added a new prebuilt report, CAMPAIGN_PLACEMENT_REPORT_INCOMING.

November 2023

We have added new tables to support the Sponsored Brands and Sponsored Display services.

The names of the new tables for the Sponsored Brands and Sponsored Display services have the SB_ and SD_ prefixes, respectively.

By default, we select all new tables are selected for the synced. You can sync these tables for free until November 17, 2023. Be sure to exclude the tables that you don't want to count towards paid Monthly Active Rows (MAR) before this date.

For more information, see our Amazon Ads ERD.

Expand for the full list of Sponsored Brands tables

Metadata tables:
- SB_AD_GROUP_HISTORY
- SB_AD_HISTORY
  - SB_AD_LANDING_PAGE_ASIN
- SB_BRAND
  - SB_STORE_ASSET
- SB_BUDGET_RULE_HISTORY
  - SB_BUDGET_RULE_CAMPAIGN
  - SB_BUDGET_RULE_RECOMMENDATION
  - SB_BUDGET_RULE_RECURRENCE_DAY
- SB_CAMPAIGN_history
  - SB_BUDGET_RECOMMENDATION
  - SB_BUDGET_USAGE_HISTORY
  - SB_CAMPAIGN_BID_ADJUSTMENTS_BY_PLACEMENt
  - SB_CAMPAIGN_BID_ADJUSTMENTS_BY_SHOPPER_SEGMENT
  - SB_CAMPAIGN_TAG
- SB_CAMPAIGN_moderation
  - SB_CAMPAIGN_VIOLATION_ASIN_CONTENT
  - SB_CAMPAIGN_VIOLATION_ASIN_EVIDENCE
  - SB_CAMPAIGN_VIOLATION_IMAGE_CONTENT
  - SB_CAMPAIGN_VIOLATION_image_EVIDENCE
  - SB_CAMPAIGN_VIOLATION_POLICY
  - SB_CAMPAIGN_VIOLATION_TEXT_CONTENT
  - SB_CAMPAIGN_VIOLATION_TEXT_EVIDENCE
- SB_CREATIVE_HISTORY
  - SB_AD_SUB_PAGE
  - SB_CREATIVE_ASIN
  - SB_CREATIVE_CUSTOM_IMAGE
  - SB_CREATIVE_ORIGINAL_VIDEO_ASSET
  - SB_CREATIVE_VIDEO_ASSET
- SB_KEYWORD
- SB_KEYWORD_RECOMMENDATION_ASIN
- SB_KEYWORD_RECOMMENDATION_URL
- SB_NEGATIVE_KEYWORD
- SB_NEGATIVE_PRODUCT_TARGET
  - SB_NEGATIVE_PRODUCT_TARGET_EXPRESSION
  - SB_NEGATIVE_PRODUCT_TARGET_RESOLVED_EXPRESSION
- SB_PRODUCT_TARGET
  - SB_PRODUCT_TARGETING_CATEGORY
  - SB_PRODUCT_TARGET_EXPRESSION
  - SB_PRODUCT_TARGET_RESOLVED_EXPRESSION
- SB_STORE
  - SB_STORE_PAGE_INFO
- SB_TARGETING_RECOMMENDATION_CATEGORY
  - SB_TARGETING_RECOMMENDATION_BRAND_CATEGORY
- SB_TARGETING_RECOMMENDATION_PRODUCT
Reporting tables:
- SB_AD_GROUP_REPORT
- SB_AD_REPORT
- SB_BENCHMARK_BRAND_AND_CATEGORY
- SB_CAMPAIGN_REPORT
- SB_KEYWORD_REPORT
- SB_PLACEMENT_REPORT
- SB_PURCHASED_PRODUCT
- SB_SEARCH_TERM_REPORT
- SB_TARGET_REPORT

Expand for the full list of Sponsored Display tables

Metadata tables:
- SD_AD_GROUP_HISTORY
- SD_BID_RECOMMENDATION
- SD_BRAND_SAFETY_HISTORY
  - SD_BRAND_SAFETY_STATUS_HISTORY
- SD_CAMPAIGN_HISTORY
  - SD_BUDGET_RULE_HISTORY
  - SD_BUDGET_USAGE_HISTORY
- SD_CREATIVE
  - SD_CREATIVE_MODERATION
- SD_negative_TARGETING_history
  - SD_NEGATIVE_TARGETING_EXPRESSION
  - SD_NEGATIVE_TARGETING_RESOLVED_EXPRESSION
- SD_PRODUCT_AD_HISTORY
- SD_TARGETING_HISTORY
  - SD_TARGETING_EXPRESSION
  - SD_TARGETING_RESOLVED_EXPRESSION
- SD_TARGETING_RECOMMENDATION_AUDIENCE
- SD_TARGETING_RECOMMENDATION_CATEGORY
- SD_TARGETING_RECOMMENDATION_PRODUCT
Reporting tables:
- SD_AD_GROUP_REPORT
- SD_ASIN_REPORT
- SD_CAMPAIGN_REPORT
- SD_MATCHED_TARGET_REPORT
- SD_PRODUCT_AD_REPORT
- SD_TARGET_REPORT

June 2023

We have upgraded our Amazon Ads connector from version 2 to 3 of the Sponsored Products API to support Amazon's upcoming deprecations. As part of the upgrade, we have made the following schema changes:

Added the following new tables:
- AD_GROUP_SERVING_STATUS_DETAIL
- CAMPAIGN_NEGATIVE_KEYWORD_SERVING_STATUS_DETAIL
- CAMPAIGN_PLACEMENT_BIDDING
- CAMPAIGN_SERVING_STATUS_DETAIL
- CAMPAIGN_TAG
- KEYWORD_SERVING_STATUS_DETAIL
- NEGATIVE_KEYWORD_SERVING_STATUS_DETAIL
- NEGATIVE_TARGETING_SERVING_STATUS_DETAIL
- TARGETING_SERVING_STATUS_DETAIL
Changed the data type of the id column from INT to STRING in the following tables:
- AD_GROUP_HISTORY
- CAMPAIGN_HISTORY
- CAMPAIGN_NEGATIVE_KEYWORD_HISTORY
- KEYWORD_HISTORY
- NEGATIVE_KEYWORD_HISTORY
- PRODUCT_AD_HISTORY
- TARGETING_CLAUSE_HISTORY
Deprecated the BIDDING_ADJUSTMENT table
Added a new column, native_language_locale, to the KEYWORD_HISTORY table
Added two new columns, native_language_keyword and native_language_locale, to the NEGATIVE_KEYWORD_HISTORY table
Made the following changes to the CAMPAIGN_HISTORY table:
- Added three new columns, budget, budget_type, and effective_budget
- Removed the campaign_type, daily_budget, placement, and premium_bid_adjustment columns
Made the following changes to the PRODUCT_AD_SERVING_STATUS_DETAIL table:
- Added a new column, help_url
- Removed two columns, _fivetran_id and level

We are rolling out these changes to all existing connections before June 30, 2023. For more information about the changes, see Amazon's migration guide.

May 2023

We have changed the INT data type to DOUBLE for the following metric columns in the PURCHASED_PRODUCT_KEYWORD_REPORT and PURCHASED_PRODUCT_TARGETING_REPORT reports:

sales_other_sku_1_d
sales_other_sku_7_d
sales_other_sku_14_d
sales_other_sku_30_d

January 2023

We have released pre-built, dbt Core-compatible data models for Amazon Ads. Find the models in Fivetran's dbt hub or our Fivetran 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 Amazon Ads to our ad reporting dbt model. Learn more in our ad reporting model documentation.

November 2022

We have migrated from version 2 to version 3 of the Bid Recommendations endpoint of the Amazon Ads Sponsored Products API.

We have added the following tables:

AD_GROUP_THEME_BASED_BID_RECOMMENDATION
AD_GROUP_BID_RECOMMENDATION_CLICK
AD_GROUP_BID_RECOMMENDATION_ORDER
AD_GROUP_BID_RECOMMENDATION_VALUE
ASIN_THEME_BASED_BID_RECOMMENDATION
ASIN_BID_RECOMMENDATION_CLICK
ASIN_BID_RECOMMENDATION_ORDER
ASIN_BID_RECOMMENDATION_VALUE

We have deprecated the AD_GROUP_BID_RECOMMENDATION and KEYWORD_BID_RECOMMENDATION tables.

October 2022

We migrated from version 2 to version 3 of the reporting Amazon Ads API. We have added the following report tables:

ADVERTISED_PRODUCT_REPORT
CAMPAIGN_AD_GROUP_REPORT
CAMPAIGN_LEVEL_REPORT
CAMPAIGN_PLACEMENT_REPORT
PURCHSED_PRODUCT_KEYWORD_REPORT
PURCHASED_PRODUCT_TARGETING_REPORT
SEARCH_TERM_AD_KEYWORD_REPORT
SEARCH_TERM_TARGETING_REPORT
TARGETING_KEYWORD_REPORT
TARGETING_REPORT

We have deprecated the following report tables:

AD_GROUP_REPORT
ASIN_KEYWORD_REPORT
ASIN_TARGET_REPORT
CAMPAIGN_REPORT
KEYWORD_REPORT
PLACEMENT_REPORT
PRODUCT_ADS_REPORT
SEARCH_TERM_KEYWORD_REPORT
SEARCH_TERM_TARGET_REPORT
TARGET_REPORT

August 2022

Our Amazon Ads connector is now generally available. Read our Amazon Ads connector documentation.

July 2022

Amazon Ads is an advertising service that uses the pay-per-click model. Sellers only pay when shoppers click sellers' ads.

Read our Amazon Ads connector documentation.