Release Notes

May 2026

Due to Amazon deprecating V2 Stores, we've updated our connector to use the new endpoints that replace it.

The old endpoint:

/v2/stores

The new endpoints (for more details, see Amazon Ads documentation):

/brand/stores/v1/stores/list
/brand/stores/v1/storePages/list

Related tables were slightly changed in the following manner:

We've added the field store_status to the SB_STORE table
We've added the field store_page_status to the SB_STORE_PAGE_INFO table

Due to Amazon deprecating V2 Suggested Keyword, we've updated our connector to use the new endpoints that replace it.

The old endpoint:

/v2/sp/adGroups/{adGroupId}/suggested/keywords/extended
/v2/sp/asins/{asin}/suggested/keywords

The new endpoints (for more details, see Amazon Ads documentation):

/sp/targets/keywords/recommendations

We have added the following columns to the AD_GROUP_SUGGESTED_KEYWORD and ASIN_SUGGESTED_KEYWORD tables:

rec_id
search_term_impression_rank
search_term_impression_share
translation
user_selected_keyword

We've discontinued support for the match_type and state columns from the AD_GROUP_SUGGESTED_KEYWORD table:

match_type
state

We've discontinued support for the match_type column from the ASIN_SUGGESTED_KEYWORD table.

April 2026

We've implemented a new mechanism to fetch source schema quicker when creating a new connection. Now, instead of deriving the schema from source data, we use fixed schema models. This allows you to see the schema blocking and hashing screen almost immediately after creating a new connection.

As a result of this improvement, you may see empty tables and columns in the Schema tab of existing connections that have not yet synced to your destination.

After optimizing schema fetch for the connectors below, these connections no longer use the pre-initial-sync schema capture flow described in schema_status.

Affected connectors

REST API request changes (breaking)

For the connectors listed above, the schema_status request field is no longer supported in:

Update a Connection

If your automation still sends schema_status for these connectors, requests may fail.

REST API response changes

For the connectors listed above, schema_status is no longer returned for flows that previously exposed it, including:

If your downstream transformations or orchestration rely on this field, update them to handle its absence.

Dashboard flow change

In the Fivetran dashboard, these connectors no longer show the schema prefetch and review step before initial sync. After connection creation, you proceed directly to the initial sync flow.

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.

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.

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_BID_RECOMMENDATION_CLICK
AD_GROUP_BID_RECOMMENDATION_ORDER
AD_GROUP_BID_RECOMMENDATION_VALUE
AD_GROUP_THEME_BASED_BID_RECOMMENDATION
ASIN_BID_RECOMMENDATION_CLICK
ASIN_BID_RECOMMENDATION_ORDER
ASIN_BID_RECOMMENDATION_VALUE
ASIN_THEME_BASED_BID_RECOMMENDATION

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.