Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/connector_preview2.sql

Last active August 19, 2016 06:26
Show Gist options
  • Save doryokujin/a7fc92b3ed56b242fad6736e09e0504e to your computer and use it in GitHub Desktop.
Save doryokujin/a7fc92b3ed56b242fad6736e09e0504e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
connector_preview2.sql
$ td connector:preview config.yml
+---------------------------+-------------------+------------------+-------------+----------------+-----------------------+
| date_hour:timestamp | browser:string | keyword:string | visits:long | pageviews:long | organic_searches:long |
+---------------------------+-------------------+------------------+-------------+----------------+-----------------------+
| "2016-08-11 15:00:00 UTC" | "Chrome" | "(not provided)" | 1 | 3 | 1 |
| "2016-08-11 15:00:00 UTC" | "Chrome" | "(not set)" | 2 | 3 | 0 |
| "2016-08-11 15:00:00 UTC" | "Firefox" | "(not provided)" | 1 | 3 | 1 |
| "2016-08-11 15:00:00 UTC" | "Safari (in-app)" | "(not set)" | 1 | 1 | 0 |
| "2016-08-11 16:00:00 UTC" | "Chrome" | "(not set)" | 2 | 2 | 0 |
| "2016-08-11 17:00:00 UTC" | "Chrome" | "(not provided)" | 1 | 1 | 1 |
| "2016-08-11 17:00:00 UTC" | "Chrome" | "(not set)" | 1 | 1 | 0 |
| "2016-08-11 17:00:00 UTC" | "Safari" | "(not set)" | 1 | 1 | 0 |
| "2016-08-11 18:00:00 UTC" | "Chrome" | "(not set)" | 1 | 1 | 0 |
| "2016-08-11 19:00:00 UTC" | "Chrome" | "(not set)" | 1 | 1 | 0 |
+---------------------------+-------------------+------------------+-------------+----------------+-----------------------+
10 rows in set
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment