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.
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 postapocalyptic 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.
