Essential Attributes and Supported Tables for Amazon Sponsored Brands

Need help with something?

Talk to data expert

Amazon Sponsored Brands is an advertising option that allows brands to promote multiple products in a single ad. It enhances brand visibility, increases product discoverability, and drives customer engagement on the Amazon platform. The benefits include improved brand recognition, increased sales, and effective promotion of product portfolios.

In this article, we will discuss the essential attributes and tables supported by the Amazon Sponsored Brands connector.

Find the links to other articles related to Amazon Sponsored Brands 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 names of tables supported by Daton for the Amazon Sponsored Brands connector:

Table Names
Profile
Store
SponsoredBrands_Campaign
SponsoredBrands_Keywords
SponsoredBrands_StoresAssets
SponsoredBrands_Targets
SponsoredBrands_TargetingRecommendations
SponsoredBrands_CampaignsReports
SponsoredBrands_AdGroupsReport
SponsoredBrands_PlacementKeywordsReport
SponsoredBrands_TargetReport
SponsoredBrands_SearchTermHeadlineSearchReport
SponsoredBrands_AdGroupsVideoReport
SponsoredBrands_PlacementCampaignsVideoReport
SponsoredBrands_PlacementKeywordsVideoReport
SponsoredBrands_UnifiedAdGroupsReport
SponsoredBrands_UnifiedKeywordsReport
SponsoredBrands_UnifiedPlacementCampaignsReport
SponsoredBrands_UnifiedPlacementKeywordsReport
Portfolio
SponsoredBrands_ProductMetadata
SponsoredBrands_AdGroup
SponsoredBrands_Drafts
SponsoredBrands_NegativeKeywords
SponsoredBrands_NegativeTargets
SponsoredBrands_BidRecommendations
SponsoredBrands_PlacementCampaignsReport
SponsoredBrands_KeywordsReport
SponsoredBrands_SearchTermKeywordsReport
SponsoredBrands_HeadlineSearchReport
SponsoredBrands_KeywordsVideoReport
SponsoredBrands_CampaignsVideoReport
SponsoredBrands_SearchTermKeywordsVideoReport
SponsoredBrands_TargetVideoReport
SponsoredBrands_UnifiedTargetReport
SponsoredBrands_UnifiedCampaignsReport
SponsoredBrands_UnifiedSearchTermKeywordsReport

To know more about the supported APIs and tables, read Amazon Sponsored Brands - Schema Information.

Reports Mapping 

The following table represents how Daton maps tables concerning the reports you see in the Amazon Ad console interface.
Report in Ad console Report in Daton
Search term

SponsoredBrands_SearchTermKeywordsReport

SponsoredBrands_SearchTermKeywordsVideoReport

Keyword

SponsoredBrands_KeywordsReport

SponsoredBrands_KeywordsVideoReport

Keyword Placement

SponsoredBrands_PlacementKeywordsReport

SponsoredBrands_PlacementKeywordsVideoReport

Campaign

SponsoredBrands_CampaignsReport

SponsoredBrands_CampaignsVideoReport

Campaign Placement

SponsoredBrands_PlacementCampaignsReport

SponsoredBrands_PlacementCampaignsVideoReport

Search Term Impression Share -
Category Benchmark -
Attributed Purchases SponsoredBrands_PurchasedProductReport
Gross And Invalid Traffic -