Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/session_metrics.sql

Last active August 25, 2016 05:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doryokujin/ba504904d1c7708fd88fad6d86c5f90f to your computer and use it in GitHub Desktop.
Save doryokujin/ba504904d1c7708fd88fad6d86c5f90f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
session_metrics.sql
+---------------------------+---------------------------------------------------------------------------------------+---------------+--------------+--------------------+----------------------------+--------------------------------+-----------+
| date_hour:timestamp | page_path:string | sessions:long | bounces:long | bounce_rate:double | session_duration:timestamp | avg_session_duration:timestamp | hits:long |
+---------------------------+---------------------------------------------------------------------------------------+---------------+--------------+--------------------+----------------------------+--------------------------------+-----------+
| "2016-08-17 15:00:00 UTC" | "www.parc.com/jp/work/focus-area/bigdata/" | 1 | 0 | 0.0 | nil | nil | 1 |
| "2016-08-17 15:00:00 UTC" | "www.parc.com/jp/work/focus-areas.html" | 0 | 0 | 0.0 | nil | nil | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/" | 1 | 1 | 100.0 | nil | nil | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | 2 | 1 | 50.0 | nil | nil | 4 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/press_release/20151202_iot_windmill_turbine_mitsubishiheavy" | 1 | 1 | 100.0 | nil | nil | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/press_release/20160621_nttdata_with_treasure_data_service" | 1 | 1 | 100.0 | nil | nil | 1 |
| "2016-08-17 16:00:00 UTC" | "www.parc.com/jp/" | 1 | 1 | 100.0 | nil | nil | 1 |
+---------------------------+---------------------------------------------------------------------------------------+---------------+--------------+--------------------+----------------------------+--------------------------------+-----------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment