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	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