Dominic Woodman says, “What do you do when Excel fails? Maybe you have more than a millions row of data. Perhaps you’ve tried to filter a large dataset with a VLOOKUP and Excel has decided to lay down and die. Excel is a fantastic tool, but that doesn’t mean it’s what we should use for everything.

What should you use?

The traditional answer is SQL, but setting up a SQL server if you haven’t done it and you’re not technical is a challenge. The free interfaces for working with it are typically very visually busy and not intuitive for those looking to get started quickly.

Enter BigQuery.

What is BigQuery?

Google’s blurb describes it as:

“A fast, economical and fully managed data warehouse for large-scale data analytics.”

If we make that a little more specific, we get:

It’s a SQL(esque) database which you can put data into and run queries on. It will work regardless of the size of your data”.

How to Use BigQuery for Large-Scale SEO (Or Whenever Excel Fails)

MOZ

Sharing is caring