Amazon Ads Migration Guide

Availability:

Airbyte Cloud Airbyte OSS PyAirbyte

Support Level:

Airbyte Connector

Connector Version:

6.2.0(Last updated 11 hours ago)

CDK Version:

6.5.0

Sync Success Rate:

Usage Rate:

The SponsoredDisplayReportStream stream now has an updated schema, thanks to a recent change in the Amazon Ads API. You can find more details in the Amazon Migration Guide (metrics).

Please note that SponsoredBrandsReportStream and SponsoredBrandsVideoReportStream will become unavailable as a result of the deprecation of API V2. We recommend switching to SponsoredBrandsV3ReportStream as a great alternative. see Amazon Migration Guide (metrics) for more info.

Streams SponsoredBrandsReportStream SponsoredBrandsVideoReportStream will become unavailable. It is recommended to use SponsoredBrandsV3ReportStream as an alternative.

1. Select Connections in the main navbar.
   1. Select the connection(s) affected by the update.
2. Select the Replication tab.
   1. Select Refresh source schema.
   2. Select OK.

Any detected schema changes will be listed for your review.

3. Select Save changes at the bottom of the page.
   1. Ensure the Reset affected streams option is checked.

Depending on destination type you may not be prompted to reset your data.

4. Select Save connection.

This will reset the data in your destination and initiate a fresh sync.

For more information on resetting your data in Airbyte, see this page.

The following streams have updated schemas due to a change with the Amazon Ads API:

• SponsoredBrandsCampaigns
• SponsoredBrandsAdGroups
• SponsoredProductsCampaigns
• SponsoredProductsAdGroupBidRecommendations

Stream Name	Removed Fields	Added Fields
SponsoredBrandsCampaigns	serviceStatus, bidOptimization, bidMultiplier, adFormat, bidAdjustments, creative, landingPage, supplySource	ruleBasedBudget, bidding, productLocation, costType, smartDefault, extendedData
SponsoredBrandsAdGroups	bid, keywordId, keywordText, nativeLanuageKeyword, matchType	extendedData
SponsoredProductsCampaigns	campaignType, dailyBudget, ruleBasedBudget, premiumBidAdjustment, networks	dynamicBidding, budget, extendedData
SponsoredProductsAdGroupBidRecommendations	suggestedBid	theme, bidRecommendationsForTargetingExpressions

1. Select Connections in the main navbar.
   1. Select the connection(s) affected by the update.
2. Select the Replication tab.
   1. Select Refresh source schema.
   2. Select OK.

Any detected schema changes will be listed for your review.

3. Select Save changes at the bottom of the page.
   1. Ensure the Reset affected streams option is checked.

Depending on destination type you may not be prompted to reset your data.

4. Select Save connection.

This will reset the data in your destination and initiate a fresh sync.

For more information on resetting your data in Airbyte, see this page.

Streams SponsoredBrandsAdGroups and SponsoredBrandsKeywords now have updated schemas.

1. Select Connections in the main navbar.
   1. Select the connection(s) affected by the update.
2. Select the Replication tab.
   1. Select Refresh source schema.
   2. Select OK.

Any detected schema changes will be listed for your review.

3. Select Save changes at the bottom of the page.
   1. Ensure the Reset affected streams option is checked.

Depending on destination type you may not be prompted to reset your data.

4. Select Save connection.

This will reset the data in your destination and initiate a fresh sync.

For more information on resetting your data in Airbyte, see this page.

A major update of attribution report stream schemas. For a smooth migration, a data reset and a schema refresh are needed.