Amazon DSP
Amazon DSP ETL 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

  1. 1.
    DSP APIs work for 'Agency' type users. Seller accounts and Attribution accounts will not have access to DSP APIs
  2. 2.
    User account used for authentication must have 'Entity Administrator' permissions for DSP.

Integrate Amazon DSP Ads with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Amazon DSP from Connectors page
  3. 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. 4.
    You will be redirected to Amazon Advertising login page for authorizing Daton to extract data periodically. Login with your seller account
  5. 5.
    After authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds
  6. 6.
    After account selection, you'll be prompted to select the Tables/APIs for replication
  7. 7.
    Then select required fields for each table
  8. 8.
    Submit the integration

Workflow

  1. 1.
    Integrations would be in configuring state initially. They would be moved to active state when selected tables are created in the warehouse.
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    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

  1. 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. 2.
    Data would always be fetched for previous day after 2 AM Seller time
  3. 3.
    There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton

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