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
-
Why our competitor has bigger DA?
I just compare our website www.simpletranslation.com with one of our competitor www.straker.com.au and their DA is much better than ours even we have more external backlinks. Can somebody explain me why? We worked really hard on new content on our blog and did few guest posts and instead of see some results on increasing of our DA our DA went down in last 2 months and I have no idea why.
Competitive Research | | Lukas-ST0 -
Best competitor analysis tool comparing my links with competitor links?
Hello All, Can anyone tell me best competitor analysis tool comparing my links with competitor links? Tool which define quality of links either low quality or spammy links etc? Thanks!
Competitive Research | | devdan0 -
Tool for finding what keywords a competitor ranks for?
Does anyone know of any good tools that display what keywords a competitor ranks for? I have many competitors that I know get a lot of traffic, but I'm not entirely sure where the traffic comes from so it would be nice to plug in their url and get a general overview of what keywords they rank for and what positions.
Competitive Research | | shawn810 -
How to track competitor who uses another website on the url?
Hi everyone, The thing is pretty simple: I have a competitor who uses a different format of url, very similar to this: www.example.com - but he started to use a thing like this: example.mtv.com The problem is that every analysis that I make tell me something about mtv.com instead of the site I want. The url is redirected. Sorry about my english, but I think it is very clear. I want to know how to track something like this, because even in competitor analysis I'm getting info about the big site, and not the one I need. Thank you very much.
Competitive Research | | bluehelmet0 -
What am I Missing on a Simple Targeted Phrase?
We have a bundle product page with a unique title, description and image. Other companies have similar items, but not a duplicate of what we offer. There are a few key phrases that we are trying to target with this product because they describe the product perfectly by nature. There are other similar ranking conundrums on our site, but I chose to ask about this one because it is a fairly simple and straight forward case. Attached is the ranking difficulty tool results. From this test, I don't see any reason why the number 1 ranking is better than our page in the SE's eyes. We don't have any problems or warnings in WMT either. I'm open to ideas/suggestions on why our pages are ranked so much lower for a simple search term. I have tried tweaking the title, text and added internal/external links as well as built social indicators. Nothing is making the difference I'm expecting. Because this is a fairly non-competitive, low-income phrase, I figured it would be easy to move up the rankings. I'm almost thinking it has more to do with our site template/design than anything, but that's hard for me to say. [Our site is 19&20 in the report] 8MXHJ.png
Competitive Research | | iJeep0 -
Competitor analysis
Hi This is obviously a well worn question (I've read the great blog by Sam Crocker last year - see below), but I'm looking for an updated set of opinions on sources of competitor data. The competitor data I'm interested in is traffic volumes either aggregated or disaggregated by referral source (i.e. organic search, PPC, email, social etc.). The types of data I've checked so far are Google Trends for websites (no disaggregation), Alexa (some good sources of free data) and Experian's Hitwise (too expensive for my current needs). In addition I'm aware that Compete will be providing an interface for such data in the UK in January at reasonable rates for what I'm after. I'm interested in views on these and other sources in relation to experience of their relative accuracy, costs, pros, con etc. Ideally I'm looking for something that is free, comprehensive, and is not being used by the competition - is that too much to ask!!! 😉 Any inputs would be greatly appeciated. Thanks in advance! Neil Sam's great blog: http://www.seomoz.org/blog/monitor-competitor-traffic
Competitive Research | | mccormackmorrison0 -
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 -
Whats the best way to see why your competitor is out ranking you?
I am trying to rank in the number on position for Part Time CFO. Currently we are in 2nd and 3rd. We have way more quality inbound links then the site in first position, more content etc. How would you go about investigating why they are ahead of us?
Competitive Research | | b2bcfo0