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 NameDescription
AD_100_PER_COMPLETE_CNT integerCount of ads watched to the fourth quartile
AD_BIDS integerCount of ads receiving bids
AD_ERRORS integerCount of ad errors
AD_IMPRESSIONS integerCount of ad impressions
AD_SLOT_TYPE string

Ad position type, varies by inventory path


Possible values:
Max RPM:
  • PreRoll
  • MidRoll
  • PostRoll
Vertical Video:
  • Carousel
  • Interstitial
  • Sidebar
Classic:
  • PreRoll
  • MidRoll
  • PostRoll
NOTE: When the slot type cannot be determined, null is returned.
ADS_IN_VIEW integerCount of ads viewable to the user
BROWSER string

Identifies the user's browser


Possible values:
  • Android (default Android browser)
  • Chrome
  • Facebook
  • Firefox
  • Instagram
  • Microsoft (IE/Edge)
  • Other
  • Pinterest
  • Safari
  • Samsung
COUNTRY_NAME stringID of the geographic region
CUSTOM_PARAM_1Custom parameter 1 set by the customer
CUSTOM_PARAM_2Custom parameter 2 set by the customer
CUSTOM_PARAM_3Custom parameter 3 set by the customer
CUSTOM_PARAM_4Custom parameter 4 set by the customer
CUSTOM_PARAM_5Custom parameter 5 set by the customer
DEVICE integer

Type of hardware used to retrieve the content


Possible values:
  • Desktop
  • Game Console
  • PDA
  • Smart TV
  • Smartphone
  • Tablet
  • Unrecognized
  • Wearable Computer
DOMAIN stringDomain of the content
EXCHANGE_DEMAND_REV decimalSum of money in US dollars to be paid to the publisher
EXPERIENCE_TYPE string

Inventory path identifier


Possible values:
  • Max RPM
  • Vertical Video
  • Classic
LINE_ITEM_ID stringID of the line item
OS integer

Operating system of the device used to fetch content


Possible values:
  • Android
  • Chrome
  • iOS
  • Linux
  • MacOS
  • Windows
PLAYER_IN_VIEW integerSum of viewable players
PLAYER_STARTS integerSum of total player sessions started
PUBLISHER_DEMAND_REV decimalSum of revenue from publisher demand in US dollars
PUBLISHER_TOTAL_REV decimalTotal publisher revenue, calculated as the sum of publisher demand revenue and JWX demand revenue in US dollars
SITE_ID stringUnique alphanumeric ID of the site
UTC_DATE stringUTC date of the ingested data in YYYY-MM-DD format
UTC_HOURUTC hour associated with the data


Did this page help you?
© 2007- Longtail Ad Solutions, Inc.