Log Level Data

Fields

IndexField NameField Data Type

Field Description

1ymdhtimestampTimestamp of the event, in UTC, in ISO format. The character "T" serves as the separator between Date and Time parts. Format: YYYY-MM-DDTHH:MM:SS
2account_idint

SpringServe account ID

3supply_tag_idintSpringServe supply tag ID
4demand_tag_idintSpringServe demand tag ID
5campaign_idint

SpringServe campaign ID

6line_item_idintCurrently not used
7creative_idintCurrently not used
8auction_idString (UUID)Unique ID identifying an auction; different events can be tied together through their auction ID
9user_idString (UUID)User's SpringServe cookie ID
10user_ipStringIP address of the user
11user_agentStringFull user-agent string of the user
12transaction_typeint

SpringServe transaction type for this event

  • 1 - In-Network/Managed (no direct-connect),
    • A supply tag in your SpringServe account sold to a demand tag in your SpringServe account
  • 2 - DC-Sold
    • The initial incoming ad request was to a (non-direct-connect) supply tag in your account, and was sold (via direct-connect) to another SpringServe account.
  • 3 - DC-DC
    • Your account bought from another SpringServe account (via direct-connect) and then sold to another SpringServe account (via direct-connect)
  • 4 - DC-Bought
    • A direct-connect supply tag bought from another SpringServe account, and sold to a non-direct-connect demand tag in your account.
13countryString (max length 2)Country code (e.g. "US", "GB", "DE")
14full_page_urlString

Full-page url that is declared on the incoming ad request.

15declared_domainString (max length128)Declared domain on the incoming ad request.
16detected_domainString (max length 128)Domain detected by our VPAID that the player is on.
17declared_player_sizeString (max length 7)

Declared player size. Sizes are based on width and are defined by the following boundaries:

  • <= 0 - "unknown"
  • 1 <= w <= 249 - "x-small"
  • 250 <= w <= 349 - "small"
  • 350 <= w <= 500 - "medium"
  • 501 <= w <= 799 - "large"
  • 800 <= w - "x-large"
18detected_player_sizeString (max length 7)Player size detected by our VPAID. Same boundaries as declared_player_size
19key_valuesJSON

Key:Values associated with the event. This field is a JSON object with String keys and String values, e.g.

 {"our_campaign_id": "123", "user_segment": "high_value_users"}
20usable_requestsint

Incoming ad request to a supply tag that has passed global blacklist, supply tag targeting, and pre-bid IVT filtering (if applicable)

21blocked_requestsintEvent is a request blocked by account or supply tag targeting
22PLACEHOLDERNULLPlaceholder - column will always be NULL
23flash_opportunitiesint

Our flash VPAID is loaded + initialized by the player (or parent VPAID)

24js_opportunitiesint

Our JS VPAID is loaded + initialized by the player (or parent VPAID)

25flash_impressionsintImpression served (flash VPAID)
26js_impressionsintImpression served (JS VPAID)
27flash_errorsint

Error our flash VPAID fires before closing. Common causes include:

  • No impressions serve in the waterfall
  • Player or parent VPAID times our VPAID out
28js_errorsint

Error our JS VPAID fires before closing. Common causes include:

  • No impressions serve in the waterfall
  • Player or parent VPAID times our VPAID out
29clicksintVideo ad is clicked on by user
30costnumeric(16,10)Media cost the SpringServe account pays the supply partner (for this event)
31revenuenumeric(16,10)Revenue the SpringServe account is paid by the demand partner (for this event)
32third_party_feesnumeric(16,10)Any third party fees for the demand partner (for this event)
33vpaid_time_on_pagebigint

Measures how long our VPAID was on the page before being timed out by the player.

Note: this is only recorded for the supply_timeouts event. Some players may erase our IFRAME from the page before timing us out, in which case a supply timeout cannot be recorded.

34player_startsintEvent is fired when the video player on the page starts up (via a SpringServe pixel placed in the HTML player code that is fired when the player is initialized)
35first_quartileintVideo ad has played through 1/4 of its duration.
36second_quartileintVideo ad has played through 1/2 of its duration.
37third_quartileint

Video ad has played through 3/4 of its duration.

38fourth_quartileintVideo ad has played through its entire duration.
39missed_opportunitiesintA usable request that we cannot attempt to fill, due to all demand in the waterfall failing targeting
40supply_timeoutsintPlayer or parent VPAID times out our VPAID
41supply_response_timebigintThe amount of time it took for our VPAID to fill an impression on the supply tag
42ad_requestsint(Demand-side event) Fired any time our VPAID requests a demand tag's VAST endpoint URL
43has_adsint(Demand-side event) VAST endpoint URL responds with a non-empty VAST response
44opportunitiesint

(Demand-side event) Indicates the VPAID received a non-empty VAST response / media file back from VAST endpoint URL, and initiated it

