Missing tab in Competitor research Template
-
The template provided in https://moz.com/blog/competitor-analysis-for-seo is missing the 'Audit Data' Tab.
Can you please update it or share the Original Template
-
This Google Sheet is great but I am experiencing the same issue. This updated sheet now includes the Audit Data tab but when I fill in the Keywords on respective competitor tabs the Keyword Gap Analysis sheet shows some rows but definitely not all the data. I saw your response saying this is awesome", did you get it resolved? Would you please share the updated sheet? Thank you!
-
This is AWESOME Oliver, THANK YOU!!!
-
Hello thirdwavellc.
To make things easier, I've made a complete spreadsheet template that you can just update. It is a modified version of the one John Michael posted on in the MOZ Blog but this one has the "Audit Data" tag added it. I also had to make a change to the way the Keyword Gap Analysis tab was counting. All good now
**Here is a link to the fixed spreadsheet: FIXED - Competitor Analysis Template **
Here is a link to a video screen share: Walkthrough of Competitor Analysis TemplateLet me know if you have any questions and I hope this helps.
-oliver-
Friend In Commerce -
Thanks Oliver for this. Unfortunately after adding the sheet, it still does not work for me. I even changed the name of the sheet to 'Audit Data'.
Also, the Keyword Gap Analysis sheet is not really working. I did not use SEMRush for my keywords as mentioned in the original article. I used Adwords and just pasted the Keywords and deleted all the other data. The populated data in the Keyword Gap Analysis looks weird, most likely not correct.
Any help would be GREATLY appreciated.
Regards
-
I've had the same issue and was able to fix things by creating a new tab (sheet) in the Competitor Analysis Template. It works for me now, and I haven't seen any issues. Here is a link to an AUDIT DATA sheet I create that you can insert into your current Competitor Analysis template. Let me know if you have any issues. Good luck!
**Here is a link to the fixed spreadsheet: FIXED - Competitor Analysis Template **
Here is a link to a video screen share: Walkthrough of Competitor Analysis Template-oliver-
Friend In Commerce
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
-
How do we find keyword opportunities - but not just against 3 competitors...
Hello everyone! How can I find out what might be a keyword opportunity against a competitor but make sure it's still a realistic opportunity in SERPS generally?* After all, we are not just competing with 2 or 3 competitors. We are competing against everyone! Perhaps there is a part of the keyword research process that helps? I can't help but think there's a wasted effort to just beat a couple of competitors unless you can rank well generally - especially if it's a competitive sector. (*I'm not in the position of making lots of pages as part of a long-tail keyword/ content strategy so I need to focus on just a few and make them count) Thanks in advance. Mp
Competitive Research | | mark_seomoz10 -
What's a good way to get started with competitive research?
Hi all, SEO noob here. I'm doing an audit for a firm that makes specialized accounting software. It's a relatively new firm, with a barebones website. My client has identified three direct business competitors. In addition, I see indirect competitors (such as product reviews) on the SERP for a relevant keyword phrase. I want to provide actionable advice for my client. What information should I present? I'd like to help my client understand: Why my client's competitors are outperforming them on the SERPs What my client needs to do to overtake their competitors What information should I present to my client? Thanks, all.
Competitive Research | | AndyKubrin0 -
How can I find out the exact match visitors for a competitor's website?
Hi, I'm trying to find a way of finding out the estimated number of exact match visitors that a competitor's website has got. I know that SEO agencies can find this out, and there must be a way of doing this for myself. Thanks
Competitive Research | | MThacker0 -
I am looking to find the top pages based on traffic volume on my competitors websites, does anyone know of any good resources?
I want to know how which pages on my competitors websites are the most popular based on the traffic volume. I do not care how many links or directed to that page or any other metric. Only thing I am looking for is the traffic volume. It would also be nice to know the length of time spent on that page.
Competitive Research | | kanteenboy0 -
Competitors SERP's
One of our competitors is routinely achieving excellent SERP for brand related keywords within only a couple of months of adding the respective brand to their website. Full details are explained in the attached image to avoid the competitor being notified of this post via Google Alerts. Can anyone identify how they are achieving this and point me in the right direction? The other thing is that I was also achieving good SERPs for these and other brand related keywords but I seem to have dropped off the face of google for them, where my competitor has not and who continues to achieve the seemingly impossible. Thanks TOfVHD8
Competitive Research | | UnderMe0 -
Our site being outranked by competitors with lower "moz" scores - due to on-page SEO?
Howdy, Our SEO efforts are doing well, but for a few keywords it seems we cannot budge one of the competitors sitting in spot #1. Through some competitive analysis I've noticed that our website has a much higher mozRank with regards to both page and domain compared to the current #1 spot. My question is what kind of factors could be the issue as to why we are still being outranked. Is it simply a case of poor on-page SEO at this point or should I be taking the mozRanks with a grain of salt.
Competitive Research | | marketingdepartment.ch0 -
Competitive Link Research Tool is not working
I receive a busy message each time I try. This has been out of commission the last several times I've tried it.
Competitive Research | | cmiller0 -
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