> ## Documentation Index
> Fetch the complete documentation index at: https://docs.adriel.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data reference

> Metrics, breakdowns, refresh cadence, and limits for the Amazon ADSP data source in Adriel.

## 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-sources/a-f/amazon-adsp/how-to-connect).

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

<Note>
  **How to read the columns**

  **Data 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.
</Note>

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

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

| 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

<Note>
  **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.
</Note>

### Time & date grouping

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

| 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

<Note>
  These groupings are provided by Adriel rather than the ADSP report itself.
</Note>

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

## API references (Amazon)

* [Amazon Ads — DSP overview](https://advertising.amazon.com/solutions/products/amazon-dsp)
* [Amazon Advertising API — reporting](https://advertising.amazon.com/API/docs/en-us/reporting/v3/overview)

## See also

* How to connect Amazon ADSP (paired how-to)
* Amazon DSP data reference — API-based DSP variant
* Amazon Ads data reference — Sponsored Products / Brands / Display