Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/traffic_sources_dimensions.sql

Created August 25, 2016 05:41
Show Gist options
  • Save doryokujin/3cef94127073aadb53753af2812d9f3c to your computer and use it in GitHub Desktop.
Save doryokujin/3cef94127073aadb53753af2812d9f3c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
traffic_sources_dimensions.sql
+---------------------------+----------------------+----------------------+---------------+------------------+-----------------------+
| date_hour:timestamp | referral_path:string | full_referrer:string | source:string | keyword:string | organic_searches:long |
+---------------------------+----------------------+----------------------+---------------+------------------+-----------------------+
| "2016-08-17 15:00:00 UTC" | "(not set)" | "google" | "google" | "(not provided)" | 1 |
| "2016-08-17 15:00:00 UTC" | "(not set)" | "yahoo" | "yahoo" | "三菱重工iot" | 1 |
| "2016-08-17 16:00:00 UTC" | "(not set)" | "google" | "google" | "(not provided)" | 4 |
| "2016-08-17 17:00:00 UTC" | "(not set)" | "google" | "google" | "(not provided)" | 2 |
| "2016-08-17 22:00:00 UTC" | "(not set)" | "google" | "google" | "(not provided)" | 2 |
| "2016-08-17 23:00:00 UTC" | "(not set)" | "google" | "google" | "(not provided)" | 3 |
| "2016-08-18 00:00:00 UTC" | "(not set)" | "google" | "google" | "(not provided)" | 7 |
| "2016-08-18 01:00:00 UTC" | "(not set)" | "bing" | "bing" | "(not provided)" | 1 |
| "2016-08-18 01:00:00 UTC" | "(not set)" | "google" | "google" | "(not provided)" | 12 |
| "2016-08-18 01:00:00 UTC" | "(not set)" | "yahoo" | "yahoo" | "treasuredata" | 1 |
+---------------------------+----------------------+----------------------+---------------+------------------+-----------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment