HomeDatonDocumentationBlog
Search…
Welcome to Daton
Platform
Essentials
Features
Connectors
Data Sources
Webhooks
SaaS Integrations
Smartrr
re:amaze
LeadSquared CRM
Amazon Sponsored Display Ads
Amazon Sponsored Brand Ads
Amazon Sponsored Product Ads
Amazon DSP
Amazon Attribution
Gorgias
Tune
Aircall
Google My Business
Helpscout
Aftership
Calendly
Yotpo
Insightly
Pipedrive
Adjust
Copper CRM
Quickbase
Campaign Monitor
Unbounce
Capsule CRM
Upscribe
Sticky.io
Shippo
DotDigital
Amazon Ads
Xero
Google Search Console
Yahoo Gemini
Stripe
Stamped.io
Shiprocket
QuickBooks
Pingdom
LiveChat
HubSpot
Customer.io
Constant Contact
ZohoDesk
FreshBooks
NewRelic
Zoho CRM
Zendesk Chat
Zendesk ETL
SendGrid
Razorpay
Optimove
Jira
Intercom
Freshsales
Freshdesk
Chargebee
Unicommerce
PushEngage
Outbrain
MailChimp
Klaviyo
LinkedIn Ads
Bing Ads
Facebook Ads
Criteo
Google Ads
Files
Databases
Analytics Platforms
Ecommerce Platforms
Destinations
FAQs and Troubleshooting
Connector permissions and API Keys
Common Errors and Resolution
FAQs
Powered By GitBook
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. 1.
    Signin to Daton.
  2. 2.
    Select AmazonAds from Integrations page
  3. 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. 4.
    You will be redirected to Amazon Advertising login for authorizing Daton to extract data periodically.
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds.
  6. 6.
    After account selection, you'll be prompted to select the Tables/APIs for which you need daton to pull.
  7. 7.
    Then select required fields for each table.
  8. 8.
    Submit the integration.

Workflow

  1. 1.
    Integrations could be seen Active tab of Integration List while the job loads data on to the configured warehouse.
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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.
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.
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.
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
Previous
DotDigital
Next
Xero
Last modified 3mo ago
Copy link
Contents
Snapshot
Integrate AmazonAds with Daton
Workflow