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
-
Ahrefs Much Higher Than Competitors But Competitors Doing Significantly More Traffic?
Hey guys, I'm baffled by checking my Ahrefs ratings lately. It looks like our rating just went up considerably... from over 1 million to now around 500k. One of my main competitors, however, has a much lower Ahrefs rank (over 3 million) but he does a considerable more amount of traffic than we do... how is this? My domain rating is higher than his by a lot. Very curious how this works.
Competitive Research | | jfishe19880 -
What a Brand should do first for Their Blog Keyword Research or Topic Research?
Hello Moz Community, Need your help guys. What a Brand should do first for their Blog? Keyword Research or Topic Research? Like for the Brand Product page/ eCom Pages, it's quite easy > 1. Buy "Product" Online
Competitive Research | | Max_
2. Buy "Product" "Geo."
3. Product Reviews [for Guest Posting or Reviews]
4. Best "Product" Online and so But, for the blog, it's tough for searching out the keywords that will work if the SEO team or the keyword research team is not aware or don't have the detailed knowledge about the niche they are working on. Please verify: Is it a correct method that an editor should provide a "topic" to the SEO team to find relevant keywords by using a Keyword Research tool that there are enough searches for it which can provide benefits to the blog via the search engine.0 -
Why competitors rank with no content & filters
We're investing a lot in on-page content and creating categories/sub categories to target relevant keywords. Although it seems competitors with high domain authorities are clearly dominating in the SERPs and the pages have NO content. They are literally filters that create landing pages. For example when you search "Kaydian Beds", Debenhams rank below the manufacturer with just a filtered page, this page has not been optimised with content to target the keywords, only the META title changes depending on the chosen filter. Link: http://www.debenhams.com/furniture/beds/kaydian Our link: https://kontenta.co.uk/brands/kaydian-beds.html This is very frustrating as quality content should beat pages with little or no content, we will spend some time and get some inbound links to the page to try boost the rankings but does anyone have any similar experiences with anything like this?
Competitive Research | | Jseddon921 -
How much should I analyze my competitors?
Hi, Recently I've started a competitor research (aka competitive analysis). A few hours after I began, I've started to feel that maybe I'm doing too much unnecessary work. What I've been doing so far is analyzing the competitor's links (using the Dr Pete's Link Profiling excel and some other things), and their site optimization. The on-site optimization analysis has been very light, just to see if the competitors are doing something really well, or not. But still, I think that maybe I'm doing too much work. So, I'd like to see your thoughs: How much work is necessary when doing competitor analysis? What things do you analyse? And how much do you report to the clients? Thank you all in advance! Ivan
Competitive Research | | ivankrm0 -
Competitor Traffic
Is there any way to know what a competitors traffic is? My website seems to be continuously falling despite attempts to fix and just curious if it's us or an industry issue? Thanks in advance
Competitive Research | | Professor0 -
Best Way to Consolidate Domains/Rankings After Purchase of Competitor
One of my customers is buying a competitor. The competitor has a site that usually ranks just 1-2 spots below the main site that we manage for them (our site has been up for about a year, and their's is 15-years old). I am wondering what is the best way to consolidate the rankings/websites to take advantage of the purchase of the competitor's web assets. I would love to leave both sites up and just get 2 top-25 links to our products, but with no more marketing being done under the competitor's name, I assume their rankings will degrade. Would a basic 301 re-direct on a page-by-page basis be enough to 'steal' all of the juice their domain name/site has built? Is there some other method of using an older domain to boost the rankings of a newer one (I am assuming they only rank as well as we do because of how long they've been active - all of our metrics are better than theirs across the board). Thanks for any help/advice the community here can provide!
Competitive Research | | dschapira0 -
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 -
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