Essential Attributes and Supported Tables for Amazon Sponsored Products
Essential Attributes and Supported Tables for Amazon Sponsored Products
In this article, we will look at the essential attributes and tables supported by the Amazon Sponsored Products connector.
Find the links to other articles related to Amazon Sponsored Products 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 | 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 Products connector:
| Supported Table Names |
|---|
| Profile |
| Portfolio |
| Store |
| SponsoredProducts_ProductMetadata |
| SponsoredProducts_Campaign |
| SponsoredProducts_CampaignEx |
| SponsoredProducts_AdGroup |
| SponsoredProducts_AdGroupEx |
| SponsoredProducts_BiddableKeyword |
| SponsoredProducts_BiddableKeywordsEx |
| SponsoredProducts_NegativeKeyword |
| SponsoredProducts_NegativeKeywordEx |
| SponsoredProducts_CampaignNegativeKeyword |
| SponsoredProducts_CampaignNegativeKeywordEx |
| SponsoredProducts_ProductAd |
| SponsoredProducts_ProductAdEx |
| SponsoredProducts_TargetingClause |
| SponsoredProducts_TargetingClauseEx |
| SponsoredProducts_KeywordBidRecommendations |
| SponsoredProducts_TargetBidRecommendations |
| SponsoredProducts_SuggestedKeywords |
| SponsoredProducts_ProductTargetingRecommendations |
| SponsoredProducts_NegativeTargetingClause |
| SponsoredProducts_CampaignsReports |
| SponsoredProducts_Store_AsinEngagement |
| SponsoredProducts_StoresInsights |
| Store_AsinEngagement |
| StoresInsights |
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 |
|---|---|
| Search term | SponsoredProducts_SearchTermKeywordReport |
| Targeting | SponsoredProducts_SearchTermTargetingReport |
| Advertised product | SponsoredProducts_ProductAdsReport |
| Campaign | SponsoredProducts_CampaignsReport |
| Budget | - |
| Placement | SponsoredProducts_PlacementCampaignsReport |
| Purchased product |
|
| Performance Over Time | - |
| Search Term Impression Share | - |
| Gross And Invalid Traffic | - |
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 the configuration.
2. Daton will repeat the report data for a given date depending on the attribution offset selected.
3. Data would always be fetched for the previous day after 2 AM Seller time.
4. There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton.