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
-
Competitor ranks high, but how?
On our campaign, I have three local competitors which I like to keep an eye on. Two have been around for years but the other is pretty new. According to Moz, he has a Domain Authority of 1, has no backlinks and ranks lower on every keyword I keep track of. How then is he getting ahead of us for certain search terms? Can Moz not give any more information?
Competitive Research | | robandsarahgillespie0 -
Fast Multiple Keyword research
Does anyone know of a good tool to drop a list of keywords into and get competitive and search volume results from? Don't want to have to enter them one by one to the Google KWT.
Competitive Research | | AESEO0 -
Lins Missing in OpenSiteExplorer
Hi There, I have just signed to SEOMoZ to try to uncover what some of the competition are doing links wise. I have noticed that there are so many missing in my report that are definitely live and working. I have read that in some cases it takes a while but i have also read on the forum that opensiteexplorer will only find up to 25% of all links. This is the same with my competitors links then. So i can only find a 1/4 of what's in place? Is this the case or am i missing something? Many Thanks
Competitive Research | | AbsoluteMike0 -
Competitor Keyword Rankings
Is there a way within SEOMoz to uncover the keywords your competitors rank for and their respective SERPs? Thx
Competitive Research | | qiherbs.com1 -
Comparing competitor folder path
Hi All I've just take on a new client and need to be able to compare their performance with a competitor's sub-folder site. The competitor is http://thebestof.co.uk/local/brightonandhove/ I've tried to add that to the competition structure in my campaign but can't use "Path" info. What do you guys do in these types of cases. BTW - TheBestOf.co.uk is a franchise with a /local/CityNames across the UK
Competitive Research | | stevecounsell0 -
How can I add more than 3 competitors
Is there some way to add more than 3 competitors to the tool to benchmark against?
Competitive Research | | lockwoodl1 -
Competitor Ranking High has 2 Domains, But Duplicate Website ?
I was using OSE and noticed all the backlinks to one of our competitors is there other domain name, which is the EXACT SAME website. You can enter both url's and they display the same content. They are not useing any canonical tags either. Why are they not penalized for duplicate content? And for using there own website for backlinks ? We try to do everything right, but still cannot beat them. Any thoughts on this?
Competitive Research | | hfranz0 -
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