How to do geo research for keyword phrases?

[mikecorso]

I'm working on a landing page for a client (music instrument rentals) and want to optimize for terms related to:

• music instrument rentals in San Francisco
• music instrument rentals in Seattle
• music instrument rentals in  St. Louis
• music instrument rentals in Minneapolis/St. Paul

How can I find the most popular terms based on a variation of the main term (music instrument rentals) and geo area? In other words, maybe 'Where to get Instrument rentals in San Francisco' is best?

Thanks for your input!

Mike Corso

[Syed1]

I tried finding a tool that would automate it for me sometime ago but didn't find it so I simply used excel.

I took a list of all major US states and cities and imported to one row. On the right row I used keyword that I wanted to combine with the geo term. Copy pasted both rows (geo+keyword) to get search count.  It took me 20 mins to do it all.

Also, if you select 'broad search' for  "music instrument rentals San Francisco" while finding the search count. you will get other search queries as well, like the one you mentioned:"Where to get Instrument rentals in San Francisco" + several other combinations