Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Excel workbook for SEO?

Competitive Research

737

adriandg last edited by

A while back someone on here posted a really good workbook for analyzing ranking factors for competitors. Unfortunately I lost it, and I am hoping someone might know what i'm talking about and hit me up with a link to it, or perhaps your favourite seo workbook for excel?

Thanks!
1 Reply Last reply
Reply Quote 0
adriandg last edited by

So this is the one i was thinking about: https://seomoz.box.com/shared/g3vz0kxbbp

but is there anything more recent than that? it says those files are from 2010.
1 Reply Last reply
Reply Quote 0

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

Which SEO Metric is the most Important?

Hello There are many SEO metrics like DA or MozTrust and even Other metrics such as cognitive SEO metric.
Competitive Research | | siteBaNa

0
SEOMOZ EXCEL PLUGIN ARRAY FORMATTING

Morning All, I have followed along, and am trying to build my own " dashboard", SEOmoz API in Excel, to get the Domain Authority and MozRank for a bunch of URLs. I have a list of competitor sites / related competitors, and I want to pull in the moz url metrics so I can decide who to investigate further. I'm using this array SEOMOZ_URKMETRICS_toFit(A2,"Cols=128" and it keeps listing the results vertically. All the tutorials show this lovely link data in horzontal rows to the right of the url in question, but mine doesn't want to behave. PS. I do know the bit data is wrong, I'll fix that. Thanks in advance to anyone who can help.
Competitive Research | | Sugartheagency

0
How Do You Create an excel spreadsheet of all blog post content on a site?

Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.? I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?
Competitive Research | | RonMedlin

0
Is there a SEO Moz Competitor Analasys tool that will show me how many Vistors their site receives?

I'm trying to find out how much traffic a competitor gets. Is there an SEOmoz tool for this?
Competitive Research | | starkSEO

0
I am stumped on this one... SEOs Assemble! *blows seo horn*

Hi guys, I am having a little trouble with one of my sites. I am trying to rank for a particular keyword, which is the same as my domain name. I have the keyword.com and my competitor has the keyword.co.uk Please see the screenshot below to show our back link comparisions. I don't understand how the mozrank and moz trust are calculated as I am getting beat here. They rank first in Google UK and I rank 10th. Both of our sites are well seo'd by professional companies so I am baffled how, with this profile and a diverse set of anchor text links, I am getting beat. I would really appreciate any help and advice on this guys... Thank you backlinkcomparison.jpg
Competitive Research | | MirandaP

2
Free SEO tools appearing in SERPS for a site

Hi there, I've just taken over a site and it doesn't have a huge amount of shelfspace on the SERPs for it's brand name. Looking at the results that are there are a lot of free SEO tools that are coming up. They haven't had an SEO before so it's not coming from their side. There's such a lot of them I was wondering if anyone had come across this before - is it simply a competitor looking at the seo, could it be one of the seo analytics packages using free sites or is there anything else to be aware of. I can start knocking the sites down the SERPs but just wondering if anyone has a good solution for this. thanks Shiv
Competitive Research | | Shivvyt

0
I would like a good SEO company

Hi, I know this must be a repeated question but I would like to have an SEO company that would take care of getting my site on the top three pages of google and I would like some advice over my website. I have been investing in link building for a month now but I think my meta tag might not be the most appropriate, i should probably have various and came across your website. I have found zero negative feed back on your company, I run other business but this is my first online experience and don't have the time to give it the SEO so with that in mind I would like to know what SEO packages would you recommend for my business and in what time would I be seeing page ranks in google bing and yahoo. I hope you can help me out, I'm a newbie at this and my online business is interesting and want to see it already operating my website is sheep buy.com, concept is people can sell for free, not just post an item like a classified site but actually sell for free through paypal and we don't charge a fee, so would really want some insight. Hope you can help me out. Beat regards Jerry
Competitive Research | | Jerrysb

0
How to select appropriate keywords to optimize for SEO?

I have an e-learning website called www.graduatetestprep.com and we provide university students preparation for the GRE examination. This is an entrance exam required for admittance to graduate school across the US. I was wondering what is the best way to find the best keywords focus on to optimize on google and the other search engines. I feel I can't use "on-page" on pro-dashboard properly unless I have the right keywords to focus on. Thanks
Competitive Research | | anuraag

0