Missing tab in Competitor research Template
-
The template provided in https://mza.seotoolninja.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
-
Visibility Score Against Top Search Competitors
Top Search Competitors
Competitive Research | | PhoebeK
The competitors that compete for the same keywords as this domain, ranked by visibility. Other websites that compete with this domain for the same keywords, ranked by visibility. Visibility (What does the visibility rating mean on this report)?
For example: If you have a visibility of 8.33 on this report and your competitor has a rating of 6.21 or 4.64, is your visibility better than theirs?0 -
What's a good way to get started with competitive research?
Hi all, SEO noob here. I'm doing an audit for a firm that makes specialized accounting software. It's a relatively new firm, with a barebones website. My client has identified three direct business competitors. In addition, I see indirect competitors (such as product reviews) on the SERP for a relevant keyword phrase. I want to provide actionable advice for my client. What information should I present? I'd like to help my client understand: Why my client's competitors are outperforming them on the SERPs What my client needs to do to overtake their competitors What information should I present to my client? Thanks, all.
Competitive Research | | AndyKubrin0 -
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 -
Competitors' paid search analysis tool
Hi, What tool will do the following: will tell me paid keywords our competitors are using. Ideally, I could narrow down by country. Thanks. Katarina
Competitive Research | | Katarina-Borovska0 -
My (properly optimised) webpage outscores page#1 ranked competitors on page/domain authority ... but I'm only on page#2\. Huh?
I'm puzzled. I've optimised a particular page for a particular search term, and the SEOMoz tool gives me an A for on-page optimisation. So no problem there. I can understand why my webpage/site is being outranked by pages from (for example) the Guardian and Oxford University, but there are several sites that Google is ranking on page #1 though their page and domain scores are well below ours. Specifically: my page/domain authority scores are 46/52, compared with 22/46 for the competitor that Google is ranking #5 - yet we only rank a lowly #12. And it's not as though the particular page in question isn't an obvious and appropriate part of our site. We work with new writers and the page in question offers a selection of creative writing courses. It's not like we're a writing-related site that suddenly has a page advertising fake rolexes. It's not a timing issue either, as most of our links have been in place for a couple of years at least. So I'm puzzled. And concerned. This page of ours was a reliable revenue generator for us and it's dying out there on the page#2 wilderness. If anyone can help, I'd be massively grateful. I don't know if this is helpful, but the page in question is http://www.writersworkshop.co.uk/Creative-Writing-Courses.html and the search term is ... well, heck, you take a wild guess. We're a British firm, so the only search engine that really matters to us is google.co.uk
Competitive Research | | harrybingham0 -
How can I add more than 3 competitors
Is there some way to add more than 3 competitors to the tool to benchmark against?
Competitive Research | | lockwoodl1 -
Anyone have experience with "Link Research Tools" ?
I'm looking into Linkresearchtools.com for competitive backlink analysis. Already have SEOmoz (obviously) and Majestic. Anyone have any experience with the toolset? If so, what does it do well, what do you like, and where does it fall down? Cheers
Competitive Research | | BedeFahey0 -
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