I have made more than 50 keyword reports for industries with more than 40 000 keywords used by searchers and designed the keyword tool at Keeyword.com.
This is how I make a seed list and how you can do it to.
Imagine you are a farmer and it is time to sow your seeds in your field. Your biggest concern is to make an equal distribution of the seed so they can grow into healthy planets and thereby give you a big yield.
It is the same concerns you should have when you make a seed list for your keyword report. Make sure you get around the subject and get keywords that cover different segments and routes potential customers might take. Don’t worry about getting all keywords, they will be found in the next phase.
There are several short cut solutions that might work faster, but they all have the drawbacks that they are bad at finding the difficult to find niches. If they are difficult to find you are very likely to have them for yourself.
I will go though the most efficient methods. Don’t worry if you don’t have an establish website to get keywords ideas from; brainstorming and lists will do the trick.
Let’s say you want to make a keyword report for Keeyword.com. You want to find the keywords searchers that are interesting in a keyword tool would use.
First step is always brainstorming. Use 1- 10 minutes to write down what you think customers will use to search for your product/service in Google (don’t use more time, it is just to get your brain started).
In our example I will suggest:
The direct keywords:
keyword suggestion tool
Keyword sorting tool
Problem solving keywords:
Google add words
keyword to Adwords
how to rank in Google
It is important that you just let your fantasy go and don’t try to control the process to much. You can always delete words later.
To save you brainstorm list and keep you Seed list organized, I recommend you make a new project in the keyword tool. I would save it as good keywords if you are almost sure all are good keywords and unsorted if your fantasy went all the way to Alice in Wonderland.
When you finish sorting and revising the keywords, you found though brainstorming, you are ready to go to the next face.
I recommend you to start right away.
Keywords from Analytics
If you are making a seed list for an established website you might want to head to the site analytics. There are many different analytics, but the most popular is Google Analytics. If you use another then just try to download a list of keywords that people use when they find your site in the search engines.
Open Google Analytics and go to the relevant account. Click on “Traffic Sources” => and then “Organic”. In the bottom you choose to show 500 rows. Go to the top and click on Export and choose TSV for Excel. Save the files in an empty folder. Click next and save the next file. It can take some time if you have a big site. Open all the files in excel and copy only the keywords (500 each time) into a Notepad document.
You can also use Google Webmaster tool (less keywords), you server analytic or another way to find the keywords people use to find your website.
When you are finish I suggest you start to sort the list in the keyword tool. Upload the Notepad keyword list as unsorted keywords. Finish to sort and revise before continuing.
The keywords that people use for internal search on your website can be a goldmine. Not only do they tell you what they are looking for, but also provide you with what they didn’t find in search engines (How to track site search in Google Analytics). You download the internally search keywords the same way as the keywords coming from the search engines (described just above) by going to Content => Site Search => Search Terms.
If you start without an established site, your best bid is to find a big keyword list. If you have access to an established site this is a chance to uncover new demands in the market.
You start by creating a list of no more than the 10 most important keywords within you industry. If you are in doubt use one of these methods.
Go to Google’s external Keyword Tool write what you think is the most important keywords and search. Sort the keywords after Global Monthly Searches. Try a few times with different keyword before you decided on the best keywords.
Your goal is to find the words that are used in connections with dictionaries and other list within the subject of your keyword report.
Time to search the Internet for keyword lists
You are looking for big lists about your subject. Many times you find you industry specified lists in connection with glossary’s and dictionaries.
Start by searching in ex. Google for: keyword + dictionary
If we are making a seed list for Car dealer, we might search in Google for: Car Dictionary
Other words you can add is: Glossary, List, Dictionary, Terms, List all, Terminology, Jargon, Word list, A-Z list, Official records, Records, Listing, Directory…
Combined with your top 10 keywords it gives you 130 combinations. You don’t need to go though them all, but try to look around to find some good lists. The best lists are big, cover the whole subject and are easy to copy paste into your notepad.
These kinds of lists are very difficult to find, so if you find an easy to copy list, when download it right away. Most of the lists are either small or difficult to download.
It is not a problem if the list is broader than your subject. You just need to sort the keywords that doesn’t belong and these keywords are very likely to be generated anyway later in the process. Therefore it might be time saving to sort a broad seed keyword list in the keyword tool.
Cleaning of difficult to download lists
Sometimes it can create problems when you try to copy/paste keywords lists. I use a combination of Excel and Notepad when I try to get lists that are polluted into a one keyword per line format.
First I try to copy and paste into Notepad to see how it looks. If it looks clean I go ahead and import it into the keyword tool. If there are many extra signs I try to see if I can find a method to separate the keywords.