• Author
  • Testimonials
  • Contact
Dmitri Ilin
Digital Analytics Tips
Menu Close
  • Home
  • Tag Manager
  • Google Analytics
  • Google Bigquery

Google Sheets

Export query results data from Bigquery to Google Sheets

November 7, 2017Dmitri Ilin Leave a Comment

This post will contain a simple JS function helping you to export data from Bigquery to Sheets. In fact, we’re going to export a resulting table after querying our GBQ tables. We’re going to need Google Bigquery API and Apps Script….

Google Bigquery, Google Cloud Platform, Google Sheets apps script, bigquery api, javascript, sql

Upcoming talks

Contact me

  • Latest
  • Popular
  • Tags
  • raw-data-export-google-analytics-google-bigquery-cpd-main

    Export data from Google Analytics to Google Bigquery

    10 Comments
  • encrypt-personally-identifiable-information-using-google-tag-manager-fields-main-min

    Encrypt users’ personally identifiable information using Google Tag Manager

    4 Comments
  • track-pop-up-conversions-google-analytics-google-tag-manager-main-min

    Track pop-up conversions in Google Analytics via Google Tag Manager

    4 Comments
  • send-analytics-hits-to-3rd-party-services-using-tag-manager-main

    Send Google Analytics hits to 3rd party services using Google Tag Manager

    1 Comment
  • GTM datalayer sifter - main pic

    Use GTM dataLayer sifter for retrieving DOM elements’ values

    1 Comment
  • use google tag manager to track twitter conversions

    Set up Twitter conversion tracking via Google Tag Manager

    1 Comment
  • use google tag manager for scroll tracking

    Use scroll depth as trigger in Google Tag Manager

    1 Comment
  • use google tag manager for yandex metrica mainpic

    Use Google Tag Manager for Yandex.Metrica: hitCallback for reachGoal method

    No Comments
  • Track users’ interaction with YouTube videos using Google Tag Manager

    No Comments
  • 3 custom variables for working with cookies and Web Storage API in Google Tag Manager

    No Comments
  • Export query results data from Bigquery to Google Sheets

    November 07, 2017
  • encrypt-personally-identifiable-information-using-google-tag-manager-fields-main-min

    Encrypt users’ personally identifiable information using Google Tag Manager

    October 07, 2017
  • make-marketing-plans-with-ga-data-and-math

    Plain math to make a forecast for a marketing plan based on Google Analytics data

    September 21, 2017
  • Track users’ interaction with YouTube videos using Google Tag Manager

    September 17, 2017
  • use google tag manager for yandex metrica mainpic

    Use Google Tag Manager for Yandex.Metrica: hitCallback for reachGoal method

    September 09, 2017
  • 3 custom variables for working with cookies and Web Storage API in Google Tag Manager

    August 12, 2017
  • raw-data-export-google-analytics-google-bigquery-cpd-main

    Export data from Google Analytics to Google Bigquery

    August 05, 2017
  • Manage query parameters in GTM (like UTM) with these simple functions

    Manage query parameters in GTM (like UTM) with these simple functions

    July 29, 2017
  • send-facebook-events-through-google-tag-manager-postbanner

    One function to rule them all: easily send events to Facebook through Google Tag Manager

    July 01, 2017
  • send-analytics-hits-to-3rd-party-services-using-tag-manager-main

    Send Google Analytics hits to 3rd party services using Google Tag Manager

    June 25, 2017
google tag manager google analytics javascript API google bigquery optimizely GTM container snippet GTM implementation Conversion tracking Website Chat Twitter google optimize GTM AB test new gtm user interface google tag manager container snippet code placement pop-up conversions workspaces scroll depth tracking Google Tag Manager Weebly GTM code placement gtm scroll tracking pop-up site search pop-up impression duration modal window FOOC GTM datalayer sifter google sheets moving average least squares youtube JS API CryptoJS javascript encryption sql bigquery api apps script password aes Yandex Metrica session storage query parameters Enhanced e-commerce Facebook events hit payload Facebook pixel utm parameters big data cookies local storage data export cloud platform python bigquery sql

Comments

  • TaniaSteenkamp on Set up Twitter conversion tracking via Google Tag Managerhi dimitri, in your screengrab of where to find the pixel id I can see you have a number of events a…
  • Eugene on Track pop-up conversions in Google Analytics via Google Tag ManagerDmitri, thanks for the insightful post! The first picture contains a question asking "where exactly…
  • Sasha Poda on Send Google Analytics hits to 3rd party services using Google Tag ManagerДобавил custom dimention под индексом 1, со значением clientid https://prnt.sc/hcv36g. Правильно ли…
  • Matthew Miao on Track pop-up conversions in Google Analytics via Google Tag Managerlooking foward your updates
  • Tracy Glastrong on Use GTM dataLayer sifter for retrieving DOM elements’ valuesVery impressive blog. Interesting article right on the subject.
  • Dmitri Ilin on Export data from Google Analytics to Google BigqueryHi Ivan! Glad the post was of help. Keep GBQ-ing!
  • Ivan on Export data from Google Analytics to Google BigqueryВсё, теперь пошли данные! ) благодарю за статью, проблема была в названии переменной GTM, нужно было…
  • Ivan on Export data from Google Analytics to Google BigqueryДмитрий, спрошу ещё раз :) Получаю следущие ошибки: ***.appspot.com/collect?undefined&cd1=664932…
  • Dmitri Ilin on Encrypt users’ personally identifiable information using Google Tag ManagerYes, Sublime is my everyday tool. Besides that I'd recommend leveraging Visual Studio Code. It's mor…
  • Marco Porracin Dieguez on Encrypt users’ personally identifiable information using Google Tag ManagerI would like to know what IDE do u use for writing GTM to GBQ? I think sublime its starting to fall…

Sing up for my newsletter

Author

Read more about author
© 2017 Dmitri Ilin. Who cares about rights reservation