So you are doing SEO but hate searching for good keywords..

[erots]

I bet many of you are searching for good keywords that don't have that much competition. It can be tedious task when you use overture to take a keyword and enter it to google to see how many sites there are with that keyword. So here's something to make your life easier.

So I made a little script called ostanalyzer(I really have no idea what I meant with that). So first you go to Overture. You enter some keyword, in my example "pancakes". You get the results and select them like on this screenshot.

Now you go directory where ostanalyzer is located at, make a text file and paste those results in that text file like on this screenshot.

Now you give that text file some nice simple name like pancakes.txt and click on the ostanalyzer.pl to start it. It will ask you filename, this is where you enter pancakes.txt. Screenshot.

Now the script starts proccessing the results, it can take lot of time, totally depends on how many results you copied. Right now this script waits 5-10 seconds between every search, to not spam Google. It can be increased simply by editing this script.. well shouldn't be very hard, but if it is I can make it easier by making script ask the sleep time interval every time it executes. Anyway... that proccessing should look like it is on this screenshot. Oh look at that, bunch of cool numbers

Anyway, after script has finished you get a result file. In this case it will be pancakes.txt.results. You click on it and open it with wordpad or notepad. And you get list like this.

So what do those numbers mean. Well first number is overture searches/google results. I called it index, don't actually know what I should call it, but this seemed like right word for it... anyway. Second number is popularity, which is the overture searches number. Third number, Competition, is Google results. And well keyword is keyword :-) Results are ordered according to index number. So searches that have less competition come first.

Script can be found here.

This is a Perl script so if you don't have Perl in your computer then you need to install it. You can get ActivePerl here.

Link to download can be found on left menu. Select MSI package as AS package does not have uninstaller. If you have Windows 9x/Me or NT, then you also need Windows Installer 2.0+, which can also be downloaded from the same page.

I hope this script is helpful. Cheers.

[erots]

You got your keywords in order. Now what?

When I first started doing SEO I thought that when you have search terms like "cork flippin like like pancake poppin," then when you use it in exacly this order, then you will most definately list as first with this search term. Well it isn't actually like that.

Google hates micro niche people some times. You search for mature cock sucking tranny in pantyhose and it gives you gay black men. Not very nice, isn't it? When you add "", you have to construct your search term very carefully, as single misplacement can show you no results at all.

What does it mean? It means that search term "cork flippin like like pancake poppin," isn't much stronger than "Flippin' like a pancake, poppin' like a cork," at all, it won't make that much difference. So you are pretty much free to put your keywords in any way you like. Try to keep them close though. Also you can optimize pages pointing to the page you are going to optimize with similar keywords, this will give you extra revelence.

Now lets open that result file we got from our script. We see that "cork flippin like like pancake poppin", doesn't have much competition at all. So lets choose some good keywords from the list. I chose:

cork flippin like like pancake poppin
pancake maker
scotch pancake recipe
basic pancake recipe


Now you should repeat them at most 3 times in your text. And they don't have to be exacly in the same order. If your keyword density is over 7%, then it is too much. This web tool can be used to check it. Actually this tool will probably show you that your pancake count is too high(*grin*).

Thing is, it counts every word seperately. And actually google also does this. This is why you get strange search queries coming to your site time to time. So the right optimization proccess should actually involve breaking your search terms to keywords like this:

cork
flippin
like
pancake
poppin
maker
scotch
recipe
basic

Now you still remember those full queries and try to use those terms if you can. But in this case, pancake is repeated in every search term, so it would seem rather strange that you use word pancake all the time, maybe rather spammy even. So pick the best term that has our main keyword pancake in it and use other words randomly in text. You will be actually still optimizing as good. Now you talk about poppin wine corks, pancake flippin. Then little bit about your new pancake maker... some basic recipe's and how you like scotch too besides wine. And you are totally fine

Every time you write some keyword in the text note it with * or with number like this

*** cork
** flippin
**** like
**** pancake
** poppin
** maker
*** scotch
** recipe
** basic

Now run it through this web tool again. At some point, when you are writing texts with the same length all the time you know how many * signs you need to put before a term to know it has been optimized well. I wouldn't suggest optimizing to 7% at all actually, less you optimize the better. But mention all your terms at least 2 times. And know that pages with SEO text that point inside such pages actually give much, much better results(type in click here, to google and try to find "click here" from adobe site). So every time you write some article, try to repeat your main keywords when blogging about your new article in example. Again, make it look like you did that totally by accident(use keywords very few times!).

[Empress_JRN]

too long...got to read this one maybe later...

[erots]

Yeah I know. Partly I hate it. But I kind a like the idea actually that you can write a long thread and say I give you $1000 in the middle, and nobody wants to claim that. When I release my free link/bbs-dumper I'm going to write even longer thread.

[ultrasking]

great stuff erots .. tx I will try your tool as soon as I install that perl script on my machine .. cheers

[Dagwolf]

Here's a great tool to play with, it has a free trial period. It's a keyword competition analyzer; it generates keyphrases based on your desired keyword and checks the number of search results against the number of searches done monthly and displays it as a ratio

<a href="http://www.1stposition.net/affiliates/idevaffiliate.php?id=11">1st Position Software</a>

I'm no SEO expert but I used the free trial and it seemed like a real timesaver

Here's what they say about it:

The most popular keywords are not the ......best to target for!!!!!! Looking for a generated keyword analysis (eg. for the keyword "promotion") you’ll see that some of the generated keywords are going to be much more competitive than others. For example, ranking well on the keyword phrase "web site promotion" will be more difficult than ranking in the top 10 for search engine promotion or "web page promotion"! Another example is the single keyword "promotion". Ranking well with this keyword will be much more difficult, or better just a waste of time and effort. Additionally the single keywords usually return the least targeted leads.
So choose only keywords and phrases that specifically apply to your business and have the least competition! Doing so you will dramatically boost the chances of making the top 10 in major search engines. Believe me, the results are amazing! Do not waste your time targeting keywords that will not bring you high quality leads.

