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
-
Why competitors rank with no content & filters
We're investing a lot in on-page content and creating categories/sub categories to target relevant keywords. Although it seems competitors with high domain authorities are clearly dominating in the SERPs and the pages have NO content. They are literally filters that create landing pages. For example when you search "Kaydian Beds", Debenhams rank below the manufacturer with just a filtered page, this page has not been optimised with content to target the keywords, only the META title changes depending on the chosen filter. Link: http://www.debenhams.com/furniture/beds/kaydian Our link: https://kontenta.co.uk/brands/kaydian-beds.html This is very frustrating as quality content should beat pages with little or no content, we will spend some time and get some inbound links to the page to try boost the rankings but does anyone have any similar experiences with anything like this?
Competitive Research | | Jseddon921 -
How can I find out the exact match visitors for a competitor's website?
Hi, I'm trying to find a way of finding out the estimated number of exact match visitors that a competitor's website has got. I know that SEO agencies can find this out, and there must be a way of doing this for myself. Thanks
Competitive Research | | MThacker0 -
Competitors ranking in top three with worse SEO
Ok I am at a loss. Our client is trying to rank for keywords like "dental assistant programs utah", but they are still on the bottom of page 1/top of page 2. The guys in the top 3 have terrible SEO. No links, newer domains, etc. I looked into it extensively and learned about the "honeymoon period" people talk about but we are long past that. I've looked through webmaster tools to see if there are any issues, and I can't find a thing. Anyone have an idea of what we could be doing wrong that is making us be put down so far on the page? Before I got here the SEO guys were doing older tactics which I think was starting to hurt them with penguin and what not so I tried my best to delete the crap content and clean everything up on the website. thanks for all your help! I really appreciate it.
Competitive Research | | boyackp0 -
Why is our website ranked lower but beats most competitors in full SERP report?
We are analysing why our website ranks so low (currently position 8 in serp). We beat our competitors in most areas. Also we produce by far the most useful content. Do not buy links or do any other malpractice. We have been for a long time ranked in top 3 (well mostly 1-2) positions. In the last year we have seen a decline to position 8-10 and we are not sure why this is the case. Can anyone suggest what we should be focusing on? We are clueless. All the practices we used to "know" now seem obsolete. m8qIeyC,Kf1LLei#0
Competitive Research | | urkeman0 -
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 -
Screaming Frog for competitor research
Hi guys, Does somebody experienced an issue with Screaming Frog spider while trying to crawl a website? It's weird since no error message appears and at the same time the crawler cannot crawl anything. There is no restriction in the robots.txt. Has someone encountered such an issue? Thank you. Cheers
Competitive Research | | lgrozeva0 -
Finding competitors best keywords?
How do I learn my competitor's best keywords? I realize I can add more keywords to my campaign but the problem is - I am not sure I am thinking of the right keywords. I don't want to compare with the keywords I am targeting - I want to know what THEY are targeting.
Competitive Research | | dealblogger1 -
Comparing competitor folder path
Hi All I've just take on a new client and need to be able to compare their performance with a competitor's sub-folder site. The competitor is http://thebestof.co.uk/local/brightonandhove/ I've tried to add that to the competition structure in my campaign but can't use "Path" info. What do you guys do in these types of cases. BTW - TheBestOf.co.uk is a franchise with a /local/CityNames across the UK
Competitive Research | | stevecounsell0