Amazon Ads

Amazon Ads ETL connector for data replication

Snapshot

##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<br>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: <Link> [Amazon Ads Profile](https://advertising.amazon.com/API/docs/en-us/reference/2/profiles)
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: <Link> [Amazon Ads Portfolio](https://advertising.amazon.com/API/docs/en-us/reference/2/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.
Source API Documentation: <Link> [Amazon Ads Store](https://advertising.amazon.com/API/docs/en-us/reference/2/stores)
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: <Link> [Amazon Ads Sponsored Product - Campaign](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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.
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Campaign Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
bidding | RECORD
####SponsoredProducts_AdGroup
Purpose: Return a list of ad groups.
Source API Documentation: <Link> [Amazon Ads Sponsored Products - Ad Group](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Ad Group Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
####SponsoredProducts_BiddableKeyword
Purpose: Return a list of ad group-level biddable keywords.
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-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.
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-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
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
####SponsoredProducts_NegativeKeyword
Purpose: Return a list of negative ad group-level keywords.
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Negative Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-negative-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.
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-negative-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
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
####SponsoredProducts_CampaignNegativeKeyword
Purpose: Return a list of campaign level negative keywords.
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Campaign Negative Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaign-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.
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Campaign Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaign-negative-keywords)
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: <Link> [Amazon Ads Sponsored Product - Product Ads](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Product Ads Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-ads)
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: <Link> [Amazon Ads Sponsored Product - Product Targeting](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-attribute-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: <Link> [Amazon Ads Sponsored Product - Product Targeting Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-attribute-targeting)
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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/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

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

Seller RAW Data

Profile

Portfolio

Store

Sponsored Products - Raw Data

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

Sponsored Products - Reports

SponsoredProducts_CampaignsReports

SponsoredProducts_PlacementCampaignsReports

SponsoredProducts_AdGroupReports

SponsoredProducts_KeywordReports

SponsoredProducts_SearchTermKeywordReports

SponsoredProducts_ProductAdsReports

SponsoredProducts_ProductTargetingReports

SponsoredProducts_SearchTermProductTargetingReports

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