Daily Reporting CSV Columns
This page describes the columns of the daily aggregated CSV file that marketplaces receive through the API. It is written for marketplace and integration teams that load the file into their own systems. If you are an advertiser looking for what a number in the dashboard means, see Analytic Metrics.
Last updated: November 3, 2026
Note: The columns in the file may vary depending on your account's configuration. The file is available to marketplaces that have the feature enabled. To get access to the file, or to learn your marketplace's attribution setting, contact your account manager.
File format
| Property | Value |
|---|---|
| Header row | The first row contains the column names. |
| Delimiter | Comma (,) |
| Decimal separator | Dot (.) |
| Date format | YYYY-MM-DD |
| Row granularity | Each row covers one hour of one date (Hour is 0–23). |
| Amounts | All amount columns are in the currency given in the Currency column of the same row. Only add up amounts of rows that have the same currency. |
Dimension columns
| Column | Description | Unit | Related metric |
|---|---|---|---|
| Date | Record date (YYYY-MM-DD). | date | |
| Hour | Record hour. Each row covers one hour (hourly aggregation). | 0–23 | |
| Marketplace ID | Relevant marketplace. | text | |
| Store ID | Identifier of the advertised product as defined by the marketplace (the product's SKU). In files that include this column, it takes the place of Product ID. | text | |
| Ad Placement ID | Ad placement identifier. | text | |
| Placement Name | Ad placement name. | text | |
| Campaign ID | Campaign identifier. | text | |
| Advertiser ID | Advertiser identifier as defined by the marketplace. | text | |
| Creative ID | Creative identifier. | text | |
| Product ID | Identifier of the advertised product as defined by the marketplace (the product's SKU). | text | |
| Category Text | Category text for impression context. | text | |
| Search Text | User search query. | text | |
| Language | Language of content/context. | text | |
| Platform | Device/channel: Desktop, MWeb (mobile web) or App. | text | |
| Currency | Currency of all amount columns in the row. | text |
Metric columns
| Column | Description | Unit | Related metric |
|---|---|---|---|
| Impressions | Number of impressions. | count | Impressions |
| Viewable Impressions | Impressions considered viewable per marketplace rules. | count | |
| Clicks | Number of clicks. | count | Clicks |
| Spent | Total ad spend. | currency | Ad Spend |
| Bid Amount | Sum of bid amounts. | currency | |
| Ad Requests | Count of ad request calls. | count | |
| Ad Responses | Count of ad responses returned. | count | |
| Organic Sale | Number of organic (non-ad) sales. Not included in Sale Quantity. | count | |
| Organic Sale Amount | Total revenue of organic sales. Not included in Sales. | currency | |
| PC Direct Sale | Post-click direct sales count (last-click attribution). | count | Sale Quantity |
| PC Direct Sale Amount | Revenue of post-click direct sales. | currency | Sales |
| PC Indirect Sale | Post-click indirect (assisted) sales count. | count | Sale Quantity |
| PC Indirect Sale Amount | Revenue of post-click indirect sales. | currency | Sales |
| PV Direct Sale | Post-view direct sales count (last-view attribution). | count | Sale Quantity |
| PV Direct Sale Amount | Revenue of post-view direct sales. | currency | Sales |
| PV Indirect Sale | Post-view indirect (assisted) sales count. | count | Sale Quantity |
| PV Indirect Sale Amount | Revenue of post-view indirect sales. | currency | Sales |
| Direct Sale | Post-view direct sales count. Files with this column have no indirect sale columns. | count | Sale Quantity |
| Direct Sale Amount | Revenue of post-view direct sales. | currency | Sales |