Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/page_tracking_dimensions.sql

Last active August 25, 2016 04:41
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/ea87d0bf9f3e4c8e7a6743f818c8a432 to your computer and use it in GitHub Desktop.
Save doryokujin/ea87d0bf9f3e4c8e7a6743f818c8a432 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
page_tracking_dimensions.sql
+---------------------------+---------------------------------------------------------------------------------------+----------------------------------------------------------------------------+---------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+----------------+
| date_hour:timestamp | page_path:string | page_title:string | landing_page_path:string | exit_page_path:string | second_page_path:string | previous_page_path:string | pageviews:long |
+---------------------------+---------------------------------------------------------------------------------------+----------------------------------------------------------------------------+---------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+----------------+
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/" | "Treasure Data - データ分析をクラウドで、シンプルに。 - Treasure Data" | "www.treasuredata.com/jp/" | "www.treasuredata.com/jp/" | "(not set)" | "(entrance)" | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "TREASURE DMPの概要 - Treasure Data" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "(not set)" | "(entrance)" | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "TREASURE DMPの概要 - Treasure Data" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "(entrance)" | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "TREASURE DMPの概要 - Treasure Data" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | "www.treasuredata.com/jp/jp_download_corporate_overview_str/??utm_source=facebook" | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/press_release/20151202_iot_windmill_turbine_mitsubishiheavy" | "三菱重工 風力発電事業にIoTモニタリングシステムを導入 Treasure Data" | "www.treasuredata.com/jp/press_release/20151202_iot_windmill_turbine_mitsubishiheavy" | "www.treasuredata.com/jp/press_release/20151202_iot_windmill_turbine_mitsubishiheavy" | "(not set)" | "(entrance)" | 1 |
| "2016-08-17 15:00:00 UTC" | "www.treasuredata.com/jp/press_release/20160621_nttdata_with_treasure_data_service" | "オープンソースのデータ収集基盤ソフトウェアの活用を推進し、 Hadoopソリューションを拡充" | "www.treasuredata.com/jp/press_release/20160621_nttdata_with_treasure_data_service" | "www.treasuredata.com/jp/press_release/20160621_nttdata_with_treasure_data_service" | "(not set)" | "(entrance)" | 1 |
+---------------------------+---------------------------------------------------------------------------------------+----------------------------------------------------------------------------+---------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment