Google Sheets to BigQuery Connector (for GA + GSC)

By David Krevitt from CIFL

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.

Subscribe to RankTank Pro!
Step 1:
Step 2:
Get the Pro Sheet SEO tool!
Subscribe and get access to this Google Sheet as well as many other Pro Sheet SEO tools!

Current Version: 1

Not sure where to start your keyword research?

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…

10 Million Marketers Can't Be Wrong!

When you join the RankTank mailing list, you'll be better than 9.9 million of them. You'll also get first access to cool new tools, tutorials and other neat stuff.

SPAM? Naw. Ain't nobody got time for that.