DIGITAL SOP 032: Generate an automated search query report

Last Updated / Reviewed: March 25th, 2024

Execution Time: 15-20 minutes

Goal: To automate your search query report using Google Sheets.

Ideal Outcome: You will be able to automatically export Search Console data into a Google Sheet which is easier to analyze and allows you to backup your data beyond 90 days.

Pre-requisites or requirements:

• You need to have the Google Search Console set up for your site. If you don’t have it, firstly check out this SOP to learn how to do it properly.

Why this is important: With Google Analytics turning evil and not showing search query data anymore, SEO managers everywhere have almost watched the apocalypse happen. The good news is that there is a safe bunker – Google Search Console. The bad news is that it doesn’t have electricity and you get kicked outside into the post-apocalyptic world after 90 days – meaning that Google Search Console is bad for data analysis and only includes 90 days of data. So it’s time to upgrade your bunker and this SOP will teach you just that.

Where this is done: Google Sheets & Search Analytics for Sheets add-on.

When this is done: You will only do this once, when you create this report. After that you will automatically get search data every month into your report.

Who does this: You or your SEO specialist do it. And your electrician 🙂