30 Jul '11, 10am

Competitive Analysis in Under 60 Seconds Using Google Docs | SEOmoz

Competitive Analysis in Under 60 Seconds Using Google Docs | SEOmoz

Faced with a new client, and having established a list of keywords they need to target, you want to evaluate the competition to find out what sites are dominating the SERPs for these keywords. However... being an SEO you're a busy guy (or gal), and you need it done right now. I've built a Google Docs tool to automagically do exactly that and this post will walk you through it. The basis for this tool comes from a report in this linkbuilding post on YOUmoz which contained a neat little 'SERP Saturation' report. I don't know how Stephen made his snazzy looking report (he's now shared a few details in this comment ), but in response to a few people asking about his I thought I'd put together a tool. Here is Stephen's report: Cool, eh? We are going to produce something very similar, albeit not as pretty. We will automatically pull ranking data and tie into the Linkscape API to...

Full article: http://www.seomoz.org/blog/competitive-analysis-in-under-...

Tweets

#missedout on our #SS11 60% sale? Don't worry you can still get 40% off our Spring Summer 2011 collection! #style #london

#missedout on our #SS11 60% sale? Don't worry y...

mischabartonhandbags.com 01 Aug '11, 6pm

SALE SHOP BY TYPE ALL BAGS Totes Purses and Clutches Across Body Grab Shoulder SHOP BY COLOUR ALL COLOURS ANIMAL PRINT BLA...

Certification Renewal for Google Adwords Qualif...

adwords.google.com 31 Jul '11, 4pm

Helping organizations achieve better business results with online marketing and communication strategies Google AdWords Ce...

Competitor Backlink Analysis in Excel:

seerinteractive.com 31 Jul '11, 8pm

This is where pivot tables in Excel can come in handy. They are great at consolidating and slicing data into small, manage...

Google +1 T-Shirt

seroundtable.com 02 Aug '11, 12pm

We have had a fake Google + TShirt in the past, and now I have spotted a real one. Frances Haugen posted a picture on Goog...

Save BIG on Network Solutions Domains! 50% off ...

networksolutions.com 31 Jul '11, 9am

There's no better time than the present to register a domain name and get online. Securing your domain name is smart and e...

Google Docs Raised Max File Size Limit to 10GB, but… via @liewcf

Google Docs Raised Max File Size Limit to 10GB,...

liewcf.com 25 Jul '11, 3am

from 1GB to 10GB for unconverted file. Now, you can upload a single 10GB file to Google Docs. That’s great! You can store ...

How Google May Fight Malware Using Document Cla...

seobythesea.com 02 Aug '11, 2pm

This process involves Google taking a large number of landing pages and using a machine learning approach to examine all o...

New blog post: Google should hire this guy

blog.dk.sg 04 Aug '11, 12pm

If someone did this and wants to work for you, it’s hard to say no. Google should really hire Matthew Epstein . Within 36 ...

Google Docs Adds New Charts & Chart Options

Google Docs Adds New Charts & Chart Options

searchenginejournal.com 05 Aug '11, 2pm

Google Docs Adds New Charts & Chart Options Google Docs continues to be a pivotal service for the search giant. Their most...

Fishing for change:

Fishing for change:

grist.org 02 Aug '11, 7pm

The truth is, whether you believe that climate change is occurring or not, the strategies and tactics that prevent carbon ...

SEER Interactive: By: wil

seerinteractive.com 30 Jul '11, 12pm

As an SEO, I am constantly trying to dispel search myths and misconceptions to the best of my little ability. I also try t...

Google Admits Bug Caused 60% Traffic Drop For Site

seroundtable.com 01 Aug '11, 12pm

Imagine 60% of your traffic goes missing one day and most of that is because Google had a bug with their algorithm. One da...

SEER Interactive: By: jody

seerinteractive.com 30 Jul '11, 12pm

As an SEO, I am constantly trying to dispel search myths and misconceptions to the best of my little ability. I also try t...

Wat say u now dear #Bersih? Even India n Philip...

rockybru.com.my 03 Aug '11, 4pm

India embarks on biometric census - Central & South Asia - Al Jazeera English › India embarks on biometric census - Centra...