Amazon Ads
Amazon Ads ETL connector for data replication
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 | |
- 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.
- 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.
Profile
Purpose: Retrieve all profiles associated with the Amazon Advertising account.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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'.
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.
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 |