By: wil

Comments Off on By: wil

Thanks for stopping by! Keep up the good work!

November 29th 2007 Uncategorized

How to use Google webmaster tools stats with Excel

Comments Off on How to use Google webmaster tools stats with Excel

Google’s webmaster tools has a neat feature that lets you download your query and click statistics (once you have verified ownership of your site). The data you can get from there is quite comprehensive, but hard to break down for use in Excel. As a fun exercise I put together a small Python-script that takes the CSV file downloaded from your webmaster tools account and turns it into new CSV files for queries and for clicks (both with the position numbers as well).

Python is a neat little programming language, I like it more and more as I use it :) .

Here’s how to get started:

  1. If you do not have Python installed, go and download and install Python. I assume most Apple OSX will have it installed, but I don’t have a Mac so I can’t say for sure. It’ll almost certainly be installed if you’re one of the 3 Linux-users who have visited my blog. If you’re using Windows, take the version with the installer (it’s easier) and make sure that the folder where you installed Python is in your “path”.
  2. Grab my and extract it into a folder. You should have three files: (the Python script) and ProcessAll.bat +
  3. Copy your query stats CSV files into that folder as well.
  4. Double-click on (or ProcessAll.bat if you’re on Windows and don’t have Python set up to run scripts directly)
  5. The script will now process all CSV files in the same folder, create a new folder called “output” and place the new CSV files there.
  6. Open the new CSV files in Excel (or Open Office or even Google Docs + Spreadsheets)
  7. Enjoy :)

Here are some more ideas for the CSV files when you have them in Excel:

  • Select everything (Ctrl-A) and set up an “AutoFilter” (menu item Data / Filter / AutoFilter). Now you can filter your stats however you want them. Want to only see the queries for which you rank #1? How about the queries that people from Switzerland used to find your site?


  • Set the Location to “All locations” and search type to “All searches”, now select everything and sort by the last column (menu Data / Sort / has header row / sort by Column E, ascending). Now select the last two columns (D and E) and click on the chart icon. Choose an “XY scatter” chart and let it create it. This chart shows you the ranking of your site for the search queries. There are some problems with the chart like this (keywords can be listed several times), but I think it’s neat anyway :)


What’s the neatest information you ever found in your webmaster tools query stats?

Copyright © 2010 This Feed is for personal non-commercial use only. If you are not reading this material in your news aggregator, the site you are looking at is guilty of copyright infringement. Please contact so we can take legal action immediately.
Plugin by Taragana

November 29th 2007 News

By: Lew Moorman, SVP Strategy, Rackspace

Comments Off on By: Lew Moorman, SVP Strategy, Rackspace

Kind words. It always makes us feel great when someone sees our true desire to be Fanatical. It is an endless task like Lexus’ pursuit of perfection and sometimes all you can say is “we messed up.” Thanks for your support during one of those times.

And, keep the feedback coming!

November 29th 2007 Uncategorized

Intranet Information Architecture (IA)

Comments Off on Intranet Information Architecture (IA)

Information about departments or divisions was a top-level category in 46% of intranets, and there was a very long tail of additional categories found in a smaller proportion of intranets.

When we started this project, we had hoped to produce a recommended IA for intranets. Although structural diversity ultimately made this an impossible goal, we did identify an IA skeleton that projects can use as a starting point and adapt to their local circumstances.

Many intranets follow several general patterns. Certain types of companies also tend to follow particular trends. For example, manufacturing companies often include a product-related category in their top-level navigation, whereas companies with a focus on intellectual property often present a top-level knowledge management (KM) category.

November 27th 2007 Alertbox

By: Kelly

Comments Off on By: Kelly

Google Checkout just added support for non-profits as well:

November 20th 2007 Uncategorized

By: Increased Online Traffic

Comments Off on By: Increased Online Traffic

I’d really love to see a video tutorial on social media & community SEO.

November 19th 2007 Uncategorized

Long vs. Short Articles as Content Strategy

Comments Off on Long vs. Short Articles as Content Strategy

Typically, people who really need something are the highest-value users because they’re more likely to turn into paying customers. That’s why I recommended writing articles instead of blog postings.
But the very best content strategy is one that mirrors the users’ mixed diet. There’s no reason to limit yourself to only one content type. It’s possible to have short overviews for the majority of users and to supplement them with in-depth coverage and white papers for those few users who need to know more.

Of course, the two user types are often the same person — the one who’s usually in a hurry, but is sometimes in thorough-research mode. In fact, our studies of B2B users show that business users often aren’t very familiar with the complex products or services they’re buying and need simple overviews to orient themselves before they begin more in-depth research.

November 13th 2007 Alertbox

By: leslie

Comments Off on By: leslie

Thanks Danielle! Rotating is a good idea. I think there are a lot of small non-profits out there that want to be successful online but just don’t know about the resources available!

November 8th 2007 Uncategorized

By: ms danielle

Comments Off on By: ms danielle

hi leslie, funny, i actually had the paypal and pages open the other day bc i was going to write a post about this as well. i’ve always wanted to put up a chip-in non-prof widget. the hardest part is picking the org. maybe i’ll rotate them monthly. great post!

November 7th 2007 Uncategorized

High-Cost Usability Sometimes Makes Sense

Comments Off on High-Cost Usability Sometimes Makes Sense

When it comes to selecting usability methods, there are many parameters to consider, and many different scenarios. That’s why both expensive and cheap usability methods make sense under the appropriate circumstances.

November 6th 2007 Alertbox