SEO Tricks: Creating a Sweet High Value Keyword List in 5 Minutes

[SEO Manager]

Creating a Sweet High Value Keyword List in 5 Minutes
 

<h3>Step 1: list a few core keywords</h3>
<p>For this example we will cover hosting...so our core word list could be something like...</p>
<ul>
<li>hosting </li>
<li>web hosting</li>
<li>host</li>
<li>web host</li>
<li>server</li>
<li>dedicated</li>
<li>vps</li>
</ul>
<p>This need not be perfect or exhaustive, as this is just a seeding list to pull deeper keywords.</p>
<h3>Step 2: Google's Search-based Keyword Tool</h3>
<p>Use the You are not allowed to view links. Register or Login. Make sure you are not logged into your Google Account, or they might show partial matches based on your sites. </p>
<p>Since hosting is a high value field we can build a list of keywords that are selling for $1 or more by using the advanced filters. For lower value fields there is no need to use a price filter.</p>
<p></p>
<p>Enter each keyword here and export the top 800 keywords from each list. If Google shows less than 800 keywords you only need to export 1 list. </p>
<p></p>
<p>If they allow you to export exactly 800 keywords you can use the keyword competition level as another filter to allow you to break the list down into two smaller lists that can be exported. Using negative keywords (ie: hosting - web) can also help you dig deeper.</p>
<p>If some services (like fax servers and email hosting) do not fit your business model then you can add them as negative words to help the tool return fewer irrelevant keywords and more relevant keywords.</p>
<h3>Step 3: In Excel Combine &amp; Sort Data</h3>
<p>Delete the unneeded columns (everything but keyword, click price, and search volume - optionally you may want to keep keyword competition level as well).</p>
<ol>
<li>Copy and paste all the lists into 1 Excel spreadsheet. </p>
<li>Once you have that list add a column that uses the equation click price * estimated monthly search volume.
<li>Sort your list by keyword value
<li>Use the de-duplication tool to remove duplicate data.
<li>Filter irrelevant keywords by hand, and/or remove rows containing x (ie: where x is the word free, or email, or some type of hosting/server you have no interest in providing).
<li>Cut off the bottom of the combined list. Decide to set a lower threshold based on how large of a site you want to build, how rapidly the keyword values fall off.</ol>
<p>As an example, here is You are not allowed to view links. Register or Login, but please note I did not filter out the various irrelevant stuff like free, because for some hosting business models maybe they rely on pitching free hosting and then selling upgrades.</p>
<h3>Step 4: Map Out Keywords Against Your Site Structure</h3>
<p>Essentially you want to cluster relevant keyword groups together and try to map them out against your site structure, planning out page titles, URLs, on page H1 headings, meta description tags, and internal anchor text.</p>
<p>We have an example of how to do this inside You are not allowed to view links. Register or Login.

</p>
<h3>Visualize the Process</h3>
<p>There are other tools similar to the Google Search-based keyword tool (like You are not allowed to view links. Register or Login). You may want to watch these videos if you need help visualizing the process.</p>
<p><object width="425" height="344">

<param name="movie" value="You are not allowed to view links. Register or Login"></param>
<param name="allowFullScreen" value="true"></param>
<param name="allowscriptaccess" value="always"></param><embed src="You are not allowed to view links. Register or Login" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed></object></p>
<p><object width="425" height="344">

<param name="movie" value="You are not allowed to view links. Register or Login"></param>
<param name="allowFullScreen" value="true"></param>
<param name="allowscriptaccess" value="always"></param><embed src="You are not allowed to view links. Register or Login" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed></object></p>
<h3>Bonus Steps</h3>
<p>Disclaimer: The above strategy relies on pulling keywords from an ad network. It will thus have a commercial focus and a bias toward high search volume keywords. If you want non-commercial keywords then using a variety of You are not allowed to view links. Register or Login and/or focus the above method on grabbing some keywords with low bid prices as well. </p>
<p>Here are 7 quick ways to expand your keyword strategy</p>
<ol>
<li>If you have an established website with significant web traffic you can look at your analytics data for additional keywords and keyword modifier ideas.</li>
<li>Track industry news, blogs, and forums to see what people are talking about. Conversation creates search demand.</li>
<li>Use keyword suggestion tools built into browsers and search toolbars, and visual keyword cloud tools like You are not allowed to view links. Register or Login to come up with additional keyword ideas.</li>
<li>Put competing sites through You are not allowed to view links. Register or Login (and other You are not allowed to view links. Register or Login if you like) to find additional valuable keywords competing sites rank for.</li>
<li>If you are creating an affiliate or review site make sure to hunt down leading brands to review. Much of this word can be done through choosing good competing sites to draw keywords from in competitive research tools.
<li>Find category based keywords using You are not allowed to view links. Register or Login.
<li>If you are advertising on AdWords you can login to your Google account then use the Google Search-based Keyword Tool and they will show you a list of up to thousands of additional keywords they think you should advertise for (one list a friend showed me had over 6,000 keywords in it).</ol>
<p></p>
<p>Bonus keyword tip: read You are not allowed to view links. Register or Login. At $39, it will probably be your highest ROI marketing spend in 2009.</p>

 

You are not allowed to view links. Register or Login