The first thing I want to talk about is something that came into my life during lockdown when I’ve been asking myself how to do things faster and more efficiently, Big Query.
If you’re working with a lot of data, it’s a great idea to get acquainted with BigQuery. BigQuery is part of Google’s cloud services. It’s all hosted in the cloud, which means it’s extremely fast and is perfect for working with huge datasets. If you’ve ever been stuck in Google Sheets, with it crashing due to the huge amounts of data, then BigQuery will change your reporting life forever. Who knows what you can achieve if you start to save that time you previously spent in Google Sheets.
BigQuery uses SQL, which stands for Structured Query Language. The great thing about SQL is that it’s quite human-oriented in terms of coding language. SQL can be complicated to learn, luckily, it’s well-resourced on the internet so there’s plenty of places you can practice or pick up tips. Big Query is very economical, around $5 per terabyte and you are given an allowance when you sign up for free on Google. The first million queries you’ll be running, (unless you work with ginormous datasets), will be cheap, if not free.
The other great thing about SQL is that it’s integrated with the programs that SEOs use, including Google Sheets, Google Data Studio, and Google Drive. If you have a massive data set you can upload it to Big Query’s cloud storage and use the data in all these tools and many more besides.