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
-
Ahrefs Much Higher Than Competitors But Competitors Doing Significantly More Traffic?
Hey guys, I'm baffled by checking my Ahrefs ratings lately. It looks like our rating just went up considerably... from over 1 million to now around 500k. One of my main competitors, however, has a much lower Ahrefs rank (over 3 million) but he does a considerable more amount of traffic than we do... how is this? My domain rating is higher than his by a lot. Very curious how this works.
Competitive Research | | jfishe19880 -
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 -
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 -
Competitors SERP's
One of our competitors is routinely achieving excellent SERP for brand related keywords within only a couple of months of adding the respective brand to their website. Full details are explained in the attached image to avoid the competitor being notified of this post via Google Alerts. Can anyone identify how they are achieving this and point me in the right direction? The other thing is that I was also achieving good SERPs for these and other brand related keywords but I seem to have dropped off the face of google for them, where my competitor has not and who continues to achieve the seemingly impossible. Thanks TOfVHD8
Competitive Research | | UnderMe0 -
Moz Rank Moz Trust and Authority higher than my competitor but still getting outranked
Hi There, I'm new to SeoMoz but ive been using it for the past month and I've been using the tools to try to optimize my site but for some reason even though my metrics are showing that my rank and authority are rising past my competitor they still rank higher in the searches. my website is the site on the far left with the domain authority @27. the competitor that keeps outranking me is the third from the left with a domain authority of 12. If anyone can advise as to why I'm being outranked that would be very helpful. I'm stumped here. Thanks guys! eYtMRr9.png
Competitive Research | | SamRaskin1 -
Much better authority and content than some competitors, why do they appear first?
On august we have lost the top positions for some keywords. Our website authority is 62 (google page rank 5), and some quite small competitors appear first now (some of them have authority 22, google page rank 3!). Our only big change was the DNS server, from godaddy to dnsimple.com, which seems to be some milisseconds slower. Every other metric is in our favor: from on-page repports to site speed. Sometimes by a factor of 3 or 4. What can be happening? We have also realized that, in private browsing, rankings will change a little bit in different cities, even if they are quite close to each other.
Competitive Research | | PauloSilveira0 -
SEOMoz bar shows competitors ranking higher in SERPS with less Moztrust and Mozrank?
We are targeting the term "wholesale fireworks" we are currently on page two and just completed some on page optimization. I noticed using the Mozbar that the SERP results on the first page show a site with near zero page rank, Moztrust, domain trust, etc.. It is steadily number two in SERPS. Our site is just as strong or stronger on these ratings as anyone on the first page. How is it possible that we are still hanging out on page 2?
Competitive Research | | devonkrusich0 -
Crazy SEO question (maybe I'm missing something?)
OK - so one of our customers just called us and told us an interesting story: A local SEO company called her yesterday to try to sell their services to her. She's in the process of starting SEO services with us, so she told them she wasn't interested. The sales guy told her that they were better (without even asking who she was currently using) and asked her for a term that she'd like to rank higher for. She said she'd like to rank higher for "spray in bedliners northern ky" and he said "Gotcha, call you tomorrow" He called back just now and told her to look at Google. She's now ranking number one for that term. He didn't have access to her site, so he wasn't able to change anything on her site. He won't tell her what he did, and told her it was legitimate - but it seems to me that with only off-site tactics, it'd be nearly impossible to white-hat her site to number one overnight... Any ideas what he's doing? First of all, we want to be able to tell her what he's doing, because she's curious. More importantly, we want to be sure he's not doing anything black-hat that's going to hurt our client's site. Thanks for your help, Mozzers!
Competitive Research | | Greg_Gifford0