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
1.Signin to Daton.
2.Select AmazonAds from Integrations page
3.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.
4.You will be redirected to Amazon Advertising login for authorizing Daton to extract data periodically.
5.Post successful authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds.
6.After account selection, you'll be prompted to select the Tables/APIs for which you need daton to pull.
7.Then select required fields for each table.
8.Submit the integration.
Workflow
1.Integrations could be seen Active tab of Integration List while the job loads data on to the configured warehouse.
2.Users would be able to edit/pause/re-activate/delete integration anytime
3.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

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

Name	Target Datatype
profileId	STRING
countryCode	STRING
currencyCode	STRING
dailyBudget	NUMERIC
timeZone	STRING
accountInfo	RECORD

Name	Target Datatype
portfolioId	STRING
name	STRING
budget	RECORD
inBudget	BOOLEAN
state	STRING

Name	Target Datatype
code	STRING
entityId	STRING
storeName	STRING
brandEntityId	STRING
storePageInfo	RECORD

Name	Target Datatype
keywordId	STRING
campaignId	STRING
state	STRING
keywordText	STRING
matchType	STRING
creationDate	STRING
lastUpdatedDate	STRING
servingStatus	STRING