Excel workbook for SEO?
-
A while back someone on here posted a really good workbook for analyzing ranking factors for competitors. Unfortunately I lost it, and I am hoping someone might know what i'm talking about and hit me up with a link to it, or perhaps your favourite seo workbook for excel?
Thanks!
-
So this is the one i was thinking about: https://seomoz.box.com/shared/g3vz0kxbbp
but is there anything more recent than that? it says those files are from 2010.
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
-
Price for SEO Audit & Strategy
Hello, I am a part-time SEO and own a few web properties, in addition to owning other small businesses. I do the best I can in my spare time to grow my site's traffic and try to create decently valuable content. However, I feel like I am not getting the best results possible, so I am wondering if anyone on here would be interested in helping me with a site audit and strategy. I can do the grunt work myself, I just want someone with a fresh perspective to weigh in and guide me on what I should focus on to achieve my goals. Please let me know if you're interested and how much it may cost. A range is fine. Here are the specs on my site & niche: About 20 pages of content, most of which have 96-100 page optimization scores on Moz. DA of 19, home PA 32 Most competitive KW is 22 difficulty, 83 opp and 67 potential. Thanks so much, any insight is much appreciated. Please respond here or DM me directly. Best, Ricardo
Competitive Research | | myriad_ricardo1 -
SEOMOZ EXCEL PLUGIN ARRAY FORMATTING
Morning All, I have followed along, and am trying to build my own " dashboard", SEOmoz API in Excel, to get the Domain Authority and MozRank for a bunch of URLs. I have a list of competitor sites / related competitors, and I want to pull in the moz url metrics so I can decide who to investigate further. I'm using this array SEOMOZ_URKMETRICS_toFit(A2,"Cols=128" and it keeps listing the results vertically. All the tutorials show this lovely link data in horzontal rows to the right of the url in question, but mine doesn't want to behave. PS. I do know the bit data is wrong, I'll fix that. Thanks in advance to anyone who can help.
Competitive Research | | Sugartheagency0 -
How to track seo campaign success fully?
Hi All, What are the best ways to track a seo campaign successfully, other or including Google Analytic?
Competitive Research | | ITRIX0 -
Improving SERP rankings via strategic SEO tactics
Hi, We just build some of our new content pages on our website 1.https://www.practo.com/ray/dental-software 2.https://www.practo.com/ray/dermatology-software 3.https://www.practo.com/ray/homeopathy-software Could someone explain how do I build around a good SEO strategy to compete with others for better positions on the SERP's. I have not done anything apart from fixing proper title tags , and meta descriptions etc and of course putting down relevant fresh content onto these pages. These pages were published about 3 weeks ago - Only this url ranks on the 2nd page as of now for keywords like "dermatology software" https://www.practo.com/ray/dermatology-software The rest of the URL's do not rank anywhere till the 10th SERP too! What could be wrong and where could I have the opportunity to boost the SEO tactics since all the pages which rank above it are just not providing the right kind of product as we are and still they take up the top positions and genuine users miss out on our domain. Thanks . Looking forward to some awesome responses.
Competitive Research | | shanky10 -
Local/Geo-Targeted SEO Keywords
Hey everyone, I work for a local jeweler who only has one store and wants to rank for geo-targeted and local results. We want to rank for "jewelry Minneapolis", "Minnesota engagement rings" and terms like that, since we're not an e-tailer we don't need to rank nationally... just in the MSP metro. I've been trying to find a service that has accurate search volume information for local search. I want to see how many searches are being conducted for various terms so I know where to focus our time and effort to rank for these terms. Does such a service exist? Or something that is more geared toward a strictly local strategy such as ours? Thanks in advance for all of your assistance! Jayme
Competitive Research | | jpretz0 -
Raise your hand if you're doing SEO for manufacturers please.
When you're working for a manufacturer it's not exactly the same as working for a company that is flat-out informing people with content and links and revealing a lot of information (relatively speaking). Please tell me what you do when you're working with a client that is not willing to reveal too much because competition = fear of the unknown (like if you take a chance and post something online that your competition may use against you). I would appreciate less speculative and more informed answers from people who have actually done this kind of work - as opposed to those who think theoretically they may know the best way to go because they work for other types of businesses that are not as proprietary as manufacturing is. Thank you.
Competitive Research | | karlseidel0 -
RankTracker , Seo Spyglass?
just want to check is anyone using these other products? and if so do they work? RankTracker Seo Spyglass Website Auditor LinkAssistant? Thank you!
Competitive Research | | mikedw0 -
How good really is Yahoo Directory Listing is on SEO optimization
I just god the approval from Yahoo Directory Listing today. How should I expect ranking increase just with that on google, yahoo and bing in the next couple of days ?
Competitive Research | | processia0