Forum Moderators: open
There is the overture search tool, googles ad words and a few commercial products wordtracker being the best known. I am of the opinion that all they will tell you is how often SEO's search for the keywords, which is not what you are looking for. I'd do a small PPC campaign and look for the best ratio of searchers to clicks.
Few days ago i took a dictonary word-list file of about 47,000 words and dumped it into an access database. I then wrote a front-end in visual basic that connected to the overture keyword suggestion tool, and had the program roll through the database, collecting the keyword suggestions. I then exported the results into an excel file.
you can download it here if you want:
www.orlandodigitalfreelance.com/keywords.zip
it is 8 megs zipped and about 28 megs unzipped. Later this week I am going to run other word-lists through it, like slang terms and technology terms.
The file is kinda interesting to browse through. I am open to comments on this little project of mine.
any way you can automatically see/sort out which keywords were tops number-wise within excel?
any automated download addition possible with the highest bidders ranked out?
(I'm not enough database geek enough to sort that out within excel)
It sure makes it easier to copy then from Overture itself.
I dunno how legit this is though...
I'll fiddle with it a little more later this week. i'll repost once i have sorting abilities intergrated into it.
-ed
