Amazon Ads Migration Guide
Upgrading to 5.0.0
The following streams have updated schemas due to a change with the Amazon Ads API:
SponsoredBrandsCampaignsSponsoredBrandsAdGroupsSponsoredProductsCampaignsSponsoredProductsAdGroupBidRecommendations
Schema Changes - Removed/Added Fields
| 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 |
Refresh affected schemas and reset data
- Select Connections in the main navbar.
- Select the connection(s) affected by the update.
- Select the Replication tab.
- Select Refresh source schema.
- Select OK.
Any detected schema changes will be listed for your review.
- Select Save changes at the bottom of the page.
- Ensure the Reset affected streams option is checked.
Depending on destination type you may not be prompted to reset your data.
- 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.
Upgrading to 4.0.0
Streams SponsoredBrandsAdGroups and SponsoredBrandsKeywords now have updated schemas.
Refresh affected schemas and reset data
- Select Connections in the main navbar.
- Select the connection(s) affected by the update.
- Select the Replication tab.
- Select Refresh source schema.
- Select OK.
Any detected schema changes will be listed for your review.
- Select Save changes at the bottom of the page.
- Ensure the Reset affected streams option is checked.
Depending on destination type you may not be prompted to reset your data.
- 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.
Upgrading to 3.0.0
A major update of attribution report stream schemas. For a smooth migration, a data reset and a schema refresh are needed.