Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/page_traffic_metrics.sql

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