Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
+---------------------------+----------------------+----------------------+---------------+------------------+-----------------------+
| 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