I personally didn't try the doorway page generator built in, I hear you have to be careful with those, but the keyword competition analyzer was really cool.

[erots]

Nice tool. Basically my tool does the exact same, although you have to copy the keywords from overture. Also my software doesn't cost $79.95, it is free. Hm interasting, maybe I should also add a feature to grab the "searches done monthly" itself. Just amazing how much they are asking for so simple piece of software. I bet you are earning a lot as affilate.

Originally Posted by Dagwolf

Here's a great tool to play with, it has a free trial period. It's a keyword competition analyzer; it generates keyphrases based on your desired keyword and checks the number of search results against the number of searches done monthly and displays it as a ratio

<a href="http://www.1stposition.net/affiliates/idevaffiliate.php?id=11">1st Position Software</a>

I'm no SEO expert but I used the free trial and it seemed like a real timesaver

Here's what they say about it:



I personally didn't try the doorway page generator built in, I hear you have to be careful with those, but the keyword competition analyzer was really cool.

[booman]

Well I use this site for other things but it is a good one for doing keyword research...

http://search.rightnow4you.com/

Also, here's another pc based free program that you can use for OVerture searches:

http://goodkeywords.com/



Is there anyway to get your script to be server based?

[Paul&John]

Originally Posted by erots

Nice tool. Basically my tool does the exact same, although you have to copy the keywords from overture. Also my software doesn't cost $79.95, it is free. Hm interasting, maybe I should also add a feature to grab the "searches done monthly" itself. Just amazing how much they are asking for so simple piece of software. I bet you are earning a lot as affilate.

Remake it in nice windows form, plus drag&drop feature and you can sell it for a small amount for example 5-10$/copy..

Btw nice tool.

[travs]

thank you erots

[daveydude]

Originally Posted by Dagwolf

<a href="http://www.1stposition.net/affiliates/idevaffiliate.php?id=11">1st Position Software</a>

I just tried to install that software and my PestPatrol alerted me to the win32.sandesa.11 worm. I won't be completing the installation.

[fresh]

seem to be informative

[erots]

Thanks for responses. Anyway...

Is there anyway to get your script to be server based?

You mean like, I make some site like Overture... with web interface? Thought about that, but I was wondering that I could get banned easily by Google of I send tons of requests. If you meant that, making this script a "server" script that you install to your server, well thought about that too. But I figured that not many people know how to install scripts, also it is Perl script and some hosting companies don't support Perl scripts.

Remake it in nice windows form, plus drag&drop feature and you can sell it for a small amount for example 5-10$/copy..

Btw nice tool.

Actually I thought about making it have a nice graphical frontend, but I'm more busy with a lot bigger animal than this thing(you will find out soon). If I finish it then I should make a graphical frontend for it.

I just tried to install that software and my PestPatrol alerted me to the win32.sandesa.11 worm. I won't be completing the installation.

Auch, they ask you $79.95 AND install a worm into your computer. Not cool. My program is a Perl script, so you can check the source to find out how many worms and trojans I wrote into it

[marcelo]

Originally Posted by erots

Yeah I know. Partly I hate it. But I kind a like the idea actually that you can write a long thread and say I give you $1000 in the middle, and nobody wants to claim that. When I release my free link/bbs-dumper I'm going to write even longer thread.

This is one I'm interested for. When did you think you can bring us a first beta testing version?

[erots]

Originally Posted by marcelo

This is one I'm interested for. When did you think you can bring us a first beta testing version?

Actually to be honest it is ready, but it has the same problem that SEO analyzer has, it doesn't have graphical frontend. I haven't written lot of graphical frontends and I'm right now trying to decide which library would be best for that. Can't give exact date when it will be finished, but as most of the job is done - very soon.

[marcelo]

If your script will be -at least at first- a free script, I'd like to get it as it is now, without frontend. I have a little perl skills, then I think I will have no problems to use it and personalize it.

[booman]

Yeah I meant rather than being installed and ran from my computer can this be installed and ran from my webhost.

Learning to install scripts is easy, and I thought most hosts have perl. I have a few hosts that have cpanel and I always see "path to perl" in the main user area.

[erots]

Originally Posted by marcelo

If your script will be -at least at first- a free script, I'd like to get it as it is now, without frontend. I have a little perl skills, then I think I will have no problems to use it and personalize it.

Patience, I'm writing GUI as we speak, I won't finish it today though, probably tomorrow. I want to test everything before.

Yeah I meant rather than being installed and ran from my computer can this be installed and ran from my webhost. Learning to install scripts is easy, and I thought most hosts have perl. I have a few hosts that have cpanel and I always see "path to perl" in the main user area.

Actually it is very easy to make it work on webhost, it can partially be made to run even now. Anyway I'll make web edition of this script then, I figured not many people have Perl scripting support with their webhost.

[Dagwolf]

Originally Posted by daveydude

I just tried to install that software and my PestPatrol alerted me to the win32.sandesa.11 worm. I won't be completing the installation.

I didn't have any problems with it but I've stopped trying to promote them. Lots of downloads and no sales. I can't figure out how to install Erots' software; I downloaded the ActivePerl thing but I don't get it.

[erots]

Originally Posted by Dagwolf

I didn't have any problems with it but I've stopped trying to promote them. Lots of downloads and no sales. I can't figure out how to install Erots' software; I downloaded the ActivePerl thing but I don't get it.

You just install ActivePerl. I hope you know how to do that. It is like installing any other program. After that my script works when you click on it and then enter the file name where the keywords are.

It isn't that hard.