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 -
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 -
Traffic Data for Competitor Subdomain
Does anyone know of a way to get monthly visitor data for a subdomain that I do not manage? I would normally use SEMRush or Compete, but they only provide domain level data.
Competitive Research | | dsinger0 -
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 top competitor's article
Hello, For bobweikel.com I'm going to work on getting some natural backlinks by making a better article than http://www.medicinenet.com/weight_loss/article.htm even though they're 30 times more of an authority than me. If you think this is a good idea, how do you recommend I top this thing? I'm just brainstorming
Competitive Research | | BobGW0 -
Which top 10 organic results are my competitors?
Hi all, This is a question about whether the top 10 ORGANIC Google results for a broad match is your competition, or whether it's the top 10 for a phrase match, or an exact match. I'm a newbie here but not a newbie to the world of SEO. I hope to be able answer just as many questions as I ask 🙂 QUESTION: If a customer comes to me and says, "hey, who's my (organic) competition for wedding present?" and I want to use Google to get the top 10 organic results, do I use a broad, phrase, or exact match? It seems many people think an exact match is the way to go but I think they were more referring to Adwords results / competition. I'm not trying to determine search volume for Adwords or even the search volume for organic results... I'm only interested in the top 10 competitors in the organic results. No one types in "wedding present" (with inverted commas" when doing a search in Google, so surely to see who ranks organically for wedding present I'd want to simply type in wedding present (no inverted commas, aka broad match). I understand all the concepts about how Google results cary whether you're logged in, etc, etc so I don't want to get distracted by that. And I know there's a bunch of tools we can use like the SEOMoz Keyword Analysis Tool. But I just want to know specifically what people would use (broad, phrase or exact) to look at the top 10 organic competitors are when doing a manual search in Google.
Competitive Research | | eatyourveggies1 -
Better tactics for keyword research
I am paying for monthly Adwords Google. I am planning to build out and optimize my website content with the findings from the Adwords campaign. What is frustrating me is the Google list of keywords recommended. Is there a better tool for determining excellent, "long-tail" keywords specific to my industry, products and services? -Feeling Left Out
Competitive Research | | natearistotle0 -
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