Hey everyone!
For those of you who have checked out our 2016 Local SEO Ranking Factors study, and if you haven’t now is a great time to, then you know that here at Local SEO Guide that we look at a grouping of 3 keywords to represent most local queries. For example, if the client is a dentist in Costa Mesa it would look something like this:
dentist
dentist costa mesa
costa mesa dentist
And for those of you that have had to localize top level keywords before you know what a huge, time consuming and manual PITA it can be. Well not anymore!
Local Keyword Generator
In order to streamline this process I developed a Google Sheet’s script that can take a couple of inputs (city and keyword list) and generate a localized set of keywords. I like to call it…
This tool is really simple to use:
- Make a copy of the sheet for you to use yourself (don’t ask me for edit access, I’m not going to give it to you)
- Put the city you want to localize for (or zip code) in cell A4
- Put the keywords you want to localize in A10+
- Click the “Generate Keywords” button
- Check the new tab that has the localized versions of all your keywords
Simple enough right? Now you can spend time doing keyword research instead of localizing your keywords lists!
12 Response Comments
Well, isn’t that nifty! Thanks for creating this guys. Worthy of sharing.
Thanks Miram!
Great idea guys! This is a nice time saver. What other google sheet/spreadsheet ideas do you have in the works?
Stuff, and things! 😉
Dan…the generate button says I need permission?!? Can’t I just tell it that I know you and such?
Nice job though. You are a saint.
Rule #1 Gerry 😉
“Make a copy of the sheet for you to use yourself (don’t ask me for edit access, I’m not going to give it to you)”
Cool little tool. Thanks for sharing! Copied and saved to my Drive.
Glad you dig it Ben!
Sweet! That is really useful. Thanks Ben!
Hi Dan,
I made a cope of the sheet. However, when I insert keywords and city’s and click the Generate keywords script it displays this – Script function generateKeywords could not be found.
Downloaded the spreadsheet but it doesn’t work… the ‘Generate’ button seems to be disabled…
Sorry – sorted! Great tool 🙂