Essential Attributes and Supported Tables for Amazon Sponsored Display

Need help with something?

Talk to data expert

Amazon Sponsored Display is an advertising solution that allows sellers to showcase their products on and off Amazon, reaching potential customers wherever they browse. It enables advertisers to target audiences based on interests, shopping behaviour, and product relevancy. The benefits include increased product visibility, expanded audience reach, and the potential to drive both on- and off-platform sales.

In this article, we will look at the essential attributes and tables supported by the Amazon Sponsored Display connector.

Find the links to other articles related to Amazon Sponsored Display Below:

Essential Attributes

The following table shows some of the essential connector attributes and their details: 

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

Supported Tables

The following table lists all the tables supported by Daton for the Amazon Sponsored Display connector: 

Supported Table Names
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 -