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

account_id

int

SpringServe account ID

supply_tag_id

int

SpringServe supply tag ID

demand_tag_id

int

SpringServe demand tag ID

campaign_id

int

SpringServe campaign ID

line_item_id

int

Currently not used

creative_id

int

Currently not used

auction_id

String (UUID)

Unique ID identifying an auction; different events can be tied together through their auction ID

user_id

String (UUID)

User's SpringServe cookie ID

user_ip

String

IP address of the user

user_agent

String

Full user-agent string of the user

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.

country

String (max length 2)

Country code (e.g. "US", "GB", "DE")

full_page_url

String

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

declared_domain

String (max length128)

Declared domain on the incoming ad request.

detected_domain

String (max length 128)

Domain detected by our VPAID that the player is on.

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"

detected_player_size

String (max length 7)

Player size detected by our VPAID. Same boundaries as declared_player_size

key_values

JSON

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

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)

blocked_requests

int

Event is a request blocked by account or supply tag targeting

PLACEHOLDER

NULL

Placeholder - column will always be NULL

flash_opportunities

int

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

js_opportunities

int

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

flash_impressions

int

Impression served (flash VPAID)

js_impressions

int

Impression served (JS VPAID)

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

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

clicks

int

Video ad is clicked on by user

cost

numeric(16,10)

Media cost the SpringServe account pays the supply partner (for this event)

revenue

numeric(16,10)

Revenue the SpringServe account is paid by the demand partner (for this event)

third_party_fees

numeric(16,10)

Any third party fees for the demand partner (for this event)

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.

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)

first_quartile

int

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

second_quartile

int

Video ad has played through 1/2 of its duration.

third_quartile

int

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

fourth_quartile

int

Video ad has played through its entire duration.

missed_opportunities

int

A usable request that we cannot attempt to fill, due to all demand in the waterfall failing targeting

supply_timeouts

int

Player or parent VPAID times out our VPAID

supply_response_time

bigint

The amount of time it took for our VPAID to fill an impression on the supply tag

ad_requests

int

(Demand-side event) Fired any time our VPAID requests a demand tag's VAST endpoint URL

has_ads

int

(Demand-side event) VAST endpoint URL responds with a non-empty VAST response

opportunities

int

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

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

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.

opportunity_timeouts

int

(Demand-side event) When our VPAID times out a demand tag for taking too long to find an ad

device_id_hashed

String (max 40)

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

pc_user_id

String (max 128)

bidder_requests

int

Count of bid requests made to a PC bidder(s)

dma_id

int

postal_code

String (max 16)

state

String (max 7)

City

String (max 64)

starts

int

Video ad started

app_name

String (Max 256)

App name as it is sent from the supply request

app_bundle

String (Max 256)

App bundle as it is sent in the supply request

node

String (Max 64)

bids

int

Count of bids returned by a PC bidder(s)

bidder_wins

int

Count of winning bids returned by a PC bidder(s)

ap_slots_count

int

Count of ad slots available in an ad pod. Determined by the UI settings or the POD_AD_SLOTS macro

ap_slots_opportunity

int

Count of available ads in the VAST request

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

ap_slots_opportunity_seconds

int

(Pod Opp Time) Sum of opportunities in seconds 

ap_slots_seconds_filled

int

(Pod Fill Time) Sum of impressions in seconds served

ad_seconds

int

Sum of seconds of ads that returned a non-empty VAST in demand tags

supply_router_id

int

SpringServe router ID

event_type

String (Max 128)

List of Event Types can be found here.

fallback_parent_supply_tag_id

int

Supply tag ID that did not fill, resulting in a request to its fallback tag in a router

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)

router_missed_opportunities

int

Sum of router requests for which no supply tag was eligible to be requested

routed_missed_requests

int

Sum of supply tag requests that were missed in a router due to supply tag targeting

ap_ad_seconds

int

Sum of seconds of ads that were requested in a supply tag

ap_demand_opportunity_seconds

int

The Sum of seconds that the Demand tag had an opportunity

coppa

boolean

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

vast_error_code

int

Error Codes used to debug problems with ad serving. For more information, please refer to this link.

duplicate_impressions

int

Impressions that are duplicate (ie. same impression beacon fired more than once)

us_privacy

boolean

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

gdpr

boolean

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

bid_price_actual

numeric(16,10)

Non-price reduced bid value as returned in the bid response from a demand partner

bid_price_reduced

numeric(16,10)

Price reduced bid value

vast_responses

int

The number of non-empty Vast response from the demand partner

device_id

string (max 40)

The user specific Device Identifier, ex: AAID, RIDA, IFA

user_ip_hashed

string (max 40)

Hashed IP address

hashed_creative_id

string (max 40)

ID generated based on media asset urls present in the vast

slot_number

int

slot_order

String (Max 16)

ss_region

String (Max 16)

sshb_bid_requests

int

Number of requests for a bid to a SS HB Demand Tag

sshb_bids

int

Number of bids from a SS HB Demand Tag

sshb_errors

int

Number of errors from a SS HB Demand Tag

sshb_wins

int