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 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 -
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 -
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 -
Tracking competitors in search engines
Hi Mozzers, I'm using Advanced Web Rankings (AWR) to track my site and a number of competitors in Google - seeing how rankings and brand visibility change from week to week. I didn't set this up from scratch and I'm worrying with all of the recent algorithm changes that I might well be tracking the wrong competitors. Is there a tool or methodology I can use to find the biggest players in the market? I'm in the travel market so there's lots of choice and I track the large sites but want to be sure I'm aware of smaller/mid-sized sites gaining visibility without me tracking them via a platform like AWR. Many thanks!
Competitive Research | | panini0 -
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 -
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 -
Spying On Competitors Links
Hi There, I am looking for a tool that will allow me to learn about the new links our competitors get each month. Do you know a tool that lets you know each time your competitor has a new link?
Competitive Research | | liors0 -
My client has shown me a similar site, though not a competitor. He wants to know what sites they are linked from that give them such a good Google rank for certain kewords. Can SEOMoz tell me this?
When using google.com.au and searching for "travel to france", www.frenchtravel.com.au is the 3rd organic result. (the 1st two are not travel businesses, they are non profit travel guides) My client, who runs www.visituk.com.au, an Australian site that organises tours of the UK, said "so we just need to add these sort of words to the site?" I said, yes, but it doesn't end there. The real task is to have a link to your site on other sites surrounded with the words "travel" and "UK". He asked if he could see a list of the sites the french site was being referred by relevant to the search phrase. Is there an SEOmoz tool for this? Or is there another way I can generate that list? Thanks Simon
Competitive Research | | electrik0