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.
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
-
What are some good SEO tactics to defend our position against an upcoming competition in a near monopolistic market?
I'm doing SEO for a medium sized client whose area of business is targeting a very niche audience, in an almost monopolistic market. We're currently in top 3 ranks in our head terms. However, market research has indicated the threat from an upcoming competitor. The competitor is relatively larger and is well established in other countries. Is there something I could do from my end to defend/maintain our current position?
Competitive Research | | iQuanti0 -
Price for SEO Audit & Strategy
Hello, I am a part-time SEO and own a few web properties, in addition to owning other small businesses. I do the best I can in my spare time to grow my site's traffic and try to create decently valuable content. However, I feel like I am not getting the best results possible, so I am wondering if anyone on here would be interested in helping me with a site audit and strategy. I can do the grunt work myself, I just want someone with a fresh perspective to weigh in and guide me on what I should focus on to achieve my goals. Please let me know if you're interested and how much it may cost. A range is fine. Here are the specs on my site & niche: About 20 pages of content, most of which have 96-100 page optimization scores on Moz. DA of 19, home PA 32 Most competitive KW is 22 difficulty, 83 opp and 67 potential. Thanks so much, any insight is much appreciated. Please respond here or DM me directly. Best, Ricardo
Competitive Research | | myriad_ricardo1 -
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 -
Ecommerce seo - competitors are using spammy links to rank HELP
After setting up SEO Moz and whilst waiting for it to crawl my site i have checked out my competitors who are ranking for the keywords i am going after. It appears from what i can see in OSE that they are ranking with back links from spammy looking sites and lots of exact match anchor text. I have tried to match a few links with what they have currently without getting myself into anything too spammy but i really don't want to follow how they have done it exactly. The niche i am in is pretty boring but the rewards are great but i am finding creating content and distributing it correctly difficult which is why i need some help. My site is roughly 9 months old and the product descriptions are hand written trying to give as much info as possible with a hint of personality so no cookie cutter back of the box descriptions. i have matched a few of the links from competitors which weren't too spammy and as relevant as i could get to my niche, i have also created articles for some article directories - all of which isn't really getting me very far and i am running out of ideas on how to create new content & the types of new content to help me get back links naturally. If any of you friendly guys could offer me some assistance in setting up a basic seo campaign which would help me target my keywords i would be very much in your debt
Competitive Research | | GarethEJones0 -
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 -
Ahrefs or Majestic SEO
Hi Guys, I'm looking to purchase 1 of the above services and I'm just wondering which one you guys think is best? Looking a ahrefs they seem to update there index more often. Thanks, Scott
Competitive Research | | ScottBaxterWW0 -
SEO Strategy Questions on an International Domain
I'm going to try not to get too wordy with my question. Any help that could be provided would be much appreciated! We recently purchased a Germany-based company. They were using two domains (possibly more) for their website. Domain1 and Domain2. I'm sure for duplicate content reasons, only Domain1 ranked well. We in the US wanted to use Domain2, as it contains the brand name and would add legitimacy to our website in the US. Problem is that they also wanted to use it in Germany. So we split it using GeoDNS. Any international traffic goes to their server. Any US/Canada traffic goes to ours. From what I've read, we in the US should have the advantage here in terms of getting our pages indexed on Google, because Google will crawl from the US. So to Google, it should be as if we've changed all of our URLs. The problem is that Google has not recognized these changes for our homepage and it has been about a month since I submitted a sitemap and changed our geo-targeting to the US in Webmaster tools. They've picked up other pages of ours, but the Title and Meta descriptions for the homepage are in German still. We also rank about 23rd for our own brand name. Bing and Yahoo have picked up the changes without issue and we rank 2nd for our brand name. My other issue is that the old distributor in the US (whom we have replaced) is ranking first for our brand name. I'm working on increasing our inbound links, but is there anything else I could be doing to jump ahead of them in the rankings? Any tips would be appreciated. Thanks!
Competitive Research | | KathleenLTG0 -
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