SEO: Google Docs Tools

Long Tail Keyword Prospecting

Long Tail Keyword Prospecting - Make a Copy
Long Tail Keyword Prospecting - Instructions (right here!)

The basic idea behind this tool is to quickly explode your keyword list with long-tail goodness. It’s not an exceptionally robust tool, but it’s great for brainstorming article topics and the like.

You’ve got four columns here. The formulas behind the sheet will slap the various permutations together and run each of them through Google Suggest, spitting out a list of 2-10 keyword suggestions.

The really fun thing about this tool is how easy it is to drill down to the uber long-tail phrases; I got a suggestion for “car speakers reviews” from the root “car speakers”, so let’s drill a bit deeper and run the suggest for “car speakers reviews” by adding “reviews” to our 3rd word column.

Ta-da! Instant prospecting. Follow the link above and make a copy of the spreadsheet. Then, have your way with it.

Content Strategy Generator

Content Idea Generator - Make a Copy
Content Idea Generator - Instructions

The folks at SEOgadget deserve a huge thanks for this; almost half of the tools I’ve collected have come from them. Their Content Strategy Generator Tool is an amazing piece of work that gives you more trending headlines and topics on a keyword search than you could possibly handle in one sitting. Couple this with the link prospecting tool, and you’ll never be able to use the “writer’s block” excuse again.

This tool doesn’t take much explanation: the results speak for themselves. Drop a topical keyword in the query box (currently holds “hotel”) and watch the magic happen. The sheet will automagically pull top news headlines, tweets, YouTube videos, Digg and Reddit results, Topsy results, Yahoo! Answers, Blog Catalog results, Fark articles and more. I know, I cried too.

This sheet will keep your finger firmly on the pulse of the news in your niche. Just thinking about the possibilities makes me salivate.

SERP Competitive Analysis

SERP Competitive Analysis - Make a Copy
SERP Competitive Analysis - Instructions

Distilled practically sweats innovation and tools, and this one from Tom Anthony is a salty, gorgeous example of that.

When you want to analyze keyword competition quickly, you can crack open this spreadsheet and see the MozRank, domain authority and number of linking root domains.

It’s also a great way to give a client an at-a-glance look at what they’re up against. Maybe it will help them manage their expectations when they’re telling you to get them to rank #1 for “credit cards.” ;)

Oh, and remember when I said you’d need a Linkscape API token? That time is now.

SEOmoz API for Google Docs

SEOmoz API for Google Docs - Make a Copy
SEOmoz API for Google Docs - Instructions

This one is pretty self-explanatory; it pulls Linkscape/OpenSiteExplorer data into a Google spreadsheet. This is a great baseline template for rolling your own competitive analysis tools and the like. I don’t really feel like this needs more explanation, so go in and mess around with it. If you break it, just make a new copy from the link above

Original Article Here 

CRO VS SEO por Agencia365