Since I’ve been away there’s been a few tools built using Google Docs using the importXML function, I’ve linked to some useful blog posts at the bottom of this post if your interested.
Anyway here’s a tool that I put together quickly that takes 25 key phrases, checks for serps that include review / ratings displayed. It’s useful if you needed to decide if implemented rating and review rich snippets would be a useful exercise, e.g. none of the serps have them = a good opportunity to be the only one. Or if certain key phrases had a low CTR you could see if the serps are saturated by rich snippets.
The rich snippets it looks for are the ones with star ratings such as the ones below.
It’s pretty simple to use.
Add up to 25 key phrases on the first sheet, rows B2 to B26.
That’s all you need to do, it grabs the top 10 results for each serp, and then looks for the div in the search results that contains the star ratings. The function in Google spreadsheet is,
You can change the search engine version and language etc by changing the query URL’s in column C in the first sheet.
Another sheet tots up the numbers with percentages. It looks for all reviews, reviews that contain ratings and reviews that contain price information (used for restaurants). I’ve stuck a couple of graphs in the last sheet to show totals.
This is in no way a completed tool, it most likely will break. Please feel free to use, copy, and improve. If you make any improvements leave a comment with a link to the file URL and I’ll repost with updated versions.
Just open the link below and make a copy to use.
Note : It’s limited to 25 key phrases as you have a maximum of 50 importxml calls, I used two for each key phrase.
Have a read of the posts below to find out more information about importxml, the links open in new tabs.