Excel workbook for SEO?
-
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!
-
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.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Improving SEO for a Niche Blog - Seeking Advice
I am a college student studying Information Sciences and was "hired" by my uncle over the summer to work and maintain his baseball-related website, which he started in 2016. His posts provide very in-depth information but were created without a focus on SEO. I've noticed that a competing site, which seems to have started as an e-commerce site, is ranking higher than my uncle's site for the query "how much does a baseball weigh." Interestingly, this competing site ranks for keywords like "mass of baseball," even though these exact keywords are not present in the post. Given the recent Google updates and changes in rankings, I'm trying to understand: How can an e-commerce site with seemingly less specific content outrank a detailed blog post?
Competitive Research | | sf9090
What strategies can I employ to improve the ranking of my uncle's site for this specific query?
Are there tools or methods I can use to analyze why the competitor is ranking higher and how to address it?
I recognize I am not well-versed in SEO, so any insights or advice would be greatly appreciated. Thanks!0 -
Competitors ranking in top three with worse SEO
Ok I am at a loss. Our client is trying to rank for keywords like "dental assistant programs utah", but they are still on the bottom of page 1/top of page 2. The guys in the top 3 have terrible SEO. No links, newer domains, etc. I looked into it extensively and learned about the "honeymoon period" people talk about but we are long past that. I've looked through webmaster tools to see if there are any issues, and I can't find a thing. Anyone have an idea of what we could be doing wrong that is making us be put down so far on the page? Before I got here the SEO guys were doing older tactics which I think was starting to hurt them with penguin and what not so I tried my best to delete the crap content and clean everything up on the website. thanks for all your help! I really appreciate it.
Competitive Research | | boyackp0 -
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 | | Sugartheagency0 -
Cognitive seo
What is your experience with congnitiveseo software? thanks
Competitive Research | | maestrosonrisas0 -
Working through the slides on my first seo project, I'm trying to determine the most popular content on competition sites.
From the video, I understand I should be looking for unique opportunities. But is there a baseline for product qualification, ie., a min. PA,LRD, Inbound LInks, social shares, etc. I guess I'm asking what I should be looking for in the data provided on each competing site? What determines THE most popular and unique product?
Competitive Research | | AhmadS0 -
I must be tripping. How is this site ranking for the term "SEO Company"??????
When I go to Google non-custom search results and search the term: seo company The website "greencowseo.com" is ranked 3rd. OpenSiteSearch shows nothing. And get this... the domain was registered 14 days ago by somebody in Egypt. Do I need to quit my SEO Moz membership and hire this guy? 🙂
Competitive Research | | Bo-Jangles0 -
How due I take the advanced report that i have exported as a excel file and recreate your online color coded version with the data.
In the keyword difficulty screen how do I recreate your beutiful color coded spreadsheet in the exported excel file based on the advanced reports.
Competitive Research | | bmcfarlane0 -
How do you perform competitive research for SEO?
What metrics tell you the most when you're looking at your competitors across the search landscape? PageRank/MozRank Inbound links Keyword rankings Alexa/QuantCast/etc. Pages indexed Something else entirely? What numbers speak volumes to you when you want to get an idea of how you benchmark against your competitors? And how do you communicate these results?
Competitive Research | | jcolman2