Report: keyword difficulty verses SERPS ranking

[nedwells]

Hi there,

I've been using the PRO tools for a few months now, and find them great for revealing information for my clients, and planning our SEO approach.

One report I've put together has been really helpful for a client, but I built it manually and it took ages.

It lists, in a spreadsheet, keywords side-by-side with keyword difficulty, target URL, and SERPs result. Sorting by keyword difficulty or SERPS position has helped us to prioritise which pages to hit first.

But it took a while to generate the report, and I'm wondering if anyone has a better approach, or if this kind of report can be generated automatically:

http://www.cicada-online.com/app/images/documents/product-page-SEO-blank.pdf

Thanks Mozzers!

[connectiveWeb]

You could basically run two separate reports and join them together in one spreadsheet. One from Google's keyword tool (the competition is PPC based data but a good indicator) and the second from your SEOmoz account for rankings and get a similar view to what you have but much faster. The one thing you would be lacking is the target URL. Raven provides the adwords competition data next to its ranking view as well.