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 Keywords
Is there any way to find out what keywords my competitors are ranking for? I would like ideas for blogs, website content, etc. to drive traffic and am curious as to what topics my competitors are focusing on. I am able to see my competitors' rankings for keywords which I am currently tracking but I would like to see keywords they are ranking for that I am not tracking if possible. Any suggestions? Josh
Competitive Research | | jbeals0 -
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 -
What tools can give reliable competitor traffic data?
Could you give details of reliable tools that can measure and provide competitors' traffic data? Google Adplanner used to provide such information until June of last year, and while it's numbers didn't match Google Analytics data, the numbers were reasonably close. The metrics we are most interested in are visits, page views and unique visitors. We have looked at sites such as Compete -- but feel it is far too inaccurate/ skewed with US data only; also, would prefer to not rely on Alexa traffic stats. Thanks in advance.
Competitive Research | | ontarget-media0 -
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 -
Manta inbound link in OSE - competitor site yes, my site no, why?
Our site has had a link back to our site from Manta for a long time, but it's not appearing in our OSE results. One of our competitors similarly has an inbound link from Manta and that link DOES appear in their OSE results. I'm not certain whether that matters for us. Does it? But in any event, why would the one link appear but not the other? Thanks! Tim
Competitive Research | | tcolling0 -
Competitor analysis
Hi This is obviously a well worn question (I've read the great blog by Sam Crocker last year - see below), but I'm looking for an updated set of opinions on sources of competitor data. The competitor data I'm interested in is traffic volumes either aggregated or disaggregated by referral source (i.e. organic search, PPC, email, social etc.). The types of data I've checked so far are Google Trends for websites (no disaggregation), Alexa (some good sources of free data) and Experian's Hitwise (too expensive for my current needs). In addition I'm aware that Compete will be providing an interface for such data in the UK in January at reasonable rates for what I'm after. I'm interested in views on these and other sources in relation to experience of their relative accuracy, costs, pros, con etc. Ideally I'm looking for something that is free, comprehensive, and is not being used by the competition - is that too much to ask!!! 😉 Any inputs would be greatly appeciated. Thanks in advance! Neil Sam's great blog: http://www.seomoz.org/blog/monitor-competitor-traffic
Competitive Research | | mccormackmorrison0 -
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