Skip to main content

Understanding the enriched TSV format

Overview - TSV Formatโ€‹

The Snowplow pipeline outputs the enriched stream in a Tab Separated Values (TSV) format. As TSV files do not contain header information, this page exists to help users of the enriched stream understand what each value represents.

Additionally, Snowplow has a number of Analytics SDKs available which help parse the TSV records into JSON:

For explanations of what each field represents, please see the Canonical Event Model.

Property IndexProperty Name
0app_id
1platform
2etl_tstamp
3collector_tstamp
4dvce_created_tstamp
5event
6event_id
7txn_id
8name_tracker
9v_tracker
10v_collector
11v_etl
12user_id
13user_ipaddress
14user_fingerprint
15domain_userid
16domain_sessionidx
17network_userid
18geo_country
19geo_region
20geo_city
21geo_zipcode
22geo_latitude
23geo_longitude
24geo_region_name
25ip_isp
26ip_organization
27ip_domain
28ip_netspeed
29page_url
30page_title
31page_referrer
32page_urlscheme
33page_urlhost
34page_urlport
35page_urlpath
36page_urlquery
37page_urlfragment
38refr_urlscheme
39refr_urlhost
40refr_urlport
41refr_urlpath
42refr_urlquery
43refr_urlfragment
44refr_medium
45refr_source
46refr_term
47mkt_medium
48mkt_source
49mkt_term
50mkt_content
51mkt_campaign
52contexts
53se_category
54se_action
55se_label
56se_property
57se_value
58unstruct_event
59tr_orderid
60tr_affiliation
61tr_total
62tr_tax
63tr_shipping
64tr_city
65tr_state
66tr_country
67ti_orderid
68ti_sku
69ti_name
70ti_category
71ti_price
72ti_quantity
73pp_xoffset_min
74pp_xoffset_max
75pp_yoffset_min
76pp_yoffset_max
77useragent
78br_name
79br_family
80br_version
81br_type
82br_renderengine
83br_lang
84br_features_pdf
85br_features_flash
86br_features_java
87br_features_director
88br_features_quicktime
89br_features_realplayer
90br_features_windowsmedia
91br_features_gears
92br_features_silverlight
93br_cookies
94br_colordepth
95br_viewwidth
96br_viewheight
97os_name
98os_family
99os_manufacturer
100os_timezone
101dvce_type
102dvce_ismobile
103dvce_screenwidth
104dvce_screenheight
105doc_charset
106doc_width
107doc_height
108tr_currency
109tr_total_base
110tr_tax_base
111tr_shipping_base
112ti_currency
113ti_price_base
114base_currency
115geo_timezone
116mkt_clickid
117mkt_network
118etl_tags
119dvce_sent_tstamp
120refr_domain_userid
121refr_device_tstamp
122derived_contexts
123domain_sessionid
124derived_tstamp
125event_vendor
126event_name
127event_format
128event_version
129event_fingerprint
130true_tstamp
Was this page helpful?