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
-
Looking for Competitive Research Tool Recommendations
Hi Moz Community! I'm doing research for a client and trying to gain insights around their competitors website data. Specifically trying to see what landing pages on the competitors site receive the most traffic. Does anyone currently use a tool that shows estimated traffic here? As an FYI, outside of MOZ Pro (which I love), I use SpyFu and SimilarWeb. Right now my client's landing page traffic is mainly homepage traffic and we want to make reccos on where to grow outside the homepage to increase visibility in other specific areas where there is search demand. We have a good idea but I'm hoping the competitor web data will back up those recommendations. Any recommendations here would be super valuable! Thank you in advance for your time. Abbi
Competitive Research | | abbiplunkett0 -
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 -
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 -
Why is my competitor's site ranking #1?
I'm about to work for a local business website that offers cleaning services and products. The keyword they want the most is ruled by a very odd site; My client's competitor's site has been around for 7 years. (Less than the average of it's competitors. Less than my client's) Has 1 backlink. Lower PA MR MT & DA than any other in the SERP. It's a 1 page site made with Flash. They do not have FB or Twitter accounts. So I thought maybe they were ranking so well because of their traffic. But neither my client, me or my coworkers have ever heard of this company. And yet, they are ranking #1. And the only thing I notice that might have helped is that the title of their page is the exact keyword and nothing more. Any ideas?
Competitive Research | | Eblan0 -
Why OSE cant show competitor backlinks , please could you help?
Today i am searching for backlinks in OSE but it cant go to result pages, can anyone help me why OSE cant work today.
Competitive Research | | conversiontactics0 -
Competior Research & Analyse
Hi, I like to know the inbound marketing sources of my competitors, and like to know how many traffic are receiving from Organic Ranking and Adwords or Search Engine Paid Marketing. ANd it would be nice to know the social media traffic too. I am searching, but i see here compete.com, but at the moment it's too expensive for me, like to ask you if you can find me to find any software cheaper than compete. Thanks.
Competitive Research | | leadsprofi0 -
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
