"concatenating keywords"

[alfo]

Hi

Could someone either point me in the right direction or explain the method of "concatenating keywords"/using excel to help grow your keyword list.

Taken from - http://www.seroundtable.com/archives/003401.html (about 1/2 way down).

How to use Excel to create long lists. Describes the process of “concatenating.” This is a system (which I use and love, btw) that combines columns in excel in order to help you grow your keyword list.

Thanks for such a rich source of info.
alfo

[Chris Boggs]

Hi Alfo,

There are many paid tutorials out there about concatenation. I can't seem to find a good one right away that is free, but I don't have much time. Here is a very basic overview for creating keyword lists using this process.

Essentially, you put your keyword in Row 1, Column A, and then put a modifier (such as a city or brand name, for exmaple) in Column B. Column C would then use the following command in the cell, in order to concatenate (join) A and B, with a space in between the words:

=CONCATENATE(A1," ",B1)

If you want to use the modifier before the keyword, switch it to:

=CONCATENATE(B1," ",A1)

You can then go onto other modifiers in other columns and substitute "B" above for which ever Column it's in. You could also add more than one modifier as follows (notice there is always a "space" between the keywords):

=CONCATENATE(A1," ",B1," ",Z1)

In order to do more keywords, simply copy down the modifier columns and the concatenation commands. Another way of doing this uses more symbols in the command but allows you to always copy one cell, so you don't have to copy down the modifiers. Once you have all your combinations, you can simply copy and paste the resulting columns into your keyword research software. Don't forget to research the original column as well!

As I said, this is only a basic view, and it may be best to invest in a real concatenation tutorial in order to use many more features. For example, this tool is a great way to build tracking URL's for PPC keyword campaigns if you use the proper commands.

[alfo]

Hi Chris

Many thanks for your very clear and concise reply, which is really going to help.

Is there a name in seo/url you could recommend for paid keyword tutorials? A recommendation might save me wasting time/money. Unfortunately I can't afford Dan's course at the moment. But may be if there was a less comprehensive, tutorial style course it might be closer to my budget at present.

Any ideas would really be most welcome.

Once again many thanks
alfo

[gabs]

Must things are free if you know where to look and if you get suck that what these and many other forums are about :)

A good starting point is:

http://www.seomoz.org/beginners.php


Good luck :)

[Chris Boggs]

You are welcome, alfo. As Gabs says, there is a plethora of information available on the Internet. You can't go wrong with anything at the SEOMoz site, and Search Engine Watch has a deep section about Paid Search. Don't forget the category archive (http://www.seroundtable.com/archives.html#category) at Roundtable. If you spend a lot of time reading, and practice things you start to see commonly mentioned, your skills will increase accordingly. There will be no substitute for self-training. I recommend that you not bite off more than you can chew. Also, if you have just $69 dollars to spend, buy Andrew Goodman's book (http://www.page-zero.com/google-adwords-book.asp).

[cessai]

thanks for the information given here.. another important things to be noted :)

[hiredesigner]

Hi Alfo,
Thanx for giving me this new concept. I really dont know about this. I will surely try it and let you know my experience.

[Thomas Schulz]

Alternative you can just use a SEO tool to do it. Use tumblers (concatenate different lists), permutations, missing space / letter, switched letter etc.