Over the past few days I’ve created quite a few new posts on this well-established blog.
For a bit of fun, I thought I’d check some keyword phrases and see if the blog had got any top search engine rankings.
Here are the results…
Creating Fat Content – 4th
Latest Google Slap -4th
Selling Links Is Profitable? – 1st
Pagerank Slap -5th
Affiliate Elite Hype – 2nd
From Cubicle Slave to the Next Internet Millionaire! – 6th
I didn’t use quotes for any of the searches.
It’s interesting that Google picks up on the blog posts so quickly, and gives them fairly high rankings. In fact, the search engine results are for the individual blog post pages, not for the blog homepage… so those posts presumably have no external links helping to give them a ranking boost… just a link from the blog homepage.
Important tip… pay close attention to your post titles… try to put in potential search phrases, while keeping them on-topic and punchy. 
A good example… for the phrase [This is LEFT JOIN problem] this recent blog post ranks nowhere in Google because… those words aren’t in the blog post title.
Dang. There go my hopes of capturing the lucrative “MySQL programming problems” traffic. 
Hey Neil,
I am addicted to your blog now. : Good Job.
But don’t you thionk those keywords are not the competitive? Though I am not an expert in SEO but I learnt that keywords that are not very competitive can easily find their way to top search engines but will not produce real traffic.
Anyway, will appreciate more education on this from you. Thanks
LOL, I didn’t claim I had a “magic blog”.
Ranking for competitive phrases takes dedicated websites, on-page keyword analysis and link campaigns.
But, having said that, my blog is usually about new things… which people may be searching about (affiliate elite, the google slap, TNIM) and some new traffic may visit because of those rankings.
Neil.
I got to agree that keywords within title makes a huge differences in rankings of your bog posts. This is part and parcel of SEO. Singapore SEO Consultant