Data reference

Introduction

Amazon ADSP (Advertising DSP) is Amazon’s programmatic demand-side platform for display, video, and audio advertising across Amazon-owned sites, apps, and third-party inventory. Unlike Amazon DSP — which pulls data from Amazon’s DSP REST API — this connector reads ADSP report data directly from the ADSP reporting UI at advertising.amazon.com. The user picks one report type at connection time, and the connector scrapes that report on a daily schedule. As a marketing connector, metrics and breakdowns are standardized so widgets can aggregate across sources. Because each report type has its own schema, ADSP data sources are best used alongside — not merged into — other Amazon connectors. To connect this data source, see How to connect Amazon ADSP to Adriel.

Data refresh strategy

Architecture data

Amazon ADSP does not import a separate architecture tree. The report type selected at connection time defines the shape of the data source — no ad accounts, campaigns, or line items are pulled separately.

Reports data

Simple cache. Report data is fetched from Amazon’s ADSP UI on a scheduled cache refresh; dashboards read from the cached snapshot rather than triggering live scrapes. Refresh schedule. The cache refreshes twice per day — at 10:00 PM UTC and 6:00 AM UTC. Historical window. The connector reads whatever the ADSP UI exposes for the configured report; there is no additional back-fill beyond what the UI shows.

Report types

One report type is chosen at connection time and cannot be changed afterwards. Each report type maps to a distinct ADSP reporting URL and stores its data in an isolated table, so available fields differ per type.

Report type	What it covers
Topline Performance	Account- and proposal-level topline delivery — impressions, clicks, spend, and headline KPIs rolled up daily.
Untargeted Audiences	Delivery and performance for audiences without explicit targeting.
Targeted Audiences	Delivery and performance broken down by targeted audience segment.
Creative Performance	Delivery and performance by individual creative.
Products Performance	Delivery and performance by advertised product.

Metrics

How to read the columnsData type uses this vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean.API Key in code style like impressions is the literal column name in the ADSP report download. Because each report type has its own dynamic schema, the exact set of columns that appear for a given data source is populated after the first successful sync.Italic text describes how a value is produced when it doesn’t map cleanly to a single API field.

Delivery

Metric	Description	Data type	API Key
Impressions	Total ad impressions served.	Number	`impressions`
Clicks	Total clicks on served ads.	Number	`clickThroughs`
CTR	Click-through rate.	Percentage	Adriel-computed (clicks ÷ impressions)

Cost & spend

Currency values are reported in the currency selected at data source creation (USD or EUR).

Metric	Description	Data type	API Key
Ad spend	Total amount spent on ad delivery.	Currency	`totalCost`
Supply cost	Cost paid to the supply source for the impression.	Currency	`supplyCost`
CPM	Effective cost per thousand impressions.	Currency	`eCPM`
CPC	Effective cost per click.	Currency	`eCPC`

Viewability

Metric	Description	Data type	API Key
Measurable impressions	Impressions eligible for viewability measurement.	Number	`measurableImpressions`
Viewable impressions	Impressions that met the viewability threshold.	Number	`viewableImpressions`
Viewability rate	Viewable impressions as a percentage of measurable impressions.	Percentage	Adriel-computed

Video performance

Metric	Description	Data type	API Key
Video starts	Video plays initiated.	Number	`videoStart`
Video completes	Video plays completed.	Number	`videoComplete`
Video played to 25% / 50% / 75%	Views reaching each completion threshold.	Number	`videoFirstQuartile` / `videoMidpoint` / `videoThirdQuartile`
Video completion rate	Completes divided by starts.	Percentage	Adriel-computed

Conversions (14-day attribution)

Metric	Description	Data type	API Key
Purchases (14d)	Attributed purchases in a 14-day window.	Number	`purchases14d`
Purchase sales (14d)	Sales value of attributed purchases.	Currency	`sales14d`
Detail page views (14d)	Amazon detail page views attributed to the ads.	Number	`detailPageViews14d`
Add-to-carts (14d)	Add-to-cart events attributed to the ads.	Number	`addToCart14d`
New-to-brand purchases (14d)	Attributed purchases from buyers new to the brand.	Number	`newToBrandPurchases14d`

Breakdowns

Report-type-scoped. ADSP breakdowns are determined by the report type chosen at connection time. Cross-type breakdowns (e.g. combining creative and product cuts) are not available in a single data source.

Time & date grouping

These time-grouping views are Adriel-side aggregations of the same underlying daily report data.

Breakdown	Description
Auto Time Breakdown	Automatically picks the best granularity for the date range.
Daily	Split reports by day.
Weekly (Start: Mon)	Split reports by ISO week, starting Monday.
Weekly (Start: Sun)	Split reports by week, starting Sunday.
Monthly	Split reports by calendar month.
Quarterly	Split reports by calendar quarter.
Yearly	Split reports by calendar year.

Report-type breakdowns

Report type	Available breakdowns
Topline Performance	Account, Proposal
Untargeted Audiences	Audience segment
Targeted Audiences	Targeted audience segment
Creative Performance	Creative
Products Performance	Product

Overview & status

These groupings are provided by Adriel rather than the ADSP report itself.

Breakdown	Description
No Grouping	Do not break down; return one aggregated row.
Datasource Name	Group by Adriel datasource name.

Limitations

Report type is fixed at connection time. To view a different report, connect a new data source with that report type selected.
Cross-report joins are not supported. Each report type stores data in its own isolated table.
Browser-based data path. Data is retrieved by scraping the ADSP reporting UI, so unusual UI changes on Amazon’s side can temporarily interrupt sync.
No independent architecture tree. Ad accounts and line items are not imported separately; only the selected report is available.
Distinct from Amazon DSP. Numbers may not reconcile line-for-line with an Amazon DSP data source because the two use different data paths and different Amazon-side reports.

Introduction

Data refresh strategy

Architecture data

Reports data

Report types

Metrics

Delivery

Cost & spend

Viewability

Video performance

Conversions (14-day attribution)

Breakdowns

Time & date grouping

Report-type breakdowns

Overview & status

Limitations

API references (Amazon)

See also

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Report types

​Metrics

​Delivery

​Cost & spend

​Viewability

​Video performance

​Conversions (14-day attribution)

​Breakdowns

​Time & date grouping

​Report-type breakdowns

​Overview & status

​Limitations

​API references (Amazon)

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Report types

Metrics

Delivery

Cost & spend

Viewability

Video performance

Conversions (14-day attribution)

Breakdowns

Time & date grouping

Report-type breakdowns

Overview & status

Limitations

API references (Amazon)

See also