Schema Information for Amazon Sponsored Display
Schema Information for Amazon Sponsored Display
In this article, we will look at the schema information of the supported APIs and tables for Amazon Sponsored Display.
Find the links to other articles related to Amazon Sponsored Display Below:
- Essential Attributes and Supported Tables for Amazon Sponsored Display
- Setup Instructions for Amazon Sponsored Display
Tables/APIs
The following is the list of tables or APIs associated with the Amazon Sponsored Display connector:
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
Source API Documentation: Amazon Sponsored Display Ads - Product Metadata
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.
Source API Documentation: Amazon Sponsored Display Ads - Negative Targeting
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
Source API Documentation: Amazon Sponsored Display Ads - Negative Targeting Extended
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.
Source API Documentation: Amazon Sponsored Display Ads - Bid Recommendations
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.
Source API Documentation: Amazon Sponsored Display Ads - Brand Safety 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.
Source API Documentation: Amazon Sponsored Display Ads - Campaign Extended
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.
Source API Documentation: Amazon Sponsored Display Ads - AdGroup Extended
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.
Source API Documentation: Amazon Sponsored Display Ads - Product Ads Extended
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.
Source API Documentation: Amazon Sponsored Display Ads - Targeting Extended
Replication Type: Key Based Replication
Replication Key: Date
SponsoredDisplay_SuggestedProducts
Purpose: Retrieves a list of suggested products
Source API Documentation: Amazon Sponsored Display Ads - 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).
Source API Documentation: Amazon Sponsored Display Ads - Recommendations
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).
Source API Documentation: Amazon Sponsored Display Ads - Recommendations
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