Fields
| Index | Field Name | Field Data Type | Field Description |
|---|---|---|---|
| 1 | account_id | int | Springserve account ID |
| 2 | demand_tag_id | int | SpringServe demand tag ID |
| 3 | campaign_id | int | SpringServe campaign ID |
| 4 | creative_id | int | Currently not used |
| 5 | auction_id | String (UUID) | Unique ID identifying an auction; different events can be tied together through their auction ID |
| 6 | user_id | String (UUID) | User's SpringServe cookie ID |
| 7 | user_ip | String | IP address of the user |
| 8 | user_agent | String | Full user-agent string of the user |
| 9 | country | String (max length 2) | Country code (e.g. "US", "GB", "DE") |
| 10 | full_page_url | String | Full-page url that is declared on the incoming ad request. |
| 11 | declared_player_size | String (max length 7) | Declared player size. Sizes are based on width and are defined by the following boundaries:
|
| 12 | detected_player_size | String (max length 7) | Player size detected by our VPAID. Same boundaries as declared_player_size |
| 13 | js_impressions | int | Impression served (JS VPAID) |
| 14 | clicks | int | Video ad is clicked on by user |
| 15 | cost | numeric(16,10) | Media cost the SpringServe account pays the supply partner (for this event) |
| 16 | revenue | numeric(16,10) | Revenue the SpringServe account is paid by the demand partner (for this event) |
| 17 | third_party_fees | numeric(16,10) | Any third party fees for the demand partner (for this event) |
| 18 | first_quartile | int | Video ad has played through 1/4 of its duration. |
| 19 | second_quartile | int | Video ad has played through 1/2 of its duration. |
| 20 | third_quartile | int | Video ad has played through 3/4 of its duration. |
| 21 | fourth_quartile | int | Video ad has played through its entire duration. |
| 22 | ad_requests | int | Fired any time our VPAID requests a demand tag's VAST endpoint URL |
| 23 | has_ads | int | VAST endpoint URL responds with a non-empty VAST response |
| 24 | opportunities | int | Indicates the VPAID received a non-empty VAST response / media file back from VAST endpoint URL, and initiated it |
| 25 | errors | int | Indicates an error occurred with the demand tag. Most common case is due to the demand not filling or our VPAID timing out the demand tag |
| 26 | device_id_hashed | String (max 40) | User device identifier for Mobile and Connected TV's, stored hashed for privacy compliance |
| 27 | dma_id | int | ID corresponding to Demographic Market Area (DMA) |
| 28 | postal_code | String (max 16) | Postal code for US & CA traffic only. |
| 29 | state | String (max 7) | |
| 30 | City | String (max 64) | |
| 31 | starts | int | Video ad started |
| 32 | app_name | String (Max 256) | App name as it is sent from the supply request |
| 33 | app_bundle | String (Max 256) | App bundle as it is sent in the supply request |
| 34 | spotx_channel_id | int | |
| 35 | adomain | String (Max 128) | Advertiser domain |
| 36 | duplicate_impressions | int | Impressions that are duplicate (ie. same impression beacon fired more than once) |
| 37 | bid_price_actual | numeric(16,10) | Non-price reduced bid value as returned in the bid response from a demand partner |
| 38 | bid_price_reduced | numeric(16,10) | Price reduced bid value |
| 39 | device_id | string (max 40) | The user specific Device Identifier, ex: AAID, RIDA, IFA |
| 40 | coppa | boolean | Whether supply is COPPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request. |
| 41 | us_privacy | boolean | Whether Supply is CCPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request. |
| 42 | dnt | boolean | Do Not Track enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request. |
| 43 | gdpr | boolean | Whether Supply is GDPR enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request. |
| 44 | lmt | boolean | Limit Ad tracking enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request. |
| 45 | app_id | int | The app_id from the incoming dsp_data object |
| 46 | content_id | int | Content ID passed in the content_data object |
| 47 | detected_adomain | string | Detected advertiser domain value |
| 48 | publisher_name | string | RTB publisher name field |
| 49 | publisher_id | String (Max 38) | RTB publisher ID field |
| 50 | inventory_source | string | Source of the supply |
| 51 | language | string | Language of the content |
| 52 | app_id | string | RTB app_id from the incoming dsp_data object |
| 53 | content_custom1_param | string | Custom parameter for content macros that may not be covered in the standardized content macros |
| 54 | content_custom2_param | string | Custom parameter for content macros that may not be covered in the standardized content macros |
| 55 | content_custom3_param | string | Custom parameter for content macros that may not be covered in the standardized content macros |
| 56 | content_episode | string | Episode name of the content |
| 57 | content_genre_list | string | Genre of the content |
| 58 | content_producer_name | string | of the content |
| 59 | network | string | Publisher declared network of the content |
| 60 | declared_domain | String (max length128) | Declared domain on the incoming ad request. |
| 61 | event_type | String (max length 128) | List of Event Types can be found here. |
| 62 | opportunity_response_time | bigint | Amount of time it takes for the demand tag to fill an impression. This is the time between an ad_request event and an impression event. |
| 63 | deal_ids | string | Deal ID associated with the inventory source bid request |
| 64 | opportunity_timeouts | int | When our VPAID times out a demand tag for taking too long to find an ad |
| 65 | iris_id | string | Publisher declared IRIS identifier. More information on IRIS here. |
| 66 | iris_context | string | Publisher declared IRIS context. More information on IRIS here. |