How do you keep track of the keywords you're working on ?
-
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
-
Thanks will
-
If you could also send it to me that would be great! Thanks!
-
Hey will,
Thank you very much for your answer. I'd definitively be interested in seeing your google docs spreadsheet example.
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
-
How to find low difficulty keywords
how to find informative low difficulty keywords. how can I get content ideas? I have lots of content ideas but it's not good search volume on google. I have a kitchen-related affiliate website called https://gloryspy.com
Keyword Research | | MalikJan0 -
Keyword Organising
Does anyone know of any tools to aid organising keywords? I'm currently using Excel extensively in an effort to bring some organisation, however it is very labour intensive.
Keyword Research | | seoman100 -
Google Adwords Keyword Planner Question
Is the keyword volume data shown the number of google adword clicks people made after searching with the used keyword, or is it the exact match search volume??
Keyword Research | | jennie.evans0 -
How to work my keywords - should I use exact, broad and phrase match in the same adgroup?
I'm looking at my adwords, and am looking to strengthen them, improve quality score by making the wording more appropriate, and ensuring they link to a more relevant page rather than just my home page. In an AdGroup should I be using all three (broad, exact and phrase) or does this just confuse Google. What are the advantages/disadvantages? When I was doing the keyword research, for some of my phrases, there was little difference in price (sometimes as low as a 3p difference) between a broad match (with large potential numbers) and an exact match (with a tiny target group) so it would seem best that I target the broad match - make sense?
Keyword Research | | Gordon_Hall0 -
Keyword and Keyphrases
I'm looking to optimise my website for some keywords and keyphrases I'm getting a bit confused on how different pages might compete (or help) each other. As we are an automotive dealer I was thinking about building the hompage around 4 keywords (one for each franchise we represent e.g 'Ford'). These show high local monthly searches and medium competition for just the manufacturer name on its own. Then if someone drills down into a franchise homepage (linked from our homepage e.g. www.ourwebsite.com/ford) I was thinking to optimise the page around e.g. 'Ford Dealer' (which has medium local monthly searches and high competition). Then if someone drills down into a particular model I optimise around that and so on. Question is will I be playing the franchise homepage vs the group homepage (Ford vs Ford Dealer) as I have read here on Keyword Cannibalization? Or will it work together? Alternative I guess is not to focus around a franchise on the group homepage and then only focus on the franchise from the franchise homepage onwards but I feel I would be missing a trick? As a new kid on the block help will be most appreciated.
Keyword Research | | design_man0 -
Do you use broad match or exact match on Adwords Keyword Tool when doing keyword research?
I wasn't sure whether to classify this as a discussion or a question. I'd love "the right answer" but I'm not sure if we're going to get one... Let's try. When you use the Adwords Keyword Tool for doing keyword research, do you use the numbers from "broad match" or "exact match" when comparing relative search volume of keywords? (And yes, I know the numbers need to be taken with a grain of salt, but when it comes down to it, you're using the numbers to compare and come to conclusions regarding the best keyword to use - so which match type gives you the data you're looking for?) To be a little more specific - when you select "exact match" for, let's say the keyword "baking supplies", is that telling you how many people searched for that phrase within quotes <"baking supplies">, or how many people searched for only <baking supplies="">, as opposed to that word within a phrase <baking supplies="" stores="">or with the words reversed <supplies baking="">?</supplies></baking></baking> Based on some keyword research we had done a year ago where any phrase reversals like <water bottles="">and <bottles water="">were coming out with the exact same numbers, even when it wasn't so intuitive that there would be the same search volume, we came to the conclusion - with the tentative suggestion of the SEOMoz staff on the old Q & A - that broad match would include all instances of the keywords in reverse order, so if you wanted to know how many people were searching for <water bottles="">only, you needed to use exact match. </water></bottles></water> That's what we did for about a year (I also think I saw Rand mention that somewhere in a presentation slide recently, although I could be mistaken and I don't recall exactly where it was to check it up) and then based on a recent forum discussion I had where someone was questioning that premise, I did another check with two KW reversals and while <water bottles="">and <bottles water="">still give the same number, <baking supplies="">and <supplies baking="">do not. </supplies></baking></bottles></water> So I'm left with a big question here as to what the best policy is. Google Adwords Help is very vague on what the match type means in the tool (it seems to be talking about only your settings for your campaigns). So - any input after this long saga? Thanks!
Keyword Research | | debi_zyx0 -
Which is best for keywords; plurals vs singular
Hello! This is my first question so I hope it will be a good one and everyone finds it useful; I have found many conflicting views and need some clarification. Question: When it comes to optimising for specific keywords, which is best; plurals or singular? Example: Should I optimise for 'conveyor' with medium competition and a larger local [exact] traffic volume, or go for 'conveyors' with a higher competition and a slightly smaller local [exact] volume of traffic? Obviously this example is a bit of no brainer as I would tend to sway towards the lower competition with a good volume of traffic to be more competitive, but when the terms are so closely linked, would it be wise to cover both grounds now and go for 'conveyors'? What is general consensus out there? Thanks in advance! Richard
Keyword Research | | BlandyDoes0 -
''furnace filter'' or ''furnaces filters'' Broad or Exact???
Those keywords are the one that will bring the most traffics. They are the one I should use, what will be your recommendations for bring more traffic to home page, using furnace filters or furnace filters? These are the results from Keytools Google: furnace filter (broad local search local): 12,100 furnace filter (exact mach local search) 390 furnace filters (broad local search): 5,400 furnace filters (exact mach local search): 880 After selecting one keyword, should I optimize one page for the other keyword? Thank you for your help. BigBlaze
Keyword Research | | BigBlaze2050