Ad Serving Raw Data
Ad Serving Raw Definitions
The Ad Serving Raw dataset provides ad serving data, including five custom-parameter fields, with hourly refreshes and a rolling 30-day history. This dataset supports use cases such as analyzing recent ad serving activity and examining custom parameters not included in the daily or monthly aggregates.
| Column Name | Description |
|---|---|
| AD_100_PER_COMPLETE_CNT integer | Count of ads watched to the fourth quartile |
| AD_BIDS integer | Count of ads receiving bids |
| AD_ERRORS integer | Count of ad errors |
| AD_IMPRESSIONS integer | Count of ad impressions |
| AD_SLOT_TYPE string | Ad position type, varies by inventory path Possible values: Max RPM:
null is returned. |
| ADS_IN_VIEW integer | Count of ads viewable to the user |
| BROWSER string | Identifies the user's browser Possible values:
|
| COUNTRY_NAME string | ID of the geographic region |
| CUSTOM_PARAM_1 | Custom parameter 1 set by the customer |
| CUSTOM_PARAM_2 | Custom parameter 2 set by the customer |
| CUSTOM_PARAM_3 | Custom parameter 3 set by the customer |
| CUSTOM_PARAM_4 | Custom parameter 4 set by the customer |
| CUSTOM_PARAM_5 | Custom parameter 5 set by the customer |
| DEVICE integer | Type of hardware used to retrieve the content Possible values:
|
| DOMAIN string | Domain of the content |
| EXCHANGE_DEMAND_REV decimal | Sum of money in US dollars to be paid to the publisher |
| EXPERIENCE_TYPE string | Inventory path identifier Possible values:
|
| LINE_ITEM_ID string | ID of the line item |
| OS integer | Operating system of the device used to fetch content Possible values:
|
| PLAYER_IN_VIEW integer | Sum of viewable players |
| PLAYER_STARTS integer | Sum of total player sessions started |
| PUBLISHER_DEMAND_REV decimal | Sum of revenue from publisher demand in US dollars |
| PUBLISHER_TOTAL_REV decimal | Total publisher revenue, calculated as the sum of publisher demand revenue and JWX demand revenue in US dollars |
| SITE_ID string | Unique alphanumeric ID of the site |
| UTC_DATE string | UTC date of the ingested data in YYYY-MM-DD format |
| UTC_HOUR | UTC hour associated with the data |
Updated about 1 hour ago
Did this page help you?
