Amazon DSP
Amazon DSP ETL connector for data replication
Snapshot
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
Authentication Credentials
DSP APIs work for 'Agency' type users. Seller accounts and Attribution accounts will not have access to DSP APIs
User account used for authentication must have 'Entity Administrator' permissions for DSP.
Integrate Amazon DSP Ads with Daton
Signin to Daton
Select Amazon DSP from Connectors page
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
You will be redirected to Amazon Advertising login page for authorizing Daton to extract data periodically. Login 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 required fields for each table
Submit the integration
Workflow
Integrations would be in configuring state initially. They would be moved to 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.
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 configuration. Daton will repeat the report data for a given date depending on the attribution offset selected
Data would always be fetched for previous day after 2 AM Seller time
There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton
Read more on attribution - [FAQs] (https://docs.sarasanalytics.com/faqs/faqs/amazon-advertising-faqs)
AmazonAds Data
TABLES
InventoryReport
Purpose: Retrieves inventory performance metrics for DSP campaigns
Source API Documentation: Amazon DSP Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
CampaignReport
Purpose: Retrieves campaign performance metrics for DSP campaigns
Source API Documentation: Amazon DSP Ads - Reports
ReportName in Seller Central: Performance Report
Replication Type: Key Based Replication
Replication Key: Date
AudienceReport
Purpose: Retrieves audience performance metrics for DSP campaigns
Source API Documentation: Amazon DSP Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
ProductsReport
Purpose: Retrieves product performance metrics for DSP campaigns
Source API Documentation: Amazon DSP Ads - Reports
ReportName in Seller Central: Products Report
Replication Type: Key Based Replication
Replication Key: Date
TechnologyReport
Purpose: Retrieves technology performance metrics for DSP campaigns
Source API Documentation: Amazon DSP Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
GeographyReport
Purpose: Retrieves geography performance metrics for DSP campaigns
Source API Documentation: Amazon DSP Ads - Reports
ReportName in Seller Central: None
Replication Type: Key Based Replication
Replication Key: Date
Last updated