Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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_idintSpringServe line item ID
7creative_idintSpringServe creative ID
8auction_idString (UUID)Auction ID which this event belongs to. UUID
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
  • 2 - DC-Sold
  • 3 - DC-DC
  • 4 - DC-Bought
13countryString (max length 2)Country code (e.g. "US", "GB", "DE")
14full_page_urlString

Full-page url

15declared_domainString (max length128)Declared domain
16detected_domainString (max length 128)Detected Domain
17declared_player_sizeString (max length 7)

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

  • <= 0 - "unknown"
  • 1 <= w <= 349 - "small"
  • 350 <= w <= 500 - "medium"
  • 501 <= w - "large"
18detected_player_sizeString (max length 7)Detected player size. Same definitions 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_requestsintEvent is an ad request to a supply tag that has passed all targeting (including pre-bid check and tag targeting)
21blocked_requestsintEvent is a request blocked by account or supply tag targeting
22PLACEHOLDERNULLPlaceholder - column will always be NULL
23flash_opportunitiesintEvent is an opportunity (flash player-load) for a supply tag
24js_opportunitiesint

Event is an opportunity (JS player-load) for a supply tag

25flash_impressionsintEvent is an impression served (flash player)
26js_impressionsintEvent is an impression served (JS player)
27flash_errorsintEvent is a flash player error
28js_errorsintEvent is a JS player error
29clicksintEvent is a click
30costnumeric(16,10)Cost associated with this event
31revenuenumeric(16,10)Revenue associated with this event
32third_party_feesnumeric(16,10)Any third party fees associated with this event
33vpaid_time_on_pagebigint
34player_startsintVideo started
35first_quartileintEvent signifies player making it 1/4 of way through video
36second_quartileintEvent signifies player making it 1/2 of way through video
37third_quartileint

Event signifies player making it 3/4 of way through video

38fourth_quartileintEvent signifies video completion
39missed_opportunitiesintEvent is missed opportunity
40supply_timeoutsintEvent is result of player timeout
41supply_response_timebigint
42ad_requestsintEvent is a request to a demand tag for an ad
43has_adsintEvent signifies demand tag has an ad to serve
44opportunitiesintEvent is demand tag opportunity to serve an ad
45errorsintEvent is a demand-side error
46opportunity_response_timebigint
47opportunity_timeoutsint
  • No labels