Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/dc_client_id.sql

Last active August 27, 2016 00:32
Show Gist options
  • Save doryokujin/f8cbbf324c3b883dfc7ce0a4a1f666f7 to your computer and use it in GitHub Desktop.
Save doryokujin/f8cbbf324c3b883dfc7ce0a4a1f666f7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dc_client_id.sql
+---------------------------+------------------+-------------------------+----------------+----------------+
| date_hour:timestamp | page_path:string | client_id:string | pageviews:long | view_id:string |
+---------------------------+------------------+-------------------------+----------------+----------------+
| "2016-08-19 07:00:00 UTC" | "/" | "1108439470.1471592890" | 4 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "1224794560.1471584000" | 1 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "1369494787.1462782000" | 1 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "1389102700.1471592860" | 3 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "1521310483.1469457390" | 1 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "1690037376.1461813950" | 2 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "1975562597.1465869340" | 2 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "2129467033.1466659600" | 1 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "2141630241.1442290310" | 1 | "128049838" |
| "2016-08-19 07:00:00 UTC" | "/" | "48640408.147159293600" | 1 | "128049838" |
+---------------------------+------------------+-------------------------+----------------+----------------+
10 rows in set
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment