Enriched stream TSV file 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.
TSV header#
Copy 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
TSV properties#
The following table lists the properties of the TSV file.
| 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 |