# Amazon Sponsored Display Ads ### 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 | #### Reports Mapping The following table represents how Daton maps tables with respect to the reports you see in the Amazon Ad console interface. | Report in Ad console | Report in Daton | | ------------------------- | -------------------------------------------------------------------------------------------------------------------------------- | | Campaign | `SponsoredDisplay_CampaignsReport` | | Targeting | `SponsoredDisplay_ProductTargetingReport` | | Advertised Product | `SponsoredDisplay_ProductAdsReport` | | Purchase Product | `SponsoredDisplay_AsinsReport` | | Matched target |

SponsoredDisplay\_MatchedTargetCampaignsReport
SponsoredDisplay\_MatchedTargetAdGroupsReport

| | Gross And Invalid Traffic | - | ### Authentication Credentials 1. Sponsored Display APIs work for 'Seller' type users. Agency users and Attribution accounts will not have access to APIs 2. User account used for authentication must have access to Campaign Manager and all Reports ### Integrate Amazon Sponsored Display Ads with Daton 1. Signin to Daton 2. Select Amazon Sponsored Display from Connectors page 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. You will be redirected to Amazon Advertising login page for authorizing Daton to extract data periodically. Login with your seller account 5. After 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 replication 7. Then select required fields for each table 8. Submit the integration ### Workflow 1. Integrations would be in configuring state initially. They would be moved to active state when selected tables are created in the 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. ### Known Issues 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. Data would always be fetched for previous day after 2 AM Seller time 3. There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton 4. Read more on attribution - \[FAQs] () ### AmazonAds Data #### TABLES **Profile** Purpose: Retrieve all profiles associated with the Amazon Advertising account Source API Documentation: [Amazon Sponsored Display Ads - Profile](https://advertising.amazon.com/API/docs/en-us/reference/2/profiles) 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](https://advertising.amazon.com/API/docs/en-us/reference/2/portfolios) 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](https://advertising.amazon.com/API/docs/en-us/product-metadata/#/Product%20selector) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Negative%20targeting/listNegativeTargetingClauses) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Negative%20targeting/listNegativeTargetingClausesEx) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Bid%20Recommendations/getTargetBidRecommendations) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Brand%20Safety%20List%20%5BOpen%20Beta%5D/listDomains) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Campaigns/listCampaigns) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Campaigns/listCampaignsEx) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Ad%20groups/listAdGroups) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Negative%20product%20targeting/listNegativeTargets) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Targeting%20recommendations/getProductRecommendations) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Product%20ads/listProductAdsEx) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Targeting/listTargetingClauses) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Targeting/listTargetingClausesEx) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/recommendations) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/recommendations) Replication Type: Key Based Replication Replication Key: Date **SponsoredDisplay\_CampaignsReport** Purpose: Retrieves Campain performance report Source API Documentation: [Amazon Sponsored Display Ads - Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Reports/requestReport) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Reports/requestReport) 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Reports/requestReport) 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](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-brands/2/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](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-brands/2/reports) ReportName in Seller Central: Purchased Product Replication Type: Key Based Replication Replication Key: Date