Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/user_dimensions.sql

Last active August 25, 2016 05:29
Show Gist options
  • Save doryokujin/beb7d8aa0c2c016bbe05a60fab64c905 to your computer and use it in GitHub Desktop.
Save doryokujin/beb7d8aa0c2c016bbe05a60fab64c905 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
user_dimensions.sql
+---------------------------+-------------+---------------------------------------------------------------------------------------+----------------+------------+----------------+-----------------------------+--------------------------+
| date_hour:timestamp | page_path:string | pageviews:long | users:long | new_users:long | percent_new_sessions:double | sessions_per_user:double |
+---------------------------+---------------------------------------------------------------------------------------+----------------+------------+----------------+-----------------------------+--------------------------+
| "2016-08-17 15:00:00 UTC" | "www.parc.com/jp/work/focus-area/bigdata/" | 1 | 1 | 0 | 0.0 | 1.0 |
| "2016-08-17 15:00:00 UTC" | "www.parc.com/jp/work/focus-areas.html" | 1 | 1 | 0 | 0.0 | 0.0 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/" | 1 | 1 | 0 | 0.0 | 1.0 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | 3 | 2 | 2 | 100.0 | 1.0 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/press_release/20151202_iot_windmill_turbine_mitsubishiheavy" | 1 | 1 | 1 | 100.0 | 1.0 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/press_release/20160621_nttdata_with_treasure_data_service" | 1 | 1 | 1 | 100.0 | 1.0 |
| "2016-08-17 16:00:00 UTC" | "www.parc.com/jp/" | 1 | 1 | 1 | 100.0 | 1.0 |
+---------------------------+-------------+---------------------------------------------------------------------------------------+----------------+------------+----------------+-----------------------------+--------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment