Amazon Sponsored Display Ads
Amazon Sponsored Display Ads 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
Seller 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
SponsoredDisplay_ProductMetadata
SponsoredDisplay_Campaign
SponsoredDisplay_AdGroup
SponsoredDisplay_Keywords
SponsoredDisplay_Drafts
SponsoredDisplay_StoresAssets
SponsoredDisplay_NegativeKeywords
SponsoredDisplay_Targets
SponsoredDisplay_NegativeTargets
SponsoredDisplay_TargetingRecommendations
SponsoredDisplay_BidRecommendations
SponsoredDisplay_CampaignsReports
SponsoredDisplay_PlacementCampaignsReport
SponsoredDisplay_AdGroupsReport
SponsoredDisplay_KeywordsReport
SponsoredDisplay_PlacementKeywordsReport
SponsoredDisplay_SearchTermKeywordsReport
SponsoredDisplay_TargetReport
SponsoredDisplay_HeadlineSearchReport
SponsoredDisplay_SearchTermHeadlineSearchReport
SponsoredDisplay_KeywordsVideoReport
SponsoredDisplay_AdGroupsVideoReport
SponsoredDisplay_CampaignsVideoReport
SponsoredDisplay_PlacementCampaignsVideoReport
SponsoredDisplay_SearchTermKeywordsVideoReport
SponsoredDisplay_PlacementKeywordsVideoReport
SponsoredDisplay_TargetVideoReport

Authentication Credentials

  1. 1.
    Sponsored Display 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 Display Ads with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Amazon Sponsored Display 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 Display 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 Display Ads - Portfolio
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_ProductMetadata
Purpose: The Amazon Display 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 Display, Sponsored Displays or Sponsored Display advertising campaigns. The Product Selector API is available to Sellers, Vendors, and Authors
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_NegativeTargetingClause
Purpose: Gets a list of negative targeting clauses objects for a requested set of Sponsored Display negative targets. Note that the Negative Targeting Clause object is designed for performance, and includes a small set of commonly used fields to reduce size. If the extended set of fields is required, use the negative target operations that return the NegativeTargetingClauseEx object.
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_NegativeTargetingClauseEX
Purpose: Gets an array of NegativeTargetingClauseEx objects for a set of requested negative targets. Note that this call returns the full set of negative targeting clause extended fields
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_BidRecommendations
Purpose: Provides a list of bid recommendations based on the list of input advertised ASINs and targeting clauses in the same format as the targeting API. For each targeting clause in the request a corresponding bid recommendation will be returned in the response. Currently the API will accept up to 100 targeting clauses.The recommended bids are derrived from the last 7 days of winning auction bids for the related targeting clause.
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_BrandSafetyDenyList
Purpose: Gets an array of websites/apps that are on the advertiser's Brand Safety Deny List. It can take up to 15 minutes from the time a domain is added/deleted to the time it is reflected in the deny list.
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_Campaign
Purpose: Gets an array of Campaign objects for a requested set of Sponsored Display campaigns. Note that the Campaign object is designed for performance, and includes a small set of commonly used fields to reduce size.
Source API Documentation: Amazon Sponsored Display Ads - Campaign
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_CampaignEx
Purpose: Gets an array of CampaignResponseEx objects for a set of requested campaigns.
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_AdGroup
Purpose: Gets an array of AdGroup objects for a requested set of Sponsored Display ad groups. Note that the AdGroup object is designed for performance, and includes a small set of commonly used fields to reduce size.
Source API Documentation: Amazon Sponsored Display Ads - AdGroup
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_AdGroupEx
Purpose: Gets an array of AdGroupResponseEx objects for a set of requested ad groups.
Replication: Full Replication
Replication Key: N/A
SponsoredDisplay_ProductAd
Purpose: Gets an array of ProductAd objects for a requested set of Sponsored Display product ads. Note that the ProductAd object is designed for performance, and includes a small set of commonly used fields to reduce size.
Source API Documentation: Amazon Sponsored Display Ads - Product Ads
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_ProductAdEx
Purpose: Gets an array of ProductAdResponseEx objects for a set of requested ad groups. The ProductAdResponseEx object includes the extended set of available fields.
Replication Type: Full Load
Replication Key: N/A
SponsoredDisplay_TargetingClause
Purpose: Gets a list of targeting clauses objects for a requested set of Sponsored Display targets. Note that the Targeting Clause object is designed for performance, and includes a small set of commonly used fields to reduce size.
Source API Documentation: Amazon Sponsored Display Ads - Targeting
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_TargetingClauseEx
Purpose: Gets an array of TargetingClauseEx objects for a set of requested targets.
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_SuggestedProducts
Purpose: Retrieves a list of suggested products
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_RecommendedCategory
Purpose: The Sponsored Display product & category Recommendations enable you to programmatically query for recommended products or categories to target based on a given a set of advertised products (ASINs or SKU). These recommendations are based on view-to-purchase data (shoppers viewing these recommended products are likely to purchase your advertised product).
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_RecommendedProduct
Purpose: The Sponsored Display product & category Recommendations enable you to programmatically query for recommended products or categories to target based on a given a set of advertised products (ASINs or SKU). These recommendations are based on view-to-purchase data (shoppers viewing these recommended products are likely to purchase your advertised product).
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_CampaignsReport
Purpose: Retrieves Campain performance report
Source API Documentation: Amazon Sponsored Display Ads - Reports
ReportName in Seller Central: Campaigns
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_AdGroupReport
Purpose: Retrieves performance report for AdGroups
Source API Documentation: Amazon Sponsored Display Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_ProductAdsReport
Purpose: Retrieves performance report for advertised products
Source API Documentation: Amazon Sponsored Display Ads - Reports
ReportName in Seller Central: Advertised Products
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_ProductTargetingReport
Purpose: Retrieves performance report for targets
Source API Documentation: Amazon Sponsored Display Ads - Reports
ReportName in Seller Central: Targets
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_AsinsReport
Purpose: Retrieves video performance report for purchased products
Source API Documentation: Amazon Sponsored Display Ads - Reports
ReportName in Seller Central: Purchased Product
Replication Type: Key Based Replication
Replication Key: Date