Ladies and gentlemen, another awesome Excel spreadsheet for you to use. Today I have taken the SEOmoz SERP Analysis Tool export and modified it to spin you out a bunch of graphs that will show you where your site might be weak against your competitors. Huge!
A bit of background
When SEOmoz announced a few months ago that they were going to turn the SERP Analysis tool that was built by BusinessHut into a dynamic tool in the SEOmoz toolbox, you could say that I was stoked. Nay, I was overjoyed.
To me though, I was a little bit disappointed when I saw the tool. Yes, I love that you can plug in a site you want to compare the search results to, which is mega helpful. And the tool looks pretty. And yes, you can export it to CSV.
The feature I loved about the old tool, though, was how it would spin you out a bunch of graphs that would show you, visually, where your site stood against the competition, and it helped you understand how and why different sites were ranking for the term that you plugged in and where your site might be weak. Then you could take action and rank your site for awesome.
The SERP Analysis tool doesn’t have these graphs, though. Bummer, huh? I missed graphs like these:
As far as I see it now, you have two choices:
1) Download the old spreadsheet and get all of the data manually, like I used to.
2) Use this awesome spreadsheet that I’ve put together for you!
Making the SERP Analysis Tool even more awesome!
Today I decided that I was going to turn the SERP Analysis tool into a tool where you can plug in the full export that you just ran, using some of your monthly credits (I think you get 50?)
Here are the steps you should go through:
1. Download the Template for Moz SERP Analysis Awesome.
2. Run the SERP Analysis Tool for your keyword in question.
3. Run the full report using the button highlighted below:
4. Export to CSV.
Now, once you have exported to CSV, all you need to do is highlight ALL of the data that you have been given in your CSV and plug it into my Template for Moz SERP Analysis Awesome.
What will I see?
Now we get to the fun part! Now that you have inserted all of your data into the spreadsheet, you can click through the tabs and see images like these:
Did you break them down by category/type?
You bet! Working from inspiration from the original document, I applied some conditional formatting to the sheet so that you can see when your onpage optimization is bad, like below:
The different categories that you will receive graphs for are:
- Ranking Page Link Metrics
- Onpage Optimization
- Domain Metrics
- Social Metrics
I’m an extremely visual person, so I find these graphs to be helpful to get an overall view of my site. For example, from running this sheet for my website and a term that I have been trying to rank it for, I see that my site is WAY behind in links, yet I’m still ranking pretty well for the term. If I needed to, and saw that my site is so far behind in domain metrics and links, I could try to outwork my competition by using videos, photos, and other types of media to get into the SERP and draw attention to my site.
Hmmmm….I might just do that.
Until later…happy optimizing!
And if you still haven’t gotten the spreadsheet, get it here.
As always, I’d love your feedback on how I could make this even cooler!
- The Best Kept Secret in the SEOmoz Toolset (seomoz.org)