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
-
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 -
Ecommerce seo - competitors are using spammy links to rank HELP
After setting up SEO Moz and whilst waiting for it to crawl my site i have checked out my competitors who are ranking for the keywords i am going after. It appears from what i can see in OSE that they are ranking with back links from spammy looking sites and lots of exact match anchor text. I have tried to match a few links with what they have currently without getting myself into anything too spammy but i really don't want to follow how they have done it exactly. The niche i am in is pretty boring but the rewards are great but i am finding creating content and distributing it correctly difficult which is why i need some help. My site is roughly 9 months old and the product descriptions are hand written trying to give as much info as possible with a hint of personality so no cookie cutter back of the box descriptions. i have matched a few of the links from competitors which weren't too spammy and as relevant as i could get to my niche, i have also created articles for some article directories - all of which isn't really getting me very far and i am running out of ideas on how to create new content & the types of new content to help me get back links naturally. If any of you friendly guys could offer me some assistance in setting up a basic seo campaign which would help me target my keywords i would be very much in your debt
Competitive Research | | GarethEJones0 -
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 -
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 -
What if your content is way better than competitors?
Do you have any suggestions if you are being outranked by competitors even though your page has way better content and better links?
Competitive Research | | Charlessipe0 -
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 -
Whats the best way to see why your competitor is out ranking you?
I am trying to rank in the number on position for Part Time CFO. Currently we are in 2nd and 3rd. We have way more quality inbound links then the site in first position, more content etc. How would you go about investigating why they are ahead of us?
Competitive Research | | b2bcfo0 -
PA and PD better than my competitors is a way to rank better?
I got a site that stuck in last position of google's first page. My on-page is grade A for this particulary page, i got links for that page too. But My competitors PA and PD is better than mine, not too much, but it is. If i build more quality backlinks and start increasing my PA and PD probaly i will rank better than my competitors? Thats the factor that i have do cara abour now?
Competitive Research | | Ex20