Archive for the ‘SEO Tools’ Category

How To Do Keyword Research Using Insights for Search

Monday, April 2nd, 2012

For many of us using Google Adwords tool for keyword research has become a stable. After today’s blog post I’m hoping to shake that ground up a bit. You may know of or might not know about Google’s Insight for Search. It’s a free service that lets you see the top search terms over time and area of the world. Additionally it provides relevant search term data. So let’s take a peak under the hood and see what we can do for our keyword research with Insights for Search. Listed below is a step by step process to use Insights for Search for keyword research.

  1. Setup Excel sheet – This is actually a pretty critical step even though it might seem like common sense. You want to make sure you have a few columns setup in your Excel sheet to allow for recording of the keyword and a column for the average search volume over the past 12 months.
  2. Brainstorm on Keywords – Before we start using the tool you want to make a list of keywords that you think would be relevant and popularly searched. Put this down somewhere so you can use it in the next step.
  3. Search Insights – Next is the actual search step. What are critical here are the settings you choose for your search. Under the search terms column on the tool’s web page enter your keyword. Then under the filter column choose “Web Search”, “United States” or your country for the second row of dropdown options and in the third row of dropdowns, select “Last 12 Months”. This setup will give you the search volumes for each month over the last 12 months for those users in the United States or your respective country. Once you’ve done that click the search button to initiate the search process.
  4. Record Data – Your next step is to record the data returned from the search. Record the total number located under the “Totals” section. This will give you an average of the search volume over the past 12 month period.
  5. Rise and Repeat – Repeat the above last 2 steps (#3-4) for each keyword you came up with in your brainstorming.
  6. Discover Keywords – While doing the above for each keyword also take note of the suggested search terms under the “Search terms” section. Add any relevant keywords here to your list.
  7. Sort – After you’ve completed making your list and recording all average search volumes, now it’s time to sort the list. Using Excel’s sort feature sort the list from highest to lowest for the average search volume column.
  8. Analysis – Now that you have a beautifully sorted list of search volumes paired up with keywords it’s time to analysis and decide which keywords to use. Remember just because a keyword has the highest search volume doesn’t mean that it’s the best keyword for you to optimize for. Factors such as competition and keyword relevance to your site’s topic should be considered. Another tip; I like to use the custom highlighters in Excel to mark which keywords I’m going to be using so I don’t get confused for forget which ones I decided upon.
  9. Recheck Annually – As you may have guessed the search volume number change monthly. So I suggest performing this task annually to make sure the keywords your targeting still have significant searches to warrant optimizing for. Mark it on your custom printed calendars so you don’t forget.

Twitter Issues - Not Working!

Friday, August 7th, 2009
Twitter Bird Dead

This is just a quick post about Twitter issues I seam to be having. It does not seam to be allowing me to login to the home page but I can from other pages using the same exact username/password. But anyways at least I got around that hurdle finally.

Although now I don’t seem to be able to post anything new on Twitter. I’m just getting the loading image when I click the update button on my Twitter home page after typing a message. I’ve even left the page open for a good hour or two and still no working!

So I then came back again and it’s still not working! Ahrrrrrrr, I hate when this kind of stuff happens. I’m not that big of a deal but I’d like to at least update my Twitter page with some of the new posts we’re making on our blog here.

I’ll try again latter and hopefully they will have the issue resolved. I’m guessing it has something to do with the browser through as I’m able to update using a twitter iPhone app. Plus I just saw this posted message on the Twitter status site: Problems with updating from Firefox 3.5. Only issue is I’m not using that version of Firefox but I did just update my version so maybe it has something to do with that.

Again hopefully they will get this issue fixed quickly!

PageRank Calculator

Monday, January 5th, 2009

I just got done putting together a neat little SEO tool that calculates how much Google PageRank you’ll need to get from links to obtain a specific PageRank. I call the tool a Google PageRank Calculator. To best explain what it does lets look at an example.

Lets say you want a PageRank of 6 and you currently have a ranking of 1 then this tool will calculate how much PageRank you’ll need from links pointing to your site to get to PR6. Which in our example would be ~297 PR1 links pointing to your site to increase your PR1 site to a PR6 (using the default settings on the tool).

The tool gives you a nice total of the complete amount PR you’ll need and then breaks it down father into how many PR1, PR2, and combination of PR2 and PR1 links that would be. In the future I might make it break that down further or have some sort of options were you can chose how many max or min links of a specific PageRank.

The benefit of this tool is that it will allow you to have some estimation of what type of effort it will take to get your site up to a point at which it’s considered an authority in Google. PageRank is really just a measure of that, that page’s authority. Although of course that has gotten lost a little bit with people buying links and obtaining them in other ways but that is really the original purpose of what PageRank shows. And so this tool really just gives you some prediction on what it would take for you to get there.

For more information on how exactly this SEO tool works just check out the tool’s page and scroll down a little bit and you’ll find an explanation of how the calculation is done. And thanks to my brother who help with the Calculus and Algebra.

Also I’ve set it up so you can post comments about the tool on that page. Just scroll down to the bottom and you’ll see the comment area.