45errorsint(Demand-side event) 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
46opportunity_response_timebigint(Demand-side metric) 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.
47opportunity_timeoutsint(Demand-side event) When our VPAID times out a demand tag for taking too long to find an ad
48device_id_hashedString (max 40)User device identifier for Mobile and Connected TV's, stored hashed for privacy compliance 
49pc_user_idString (max 128)
50bidder_requestsintCount of bid requests made to a PC bidder(s)
51dma_idint
52postal_codeString (max 16)
53stateString (max 7)
54CityString (max 64)
55startsintVideo ad started
56app_nameString (Max 256)App name as it is sent from the supply request
57app_bundleString (Max 256)App bundle as it is sent in the supply request
58nodeString (Max 64)
59bidsintCount of bids returned by a PC bidder(s)
60bidder_winsintCount of winning bids returned by a PC bidder(s)
61ap_slots_countintCount of ad slots available in an ad pod. Determined by the UI settings or the POD_AD_SLOTS macro
62ap_slots_opportunityintCount of available ads in the VAST request
63ap_slots_seconds_availableint(Pod Avail Time) Sum of seconds available in an ad pod. Determined by the UI settings or the POD_MAX_DUR macro
64ap_slots_opportunity_secondsint(Pod Opp Time) Sum of opportunities in seconds 
65ap_slots_seconds_filledint(Pod Fill Time) Sum of impressions in seconds served
66ad_secondsintSum of seconds of ads that returned a non-empty VAST in demand tags
67supply_router_idintSpringServe router ID
68event_typeString (Max 128)List of Event Types can be found here.
69fallback_parent_supply_tag_idintSupply tag ID that did not fill, resulting in a request to its fallback tag in a router
70router_usable_requestsintSum of incoming ad request to a router that have passed global blacklist, supply partner and router targeting, and pre-bid IVT filtering (if applicable)
71router_missed_opportunitiesintSum of router requests for which no supply tag was eligible to be requested
72routed_missed_requestsintSum of supply tag requests that were missed in a router due to supply tag targeting
73ap_ad_secondsintSum of seconds of ads that were requested in a supply tag
74ap_demand_opportunity_secondsintThe Sum of seconds that the Demand tag had an opportunity
75coppabooleanWhether supply is COPPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
76vast_error_codeintError Codes used to debug problems with ad serving. For more information, please refer to this link.
77duplicate_impressionsintImpressions that are duplicate (ie. same impression beacon fired more than once)
78us_privacybooleanWhether Supply is CCPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
79gdprbooleanWhether Supply is GDPR enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
80bid_price_actualnumeric(16,10)Non-price reduced bid value as returned in the bid response from a demand partner
81bid_price_reducednumeric(16,10)Price reduced bid value
82vast_responsesintThe number of non-empty Vast response from the demand partner
83device_idstring (max 40)The user specific Device Identifier, ex: AAID, RIDA, IFA
84user_ip_hashedstring (max 40)Hashed IP address
85hashed_creative_idstring (max 40)ID generated based on media asset urls present in the vast
86slot_numberint
87slot_orderString (Max 16)
88ss_regionString (Max 16)
89spotx_campaign_idString (Max 30)SpotX Campaign ID
90spotx_channel_idintSpotX Channel ID
91sshb_bid_requests

int

Number of requests for a bid to a SS HB Demand Tag
92sshb_bidsintNumber of bids from a SS HB Demand Tag
93sshb_errorsintNumber of errors from a SS HB Demand Tag
94sshb_wins

int

Number of times an SS HB Demand Tag's response is chosen
95adomainString (Max 128)Advertiser Domain associated with the demand
96spotx_marketplaceboolean
97buyer_idString (Max 50)
98selling_supply_tag_idint
99buying_demand_tag_idint
100deal_idsarrayIdentifier used in deal between publisher and buyer
101channel_idintSpecific to Clearline; and is incoming channel_id
102publisher_idString (Max 38)RTB publisher ID field
103publisher_nameString (Max 64)RTB publisher Name field
104app_idint
105content_idintAn ID specific to a publisher's content
106

content_episode

String (Max 64)The Episode of the content
107content_titleString (Max 64)The Title of the content
108content_seriesString (Max 64)The Series of the content
109content_seasonString (Max 64)The Season of the content
110content_genre_listarrayList of applicable genres for the content
111content_rating_listarrayList of applicable ratings for the content
112channel_nameString (Max 64)Name of the channel
113

language

String (Max 64)Language of the content
114networkString (Max 64)Network of the Content
115production_qualityintProduction Quality of the content
116livestreambooleanIndicates whether the content is a livestream or not
117total_response_sizeint
The size of the JSON response from the bidder
118iris_idString (Max 200)Iris.TV ID used for API call
119iris_contextarrayIris.TV Context ID's for targeting
120brand_nameString (Max 64)Connected TV brands
121content_producer_nameString (Max 64)The producer of the content
122content_custom1_paramString (Max 64)Custom parameter for content macros that may not be covered in the other content macros
123content_custom2_paramString (Max 64)Custom parameter for content macros that may not be covered in the other content macros
124content_custom3_paramString (Max 64)Custom parameter for content macros that may not be covered in the other content macros
125device_type_idintThe Device type identifer for CTV, Set-top-box, desktop, Mobile
126app_id_stringString (Max 64)Specific to Clearline and is the app_id
127publisher_id_stringString (Max 64)Specific to Clearline and is the publisher_id
128dntbooleanDo Not Track enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
129lmtbooleanLimit Ad tracking enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
130liveramp_eidsbooleanThe Liveramp Envelope ID, Only populated when it is passed through in supply request
131inventory_sourceString (Max 64)Source of the supply
132throttled_requestsintThis represents bid requests to BidLink that were rejected with a 429 due to QPS limitations.
133detected_adomainString(Max 128)Advertiser Domain as detected by BingeWatcher for a hashed_creative_id
134device_id_synBooleanboolean that defines whether the DEVICE_ID value stored in the DB is a generates synthetic device ID
135pod_idintFor a podded tag, this is the id of the pod in the call chain. If not, this defaults to zero
136schain_presentbooleanIndicative of the presence of an schain being passed in the incoming supply request. This is set to 1 if yes, else 0
137gdpr_consent_presentbooleanIf an incoming request has a value for gdpr_consent that is a string and not NULL, 0, or 1 then we set gdpr_consent_present to 1
138bidder_account_idintBidder Account ID
139bid_floornumeric(17, 10)
140foreign_deal_idString (Max 128)Deal ID as present on Magnite Streaming
141adomain_targeting_onintSpecifies the adomain used for targeting (declared, detected, or overridden)