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
-
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 -
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 -
How can I tell if a competitor has a KML Geositemap or not?
Is there someone to tell if a competitor has a KML Geositemap or not? Would it be in the source code on their homepage? or can I just put their url in a "Open Site Explorer" type product to find out? Thanks, Ruben
Competitive Research | | KempRugeLawGroup0 -
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 -
Which top 10 organic results are my competitors?
Hi all, This is a question about whether the top 10 ORGANIC Google results for a broad match is your competition, or whether it's the top 10 for a phrase match, or an exact match. I'm a newbie here but not a newbie to the world of SEO. I hope to be able answer just as many questions as I ask 🙂 QUESTION: If a customer comes to me and says, "hey, who's my (organic) competition for wedding present?" and I want to use Google to get the top 10 organic results, do I use a broad, phrase, or exact match? It seems many people think an exact match is the way to go but I think they were more referring to Adwords results / competition. I'm not trying to determine search volume for Adwords or even the search volume for organic results... I'm only interested in the top 10 competitors in the organic results. No one types in "wedding present" (with inverted commas" when doing a search in Google, so surely to see who ranks organically for wedding present I'd want to simply type in wedding present (no inverted commas, aka broad match). I understand all the concepts about how Google results cary whether you're logged in, etc, etc so I don't want to get distracted by that. And I know there's a bunch of tools we can use like the SEOMoz Keyword Analysis Tool. But I just want to know specifically what people would use (broad, phrase or exact) to look at the top 10 organic competitors are when doing a manual search in Google.
Competitive Research | | eatyourveggies1 -
What is the best tool to monitor your competitor's backlinks?
I am looking for a tool that not only accurately tells me how many links are being built by a competitor, I want to know the specific URLs for specific periods. If I can filter/search by time periods, i.e which links were added for the month of August, 2012, that would be great. Thanks for the help.
Competitive Research | | inhouseseo0 -
Why OSE cant show competitor backlinks , please could you help?
Today i am searching for backlinks in OSE but it cant go to result pages, can anyone help me why OSE cant work today.
Competitive Research | | conversiontactics0 -
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