Amazon DSP V1

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

  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.

Integrate Amazon DSP Ads with Daton

  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

Workflow

  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.

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 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

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