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 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 -
Keyword - Competition between competitors
So, I'm about 2-3 weeks into my subscription and see a renewal coming. I love the information I'm getting - but I really want to maximize my capabilities with these tools. Any article/blogs or forum post suggestions that I should read would be awesome, right now I'm still in that phase where i see lots of cool things - but have no idea to fully use them to really give me that even bigger boost. My First Question is - There are some keywords, that I climb and sometimes slip. But overall a competitor and i flip flop between 15-22 range for it. What would be a good way for me to really add that extra push to throw me down into the top ten and leave them in the dust?.. Also on the Keyword topic - There are a lot of keywords they probably rank for that I don't, what is the best way to go about identifying keywords they may targeting/have a good presence in that I'm not aware of. I do have a site that is on multiple newspapers, and .gov sites. Among other things... This has already proven to be very good for me. But I'm 99% sure I have a few/lot of leaks, that if they were plugged - We would see a lot of good things come from those results.
Competitive Research | | choiceenergy0 -
Competitor Keyword Rankings
Is there a way within SEOMoz to uncover the keywords your competitors rank for and their respective SERPs? Thx
Competitive Research | | qiherbs.com1 -
Keyword Research Tool Problem
Hi, I had been in SEO for around 2 to 3 years, I am looking for your suggestion if there is any best keyword research tool. I tried almost most of the keyword research tool (both paid or free) but I found the following problem: -Worktracker: I think it is too difficult to use and understand as a non technical person. I always wonder the data accuracy because when the same keyword appear in Google for few thousand traffic, it only appear in Wordtracker for few dozen or hundred of search. Also I don't think they suggest any long trail keywords in my view. The long trail keyword you can also find in free keyword search tool. -Google Keywords Tool- Good, but it can only show 100 results. I cannot get a better pictures of related or niches keywords. I always find some competitive keywords can rank easily but some non competitive keywords usually very difficult to rank in some case. It will depend on how you interpret the data results. -Keyword Discovery and Wordstream-Although I really want to subscribe, but they are a way too expensive (you have to subscribe for 12 months). I check with their free keywords tool but only shown very limited results. Although there are some other like spyfu.com or keywords spy...... Is there any one can suggest me which is the best tool to start with keyword search for the long trail and niche keywords ? or is there any way or trick to find the best keywords ? Thank you. Tom
Competitive Research | | Stevejobs20110 -
What am I Missing on a Simple Targeted Phrase?
We have a bundle product page with a unique title, description and image. Other companies have similar items, but not a duplicate of what we offer. There are a few key phrases that we are trying to target with this product because they describe the product perfectly by nature. There are other similar ranking conundrums on our site, but I chose to ask about this one because it is a fairly simple and straight forward case. Attached is the ranking difficulty tool results. From this test, I don't see any reason why the number 1 ranking is better than our page in the SE's eyes. We don't have any problems or warnings in WMT either. I'm open to ideas/suggestions on why our pages are ranked so much lower for a simple search term. I have tried tweaking the title, text and added internal/external links as well as built social indicators. Nothing is making the difference I'm expecting. Because this is a fairly non-competitive, low-income phrase, I figured it would be easy to move up the rankings. I'm almost thinking it has more to do with our site template/design than anything, but that's hard for me to say. [Our site is 19&20 in the report] 8MXHJ.png
Competitive Research | | iJeep0 -
What metrics are you using to build profiles of competitors Google Places pages?
Hi, I am attempting to put together a set of procedures to undertake when optimizing Google Places pages. Does anyone have a good list of metrics and methods for determining them in order to build profiles of competitors' Places pages? Thanks
Competitive Research | | networkelites0
