Fields

Index	Field Name	Field Data Type	Field Description
1	ymdh	timestamp	Timestamp 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
2	account_id	int	SpringServe account ID
3	supply_tag_id	int	SpringServe supply tag ID
4	demand_tag_id	int	SpringServe demand tag ID
5	campaign_id	int	SpringServe campaign ID
6	line_item_id	int	Currently not used
7	creative_id	int	Currently not used
8	auction_id	String (UUID)	Unique ID identifying an auction; different events can be tied together through their auction ID
9	user_id	String (UUID)	User's SpringServe cookie ID
10	user_ip	String	IP address of the user
11	user_agent	String	Full user-agent string of the user
12	transaction_type	int	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.
13	country	String (max length 2)	Country code (e.g. "US", "GB", "DE")
14	full_page_url	String	Full-page url that is declared on the incoming ad request.
15	declared_domain	String (max length128)	Declared domain on the incoming ad request.
16	detected_domain	String (max length 128)	Domain detected by our VPAID that the player is on.
17	declared_player_size	String (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"
18	detected_player_size	String (max length 7)	Player size detected by our VPAID. Same boundaries as declared_player_size
19	key_values	JSON	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"}
20	usable_requests	int	Incoming ad request to a supply tag that has passed global blacklist, supply tag targeting, and pre-bid IVT filtering (if applicable)
21	blocked_requests	int	Event is a request blocked by account or supply tag targeting
22	PLACEHOLDER	NULL	Placeholder - column will always be NULL
23	flash_opportunities	int	Our flash VPAID is loaded + initialized by the player (or parent VPAID)
24	js_opportunities	int	Our JS VPAID is loaded + initialized by the player (or parent VPAID)
25	flash_impressions	int	Impression served (flash VPAID)
26	js_impressions	int	Impression served (JS VPAID)
27	flash_errors	int	Error our flash VPAID fires before closing. Common causes include: No impressions serve in the waterfall Player or parent VPAID times our VPAID out
28	js_errors	int	Error our JS VPAID fires before closing. Common causes include: No impressions serve in the waterfall Player or parent VPAID times our VPAID out
29	clicks	int	Video ad is clicked on by user
30	cost	numeric(16,10)	Media cost the SpringServe account pays the supply partner (for this event)
31	revenue	numeric(16,10)	Revenue the SpringServe account is paid by the demand partner (for this event)
32	third_party_fees	numeric(16,10)	Any third party fees for the demand partner (for this event)
33	vpaid_time_on_page	bigint	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.
34	player_starts	int	Event 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)
35	first_quartile	int	Video ad has played through 1/4 of its duration.
36	second_quartile	int	Video ad has played through 1/2 of its duration.
37	third_quartile	int	Video ad has played through 3/4 of its duration.
38	fourth_quartile	int	Video ad has played through its entire duration.
39	missed_opportunities	int	A usable request that we cannot attempt to fill, due to all demand in the waterfall failing targeting
40	supply_timeouts	int	Player or parent VPAID times out our VPAID
41	supply_response_time	bigint	The amount of time it took for our VPAID to fill an impression on the supply tag
42	ad_requests	int	(Demand-side event) Fired any time our VPAID requests a demand tag's VAST endpoint URL
43	has_ads	int	(Demand-side event) VAST endpoint URL responds with a non-empty VAST response
44	opportunities	int	(Demand-side event) Indicates the VPAID received a non-empty VAST response / media file back from VAST endpoint URL, and initiated it
45	errors	int	(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
46	opportunity_response_time	bigint	(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.
47	opportunity_timeouts	int	(Demand-side event) When our VPAID times out a demand tag for taking too long to find an ad
48	device_id_hashed	String (max 40)	User device identifier for Mobile and Connected TV's, stored hashed for privacy compliance
49	pc_user_id	String (max 128)
50	bidder_requests	int	Count of bid requests made to a PC bidder(s)
51	dma_id	int
52	postal_code	String (max 16)
53	state	String (max 7)
54	City	String (max 64)
55	starts	int	Video ad started
56	app_name	String (Max 256)	App name as it is sent from the supply request
57	app_bundle	String (Max 256)	App bundle as it is sent in the supply request
58	node	String (Max 64)
59	bids	int	Count of bids returned by a PC bidder(s)
60	bidder_wins	int	Count of winning bids returned by a PC bidder(s)
61	ap_slots_count	int	Count of ad slots available in an ad pod. Determined by the UI settings or the POD_AD_SLOTS macro
62	ap_slots_opportunity	int	Count of available ads in the VAST request
63	ap_slots_seconds_available	int	(Pod Avail Time) Sum of seconds available in an ad pod. Determined by the UI settings or the POD_MAX_DUR macro
64	ap_slots_opportunity_seconds	int	(Pod Opp Time) Sum of opportunities in seconds
65	ap_slots_seconds_filled	int	(Pod Fill Time) Sum of impressions in seconds served
66	ad_seconds	int	Sum of seconds of ads that returned a non-empty VAST in demand tags
67	supply_router_id	int	SpringServe router ID
68	event_type	String (Max 128)	List of Event Types can be found here.
69	fallback_parent_supply_tag_id	int	Supply tag ID that did not fill, resulting in a request to its fallback tag in a router
70	router_usable_requests	int	Sum of incoming ad request to a router that have passed global blacklist, supply partner and router targeting, and pre-bid IVT filtering (if applicable)
71	router_missed_opportunities	int	Sum of router requests for which no supply tag was eligible to be requested
72	routed_missed_requests	int	Sum of supply tag requests that were missed in a router due to supply tag targeting
73	ap_ad_seconds	int	Sum of seconds of ads that were requested in a supply tag
74	ap_demand_opportunity_seconds	int	The Sum of seconds that the Demand tag had an opportunity
75	coppa	boolean	Whether supply is COPPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
76	vast_error_code	int	Error Codes used to debug problems with ad serving. For more information, please refer to this link.
77	duplicate_impressions	int	Impressions that are duplicate (ie. same impression beacon fired more than once)
78	us_privacy	boolean	Whether Supply is CCPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
79	gdpr	boolean	Whether Supply is GDPR enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
80	bid_price_actual	numeric(16,10)	Non-price reduced bid value as returned in the bid response from a demand partner
81	bid_price_reduced	numeric(16,10)	Price reduced bid value
82	vast_responses	int	The number of non-empty Vast response from the demand partner
83	device_id	string (max 40)	The user specific Device Identifier, ex: AAID, RIDA, IFA
84	user_ip_hashed	string (max 40)	Hashed IP address
85	hashed_creative_id	string (max 40)	ID generated based on media asset urls present in the vast
86	slot_number	int
87	slot_order	String (Max 16)
88	ss_region	String (Max 16)
89	sshb_bid_requests	int	Number of requests for a bid to a SS HB Demand Tag
90	sshb_bids	int	Number of bids from a SS HB Demand Tag
91	sshb_errors	int	Number of errors from a SS HB Demand Tag
92	sshb_wins	int	Number of times an SS HB Demand Tag's response is chosen
93	adomain	String (Max 128)	Advertiser Domain associated with the demand
94	buyer_id	String (Max 50)
95	selling_supply_tag_id	int
96	buying_demand_tag_id	int
97	deal_ids	array	Identifier used in deal between publisher and buyer
98	channel_id	int	Specific to Clearline; and is incoming channel_id
99	publisher_id	String (Max 38)	RTB publisher ID field
100	publisher_name	String (Max 64)	RTB publisher Name field
101	app_id	int
102	content_id	int	An ID specific to a publisher's content
103	content_episode	String (Max 64)	The Episode of the content
104	content_title	String (Max 64)	The Title of the content
105	content_series	String (Max 64)	The Series of the content
106	content_season	String (Max 64)	The Season of the content
107	content_genre_list	array	List of applicable genres for the content
108	content_rating_list	array	List of applicable ratings for the content
109	channel_name	String (Max 64)	Name of the channel
110	language	String (Max 64)	Language of the content
111	network	String (Max 64)	Network of the Content
112	production_quality	int	Production Quality of the content
113	livestream	boolean	Indicates whether the content is a livestream or not
114	total_response_size	int	The size of the JSON response from the bidder
115	iris_id	String (Max 200)	Iris.TV ID used for API call
116	iris_context	array	Iris.TV Context ID's for targeting
117	brand_name	String (Max 64)	Connected TV brands
118	content_producer_name	String (Max 64)	The producer of the content
119	content_custom1_param	String (Max 64)	Custom parameter for content macros that may not be covered in the other content macros
120	content_custom2_param	String (Max 64)	Custom parameter for content macros that may not be covered in the other content macros
121	content_custom3_param	String (Max 64)	Custom parameter for content macros that may not be covered in the other content macros
122	device_type_id	int	The Device type identifer for CTV, Set-top-box, desktop, Mobile
123	app_id_string	String (Max 64)	Specific to Clearline and is the app_id
124	publisher_id_string	String (Max 64)	Specific to Clearline and is the publisher_id
125	dnt	boolean	Do Not Track enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
126	lmt	boolean	Limit Ad tracking enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.
127	liveramp_eids	boolean	The Liveramp Envelope ID, Only populated when it is passed through in supply request
128	inventory_source	String (Max 64)	Source of the supply
129	throttled_requests	int	This represents bid requests to BidLink that were rejected with a 429 due to QPS limitations.
130	detected_adomain	String(Max 128)	Advertiser Domain as detected by BingeWatcher for a hashed_creative_id
131	device_id_syn	Boolean	boolean that defines whether the DEVICE_ID value stored in the DB is a generates synthetic device ID
132	pod_id	int	For a podded tag, this is the id of the pod in the call chain. If not, this defaults to zero
133	schain_present	boolean	Indicative of the presence of an schain being passed in the incoming supply request. This is set to 1 if yes, else 0
134	gdpr_consent_present	boolean	If 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
135	bidder_account_id	int	Bidder Account ID
136	bid_floor	numeric(17, 10)
137	foreign_deal_id	String (Max 128)	Deal ID as present on Magnite Streaming
138	adomain_targeting_on	int	Specifies the adomain used for targeting (declared, detected, or overridden)

Spring Serve Documentation

Log Level Data

Fields