Skip to content

Instantly share code, notes, and snippets.

@ak--47
Last active February 6, 2025 15:51
Show Gist options
  • Save ak--47/ad1ad6ed856b2583b59c81816dc84ff1 to your computer and use it in GitHub Desktop.
Save ak--47/ad1ad6ed856b2583b59c81816dc84ff1 to your computer and use it in GitHub Desktop.
a CSV file
event_id timestamp user_id event_type page_url time_spent_seconds is_mobile referrer click_coordinates items_in_cart user_agent browser_language is_ad_blocker_enabled favorite_colors notes is_conversion
1 2023-10-01T12:34:56Z 101 page_view https://example.com/home 45 TRUE https://google.com -1,024,768 3 Mozilla/5.0 (Windows NT 10.0; Win64; x64) en-US TRUE blue,green User loves cats. FALSE
2 2023-10-01T12:35:10Z 102 click https://example.com/products 10 FALSE https://bing.com -800,600 Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) en-GB FALSE red,orange TRUE
3 2023-10-01T12:36:22Z 103 add_to_cart https://example.com/product/123 30 TRUE https://yahoo.com -12,801,024 1 Mozilla/5.0 (iPhone; CPU iPhone OS 15_0 like Mac OS X) fr-FR TRUE purple,yellow User left a funny comment. FALSE
4 2023-10-01T12:37:45Z 104 page_view https://example.com/about 120 FALSE Mozilla/5.0 (Linux; Android 10; SM-G975F) de-DE FALSE black,white FALSE
5 2023-10-01T12:38:50Z 105 purchase https://example.com/checkout 60 TRUE https://example.com/products -1,366,768 5 Mozilla/5.0 (Windows NT 10.0; Win64; x64) de-DE TRUE black,white User asked if we sell unicorns. FALSE
6 2023-10-01T12:40:00Z 106 page_view https://example.com/contact 25 FALSE https://duckduckgo.com -19,201,080 Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) en-GB FALSE black,white User asked if we hire ninjas. FALSE
7 2023-10-01T12:41:15Z 107 click https://example.com/product/456 5 TRUE https://google.com -1,024,768 2 Mozilla/5.0 (iPhone; CPU iPhone OS 15_0 like Mac OS X) en-US TRUE yellow,purple User is a fan of pineapple on pizza. FALSE
8 2023-10-01T12:42:30Z 108 add_to_cart https://example.com/product/789 20 FALSE https://bing.com -800,600 3 Mozilla/5.0 (Linux; Android 10; SM-G975F) fr-FR FALSE red,blue TRUE
9 2023-10-01T12:43:45Z 109 page_view https://example.com/faq 90 TRUE Mozilla/5.0 (Windows NT 10.0; Win64; x64) de-DE TRUE black,white User asked if we sell unicorns. FALSE
10 2023-10-01T12:44:50Z 110 purchase https://example.com/checkout 45 FALSE https://example.com/products -1,366,768 4 Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) en-GB FALSE green,blue User bought a lifetime supply of coffee. TRUE
11 2023-10-01T12:45:55Z 111 page_view https://example.com/blog 60 TRUE https://yahoo.com -12,801,024 Mozilla/5.0 (iPhone; CPU iPhone OS 15_0 like Mac OS X) en-US TRUE purple,yellow FALSE
12 2023-10-01T12:47:00Z 112 click https://example.com/product/101 15 FALSE https://duckduckgo.com -19,201,080 1 Mozilla/5.0 (Linux; Android 10; SM-G975F) fr-FR FALSE red,orange User loves dad jokes. FALSE
13 2023-10-01T12:48:10Z 113 add_to_cart https://example.com/product/202 30 TRUE https://google.com -1,024,768 2 Mozilla/5.0 (Windows NT 10.0; Win64; x64) de-DE TRUE blue,green TRUE
14 2023-10-01T12:49:20Z 114 page_view https://example.com/careers 120 FALSE Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) en-GB FALSE black,white User asked if we hire ninjas. FALSE
15 2023-10-01T12:50:30Z 115 purchase https://example.com/checkout 60 TRUE https://example.com/products -1,366,768 3 Mozilla/5.0 (iPhone; CPU iPhone OS 15_0 like Mac OS X) en-US TRUE yellow,purple User bought a giant inflatable dinosaur. TRUE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment