Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@martin-loetzsch

martin-loetzsch/server-side-tracking-bigquery-example-output.txt

Created April 15, 2020 14:37
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 martin-loetzsch/8c87b4e4f7a9e54645882e77f515b5d1 to your computer and use it in GitHub Desktop.
Save martin-loetzsch/8c87b4e4f7a9e54645882e77f515b5d1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
server-side-tracking-bigquery-example-output.txt
cat text/bigquery-example-query.sql | bq query --nouse_legacy_sql
Waiting on bqjob_r1213acb52d17011a_0000016cfc7967d0_1 ... (0s) Current status: DONE
+-----+------------------------------------------------------------------------------+
| n | url |
+-----+------------------------------------------------------------------------------+
| 109 | https://www.project-a.com/de/offline |
| 108 | https://www.project-a.com/en/offline |
| 93 | https://www.project-a.com/en |
| 36 | https://www.project-a.com/ |
| 34 | https://www.project-a.com/en/about-us/who-we-are |
| 29 | https://www.project-a.com/de |
| 21 | https://www.project-a.com/en/portfolio |
| 14 | https://www.project-a.com/en/about-us/expertise |
| 13 | https://www.project-a.com/en/media/press-releases |
| 9 | https://www.project-a.com/en/contact |
| 9 | https://www.project-a.com/career/recommend-friends |
| 7 | https://www.project-a.com/en/media/press-releases?offset=6 |
| 7 | https://www.project-a.com/de/ueber-uns/wer-wir-sind |
| 6 | https://www.project-a.com/en/media/press-releases?offset=138 |
| 6 | https://www.project-a.com/en/media/video |
| 6 | https://www.project-a.com/en/portfolio/natue |
| 6 | https://www.project-a.com/jobs/4082751002?gh_jid=4082751002&gh_src=bc4eeadd2 |
| 6 | https://www.project-a.com/en/portfolio/trendtours |
| 5 | https://www.project-a.com/en/portfolio/lampenwelt |
| 5 | https://www.project-a.com/en/portfolio/spryker-systems |
+-----+------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment