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 do we find keyword opportunities - but not just against 3 competitors...
Hello everyone! How can I find out what might be a keyword opportunity against a competitor but make sure it's still a realistic opportunity in SERPS generally?* After all, we are not just competing with 2 or 3 competitors. We are competing against everyone! Perhaps there is a part of the keyword research process that helps? I can't help but think there's a wasted effort to just beat a couple of competitors unless you can rank well generally - especially if it's a competitive sector. (*I'm not in the position of making lots of pages as part of a long-tail keyword/ content strategy so I need to focus on just a few and make them count) Thanks in advance. Mp
Competitive Research | | mark_seomoz10 -
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 -
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 -
Would sharing the same IP address with competitors in the same market hurt SEO?
I work for the Chevy dealership in New York who is trying to rank against other Chevy dealerships in the same area. All the dealerships, including my client, are using the same Chevy endorsed CMS (Cobalt). I just noticed that all of these competitors, including my client, are using the SAME IP address. Would it be beneficial to SEO if we were to ditch the Cobalt platform and choose another one that gave us a unique IP address? Have any of you run into this before? Any help would be appreciated.
Competitive Research | | tjkirgin0 -
Is there a SEO Moz Competitor Analasys tool that will show me how many Vistors their site receives?
I'm trying to find out how much traffic a competitor gets. Is there an SEOmoz tool for this?
Competitive Research | | starkSEO0 -
Keyword Research - tools
Hello all, I would like to find better synonyms for my keywords, and dig deeper to bid / place strategy into place for them. I am currently using the adwords too but it only gives me closely related keyword ideas. Is there something "free" which can give me a better co-relation data to work with? Thanks Aditya
Competitive Research | | shanky10 -
Determining why an established competitor's rankings have bombed - What's the best way to go about it?
I arrived at work this morning to find my weekly SEOmoz ranking report for a main competitor waiting in my inbox. 90% of the their rankings have tanked in the last day or so by an average of 3 pages - most down from page 1 or 2 where they had been sitting pretty for ages. I'm not in a state of (total) euphoria about this because a) you should be humble enough not to gloat at your enemy's demise, and b) I need to find out what they did wrong so that I don't make the same mistake, too. **What is your first suggested port of call to determine where my (vanquished) foe has gone wrong? How much can I find out? ** I do know one thing - with OSE I can see they've used dodgy blogging services but this, to my mind, would have been jumped upon by Google last year. No? Thanks guys
Competitive Research | | Martin_S0