Our Google Drive add-on now connects to BigQuery, Google’s tool for analyzing large datasets. This is especially useful for Google Analytics Premium users, who can export their raw GA session data into BigQuery, can now easily analyze it using the Supermetrics in Google Sheets. This allows for much more complex analysis than using the Google Analytics API.
To get started, simply choose BigQuery from our add-on’s Data source tab. After logging in, you can select a dataset and start typing SQL. To help you write queries, we display a list of your tables and columns in each table.
If you don’t have it already, you can get our Google Drive add-on here. The BigQuery connector will require the Pro version of the add-on, but everyone can test it for free for now. For Excel users, we offer a BigQuery connector in Supermetrics Functions.