The Grepwords API is a powerful, fast endpoint for keyword search volume collection.
For a long time, its output was for US and “global” search volumes only, but that all changed thanks to Russ and his team. Now we have search volumes from Google in around 32 countries. SEOgadget for Excel supports these new locations with just a simple change to your query syntax.
A quick primer on keyword research with Grepwords
Working with Grepwords and SEOgadget for Excel is easy – follow this introductory video for a quick primer:
What’s the change?
It’s a really simple addition to the same syntax you’re already using. There’s no need to update your installation, although I’d advise you to check and make sure you’re using the latest distribution (we’ve fixed some issues with Moz). You just add one of the country names listed in the 5th argument, just like this:
Or, if you’d like to fetch search volumes for a list of keywords in a range of cells:
Notice I’ve referred to a table called #grepwordslookup. Using the [#All] character at the beginning of the table name stops the table moving every time you refresh the formula. Handy.
Obviously, “canada” is but one location. Here’s the full list:
Enjoy having a little more flexibility in your keyword research! Remember, you can take a closer look at SEOgadget for Excel.