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
-
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 -
What tools can give reliable competitor traffic data?
Could you give details of reliable tools that can measure and provide competitors' traffic data? Google Adplanner used to provide such information until June of last year, and while it's numbers didn't match Google Analytics data, the numbers were reasonably close. The metrics we are most interested in are visits, page views and unique visitors. We have looked at sites such as Compete -- but feel it is far too inaccurate/ skewed with US data only; also, would prefer to not rely on Alexa traffic stats. Thanks in advance.
Competitive Research | | ontarget-media0 -
Anyone want to test out my keyword research theory?
Hi all, I'm relatively new here but not new to the world of SEO / SEM. Over the years I've loved using SEOmoz and other tools but of course have found certain limitations with respect to how I like to work. That's the case with any tool / service. So over the years I've put together a keyword research / competitor analysis process that has worked well for me and I'm wondering if it might also work for others. I've spent the last 15 years of my life as a director of a range of companies, mainly in printing but also in systems development, marketing, etc. I spent a large percentage of my time developing systems and tools to help me with my search engine marketing. I've now sold all my companies and I'm semi-retired, somewhat bored, and would love it if I can assist others with the process I've used over the years. I'm curious to know whether SEM professionals agree with the way my system ranks search terms from "best" to "worst". If you're interested in testing this process and telling me if you think the resulting list of search terms that I come up with for your website is "spot on", "not bad" or "horrible!", then please read on. My key motivation here is to educate myself as well as others. I'm not charging for any of this... If you give me your website URL, your top 5 competitors and your top 5 search terms, I will return to you: a complete list of search terms including "niche" and longtail search terms you can then... really easily filter out irrelevant search terms, thus creating a list of negative keywords, ready to import into your Adwords campaign. easily group your search terms in "education" and "purchase" search terms so I can analyse these two groups of keywords separately see which words are used most often across all the search terms so you can easily create keyword specific Ad Groups in your Adwords campaign. You can tell me which options you prefer: broad match, "phrase match" or [exact match] when getting search engine results specify any country you want the SERP results for, or even any city. I will then: do all the keyword research, getting the latest (live) Google SERP results combine all competitor metrics (page rank, domain age, juice links, etc) and search term information (search volume, CPC, search term length, etc) together to give you a list of search terms ranked from "best" to "worst" do the same for both organic search terms and paid (Adwords) search terms do the same for both direct search terms and niche search terms take into account "word count" (number of words in a search term) as longtail keywords generally higher-converting search terms And you can adjust things to change how the keywords are ranked: specify "thresholds". eg; you can ignore the really competitive search terms, or ignore the really short search terms specify "weightings". eg; you can put a greater emphasis on search term length, or a lesser emphasis on cost per click As a result of the keyword analysis, it'll also show you who your organic and adwords competitors are based on all keywords, or just your top ranked ("best") keywords. In that competitor data you can see: which paid ads appear at the top, side AND bottom of the results page which organic results are shopping, image, video, and local results all the metrics for each competitor (page rank, domain age, juice links, etc) All of this is is handled in a simple web interface that I threw together recently. It's really simple, merely asking for your site and preferences and then an interface to view / sort the results. Interested?
Competitive Research | | eatyourveggies
I'd like to hear from any SEM professionals who want to test this process. Once I have your basic details, I can get a keyword list together simply (using my internal process / software) and then you need to do some basic sorting, particularly if your search terms are in an industry that I know nothing about. Your input will be required. From there, give me 24-48 hours and I'll return 2 lists of search terms: "organic", and "Adwords". I'd love to hear your opinion about the relevance of the search term lists. I hope it will also spark some interesting discussion and hopefully help people learn a bit more about keyword / competitor research. If you're interested, please shoot me a private message letting me know why you'd be a good candidate to test this system. I really do want people who are well versed in search engine marketing. So please include a basic "resume" about who you are. If you have an SEM company and that's your main career focus then I definitely want to hear from you. Adam0 -
Competitor's Ranking's Reports are Showing Blank Values for Rankings
When selecting competitors to see how they rank for specific terms in the ranking's report page here, it loads the page normally, but without any actual rankings. Where values should be, it lists all values as our competition not ranking whatsoever (for all competitors). I'm not sure if there is something we're doing wrong, or perhaps we just need to wait for a refresh, but if anybody could help out, that would be wonderful!
Competitive Research | | ACLens0 -
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 -
Is it possible to see how many visitors a competitor has received for any given keyword over a set time period?
Is it possible to see how many visitors a competitor has received for any given keyword over a set time period via either Organic / Paid means? Thanks
Competitive Research | | jaycfc1230070 -
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 -
Anyone have experience with "Link Research Tools" ?
I'm looking into Linkresearchtools.com for competitive backlink analysis. Already have SEOmoz (obviously) and Majestic. Anyone have any experience with the toolset? If so, what does it do well, what do you like, and where does it fall down? Cheers
Competitive Research | | BedeFahey0