Monday, November 05, 2007

In search of themes and keywords - SEO and LSI

Oh, aren't we cute with acronyms and inside terms?

Still burned about KeywordSpider quitting on me... So here is some more figure out on how to replace it, left over from the last post:

The trick is to have something that queries both Overture (still stuck in Jan 2007 data) and Google at the same time. You still have Trellian's free tool and this one I just found: - which looks up similar words, gives competition and competing adwords all at the same time. 100 results per page.

Woohoo-- Here's some interesting results from that tool. Looked up "self-help" and got my 100 replies. Now the odd thing is that this shows the number of searches per month for that term - check out "free self help ebook" from this list - 259 searches, but 6050 competing sites and only 8 people taking adwords. Now check out "free self help book" - 300 searches (more), and only 21 (!) competing sites and 7 adwords. Fascinating how you could miss a profitable niche by a mile and not know it... If you looked this backwards by adwords, you might find niches more profitable for Adsense on the page.

CheckRankings tool then replaces NicheBot's free page in the above use. Because it does more. Now it doesn't replace MKLB's Competition Finder, which still shows you which sites are actually using the keywords in their pages - important.

But this still looks for search terms with your word in them.

This again misses what I had with the Keyword Spider - the ability to find related keywords to the one I was using. Best substitute I have right now is the Massive Keyword List Builder - which searches meta tags (but these are suspect in general, compared to actual search engine results).

Google Sets might be an interesting approach to this. The returns aren't the greatest number - but they give what Google thinks are related terms - and this is important in terms of LSI.

What I'm looking for is what people call self-help, self-improvement, personal development.

I'm trying to find the base keyword which I can then build my niche on. Each of these is used to decribe the same idea. And that is what I've found tons of books about. I thought it was self-help, but personal development is higher in Google Trends.

The weird thing is that recently self-help, personal growth, and self-improvement have become almost synonymous in search engine rankings. Means the same subject could be sold three different ways - in three different niches. (A wierder one is that personal achievement doesn't rank according to these others, but does come up high in "news" searches - of use in press releases...)

Here's an oddball niche as example I found while posting:
Out of Google Sets, comparing "self improvement, self-help, personal achievement, personal growth, and personal development", I found that it gave me back "success" as a key term (among others) Now, plugging this into Competition Finder showed that success had huge following, nearly 400,000,000 pages and 1,580,000 pages with terms in title and anchor. Now, checking out "personal success" found a wild niche - with 95,500,000 pages, but only 651 pages with both anchor/title.

Now, ignoring those wild ones above, we take personal development as a base term.

Plugging this into Trellian's free online keyword tool gave us a list of possible niche terms.

Then those terms go into Competition Finder = GOLD MINE! Millions of pages and nothing optimized for all these variant terms.

OK pardner, take a step back and let's check these out in Google's Adwords Traffic Estimator tool - now we're making more sense - some of these don't get any estimated clicks per day (and some have available data but no traffic - people are buying ads, but no one is clicking on those terms...).

Now, out of one hundred terms found through these overture-linked sites, only 17 turned out to have traffic according to Google. Doesn't mean they don't get traffic, they just don't get clicked through, even one per day - so the average clicks is less than 30 per month. These would have to be really profitable niches to be useful.

In doing this, I compared the MKLB against Google's Adword TrafficEstimator and found them to be nearly identical.

- - - -

Now I'm working to get this all figured out - so bear with me as I lay out this logic.

I'm working from having an existing product to pitch (product-line, actually). Most of the SEO books I've been covering are simply working over the affiliate angle and only nod in the general direction of the producer. But this was the entire reason I wrote that mega-book, An Online Millionaire Plan.

Closest tool I've found to getting a theme (that's free) is not Google Sets, but adding a "~" in front of any search term and keeping track of the words in bold.

Now, I'm going to depart from all this, since I just found that my off-budget investment in a program by Andy Williams, called Fat Content Creator, has a neat little theme builder built into its article editor.

Certainly cuts short all these past few days of work in trying to find free tools.

So let's recap:
  • Get your keywords by searching through your product and finding what you've been talking about - or what you want to be talking about.
  • Post your product on some private website with no out-bound links (or very few) and use some sort of site search to find what keywords you are using.
  • Take these, one by one, and drop them into some overture/search engine meld - and find the variations.
  • For each set of variations, drop these into Google AdWords: Traffic Estimator to make sure you have working keywords.
  • Build your mini-web and mini-net around these keywords.
Or that is at least the basic plan.

I'll be using the theme builder inside Fat Content Builder, plus Dr. Williams' other tool, SEO Website Builder - which does the mini-web building thing.

And no, I'm not an affiliate (you don't see a link there, do you?) but I'll be one shortly, given that his product works (and had better for what I paid for it) than that Keyword Spider.

- - - -

And that, really, concludes my post grad studies. I've got a little to learn about server side includes and the no follow tag - but if you want to bone up on Michael Cambell, Dr. Andy Williams and that bunch, you'll quickly see where I'm going. (Campbell has a page of downloads and they both have good blogs and newsletters. Start out with "Nothing But Net" and you'll wind up going through the rest of his stuff and creating a whole new way of looking at marketing.)

Not that I haven't introduced you to it over the last few days as I studied it myself.

I don't know that this really goes much further on. It really is a minor point, but the key point to a web presence if you are going to seriously make any millions.

Certainly, low maintenence websites which sell your product for you are the certain way to go.

I've got a bit to work over tying this into what we've already gone over. The core of an Online Millionaire Plan is to get the viewer to become a subscriber - that all your articles push a person over to a single opt-in page. The average three links you have on an article can push for a) an opt-in to your newsletter, b) a particular product sales page, c) your main landing or directory page. Since a comment usually has only one link, this would probably best be invested in a newsletter opt-in page. Offline lead generation would be to get the person to a main page, devoted mostly to product views and to your newsletter - or just to get people to sign up for your newsletter via that opt-in form on your landing page.

Your work is to continue marketing your product-line(s) every week by putting out more articles, more comments, more blog posts, more Squidoo lenses, getting more radio interviews and podcasts done. And you should really have fun at all this. And you'll be building massive sites by adding another mini-web each week - one for each product line (well maybe a bit less to begin with as you take the time to get used to building them...)

OK, if you don't hear from me, it's because I have my work cut out. You see, I have all this material that simply needs to be extracted into website pages, articles, lenses, and so on. And I've talked enough over the last few days to earn a bit of rest for my weary, throbbing head.

But check out my other blogs - that's probably where I'm spending my time...

No comments: