The first step to doing any Search Engine Optimization (SEO) or Pay-Per-Click (PPC) advertising is to have a keyword list of the targets you are going to go after. Generating a long list that combines different commonly used phrases can be difficult so that is why I was pretty happy when I found this keyword variation generator for excel.
It is fairly easy to use. All you have to do is come up with a list of prefixs then a list of keywords. The spreadsheet then gives you all of the different combinations for the two.
So let’s say you have an e-commerce store that sells dog supplies. Your keyword list might look something like this:
Prefixes: Blue, Red, Holiday, Yellow, Black, White
Keywords: Collars, Leashes, Clothes, Placemats
The spreadsheet would then combine the two, giving you 24 different keyword variations.
This isn’t a perfect solution, since some of your keywords might use certain prefixes and others note. In our example if you are selling carriers, treats, or food then having those prefixes might not give you the best combination to go for.
After you have your keyword list, you can then start targeting these combinations with your SEO efforts, or if you do PPC advertising then you have a nice list of keywords to start testing and tracking.