Posts Tagged ‘google docs’

Google Docs, and efficient was to produce competitive Analysis in less than a minute

Google Docs, and efficient was to produce competitive Analysis in less than a minute

Google Docs, and efficient was to produce competitive Analysis in less than a minute

This Article is all about Competitive analysis in under 60 seconds

Now let us go through about this article and will analysis it

First we will look into the point

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 SERP’s

The basic for this tool comes from a report in this link
but in response to afew people asking about for a tool

these all we can rate by a graphics report

This was his first real foray into google docs , so it might not be particular elegant thanks for this article given to me.

So, what’s the report all about? It is a pretty standard report, and most SEOs will have put together similar reports in their time. It shows which domains are dominating the results pages for the specified list of keywords. It is an excellent way to quickly see who the main players are, and see a few metrics for them.

Ours will be sorted by the cumulative number of times a subdomain has appeared in the top 10 of the search results over all the keywords we specify, and will display the mozRank, Domain Authority and Linking Root Domains for each. We’ll show just the top 10 competitors in our report.

You can just duplicate the Google Docs spreadsheet I provide below, and change almost any of this to add, modify or take away as per your needs.

ou must configure it the first time you use it:

1) If you’ve not yet done so, get a SEOmoz API key. Its free!

2) Open the Google Docs spreadsheet. In File menu select ‘Make a copy’ so you have a version you can edit (call it “Report Template” or such).

3) Go to the ‘Config’ sheet at the bottom, and enter your SEOmoz API details.

4) If you’d like to change the template for which Google URL to do (it defaults to UK for me), you can do that here too.

Read the full article here:

Competitive Analysis in Under 60 Seconds Using Google Docs

Share
Read full storyComments { 0 }

How To Use Google Docs for Competitive Analysis

How To Use Google Docs for Competitive Analysis

How To Use Google Docs for Competitive Analysis

This Article is all about Competitive analysis in under 60 seconds

Now let us go through about this article and will analysis it

First we will look into the point

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 SERP’s

The basic for this tool comes from a report in this link
but in response to afew people asking about for a tool

these all we can rate by a graphics report

This was his first real foray into google docs , so it might not be particular elegant
thanks for this article given to me

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.

Read the full article here:

Competitive Analysis in Under 60 Seconds Using Google Docs

Share
Read full storyComments { 0 }

Use Google Docs for Competitive Analysis Under Sixty Seconds

Use Google Docs for Competitive Analysis Under Sixty Seconds

Use Google Docs for Competitive Analysis Under Sixty Seconds

This Article is all about Competitive analysis in under 60 seconds

Now let us go through about this article and will analysis it

First we will look into the point

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 SERP’s

The basic for this tool comes from a report in this link
but in response to afew people asking about for a tool

these all we can rate by a graphics report

This was his first real foray into google docs , so it might not be particular elegant
thanks for this article given to me

Read the full article here:

Competitive Analysis in Under 60 Seconds Using Google Docs

Share
Read full storyComments { 0 }