...

Clearline Log Level Data Events

***ClearLine Log Level Data should be set up with these events only*** : impressions, clicks, starts, first_quartile, second_quartile, third_quartile, and fourth_quartile.

Fields

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

3supply_tag_idintSpringServe supply tag

Clearline account ID

4

demand_tag_id

int

SpringServe

Clearline demand tag ID

5

campaign_id

int

SpringServe line_item

Clearline campaign ID

6

creative_id

int

Currently not used7creative_idintCurrently not used8

Clearline creative ID
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

Clearline cookie ID

10


user_ip	String	IP address of the user

11

user_agent

String

Full 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-DCYour account bought from another SpringServe account (via direct-connect) and then sold to another SpringServe account (via direct-connect)13

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.

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

.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

.

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"

18detected_player_sizeString (max length 7)Player size detected by our VPAID. Same boundaries as declared_player_size19key_values

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

Code Block
{"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 targeting22PLACEHOLDERNULLPlaceholder - column will always be NULL23flash_opportunitiesint

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

24

JSON

js

_opportunitiesint

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

25flash

_impressions

int

Impression 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

29

clicks

int

Video ad is clicked on by user

30

cost

numeric(16,10)

Media cost the

SpringServe

Clearline account pays the supply partner (for this event)

31

revenue

numeric(16,10)

Revenue the

SpringServe

Clearline 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)

3334player_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)35

vpaid_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.

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

.39missed_opportunitiesintA usable request that we cannot attempt to fill, due to all demand in the waterfall failing targeting40supply_timeoutsintPlayer or parent VPAID times out our VPAID41supply_response_timebigintThe amount of time it took for our VPAID to fill an impression on the supply tag42ad_requestsint(Demand-side event) Fired any time our VPAID requests a demand tag's VAST endpoint URL43has_adsint(Demand-side event) VAST endpoint URL responds with a non-empty VAST response44opportunitiesint

(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 tag46opportunity_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

48pc_user

device_id_hashed

String (max 40)

User device identifier for Mobile and Connected TV's, stored hashed for privacy compliance

4950bidder_requestsintCount of bid requests made to a PC bidder(s)51dma_idint52

dma_id

String (max 128)

int	ID corresponding to Demographic Market Area (DMA)
postal_code	String (max 16)

53

Postal code for US & CA traffic only.
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 request58nodeString (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 macro62ap_slots_opportunityintCount of available ads in the VAST request63ap_slots_seconds_availableint(Pod Avail Time) Sum of seconds available in an ad pod. Determined by the UI settings or the POD_MAX_DUR macro64ap_slots_opportunity_secondsint(Pod Opp Time) Sum of opportunities in seconds 65ap_slots_seconds_filledint(Pod Fill Time) Sum of impressions in seconds served66ad_secondsintSum of seconds of ads that returned a non-empty VAST in demand tags67supply_router_idintSpringServe router ID68event_typeString (Max 128)69fallback_parent_

supply

_tag_idintSupply tag ID that did not fill, resulting in a request to its fallback tag in a router70router_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 requested7277spotx_channel_idint78sshb_bid_requestsint79sshb_bidsint80sshb_errorsint81sshb_winsint82

routed_missed_requestsintSum of supply tag requests that were missed in a router due to supply tag targeting73ap_ad_secondsintSum of seconds of ads that were requested in a supply tag74ap_demand_opportunity_secondsintThe Sum of seconds that the Demand tag had an opportunity75spotx_tierint76spotx_campaign_idString (Max 38)

adomain

String (Max 128)

83spotx_marketplace

boolean

84

Advertiser domain
duplicate_impressions	int	Impressions that are duplicate (ie. same impression beacon fired more than once)

85


bid_price_actual	numeric(16,10)	Non-price reduced bid value as returned in the bid response from a demand partner

86

bid_price_reduced

numeric(16,10)

Price reduced bid value

87


device_id	string (max 40)	The user specific Device Identifier, ex: AAID, RIDA, IFA

88


coppa	boolean	Whether supply is COPPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.

89


us_privacy	boolean	Whether Supply is CCPA compliant (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.

90


dnt	boolean	Do Not Track enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.

91

gdpr

boolean

Whether Supply is GDPR enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.

92

lmt

boolean

Limit Ad tracking enabled (1) or not (0). Determined by the presence of the corresponding parameter in the ad request.

93


app_id	int	The app_id from the incoming dsp_data object

94

content_id

int

Content ID passed in the content_data object

95

. IRIS segment IDs will be passed through this field.
detected_adomain	string	Detected advertiser domain value

9697

publisher_name	string	RTB publisher name field
publisher_id_string	String (Max 38)

RTB publisher ID field

Specific to Clearline and is the publisher_id
inventory_source	string	Source of the supply
language	string	Language of the content
content_episode	string	Episode name of the content
content_genre_list	string	Genre of the content
content_producer_name	string	Producer of the content
content_rating_list	string	Rating of the content
channel_name	String (Max 64)	Name of the channel
content_season	string	Seaons of the content
content_series	string	Series of the content
content_title	string	Title of the content
network	string	Publisher declared network of the content
production_quality	int	Production Quality of the content
livestream	boolean	Indicates whether the content is a livestream or not
declared_domain	String (max length128)	Declared domain on the incoming ad request.
event_type	String (max length 128)	List of Event Types can be found here.
deal_ids	string	Deal ID associated with the inventory source
iris_id	string	Publisher declared IRIS identifier. More information on IRIS here.
iris_context	string	Publisher declared IRIS context. More information on IRIS here.
brand_name	String (Max 64)	Device brand
platform_fees	int	Contractual platform fee
non_billable_fees	int	Aggregated 'Fees' as entered on Settings page of Demand Partner, Campaign. These fees are applied when using the Gross Cost budget type.
expired_impressions	int	Impressions fired outside of the beacon expiry (aka time to live) as determined by the SSP. These are not billed.
device_type_id	int	The Device type identifier as defined below. 0 Other 1 Computer 2 Mobile 3 Tablet 4 Game Console 5 Digital Media Receiver 6 Wearable Computer 7 Connected TV 20 Games Console 21 Mobile In-app 22 Mobile Web 23 Tablet In-app 24 Tablet Web 25 CTV 26Set-top Box

Version	Old Version 1	New Version Current
Changes made by	Brian Garey	Brian Garey
Saved on	Dec 08, 2022	Nov 19, 2024

Page Comparison

Versions Compared

Key

<span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-0">[data-colorid=</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-4">w4cnlbk6ci</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-5">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-6">w4cnlbk6ci</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-7">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-8">t5tfxnfd0q</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-9">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-15">#bdd2f6}</span>Clearline Log Level Data Events

Fields

Clearline Log Level Data Events