Google Sheets to BigQuery Connector (for GA + GSC)
If you’re running more than one site, handling all of your Google Analytics and Search Console data in Google Sheets can quickly get out of hand.
Enter BigQuery, the analytics warehouse from Google.
This template allows you to push data from Sheets up to BigQuery – allowing you to do far more complex analysis than you could ever do in Sheets.
How it works?
It comes out of the box with BigQuery tables setup for Google Analytics and Search Console, using Supermetrics to pull raw data – but you can just as easily configure any data source to push to BigQuery.
Keep this template handy for when you reach the end of the spreadsheet…