Weekly Wisdom: Mining GSC – Using Query language to build powerful reports and gain instant insights

Learn about content strategy, SEO tips and more ► http://smr.sh/Kdv
Watch our latest video: How to Go Viral on Quora https://bit.ly/ViralOnQuora1
609

#WeeklyWisdom #GSC #QueryLanguage
For full transcript https://www.semrush.com/blog/weekly-wisdom-with-ross-tavendale-gsc-query-tutorial/

The great thing about using Google Sheets to do something called QUERY, which is kind of like a pseudo-SQL type of language, and I am gonna show you all the SEO tips and tricks I have got using QUERY inside of Google Sheets to make your data analysis life way, way easier.

So, I think we have all been in a position where we get a bunch of search console data in, and we can see our keywords, but the thing is when you get 5,000 keywords, it is kind of hard to actually work out what to do with this data.

Using a Table: How it Works

I mean, there are some obvious things, right? I mean, you could stick it in a table. That is relatively straightforward, so select the entire thing and stick it in a nice little filler table. And then we can know, you can start filtering through it, which is fine. You know, you have got filter by condition, so give me everything that is greater than 10,000 impressions, so I can see all the high-end stuff, and that will chop the data down.

Follow us on social media:

Facebook: https://bit.ly/2D1w7Nn
Twitter: https://bit.ly/3g8GMnI
LinkedIn: https://bit.ly/2XaiVfP

Subscribe to our YouTube channel! http://smr.sh/KdD
#semrush #seo #digitalmarketing #seotools

You May Also Like