Welcome to the Q&A Forum

Hello Moz community, Let's suppose you're working on a +600 pages website and you are working on lots of keywords. I'd like to know if you had a database / excel / tool to know which keywords you've been targetting so that you don't create twice the same content ? Thanks for your answers

Hello Moz community, I wonder if you have tips / tools to build a good competitive landscape "picture" for your clients ? When i'm working on a pre-sales audit, i like to generate 100/200 keywords related to my prospect universe and then show him how well/bad positioned he is on this "market". To do so i use AdvancedWebRanking to monitor position of prospect + 3 competitors for this list of Keywords. Then i manually calculate a "market share" derived from each actor position. I wonder if there is a tool that can automatically do it ? For a list of keywords that you input. Thanks for your answers

Hello Moz community, I am re-structuring information architecture on a website. The homepage targets keyword A 
There is a page /page-on-B/ that targets keyword B 
There is also an older page /page-on-kinda-B/ that targets a keyword which is really close to B ( i think they should have been worked on the same page...) I want to re-optimise the homepage on keyword B because i know it is worth the effort. If i re-write the homepage to talk about B and do a 301 redirect of : /page-on-B/ 
/page-on-kinda-B/ to the homepage is it going to add page authority to the homepage ? is it the right way to proceed ? 
Thanks for your support !

Hello Moz community, I'd like to know if you build "pre-sales seo audit" when selling your services to a prospect. I think the main idea of a pre-sales audit is to show your prospect that you understand his industry (trends & competition) understand the opportunities know the roadblocks on his website If so, i'd be interested in discussing the information you put into your pre-sales audit and how you organise it. If you know ressources i should read as regards to mini seo audit / pre-sales seo audit just paste the link 🙂 Thanks for your answers

Hello everybody, With hummingbird update i think i understand that two pages like exclusive dating website chic dating services which could have been targeted on 2 different pages can now be targeted in a single one. 
In the end google is asking "Well... isn't an "exclusive" dating website the.. same as a "chic" one ? isn't it the same visitor intent which is triggered ? ". I'm building a new keyword study for one of my websites and i'm trying to be more in the "intent" point of view than in the "keyword" one. I've added a new column to my study which includes transactional / navigational and informational dropdown. I think this information is great but i feel that something is missing... I wonder if we could include a column which describes the real visitor intent in the form of a "user story" 
http://en.wikipedia.org/wiki/User_story for example : As a visitor i want to land on a page that proves that the company is only working with "exclusive" people.
-> We could optimise this page for all the "exclusive" "chic" "fancy" "elegant" "elite" keywords. Just a thought, i'd be really interested in knowing your point of view. Thanks a lot for your answers 🙂

I'm looking to integrate moz keywords analysis grade (in %) into my keyword research spreadshit as a column. Is there a way to get the % through the API ? Thanks

Hi there, i do not manage to find how to buy your DVD set ? There is a page but no product to buy ... http://www.seomoz.org/store/4 Thanks