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
-
Keywords and content query
Hi we are in the process of redesigning a web site and I’m looking to ensure each of the pages are correctly optimized. I’m concerned that some of the pages do not allow for text or content . From an optimization perspective is there a general rule around the amount of text a page should have and the amount/ration of keywords they should contain? Any advice would be much appreciated.
Keyword Research | | aplnzjune180 -
Different or Same Keywords for Second Site
Hello, We're flushing out a second site for a client that's a second site in the same niche. How do I know when to use the same keywords for both sites and when to use entirely different keywords. One site is fairly strong, and the other will be less strong, though we're going to strengthen it quickly.
Keyword Research | | BobGW0 -
Suggestions for RU Keyword Research
Does anyone have suggestions for a better RU keyword tool than Yandex and/or is there a way to see exact searches in Yandex's keyword tool? It seems like the data is not at all accurate. For example - we are ranked #2 for a keyword which has over 40,000 monthly searches (searches according to Yandex keyword tool and position confirmed with someone doing a manual search in Russia). However, we are not getting any traffic for this keyword and according to Yandex webmaster tools the keyword only got 10 impressions this past month. Any ideas for me... or would using Google be preferable eventhough people in Russia don't really use Google?
Keyword Research | | theLotter0 -
Website no.1 on Google for keyword but why?
Hi Guys, I'm trying to figure out why a site is ranking for a keyword. Keyword is "guitar strings" They have only implemented the following techniques: -Chosen keyword is within Meta title -Chosen keyword is used 8 times within content What else would make them rank so highly? Thanks, Dan
Keyword Research | | Sparkstone0 -
Keyword analysis tool
Is it not working? I have not been able to use it for the past 2 or so days.
Keyword Research | | JohnWalker0 -
Google Keyword Tool - Competition - How does it compare to SEOMoz Keyword Difficulty?
Hi, Many times, when I look up a keyword in google using their Keyword Tool, the competition might be low or medium, but, it doesn't seem close to the keyword difficulty on SEOMoz. For example, I looked up fantasy sports. It's low competition on Google. I thought, wow, that's amazing. How can that be when it's so popular? Huge search volume, low competition. Then, SEOMoz says 76% difficulty. It sort of shatters my enthusiasm all of a sudden. Maybe I have to change the order of how I look at it 🙂 What is the difference that's going on? What would be considered low keyword difficulty on SEOMoz? How about medium and high? I know someone might argue that for some guru, what's hard for one person isn't hard for the guru, but, for the average webmaster who does some seo, uses SEOMoz, and some other SEO tools, is there some general breakdown? Thanks.
Keyword Research | | webtarget0 -
International Keyword Ranking
I want measure my ranking for keywords in various countries and search engines. If I use a tool such as rank checker to determine my rank for google.uk, google.au.com, etc... is that accurate, or does my IP still affect the rankings I see? If I use a VPS such as Hide My Ass (or another product you would recommend), would that make my ranking results more accurate? I also want to measure my ranking in Russia, where Yandex is very strong so a tool to measure my Yandex ranking + Google would be ideal. What method you would recommend to accurately determine my rankings in different countries? Thank you!
Keyword Research | | theLotter0 -
Effective keyword grouping - any suggestions?
I have a specific question regarding keyword grouping. Whenever I've have compiled a (long) list of keywords, I create smaller groups of keywords that can be targeted by a category or page. However, I find this to be quite labour-intensive as I'm doing this work manually through filtering in Excel. To illustrate what I mean, here's an example of a keyword list: baby shirt
Keyword Research | | DeptAgency
t-shirt for baby
pregnancy shirts
pregnancy gifts Normally I would create a list of root words, like this: baby
shirt
pregnancy
gift I would then manually filter the list on each root word and copy the filtered list to separate tabs, which would result in lists like this: baby
baby shirt
t-shirt for baby shirt
baby shirt
t-shirt for baby
pregnancy shirts etc. As you can imagine, this is a lot of work. So my hope is that you can help me out with a smart tool / Excel formula / ??? to automate this process. Thanks for any suggestions!0