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:

• Analytics SDK Scala
• Analytics SDK Python
• Analytics SDK .NET
• Analytics SDK Javascript
• Analytics SDK Golang

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

Table

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

TSV header

You can use this if you need a header to work with the Snowplow TSV files.

app_id	platform	etl_tstamp	collector_tstamp	dvce_created_tstamp	event	event_id	txn_id	name_tracker	v_tracker	v_collector	v_etl	user_id	user_ipaddress	user_fingerprint	domain_userid	domain_sessionidx	network_userid	geo_country	geo_region	geo_city	geo_zipcode	geo_latitude	geo_longitude	geo_region_name	ip_isp	ip_organization	ip_domain	ip_netspeed	page_url	page_title	page_referrer	page_urlscheme	page_urlhost	page_urlport	page_urlpath	page_urlquery	page_urlfragment	refr_urlscheme	refr_urlhost	refr_urlport	refr_urlpath	refr_urlquery	refr_urlfragment	refr_medium	refr_source	refr_term	mkt_medium	mkt_source	mkt_term	mkt_content	mkt_campaign	contexts	se_category	se_action	se_label	se_property	se_value	unstruct_event	tr_orderid	tr_affiliation	tr_total	tr_tax	tr_shipping	tr_city	tr_state	tr_country	ti_orderid	ti_sku	ti_name	ti_category	ti_price	ti_quantity	pp_xoffset_min	pp_xoffset_max	pp_yoffset_min	pp_yoffset_max	useragent	br_name	br_family	br_version	br_type	br_renderengine	br_lang	br_features_pdf	br_features_flash	br_features_java	br_features_director	br_features_quicktime	br_features_realplayer	br_features_windowsmedia	br_features_gears	br_features_silverlight	br_cookies	br_colordepth	br_viewwidth	br_viewheight	os_name	os_family	os_manufacturer	os_timezone	dvce_type	dvce_ismobile	dvce_screenwidth	dvce_screenheight	doc_charset	doc_width	doc_height	tr_currency	tr_total_base	tr_tax_base	tr_shipping_base	ti_currency	ti_price_base	base_currency	geo_timezone	mkt_clickid	mkt_network	etl_tags	dvce_sent_tstamp	refr_domain_userid	refr_device_tstamp	derived_contexts	domain_sessionid	derived_tstamp	event_vendor	event_name	event_format	event_version	event_fingerprint	true_tstamp