Comment on page
Amazon DSP
Amazon DSP ETL connector for data replication
Features | Details |
Release Status | Beta |
Source API Version | V1 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Agency 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 | |
InventoryReport | CampaignReport |
AudienceReport | ProductsReport |
TechnologyReport | GeographyReport |
- 1.DSP APIs work for 'Agency' type users. Seller accounts and Attribution accounts will not have access to DSP APIs
- 2.User account used for authentication must have 'Entity Administrator' permissions for DSP.
- 1.Signin to Daton
- 2.Select Amazon DSP 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
- 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.
- 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] (https://docs.sarasanalytics.com/faqs/faqs/amazon-advertising-faqs)
InventoryReport
Purpose: Retrieves inventory performance metrics for DSP campaigns
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
CampaignReport
Purpose: Retrieves campaign performance metrics for DSP campaigns
ReportName in Seller Central: Performance Report
Replication Type: Key Based Replication
Replication Key: Date
AudienceReport
Purpose: Retrieves audience performance metrics for DSP campaigns
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
ProductsReport
Purpose: Retrieves product performance metrics for DSP campaigns
ReportName in Seller Central: Products Report
Replication Type: Key Based Replication
Replication Key: Date
TechnologyReport
Purpose: Retrieves technology performance metrics for DSP campaigns
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
GeographyReport
Purpose: Retrieves geography performance metrics for DSP campaigns
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
Last modified 9mo ago