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