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 -
SEO newbie here - I cannot seem to find the direct answers to a few queries that I have
Hi, Apologies if these are very simple queries, but I cannot seem to find the answers anywhere. I understand meta keywords are pretty much pointless nowadays, however when I run a report on another 'keyword website' - my website only ranks for around 2k keywords where my competitors rank for much more (around 20k). I was just wondering where these keywords are found, as I can only assume that these are meta keywords? The company that I'm working on the SEO for is a holiday agency that specialises in holidays abroad for disabled people, so that means that we have a niche product/service and whilst we rank fairly high for some keywords, we would like to rank higher. How is it possible to work towards ranking higher for particular keywords? When doing keyword research 'disabled holidays' has a lot more search traffic than 'accessible holidays'. We are called Enable Holidays and our main competitors have the words 'disabled' and 'accessible' in their domain's, so I would imagine that it's going to be hard to potentially rank higher than our competitors for these keywords? Could someone put me in the right direction of how you improve rankings in the SERP for certain keyword searches? For example, do we have to write more content on a certain page about a keyword? Do we have to include more long-tail keywords in the content? Any help is appreciated. Thanks
Competitive Research | | enableholidays0 -
Pre Launch New Website SEO Best Practices
Hi All, I am currently mid development of a website (no testing page yet) and want to make sure I am doing my due diligence in regards to SEO. Are there best practices to always complete while a website is being built? If so what are they? I've gotten to the stage where I've read every blog on the planet and now maybe too much info. I am also focusing my Keyword Analysis around competitor research to write great copy from, but seem to be falling down a rabbit hole of way too many keywords. Is there agencies/services that would just be hired to do Keyword Research for my needs? Thanks a lot!
Competitive Research | | Krackle0 -
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 -
SEO Keyword Research
Hi, We are SEO beginners so please bear with us! We are trying to promote "Web based Invoicing Software". The SEO company we have signed with offer us 5 keywords for the package we are on with them. They have suggested\offered us: 1. Invoicing Software - Fine
Competitive Research | | Studio33
2. Online Invoicing - Fine
3. Online Invoicing Software - Covered by 1 and 2
4. Small Business Invoicing Software - Covered by 1
5. Invoice Template - Fine. Will Invoice templateS be covered on this one too? My question is does number 3 cover number 1,2 & 4 anyway? If so I am thinking to not go for 1,2, & 4 just keep 3 and choose three other new keywords. Would this be a better strategy and "more for our money?" Or, keep 1 and 2 and lose 3 and 4, would that be a good option. So, in summary options are (all assuming keeping number 5) 1. Keep all
2. Keep 1 & 2 - Lose 3 & 4
3. Keep 3 - Lose 1,2 & 4 4. Any other combo you can suggest? Any advice welcomed Thanks nutnut0 -
Training Recommendation for In House SEO
Hi, I'm a business owner who has been dabbling in SEO for years. I have a bright, capable employee with a development/coding background and I would like her to start doing full time SEO for me. (competitive analysis, link building and content marketing specifically - I like the strategy laid out here and would like her to implement it for me) What do you think is the best training resource for her to develop an in-depth understanding of SEO for my business? Any recommendations for specific courses she can take? Thanks.
Competitive Research | | plrkieran0 -
Local SEO questions
Been getting into Local SEO a bit but still not completely up to speed on a few things. Would appreciate any input by experienced local SEO's to any parts of this: Ill ask my broader questions within the context of an example. I have a client who is a part of a keyword niche that isn't exactly what Google might consider "local". What i mean by this is that if you are a car accident lawyer and you type this into Google Google with spit out local results because it seems to know which terms are searched for with intent to find local results. This client makes essentially medical form software which I dont get any local results for when I search for their keywords. But they do have a local focus as in they have an address in a city which is a target market. The client told me they are looking to target other markets nationally as well down the road. However they don't have brick and mortar locations for these other cities so I am under the impression that it wouldn't be something we could target locally. This brings up a strange question in my mind though - if you need an address for a physical location for each city you want target...if you want to target the whole country locally, you would need to have a location in every city? Is there any way to target local focus without purchasing a new office in every city you target? Or can you target a state with one office etc or is Google bond things down to cities or understood regions? Does it sound like this company should even be doing local? The last part to this is whether or not there is any way (tool?) to figure out what local areas are searching for you keywords? Why doesn't Google allow us to use the Keyword Search Tool to see traffic etc for more than just a nation or the globe? What I would love to see is, which cities get the most traffic for X keyword term and have the lowest competition. Then it might justify having to buy some Regis office in a random location. I feel like this doesn't exist but maybe some of you have some ideas to direct me...
Competitive Research | | eastco0
