Amazon Ads
Amazon Ads ETL connector for data replication
Snapshot
Features | Details |
Release Status | Released |
Source API Version | V2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Login Id and Password |
Replication Type | Full Replication Key Based Incremental |
Replication Key | Date |
Suggested Replication Frequency | 24 hours |
Tables/APIs Supported | |
Profile | Portfolio |
Store | SponsoredProducts_Campaign |
SponsoredProducts_CampaignEx | SponsoredProducts_AdGroup |
SponsoredProducts_AdGroupEx | SponsoredProducts_BiddableKeyword |
SponsoredProducts_BiddableKeywordsEx | SponsoredProducts_NegativeKeyword |
SponsoredProducts_NegativeKeywordEx | SponsoredProducts_CampaignNegativeKeyword |
SponsoredProducts_CampaignNegativeKeywordEx | SponsoredProducts_ProductAd |
SponsoredProducts_ProductAdEx | SponsoredProducts_TargetingClause |
SponsoredProducts_TargetingClauseEx | SponsoredProducts_CampaignsReports |
SponsoredProducts_CampaignsReports_Placement | SponsoredProducts_AdGroupReports |
SponsoredProducts_KeywordReports | SponsoredProducts_KeywordReports_SearchTerm |
SponsoredProducts_ProductAdsReports | SponsoredProducts_ProductTargetingReports |
SponsoredProducts_ProductTargetingReports_SearchTerm |
Integrate AmazonAds with Daton
Signin to Daton.
Select AmazonAds from Integrations page
Provide Integration Name, Replication Frequency, History and Region/Marketplace associated with your Amazon Advertising account. Integration name would be used in creating tables for the integration and cannot be changed later.
You will be redirected to Amazon Advertising login for authorizing Daton to extract data periodically.
Post successful authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds.
After account selection, you'll be prompted to select the Tables/APIs for which you need daton to pull.
Then select required fields for each table.
Submit the integration.
Workflow
Integrations could be seen Active tab of Integration List while the job loads data on to the configured warehouse.
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.
AmazonAds Data
TABLES
Profile
Purpose: Retrieve all profiles associated with the Amazon Advertising account.
Source API Documentation: Amazon Ads Profile
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
countryCode | STRING |
currencyCode | STRING |
dailyBudget | NUMERIC |
timeZone | STRING |
accountInfo | RECORD |
Portfolio
Purpose: Retrieve a list of up to 100 portfolios.
Source API Documentation: Amazon Ads Portfolio
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
portfolioId | STRING |
name | STRING |
budget | RECORD |
inBudget | BOOLEAN |
state | STRING |
Store
Purpose: List store information for all registered stores under an advertiser.
Source API Documentation: Amazon Ads Store
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
code | STRING |
entityId | STRING |
storeName | STRING |
brandEntityId | STRING |
storePageInfo | RECORD |
SponsoredProducts_Campaign
Purpose: Return a list of Sponsored Products campaigns.
Source API Documentation: Amazon Ads Sponsored Product - Campaign
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
campaignId | STRING |
name | STRING |
campaignType | STRING |
targetingType | STRING |
state | STRING |
dailyBudget | NUMERIC |
startDate | STRING |
premiumBidAdjustment | BOOLEAN |
bidding | RECORD |
SponsoredProducts_CampaignEx
Purpose: Return a list of Sponsored Products campaigns with additional properties.
Source API Documentation: Amazon Ads Sponsored Product - Campaign Extended
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
campaignId | STRING |
name | STRING |
campaignType | STRING |
targetingType | STRING |
state | STRING |
dailyBudget | NUMERIC |
startDate | STRING |
premiumBidAdjustment | BOOLEAN |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
bidding | RECORD |
SponsoredProducts_AdGroup
Purpose: Return a list of ad groups.
Source API Documentation: Amazon Ads Sponsored Products - Ad Group
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
adGroupId | STRING |
campaignId | STRING |
name | STRING |
defaultBid | NUMERIC |
state | STRING |
SponsoredProducts_AdGroupEx
Purpose: Return a list of ad groups with additional properties
Source API Documentation: Amazon Ads Sponsored Product - Ad Group Extended
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
adGroupId | STRING |
campaignId | STRING |
name | STRING |
defaultBid | NUMERIC |
state | STRING |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
SponsoredProducts_BiddableKeyword
Purpose: Return a list of ad group-level biddable keywords.
Source API Documentation: Amazon Ads Sponsored Product - Keyword
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
keywordId | STRING |
campaignId | STRING |
adGroupId | STRING |
state | STRING |
keywordText | STRING |
matchType | STRING |
SponsoredProducts_BiddableKeywordsEx
Purpose: Return a list of ad group-level biddable keywords with additional properties.
Source API Documentation: Amazon Ads Sponsored Product - Keyword Extended
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
keywordId | STRING |
campaignId | STRING |
adGroupId | STRING |
state | STRING |
keywordText | STRING |
matchType | STRING |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
SponsoredProducts_NegativeKeyword
Purpose: Return a list of negative ad group-level keywords.
Source API Documentation: Amazon Ads Sponsored Product - Negative Keyword
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
keywordId | STRING |
campaignId | STRING |
adGroupId | STRING |
state | STRING |
keywordText | STRING |
matchType | STRING |
SponsoredProducts_NegativeKeywordEx
Purpose: Return a list of negative ad group-level keywords with additional properties.
Source API Documentation: Amazon Ads Sponsored Product - Negative Keyword Extended
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
keywordId | STRING |
campaignId | STRING |
adGroupId | STRING |
state | STRING |
keywordText | STRING |
matchType | STRING |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
SponsoredProducts_CampaignNegativeKeyword
Purpose: Return a list of campaign level negative keywords.
Source API Documentation: Amazon Ads Sponsored Product - Campaign Negative Keyword
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
keywordId | STRING |
campaignId | STRING |
state | STRING |
keywordText | STRING |
matchType | STRING |
SponsoredProducts_CampaignNegativeKeywordEx
Purpose: Return a list of campaign level negative keywords with additional properties.
Source API Documentation: Amazon Ads Sponsored Product - Campaign Negative Keyword Extended
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
keywordId | STRING |
campaignId | STRING |
state | STRING |
keywordText | STRING |
matchType | STRING |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
SponsoredProducts_ProductAd
Purpose: Return a list of product ads.
Source API Documentation: Amazon Ads Sponsored Product - Product Ads
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
adId | STRING |
campaignId | STRING |
adGroupId | STRING |
sku | STRING |
state | STRING |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
SponsoredProducts_ProductAdEx
Purpose: Return a list of product ads with additional properties.
Source API Documentation: Amazon Ads Sponsored Product - Product Ads Extended
Replication: Full Replication
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
adId | STRING |
campaignId | STRING |
adGroupId | STRING |
sku | STRING |
asin | STRING |
state | STRING |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
SponsoredProducts_TargetingClause
Purpose: List targeting expressions.
Source API Documentation: Amazon Ads Sponsored Product - Product Targeting
Replication: Full Load
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
targetId | STRING |
campaignId | STRING |
adGroupId | STRING |
state | STRING |
resolvedExpression | RECORD |
expression | RECORD |
expressionType | STRING |
bid | NUMERIC |
SponsoredProducts_TargetingClauseEx
Purpose: List targeting expressions with additional properties.
Source API Documentation: Amazon Ads Sponsored Product - Product Targeting Extended
Replication: Full Load
Replication Key: N/A
Fields
Name | Target Datatype |
profileId | STRING |
targetId | STRING |
campaignId | STRING |
adGroupId | STRING |
state | STRING |
expression | RECORD |
expressionType | STRING |
bid | NUMERIC |
creationDate | STRING |
lastUpdatedDate | STRING |
servingStatus | STRING |
SponsoredProducts_CampaignsReports
Purpose: Retrieves campaigns performance report.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
bidPlus | NUMERIC |
campaignName | STRING |
campaignId | STRING |
campaignStatus | BOOLEAN |
campaignBudget | NUMERIC |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
SponsoredProducts_CampaignsReports_Placement
Purpose: Retrieves campaigns performance report with 'placement' segmentation'.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
placement | STRING |
bidPlus | NUMERIC |
campaignName | STRING |
campaignId | STRING |
campaignStatus | STRING |
campaignBudget | NUMERIC |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
SponsoredProducts_AdGroupReports
Purpose: Retrieves ad-group performance report.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
campaignName | STRING |
campaignId | STRING |
adGroupName | STRING |
adGroupId | STRING |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
currency | STRING |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
SponsoredProducts_KeywordReports
Purpose: Retrieves keyword performance report.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
campaignName | STRING |
campaignId | STRING |
adGroupName | STRING |
adGroupId | STRING |
keywordId | STRING |
keywordText | STRING |
matchType | STRING |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
SponsoredProducts_KeywordReports_SearchTerm
Purpose: Retrieves keyword performance report with 'query' segmentation.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
query | STRING |
campaignName | STRING |
campaignId | STRING |
adGroupName | STRING |
adGroupId | STRING |
keywordId | STRING |
keywordText | STRING |
matchType | STRING |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
SponsoredProducts_ProductAdsReports
Purpose: Retrieves product-ads performance report.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
campaignName | STRING |
campaignId | STRING |
adGroupName | STRING |
adGroupId | STRING |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
currency | STRING |
asin | STRING |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
SponsoredProducts_ProductTargetingReports
Purpose: Retrieves targets performance report.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
campaignName | STRING |
campaignId | STRING |
adGroupName | STRING |
adGroupId | STRING |
targetId | STRING |
targetingExpression | STRING |
targetingText | STRING |
targetingType | STRING |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
SponsoredProducts_ProductTargetingReports_SearchTerm
Purpose: Retrieves targets performance report with 'query' segmentation.
Source API Documentation: Amazon Ads Sponsored Product - Reports
Replication: Key Based Replication
Replication Key: Date
Fields
Name | Target Datatype |
date | STRING |
query | STRING |
campaignName | STRING |
campaignId | STRING |
adGroupName | STRING |
adGroupId | STRING |
targetId | STRING |
targetingExpression | STRING |
targetingText | STRING |
targetingType | STRING |
impressions | INTEGER |
clicks | INTEGER |
cost | NUMERIC |
attributedConversions1d | INTEGER |
attributedConversions7d | INTEGER |
attributedConversions14d | INTEGER |
attributedConversions30d | INTEGER |
attributedConversions1dSameSKU | INTEGER |
attributedConversions7dSameSKU | INTEGER |
attributedConversions14dSameSKU | INTEGER |
attributedConversions30dSameSKU | INTEGER |
attributedUnitsOrdered1d | INTEGER |
attributedUnitsOrdered7d | INTEGER |
attributedUnitsOrdered14d | INTEGER |
attributedUnitsOrdered30d | INTEGER |
attributedSales1d | INTEGER |
attributedSales7d | INTEGER |
attributedSales14d | INTEGER |
attributedSales30d | INTEGER |
attributedSales1dSameSKU | INTEGER |
attributedSales7dSameSKU | INTEGER |
attributedSales14dSameSKU | INTEGER |
attributedSales30dSameSKU | INTEGER |
attributedUnitsOrdered1dSameSKU | INTEGER |
attributedUnitsOrdered7dSameSKU | INTEGER |
attributedUnitsOrdered14dSameSKU | INTEGER |
attributedUnitsOrdered30dSameSKU | INTEGER |
Last updated