Breadcrumbs

Amazon DSP

Overview

This part of the Amazon Ads datasource pulls multiple different report types (Campaign, Inventory, Audience, Products, Technology, and Geography) from their DSP API.

Vendor/Partner

Amazon

Version

v3

API Documentation

Vendor UI, Seller UI, Amazon DSP API Docs

Sunset Date

06/30/2025

Channel(s)

Refresh Time (CST)

5 am, 1 pm

Default backfill

14 Days

Alli Data Library

https://agencypmg.atlassian.net/wiki/s/-1529285079/6452/4c2832860aad97c77f44f8794b470d79af5ad2a7/_/images/icons/emoticons/check.png

This datasource has been deprecated and will be removed from Alli in favor of the newer Amazon Reporting datasource, which includes DSP reports.

Getting Started

  1. In the Required Authorizations section, click on "Request AmazonAds Access" button to redirect to the Amazon Sign-In page.

  2. Input the account credentials that have reporting access, and allow access to PMG Datawarehouse.

    image-20210324-190415.png
    image-20210324-190430.png
    image-20210324-190442.png

    To ensure data security the accounts we display are individual advertiser accounts that have historically used Amazon DSP according to the api.

Limitations

Data Delay

When pulling data from yesterday or today, there will be a data discrepancy between the API pull and the manual report pull from the UI.

While we do not know how much of a difference, if you pull information from two days ago there should be no discrepancies.

Quotas

No quotas explicitly stated. However, here is a link to their notes on error descriptions, their guarantees on data integrity, etc.

Dimensions

Campaign Report

Name

Type

Description

orderName

string


orderId

number


orderStartDate

date


orderEndDate

date


orderBudget

number


orderExternalId

number


orderCurrency

number


lineItemName

string


lineItemId

number


lineItemStartDate

date


lineItemEndDate

date


lineItemBudget

number


lineItemExternalId

number


creativeName

string


creativeId

number


creativeType

string


creativeSize

string


creativeAdId

number


Inventory Report

Name

Type

Description

orderName

string


orderId

number


orderStartDate

date


orderEndDate

date


orderBudget

number


orderExternalId

number


orderCurrency

number


lineItemName

string


lineItemId

number


lineItemStartDate

date


lineItemEndDate

date


lineItemBudget

number


lineItemExternalId

number


siteName

string


supplySourceName

string


deal

string


dealID

number


Audience Report

Name

Type

Description

orderName

string


orderId

number


orderStartDate

date


orderEndDate

date


orderBudget

number


orderExternalId

number


orderCurrency

number


lineItemName

string


lineItemId

number


lineItemStartDate

date


lineItemEndDate

date


lineItemBudget

number


lineItemExternalId

number


Products Report

Name

Type

Description

orderName

string


orderId

number


orderStartDate

date


orderEndDate

date


orderBudget

number


orderExternalId

number


orderCurrency

number


lineItemName

string


lineItemId

number


lineItemStartDate

date


lineItemEndDate

date


lineItemBudget

number


lineItemExternalId

number


Technology Report

Name

Type

Description

orderName

string


orderId

number


orderStartDate

date


orderEndDate

date


orderBudget

number


orderExternalId

number


orderCurrency

number


lineItemName

string


lineItemId

number


lineItemStartDate

date


lineItemEndDate

date


lineItemBudget

number


lineItemExternalId

number


operatingSystem

string


browser

string


browserVersion

string


device

string


enviormentType

string


Geography Report

Name

Type

Description

orderName

string


orderId

number


orderStartDate

date


orderEndDate

date


orderBudget

number


orderExternalId

number


orderCurrency

number


lineItemName

string


lineItemId

number


lineItemStartDate

date


lineItemEndDate

date


lineItemBudget

number


lineItemExternalId

number


country

string


region

string


city

string


designatedMarketAreaCode

string


designatedMarketAreaName

string


postalCode

number