Archive for the 'Reporting' Category

Digging For Buried Traffic

Finding more organic traffic

Use tools you already have to find ways to boost traffic.

Using a Site Analytics tool? Got a Rank Tracker or some free time to manually check some rankings? Here’s a way you can find and predict how much traffic you might be missing out on.

Aside from the fact that I just ended that sentence with a preposition which drives me nuts, let walk through the process, shall we? Super. Open up your analytics tool and your favorite spreadsheet app and let’s go.

Collect the keywords

Go into your analytics tool and find the report that tells you what keywords are driving organic traffic to your website.

Set your date report range for 30 days and make sure you can see how many visits each keyword/keyphrase drove to your site within that time frame. Get as many keywords as you can. I’m talking like 400-500 keywords if your report allows and if you have that much data.

Paste that data into a spreadsheet. One column for the keyphrase and one column for the number of visits. Good!

Get the rankings

Arguments about the veracity of rank-checking these days aside, paste that list of keywords into your favorite rank checking tool and fire it up. Or, you can always check them one-by-one if your list is manageable.

Plug in your findings into a third column on your spreadsheet. (I’m just checking Google here)

Forget about the #1 ranked items

Now, sort the spreadsheet and delete all the rows that have keywords that are currently ranking #1 for you. We’re only going to concern ourselves with anything not currently ranking #1 from here on out.

Now for some imperfect math

Let’s take a look at the chart here…

source: http://www.seo-scientist.com/google-ranking-ctr-click-distribution-over-serps.html

If we accept these numbers, you can start to calculate how much traffic you might be losing by ranking something other than #1. For example…

“red widgets” brought in 100 visits and you’re currently ranking #4. Based on our chart above, there’s a difference of  44.83% between #1 and #4. Let’s do the math: You could have had roughly 45 extra visits had you been #1. See where this is going?

You can use these numbers to help justify projects/man-hours geared toward trying to rank for all these other keywords. You can use them to give a ROUGH projection of potential traffic/lead increases. I can’t emphasize the term “rough” enough here. The math is not perfect all the time in all cases. You’re going to have two moving targets here:

  1. The percentage of click-thru rates are not going to work out exactly for every market or set of search terms
  2. The rankings you see might not be the rankings that everyone sees.

But overall, you can see how this can give you a rough estimate on traffic of which you could be taking advantage. You can also turn this into a monthly or quarterly exercise. I find it best to track the traffic I’ve gained by moving up the rankings on that initial list. I use the same spreadsheet we set up above and add columns by date that track the ranking improvements/setbacks. I then add a column after 30 days to see if the traffic to that keyword has improved.

Hope this helps! It’s an interesting report anyways. I gotta give a shout-out to Larry Cotter from ApartmentHomeLiving.com on this one.

Red Herrings in Google’s Web Crawl Report

Found this interesting today when going through a site’s Web Crawl error report in Google Webmaster Tools. I was looking at the 404s (not found) report and found a number of what looked to be partial URLs pointing at the site from hundreds of affiliate pages.

Turns out that Google has tried to follow a URL it found in a JavaScript function. The problem is that this URL is only the beginning of an address that was to be constructed using other variables from the JavaScript function. Google obviously can’t run the function and put the whole thing together. It just found an “http://www.blahblahblah.com/and-so-on” and tried to go there.

What I find most interesting about this are the ramifications. Can you exploit this as an inbound link to another page? Does this pass page rank goodness? Would Google try to follow a URL in a JavaScript comment?

Interesting indeed.