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 using our product descriptions
Hi, We have a competitor (with a higher DA) using some content from our product pages word for word on a few of their product pages. It's only a couple paragraphs per product page (including the main product description), not the entirety of the content on the page. It also appears they have scraped some content from another authoritative competitor (and even left their brand name mentioned on it!) I've read mixed thoughts on whether plagiarized content will harm the original site, but am concerned since it is an authoritative site. Should I be concerned since it's only parts of our product page? Thank you all!
Competitive Research | | ATShock0 -
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 -
Methods for estimating competitor website traffic from natural search
Hi all, I'm currently working on some competitor analysis and estimating website traffic based on rankings and estimated search volume for approximately 500 keywords. I'm then estimating based on click through rate from Webmaster tools. I think this will give me a relatively accurate estimation but was wondering how everyone else does this? Any other methods out there? Thanks, Elias
Competitive Research | | A_Q0 -
Keyword Research Competition
Hello everyone. Was talking to my "competition" the other day and they mentioned the amount of traffic they are getting from google. It's double what I currently am receiving. I feel like I am not targeting the correct keywords. What is the best way to research competitions keywords? Anyway to find out what is driving traffic their direction?
Competitive Research | | Jasonalanmagic0 -
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 -
How to combat competitor buying who is buying links and winning.
I have a competitor who is buying links in the Featured Advertiser Links section of Washington Post online. His backlink profile is a very low # of referring domains. (38ish) with a good bit being repeats of Wahington Post. My question, is their strategy within Google guidelines, and what can I do to combat it? Thanks.
Competitive Research | | bozzie3110 -
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 -
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