Bulk Keyword Research For Local SEO & PPC

Author: Gab Goldenberg

Here’s a secret … I LOVE Aaron Wall’s Keyword List Generator Concatenator tool.

You take keywords, input them in a series of boxes, and it concatenates (glues) them together (with a space in between). If that sounds like gibberish, play with the tool. It’s super intuitive and you’ll be able to figure it out pretty easily.

In short, it’s a shortcut to building long keyword lists for exact or phrase matched ad groups.

Instead of typing out:

Adidas basketball shoes

Nike basketball shoes

Air Jordan basketball shoes

Kobe Bryant basketball shoes

point guard basketball shoes

You type out the modifiers in one group, with commas and no spaces: Adidas,Nike,Air Jordan,Kobe Bryant,point guard

And you type basketball shoes, once.

Then it sticks them together for you like with the list above. It can also add on quotation marks (” “) or square brackets ( [ ] ) for phrase or exact match purposes.

I was doing some of this myself in a local context and decided to save some time for the rest of you. Here’s a list of states, stuck together and only separated by commas, as you need them for Aaron’s tool. Note: I skipped the Marianas Islands (also some other islands I deleted, I think) and turned District of Columbia into Washington DC.

Alabama,Alaska,Arizona,Arkansas,California,Colorado,Connecticut,Delaware,Washington DC,Florida,Georgia,Guam,Hawaii,Idaho,Illinois,Indiana,Iowa,Kansas,Kentucky,Louisiana,Maine,Maryland,Massachusetts,Michigan,Minnesota,Mississippi,Missouri,Montana,Nebraska,Nevada,New Hampshire,New Jersey,New Mexico,New York,North Carolina,North Dakota,Ohio,Oklahoma,Oregon,Pennsylvania,Puerto Rico,Rhode Island,South Carolina,South Dakota,Tennessee,Texas,Utah,Vermont,Virginia,Virgin Islands,Washington,West Virginia,Wisconsin,Wyoming

If you liked this bit on keyword research , add my RSS feed to your reader.

Sidebar Story

Comments

  1. As an alternative, I've always found Keyword Expander a quick and useful tool for this sort of stuff.

    Comment by Tony McCreath - July 23, 2010 @ 11:46am

Leave a Reply