Release Notes

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'

NOTE: 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'

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

September 2024

We have added a new prebuilt report, CAMPAIGN_PLACEMENT_REPORT_INCOMING.

Until December 5, 2024, all usage for this report will count towards free MAR.

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