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
-
I can see competitors ranking for certain long-tail keywords but cannot find them on web pages. What am I missing?
Hi there. I'm pretty new to SEO and I've been doing a fair bit of training but there is one aspect I have yet to grasp. When I carry out keyword research, I get all these results and I understand the metrics. What I'm not getting is, when a competitor is ranking highly for say "where can I buy fresh turkeys", I assume that that phrase must appear somewhere on the page, but it doesn't. I realise I'm just not thinking about this in the right way. Can anyone offer clarification, please? Kind regards, Bruce
Competitive Research | | BruceBarbour0 -
My competitor's sneaky link building technique
Hi, I can't figure out how my competitor seems to fit four invisible nav menus into her home page. If you view her page source and type "/about" for example, it shows five examples of the text linking to her "about" page. But four of them can't be located on the web page (they are hidden). How does she do this? She basically has four duplicate links that are counted for SEO but can't be seen on the webpage. address: http:// camilla peffer.com. au/ Any ideas?
Competitive Research | | SleekCopy0 -
Subdomain Research Tool
Does anybody know of a research tool that can track the amount of subdomains on a root domain? Maybe there is a way to manipulate a Google search to display the different subdomains that are indexed?
Competitive Research | | iSTORM-New-Media0 -
SEO Keyword Research
Hi, We are SEO beginners so please bear with us! We are trying to promote "Web based Invoicing Software". The SEO company we have signed with offer us 5 keywords for the package we are on with them. They have suggested\offered us: 1. Invoicing Software - Fine
Competitive Research | | Studio33
2. Online Invoicing - Fine
3. Online Invoicing Software - Covered by 1 and 2
4. Small Business Invoicing Software - Covered by 1
5. Invoice Template - Fine. Will Invoice templateS be covered on this one too? My question is does number 3 cover number 1,2 & 4 anyway? If so I am thinking to not go for 1,2, & 4 just keep 3 and choose three other new keywords. Would this be a better strategy and "more for our money?" Or, keep 1 and 2 and lose 3 and 4, would that be a good option. So, in summary options are (all assuming keeping number 5) 1. Keep all
2. Keep 1 & 2 - Lose 3 & 4
3. Keep 3 - Lose 1,2 & 4 4. Any other combo you can suggest? Any advice welcomed Thanks nutnut0 -
Keyword - Competition between competitors
So, I'm about 2-3 weeks into my subscription and see a renewal coming. I love the information I'm getting - but I really want to maximize my capabilities with these tools. Any article/blogs or forum post suggestions that I should read would be awesome, right now I'm still in that phase where i see lots of cool things - but have no idea to fully use them to really give me that even bigger boost. My First Question is - There are some keywords, that I climb and sometimes slip. But overall a competitor and i flip flop between 15-22 range for it. What would be a good way for me to really add that extra push to throw me down into the top ten and leave them in the dust?.. Also on the Keyword topic - There are a lot of keywords they probably rank for that I don't, what is the best way to go about identifying keywords they may targeting/have a good presence in that I'm not aware of. I do have a site that is on multiple newspapers, and .gov sites. Among other things... This has already proven to be very good for me. But I'm 99% sure I have a few/lot of leaks, that if they were plugged - We would see a lot of good things come from those results.
Competitive Research | | choiceenergy0 -
Can i see the keywords my competitors are optimizing seo for?
Ideally, I would get a list of the keywords my competitors are targeting.
Competitive Research | | sajalsahay0 -
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 -
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