Brian Clifton – idaconcpts.com

How to Calculate Keyword Density

I am back from a very nice trip to the beautiful island of Kauai here in Hawaii and I highly recommend visiting this beautiful island for some great sights that will blow you away. The Kauai island offers great hiking, kayaking, eating, sunbathing options. If you are interested in visiting an island that keeps that country feeling, then you should definitely visit Kauai.

Here are two samples:

Jen Toba — Wailua Waterfall - Kaui Island

Beautiful! Just like today’s topic in the series of the 5 key factors that determine that your website is a returned match on a search engine query. The first posting was about Google AdWords, the second one about Keyword Prominence and Link Popularity.

Calculating your Keyword Density, that is the percentage that your selected keyword is out of the total number of words in a selected number of web pages, takes 4 easy steps.

Step 1: Write the text of your web page on any text editor of your choice (e.g. MS Word). Or just copy/paste the selected text(s) from your website(s) into the word editor.

Step 2: Find out the total word count of your text using the Word Count tool of your text editor.

Step 3: Using your Find tool, find out how many times your keyword appears on the text. Write down that number.

Step 4: Divide the number that your keyword appeared by the total word count. Multiply the result by 100. This is the keyword density of your keyword.

Let’s do an example!

Let’s use the opening paragraph of this post and find the keyword density of island.

Step 1: I copy/paste this text into MS Word.

I am back from a very nice trip to the beautiful island of Kauai here in Hawaii and I highly recommend visiting this beautiful island for some great sights that will blow you away. The Kauai island offers great hiking, kayaking, eating, sunbathing options. If you are interested in visiting an island that keeps that country feeling, then you should definitely visit Kauai.

Step 2: From the menu bar, select Tools, then Word Count. Total word count is 63.

Step 3 : From the menu bar, select Edit, then Find. The keyword “island” appears a total of 4 times.

Step 4: 4 / 63 * 100 = 6.34%

Easy, isn’t it?

Yes, but there are some important points to consider.

–

Major search engines have their own “skip words”. These skip words may or not may not set by the user. Usually words with three or less letters are skipped (e.g. and, or, I, etc.) and not included in the total word count.
Partial matches may or not be included (e.g. island versus islands).
Tags may or many not be included.

–

Therefore, when using online Keyword Density calculators, make sure that you look for these three points. I recommend Google Rankings Keyword Density Calculator (not affiliated with Google).

According to Brian Clifton in his How Search Engine Optimisation Works whitepaper, SEO companies usually aim for a Keyword Density between 5 – 10 %. Our previously calculated Keyword Density in the example above meets that criteria. Not too bad.

See you next time!

More on Google Ad(key)Words

This post will be short and sweet because I need to take a drive road test today because I am buying a brand new car!

Yesterday on my way home, I was reviewing a SEO whitepaper by Brian Clifton and Nikki Rae from Omega Digital Media tittled “How Search Engine Optimisation Works”. This 20-page document explains how search engines work and how search engine optimisation (SEO) can help you achieve high search engine visibility.

According to Clifton and Rae, web sites appearance on search engine results depends on 5 key factors (p. 8):

Which Keywords the user entered
Your web page Keyword Density for these keywords
Your web page Keyword Prominence (page location) for these keywords
Your Link Popularity – the number of other sites that link to you
Your link and keyword Relevancy

These 5 factors are essential for SEO and I promise that the next 5 posts are going to be on these topics. In the meantime, let’s take a look at idaconcpts WordPress Blog Stats regarding keywords that that returned matches with www.idaconcpts.com:

As it becomes obvious the term that returned the most matches to idaconcpts is google analytics flickr. This makes sense because as of right now, 08/21/2008, my post that has an analysis of Flickr using Google Analytics is the most viewed page of this blog (30 views). The term flickr was included in 7 out of 20 of the search engine queries that matched idaconcpts. The term google had the same outcome.

