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
-
Keyword inside keyword
Hi, I'm a newb and I'm trying to wrap my head around how this keyword thing works. Let's say I find these KWs as part of my research: Acupuncture Acupuncture Clinics Acupuncture Clinics in Gainesville Acupuncture Clinics in Gainesville Florida Does optimizing for Acupuncture Clinics in Gainesville Florida optimize me for all the other terms as well? And furthermore, might I appear for searches like these too: Acupuncture Florida Acupuncture Gainesviile Acupuncture clinics Fl Thanks a bunch!
Keyword Research | | Graphbyte0 -
Focus Keyword
Hi, I have 2 doubts regarding keywords SEO optimization. 1. I would like to optimize the keyword "liquidation channel". The thing is, in my copy/page title/URL/etc it doesn't make a lot of sense to use this exact keyword, but rather "liquidation channels", in plural. Will I rank higher for liquidation channel anyway? And if so, to which extent? (e.g. about 70%...?) 2. I would like to optimize the homepage for the word "liquidation", but found out that some combinations using this keyword (like "liquidation sales" or "liquidation auctions") would have higher traffic and might work better for some pages. I understand I would still be ranking higher for the keyword liquidation, but to which extent? If it's 100% because the keyword is always included, does it makes sense to use 1-word keywords or should we always focus on multiple word keywords? Would the same apply for 2-words keywords vs 3-words keywords, like "wholesale liquidation" SEO rankings being applied when optimizing "wholesale liquidation sales"? Thank you,
Keyword Research | | viatrading11 -
Keyword ranking tool?
I am looking for a tool that would show ranking keywords for my website - except Google Anlaytics and Webmaster. I don't want to enter the keywords to see if my website is ranking I'd like to see if there are any keywords that rank already Thanks!
Keyword Research | | Rubix0 -
What does it mean when two keywords in Google's Keyword Research Tool have exactly the same amount of searches?
The two keywords are [publicity] and [product placement] (both in exact search - not broad) and have 22,200 searches each. Is it purely coincidental or are the two keywords kind of related in Google's eyes and that's why we're seeing the same amount of searches for each?
Keyword Research | | davhad0 -
Keywords + Country?
Hey guys, Let's say that I'm doing on-site SEO for a website that sells football shirts. This website targets 5 different countries. We only have a .com domain and no other country specific domains will be added at this point. When I choose the keywords, do I opt for product name + country or only product name? football shirts france or football shirts? Some info: Countries have been added in the title of the pages. Countries appear in the footer. Thank You.
Keyword Research | | BruLee0 -
Trying to avoid Keyword Cannibalization
I have a navigation menu at the top of my page with drop down menus that lead to different pages of my web site. Very typical navigation. If I have a page that is optimized for a particular keyword, lets say "Awesome Blue Widgets", do I want to remove that link from the navigation menu on the page awesome-blue-widgets.htm since the link uses the keyword phrase "Awesome Blue Widgets'?
Keyword Research | | TRICORSystems0 -
Why does google's autocomplete not align with google's keyword tool?
Is google autocomplete based solely off keyword search volume? Or is there some other factors i am missing here? Here's an example: Auto complete suggestions for 'storage toronto': [storage toronto cost] [storage toronto downtown] [storage toronto rates] [storage toronto leaside] [storage toronto prices] [storage toronto dupont] [storage toronto laird] [storage toronto eastern ave] [storage toronto ontario] Google adwords keyword tool results for these: <colgroup><col width="151"> <col width="129"> <col width="169"></colgroup>
Keyword Research | | adriandg
| Keyword | Global Monthly Searches | Local Monthly Searches |
| [storage toronto cost] | 0 | 0 |
| [storage toronto downtown] | 36 | 28 |
| [storage toronto rates] | 0 | 0 |
| [storage toronto leaside] | 0 | 0 |
| [storage toronto prices] | 73 | 73 |
| [storage toronto dupont] | 0 | 0 |
| [storage toronto laird] | 0 | 0 |
| [storage toronto eastern ave] | 0 | 0 |
| [storage toronto ontario] | 0 | 0 | So here is what i find confusing: If [storage toronto cost] is the top suggestion for [storage toronto...] then why does google say it has 0 monthly searches? Why isn't [storage toronto downtown] the first suggestion? or better yet, why isn't [storage toronto prices] the top suggestion? So either: 1) google adwords keyword tool is wrong. or 2) google suggest isn't based on just volume?? I've run these same keywords through Bing's Excel keyword information spreadsheet query and it came back saying all keywords had 0 searches ever, except for...drumroll: [storage toronto prices] with 7 monthly searches, once, in august, and 0 all other months. Now i assume that bing/yahoo numbers are significantly smaller, but this does show that that the same keyword is the most popular, so in some way suggests that google's keyword is accurate. So i guess this brings be back to my confusion, what other factors is google's suggest based on, because it obviously isn't primarily search volume. And yes, i have made sure to clear caches, and disable personalized search and search history, and tried the query in several browsers, just to double check i wasn't getting a personalized list, so we can rule that out. Thanks, Storwell.0 -
Most Important Keyword Term
Question about a sites most important keyword term. So lets say you have a website and your most important keyword term is "Blue Widgets", you also have a page named "blue-widgets.htm". What do we do with our index page in this instance? Especially for the title tag? Should I put "Blue Widgets" in the title tags of both pages? I'm guessing this would be a duplicate meta tag error? Any feedback would be greatly appreciated!
Keyword Research | | TRICORSystems
Thanks
-Brandon0