I want to be really clear, this isn’t new news. In fact, it’s actually quite old news. But, recently I was sat at my desk wishing I could examine my search query reports in a little more detail. I was thinking to myself, “surely there’s a better way to uncover trends in this data?”.
So, I started to play around in Excel to look for ways to separate each search query into individual terms to examine how that data looked. My Excel didn’t handle this request across thousands of keywords very well, so I quickly moved to Bing to search for an easier solution.
That’s when I stumbled across a script from 2015(!!) and realised I had missed out on a whole load of juicy data goodness over the last few years.
This script did exactly what I was looking for. I just had to copy and paste it into my account, tweak a few options, and then it automatically pulled my search query data into a specified Google Doc. The exciting bit here is that it allows you to separate out and report on performance stats for each individual term in a query, rather than each full search query, as you would find in your standard search query reports.
Three reasons why I’m so excited about this
So, if you’re interested in looking at your search queries from another angle – head to this article to access the script for yourself.