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
-
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 -
Reaching out to all SEO experts for exciting new brand and project
Hi everyone! We're a beauty and travel ecomm brand looking to hire an SEO consultant (independent contractors only - no agencies please) on a contract basis to join our team. We're fast-growing and need help to optimize our on-site and off-site SEO efforts (www.shopsphynx.com). Please message me directly if you're interested in working with us. Below is a little more about us. Thanks! About Us: We recently launched with our first line of products - a new and innovative 3-in-1 travel razor for women that includes a water spray bottle, moisturizing shave bar and two razors all in one compact case. We've received tons of press for the product's unique design and innovation within the shaving industry (and are also in over 900 retail stores nationwide), and only recently launched our new site on shopify (two weeks ago) to drive our B2C sales. There's a lot of room for SEO improvement in terms of on-site efforts, as well as some guidance we'd like to receive for off-site SEO strategies, so we can build up our traffic, audience and customer base. We're targeting a big market & demographic of young women (ages 19-35), mainly competing with Gillette and Schick for a product segment that has largely gone untouched for decades. We'd like to change that 🙂 Let me know if you're interested! Thanks.
Competitive Research | | shopsphynx0 -
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 -
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 -
What's the best SEO way to benefit from your competitor's shutting down?
Hi ! Our main competitor is shutting down (website will be offline) at the end of the month and we are negotiating with them to buy their domain name: the idea would be to take advantage of their good rankings in the SERPs to redirect traffic to our pages (we're planning to crawl their site or get their sitemap and redirect th category / product pages to ours). The question is: for how long this strategy will be useful: days / weeks / months? (= for how long their pages will continue to appear in the SERPs from the day we enable the 301 redirections to our site?) Thanks in advance for your help! And if you have better suggestions, we're up to hear them of course.. 😉 Cheers
Competitive Research | | Kuantokusta0 -
Improving SERP rankings via strategic SEO tactics
Hi, We just build some of our new content pages on our website 1.https://www.practo.com/ray/dental-software 2.https://www.practo.com/ray/dermatology-software 3.https://www.practo.com/ray/homeopathy-software Could someone explain how do I build around a good SEO strategy to compete with others for better positions on the SERP's. I have not done anything apart from fixing proper title tags , and meta descriptions etc and of course putting down relevant fresh content onto these pages. These pages were published about 3 weeks ago - Only this url ranks on the 2nd page as of now for keywords like "dermatology software" https://www.practo.com/ray/dermatology-software The rest of the URL's do not rank anywhere till the 10th SERP too! What could be wrong and where could I have the opportunity to boost the SEO tactics since all the pages which rank above it are just not providing the right kind of product as we are and still they take up the top positions and genuine users miss out on our domain. Thanks . Looking forward to some awesome responses.
Competitive Research | | shanky10 -
What is the difference between "external backlinks" & "referring domains" on Majestic SEO?
According to Majestic SEO's glossary, a "Referring domain, also known as "ref domain", is a domain from which a backlink is pointing to a page or link." Given this definition, I'm not sure what an external backlink is?
Competitive Research | | nicole.healthline0 -
Starting SEO
Hi everyone, I am new to SEO basically learning as I go and trying to catch up on all of the information needed to successfully move a website up the search engine ranks. The website I am trying to optimize is www.luxurylifestylevacationhomes.com/. Right now I have determined which keywords I want to use, I have saturated them into the website in an organic way and have submitted the sites to various engines, also I have created a Facebook fan page which has 606 active monthly users in it's first month ( I don't know if that's a great number), as well as started writing a blog where I am putting links to the page in each relevant blog. My question has 3 parts 1. what else should I be doing to improve my ranking? 2. how do I find quality relevant websites that want to link exchange? 3. What is the best way to really get volume/ quality links to a relatively unknown site?Any advice or Ideas help and are very appreciated. Thanks
Competitive Research | | Future130