Amazon Sponsored Product Ads
Amazon Sponsored Product ETL 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
Supports attribution
Yes
Tables/APIs Supported
Profile
Portfolio
Store
SponsoredProducts_ProductMetadata
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_KeywordBidRecommendations
SponsoredProducts_TargetBidRecommendations
SponsoredProducts_SuggestedKeywords
SponsoredProducts_ProductTargetingRecommendations
SponsoredProducts_NegativeTargetingClause
SponsoredProducts_CampaignsReports
SponsoredProducts_PlacementCampaignsReport
SponsoredProducts_AdGroupReport
SponsoredProducts_KeywordReport
SponsoredProducts_SearchTermKeywordReport
SponsoredProducts_ProductAdsReport
SponsoredProducts_ProductTargetingReport
SponsoredProducts_SearchTermProductTargetingReport
SponsoredProducts_AsinsReportWithTargetId
SponsoredProducts_AsinsReportWithKeywordId

Authentication Credentials

  1. 1.
    Sponsored Product APIs work for 'Seller' type users. Agency users and Attribution accounts will not have access to APIs
  2. 2.
    User account used for authentication must have access to Campaign Manager and all Reports

Integrate Amazon Sponsored Product Ads with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Amazon Sponsored Product from Connectors page
  3. 3.
    Provide all required configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, Attribution lookback. Integration name would be used while creating tables in the warehouse and cannot be changed later
  4. 4.
    You will be redirected to Amazon Advertising login page for authorizing Daton to extract data periodically. Login with your seller account
  5. 5.
    After 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 replication
  7. 7.
    Then select required fields for each table
  8. 8.
    Submit the integration

Workflow

  1. 1.
    Integrations would be in configuring state initially. They would be moved to active state when selected tables are created in the 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.

Known Issues

  1. 1.
    Amazon reconciles data and may update metrics for up to 30 days. If you want to use 7-day attribution metrics, then you must select 8 day attribution offset in configuration. Daton will repeat the report data for a given date depending on the attribution offset selected
  2. 2.
    Data would always be fetched for previous day after 2 AM Seller time
  3. 3.
    There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton

AmazonAds Data

TABLES

Profile
Purpose: Retrieve all profiles associated with the Amazon Advertising account
Source API Documentation: Amazon Sponsored Product Ads - Profile
Replication Type: Full Load
Replication Key: N/A
Portfolio
Purpose: Retrieve a list of up to 100 portfolios
Source API Documentation: Amazon Sponsored Product Ads - Portfolio
Replication Type: Full Load
Replication Key: N/A
Store
Purpose: List store information for all registered stores under an advertiser
Source API Documentation: Amazon Sponsored Product Ads - Store
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_ProductMetadata
Purpose: The Amazon Product Selector API allows integrators to receive product metadata such as inventory status, price, eligibility status and product details for SKUS or ASINs in their Product Catalog in order to launch, manage or optimize Sponsored Product, Sponsored Brands or Sponsored Display advertising campaigns. The Product Selector API is available to Sellers, Vendors, and Authors
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_Campaign
Purpose: Return a list of Sponsored Products campaigns
Source API Documentation: Amazon Sponsored Product Ads - Campaign
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_CampaignEx
Purpose: Return a list of Sponsored Products campaigns with additional properties
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_AdGroup
Purpose: Return a list of ad groups
Source API Documentation: Amazon Sponsored Product Ads - Ad Group
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_AdGroupEx
Purpose: Return a list of ad groups with additional properties
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_BiddableKeyword
Purpose: Return a list of ad group-level biddable keywords
Source API Documentation: Amazon Sponsored Product Ads - Keyword
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_BiddableKeywordsEx
Purpose: Return a list of ad group-level biddable keywords with additional properties
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_NegativeKeyword
Purpose: Return a list of negative ad group-level keywords
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_NegativeKeywordEx
Purpose: Return a list of negative ad group-level keywords with additional properties
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_CampaignNegativeKeyword
Purpose: Return a list of campaign level negative keywords
Replication: Full Replication
Replication Key: N/A
SponsoredProducts_CampaignNegativeKeywordEx
Purpose: Return a list of campaign level negative keywords with additional properties
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_ProductAd
Purpose: Return a list of product ads
Source API Documentation: Amazon Sponsored Product Ads - Product Ads
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_ProductAdEx
Purpose: Return a list of product ads with additional properties
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_TargetingClause
Purpose: List targeting expressions
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_TargetingClauseEx
Purpose: List targeting expressions with additional properties
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_KeywordBidRecommendations
Purpose: Gets a bid recommendation for keywords
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_TargetBidRecommendations
Purpose: Gets a list of bid recommendations for keyword, product, or auto targeting expressions
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_SuggestedKeywords
Purpose: Gets suggested keyword for a specified list of ASINs
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_ProductTargetingRecommendations
Purpose: Gets a list of recommended products for targeting
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_NegativeTargetingClause
Purpose: Gets a list of negative targeting clauses
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_NegativeTargetingClauseEx
Purpose: Gets a list of negative targeting clauses
Replication Type: Full Load
Replication Key: N/A
SponsoredProducts_CampaignsReports
Purpose: Retrieves campaigns performance report
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: Campaign
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_PlacementCampaignsReport
Purpose: Retrieves campaigns performance report with 'placement' segmentation
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: Placement
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_AdGroupReports
Purpose: Retrieves ad-group performance report
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_KeywordReport
Purpose: Retrieves keyword performance report
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_SearchTermKeywordReport
Purpose: Retrieves keyword performance report with 'query' segmentation
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: Search term
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_ProductAdsReport
Purpose: Retrieves performance report for advertised products
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: Advertised product
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_ProductTargetingReport
Purpose: Retrieves targets performance report
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: Targeting
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_SearchTermProductTargetingReport
Purpose: Retrieves targets performance report with 'query' segmentation
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_AsinsReportWithTargetId
Purpose: Retrieves purchased product performance report
Source API Documentation: Amazon Sponsored Product Ads - Reports
ReportName in Seller Central: Purchased product
Replication Type: Key Based Replication
Replication Key: Date
SponsoredProducts_AsinsReportWithKeywordId
Purpose: Retrieves purchased product performance report
ReportName in Seller Central: Purchased product
Source API Documentation: Amazon Sponsored Product Ads - Reports
Replication Type: Key Based Replication
Replication Key: Date
Last modified 3mo ago