doryokujin doryokujin
doryokujin
/ dc_client_id.yml
Last active
August 27, 2016 00:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| in: | |
| type: google_analytics | |
| json_key_content: | | |
| { | |
| // omit | |
| } | |
| view_id: ***** | |
| start_time: "2001-01-01" | |
| end_time: "2016-09-01" | |
| time_series: "ga:dateHour" |
doryokujin
/ client_id_js.js
Last active
August 26, 2016 06:57
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <script> | |
| (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ | |
| (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), | |
| m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) | |
| })(window,document,'script','https://www.google-analytics.com/analytics.js','ga'); | |
| ga('create', 'UA-XXXXXX-XX', 'auto'); | |
| // get client id | |
| ga(function(tracker) { |
doryokujin
/ 30dayUsers.sql
Last active
August 26, 2016 04:37
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| +---------------------------+-----------------+----------------+----------------+ | |
| | date:timestamp | 1day_users:long | pageviews:long | view_id:string | | |
| +---------------------------+-----------------+----------------+----------------+ | |
| | "2016-08-18 07:00:00 UTC" | 5279 | 27240 | "104634715" | | |
| | "2016-08-19 07:00:00 UTC" | 4313 | 17425 | "104634715" | | |
| | "2016-08-20 07:00:00 UTC" | 3196 | 8372 | "104634715" | | |
| | "2016-08-21 07:00:00 UTC" | 4224 | 17468 | "104634715" | | |
| | "2016-08-22 07:00:00 UTC" | 5604 | 30809 | "104634715" | | |
| | "2016-08-23 07:00:00 UTC" | 5512 | 29494 | "104634715" | | |
| | "2016-08-24 07:00:00 UTC" | 5241 | 28102 | "104634715" | |
doryokujin
/ 30dayUsers.yml
Last active
August 26, 2016 04:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| time_series: "ga:date" | |
| dimensions: | |
| metrics: | |
| - "ga:30dayUsers" | |
| - "ga:pageviews" | |
| out: |
doryokujin
/ page_path_level.sql
Created
August 26, 2016 04:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| +---------------------------+----------------------------------------------------+-----------------------------+-------------------------+-------------------------+-------------------------+----------------+----------------+ | |
| | date_hour:timestamp | page_path:string | page_path_level1:string | page_path_level2:string | page_path_level3:string | page_path_level4:string | pageviews:long | view_id:string | | |
| +---------------------------+----------------------------------------------------+-----------------------------+-------------------------+-------------------------+-------------------------+----------------+----------------+ | |
| | "2016-08-18 07:00:00 UTC" | "auth.treasuredata.com/users/password/new" | "auth.treasuredata.com/" | "/users/" | "/password/" | "/new" | 4 | "104634715" | | |
| | "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/archive/category/query" | "blog-jp.treasuredata.com/" | "/archive/" |
doryokujin
/ geo_dimensions.sql
Created
August 25, 2016 05:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| +---------------------------+----------------+--------------------+--------------+-------------+-----------------+------------------+----------------+ | |
| | date_hour:timestamp | country:string | region:string | metro:string | city:string | latitude:string | longitude:string | pageviews:long | | |
| +---------------------------+----------------+--------------------+--------------+-------------+-----------------+------------------+----------------+ | |
| | "2016-08-17 15:00:00 UTC" | "Japan" | "Aichi Prefecture" | "(not set)" | "Nagoya" | "35.1814" | "136.9064" | 2 | | |
| | "2016-08-17 15:00:00 UTC" | "Japan" | "Nara Prefecture" | "(not set)" | "Tenri" | "34.5966" | "135.8373" | 1 | | |
| | "2016-08-17 15:00:00 UTC" | "Japan" | "Osaka Prefecture" | "(not set)" | "Osaka" | "34.6937" | "135.5022" | 1 | | |
| | "2016-08-17 15:00:00 UTC" | "Japan" | "Tokyo" | "(not set)" | "Minato" | "35.6581" | "13 |
doryokujin
/ geo_dimensions.yml
Created
August 25, 2016 05:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dimensions: | |
| - "ga:country" | |
| - "ga:region" | |
| - "ga:metro" | |
| - "ga:city" | |
| - "ga:latitude" | |
| - "ga:longitude" | |
| metrics: | |
| - "ga:pageviews" |
doryokujin
/ system_dimensions.yml
Created
August 25, 2016 05:48
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dimensions: | |
| - "ga:browser" | |
| - "ga:browserVersion" | |
| - "ga:operatingSystem" | |
| - "ga:operatingSystemVersion" | |
| - "ga:mobileDeviceBranding" | |
| - "ga:mobileDeviceInfo" | |
| metrics: | |
| - "ga:pageviews" |
doryokujin
/ system_dimensions.sql
Created
August 25, 2016 05:46
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| +---------------------------+----------------+------------------------+-------------------------+---------------------------------+-------------------------------+---------------------------------+----------------+ | |
| | date_hour:timestamp | browser:string | browser_version:string | operating_system:string | operating_system_version:string | mobile_device_branding:string | mobile_device_info:string | pageviews:long | | |
| +---------------------------+----------------+------------------------+-------------------------+---------------------------------+-------------------------------+---------------------------------+----------------+ | |
| | "2016-08-17 15:00:00 UTC" | "Chrome" | "51.0.2704.81" | "Android" | "5.0.2" | "Sony" | "Sony SO-02G Xperia Z3 Compact" | 2 | | |
| | "2016-08-17 15:00:00 UTC" | "Chrome" | "52.0.2743.98" | "Android" | "5.0" | "Asus" | |
doryokujin
/ traffic_sources_dimensions.yml
Created
August 25, 2016 05:42
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dimensions: | |
| - "ga:referralPath" | |
| - "ga:fullReferrer" | |
| - "ga:source" | |
| - "ga:keyword" | |
| metrics: | |
| - "ga:organicSearches" |