Amazon Sponsored Products
Amazon Sponsored Products
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 |
| ProductMetadata |
| Campaign |
| CampaignEx |
| AdGroup |
| AdGroupEx |
| BiddableKeyword |
| BiddableKeywordsEx |
| NegativeKeyword |
| NegativeKeywordEx |
| CampaignNegativeKeyword |
| CampaignNegativeKeywordEx |
| ProductAd |
| ProductAdEx |
| TargetingClause |
| TargetingClauseEx |
| KeywordBidRecommendations |
| TargetBidRecommendations |
| SuggestedKeywords |
| ProductTargetingRecommendations |
| NegativeTargetingClause |
| CampaignsReports |
| 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 | SearchTermKeywordReport |
| Targeting | SearchTermTargetingReport |
| Advertised product | ProductAdsReport |
| Campaign | CampaignsReport |
| Budget | - |
| Placement | PlacementCampaignsReport |
| Purchased product |
|
| Performance Over Time | - |
| Search Term Impression Share | - |
| Gross And Invalid Traffic | - |
Known Issues
- 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.
- Daton will repeat the report data for a given date depending on the attribution offset selected
- Data would always be fetched for the previous day after 2 AM Seller time
- There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton
Authentication Credentials
- Sponsored Product APIs work for 'Seller' type users. Agency users and Attribution accounts will not have access to APIs.
- User account used for authentication must have access to Campaign Manager and all Reports.
Integrate Amazon Sponsored Product Ads with Daton
- Sign in to Daton.
- Select Amazon Sponsored Product from the Connectors page.
- Provide all required configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, and Attribution lookback. The integration name would be used while creating tables in the warehouse and cannot be changed later.
- You will be redirected to the Amazon Advertising login page to authorize Daton to extract data periodically. Log in with your seller account.
- After authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds.
- After account selection, you'll be prompted to select the Tables/APIs for replication.
- Then select the required fields for each table.
- Submit the integration.
Workflow
- Integrations would be in the configuring state initially. They would be moved to the active state when selected tables are created in the warehouse.
- Users would be able to edit/pause/re-activate/delete integration anytime.
- Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.
Schema Information
Dive deeper into data structuring essentials by now visiting the Amazon Sponsored Products - Schema Information page.