Therefore, the terms google and flickr are golden ones to consider for my personal Google AdWords campaign. However, the important part is to be able to combine with appropriate terms (remember quality over quantity! I want my readers to remain in the blog, not leave right after they click on it!). Possible keywords are google analytics and the different mispellings of analytics (e.g. analytic, analystics, analytis)! Believe or not, including this misspelled words, inflates my search engine keyword result matching. Cheating? Clifton and Rae don’t believe so!

(p. 9) Don’t forgit misspelled keywhords! (p. 10) The Google Trends tool is an excellent free resource for checking mispellings, relative keyword popularities (e.g. product X versus product Y) and regional variation (e.g. cell phones versus mobile phone).

What do you think?

Find your Top 10 Google AdWords (feat. Vampire Weekend)

There has been a lot of movement at our office over the last and current week, a lot of colleagues coming in to finalize the details of our product launch. Given the nature of our product launch, I cannot write much about it, but I can tell you that in about 20 days I will be able to give more details.

In the meantime, let’s talk about one of my assignments: to find the top 10 Google AdWords for us. The main goal is to set up a monitoring systems that allows us to monitor these keywords in conversations relevant to us on Blogs, Twitter, Friendfeed, etc. Sounds easy? I wish!

Finding the right (key)words is hard, just like NY prepsters, Vampire Weekend sing on “Oxford Comma”:

Haven’t got the words for you / All your diction dripping with disdain / Through the pain

So what is a web analytics newbie to do? I set on the following 3 tasks:

Review Brian Clifton’s “Advanced Web Metrics with Google Analytics” for all mentions of Google AdWords.
Review Google AdWords’ Keyword Tool.
Read relevant blogs on the subject.

Given the urgency of our product launch, I have only been able to do the two first tasks so far (and have not been able to blog about it, until today!).

–

Let’s see what I got:

–

First, the book by Clifton is really great and I can see referring to it a lot in the future. It already has lots of page separator’s by subject. If this book is either sitting on your shelf or on your Amazon.com wish list, here is a motivator to pick it up. Check the following pages on tips regarding AdWords: 73-75, 92, 103-105, 173, 190-201, 299-305 and 308. The tips range from setting objectives of your AdWords campaign to creating filters on Google Analytics reports to determining key measures such as cost per acquisition.

–

One of the main problems with selecting and monitoring keywords is the specific/broad dilemma, that is whether to choose a campaign based on “shoes” versus “blue shoes”. A broad match set on “shoes” would allow you to measure web visitors that searched for “blue shoes”, “nice shoes”, etc., while a specific match set just on “shoes” would only measure web visitors that searched “shoes” only. Also, a specific match set on “blue shoes” would not include a keyword search like “pair of blue shoes”.

–

Second, after reviewing the Google Adwords’ Keyword Tool, the mentioned problem becomes evident. By generating keywords using descriptive words or phrases I get some interesting results. For example, I am particularly interested in “photo sharing”, which has an approximate average search volume (AASV) of 165,000. Not too bad…I thought. Just the keyword “photo” has an AASV of 20,400,000! The keyword sharing has an AASV of 2,240,000! What is a web analyzer to do?

Think outside of the box!, said Vampire Weekend.

–

So if there’s any other way / To spell the word / It’s fine with me, with me

-.p

The next step is to generate keywords using your actual website content, let it talk to you. After inputing our company address I got very good leads like “photo gallery” with a healthy AASV of 823,000 and “slideshow” with 1,000,000. Funny, these are key features that I had not consider before and they make more sense (besides having a greater AASV!).

–

Conclusions:

–

Check your handbook / It’s no trick: There is a lot of literature available on selection of keywords. Try the tutorials at Google AdWords and AdSense first, then complement your ideas with Clifton and web analytics’ blogs (refer to my Blogroll on the left side for some references).
Adjust my tie / Know your butler, unlike other guys: Two words > Keyword Tool! Listen to your website. Let it do the legwork for you.
I met the highest lama / His accent sounded fine: Quality over quantity. Selecting a single word with a high AASV may provide you a greater hit rate, but these site visitors may just exit on your home page after realizing that your site has nothing to do with their search. Remember the key is conversion!

Vampire Weekend playing "Oxford Comma" at Pipeline Cafe (Honolulu, HI). Photo credit: me!