We use cookies. You have options. Cookies help us keep the site running smoothly and inform some of our advertising, but if you’d like to make adjustments, you can visit our Cookie Notice page for more information.
We’d like to use cookies on your device. Cookies help us keep the site running smoothly and inform some of our advertising, but how we use them is entirely up to you. Accept our recommended settings or customise them to your wishes.
×

Linking Google Analytics and BigQuery Just Became Simple

Another large announcement has just been made by Google only an hour ago which will revolutionise the way we link Google Analytics and Big Query.

You can now link the two yourself to enable regular data exports of your Google Analytics data to Big Query.

See this guide for more information about GA data exports into Big Query: https://support.google.com/analytics/answer/3437618?hl=en

Note this feature is only available for Google Analytics Premium customers!

Previously, linking Google Analytics and Big Query could only be done after lots of manual back and forth with your GAP representative or agency which took weeks in some cases to set up.

Allowing users to manage these links in the Google Analytics Admin console themselves smooths out and considerably speeds up the process of exporting your GA data to Big Query.

Follow the below steps to link the two platforms and you should start to see data being exported the following day!

Prerequisites:

Before you start you’ll need to set up a Google Developers Console project: https://console.developers.google.com/

… and enable billing:

https://support.google.com/cloud/answer/6288653?hl=en

Finally, ensure that the BigQuery API is enabled for your project in your API manager in the Developer’s Console. If not, add it in the Google APIs tab also shown below:

1

Next up – Linking GA views to Big Query:

Start by logging into GA and navigating to the Admin console (link at the top of the page).

Go to the ‘All Products’ link under your selected Web Property:

2

Scroll down to BigQuery and select ‘Link BigQuery’:

3

In the wizard, enter your project ID / Number from the Developer’s Console:

4

Next choose a view that will be exported to BigQuery, check the terms and Submit:

5

Note that you can only link one view for each Web Property so choose wisely!

If successful you should see the following confirmation message under the wizard:

confirmation screenshot

Managing the link:

Once linked up you can edit or remove any links through the All Products menu via the Adjust Link button:

edit button in all products

That’s it! Please contact us if you have any questions.

Useful Links:

Google Developers console:

https://console.developers.google.com/

Big Query Web UI:

https://bigquery.cloud.google.com/

Introduction to BQ:

https://cloud.google.com/bigquery/what-is-bigquery

Details on GAP data export:

https://support.google.com/analytics/answer/3437618?hl=en

Join the Discussion