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 many keywords do you recommend tracking?
I am working through thousands of organic keywords and would like to create a list of core keywords. I want the list to be small enough that we can really go after these keywords and track progress. I work for a B2B software company. I am thinking between 20-30 but I would love to hear any tips, opinions and recommendations! Thank you!
Keyword Research | | NikCall0 -
What makes a keyword good?
Having taken a day-long course not long ago, I'm new to SEO and I'm struggling to decide which keywords to target. I work in a really niche area: we make booking engines that allow travel agencies to sell flights, hotels, cars and other travel services online. I know there are various tools on the web (and on Moz) which give you the average monthly searches and competition for each term but I still don't understand how to decide which ones to target. For example, the term 'travel systems' gets a high amount of search and the competition for it is high. However, Google brings back results about prams and buggies so I think I should avoid this one. Another is 'travel solutions' which gets a high amount of search and is low on competition. Google brings back results about travel agencies. This is more our area but our target audience is travel agencies so I'm not really sure I'd be attracting the right traffic? I'd be really grateful for any advice that you can give me.
Keyword Research | | noortomlinson0 -
Keyword Ranking
I would like to understand how to search for all instances where Johansens is on the 1st page of Google (US/UK) for any keywords that have Portugal, Lisbon or Algarve in them i.e. "luxury hotels portugal". Is there an easy/automated way to do such a search? Many thanks for your support, Doug
Keyword Research | | CN_Johansens0 -
Used 'wrong' keywords in blog posts, should I go back and edit?
I have a bout 70 blog articles spanning about 2 years. Because I hadn't done proper SEO research, I used the term I thought made the most sense when talking about my services. However now that I have done my homework, I realize that the term I like, is not actually the term most people use to search. Very few of these articles are time sensitive and mostly generic best practice kind of stuff. I'm not talking about keyword stuffing, simply going back and replacing one poorly chosen keyword with one that people are actually searching for where it occurs naturally in the course of the article. Any advice would be greatly appreciated, thanks!
Keyword Research | | sea2dca0 -
Accuracy of search volume for keyword planner v old keyword tool?
Hi there, I'm (logged into Google Adwords) and researching search volume for keywords but I'm seeing weird results. I know that the term "outage notification" had between 1000 and 5000 monthly global searches when I last looked (I know this because I add a search volume tag to the keywords I track ranking of via Moz). Yet, now when I check global search volume via keyword planner I'm seeing only 70 global searches per month (AND low competition which I know is not true). Is this perhaps because only the exact match is reported or is something else going on? Very frustrated as I have now lost faith in the keyword research process via Google keyword planner....not sure where to go from here!! Thanks very much
Keyword Research | | SnapComms1 -
No idea where to start with keywords
I have a friend who owns an IT business in Pennsylvania. I have been on the adwords tool begging for keywords that people are searching for and I am getting no search results at all. I have tried all types of combinations- IT consultant Pennsylvania IT consultant PA network solutions pennsylvania computer tech pennsylvania ...and many variations thereof. Does this mean that maybe just no one looks for this type of business on google? What would you guys do in this situation? Thanks!
Keyword Research | | GroundFloorSEO0 -
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 -
Does keyword arrangement matter?
If I choose: Blue Wide Widgets vs. Wide Blue Widgets vs. Widgets Wide Blue Are these considered 3 different keywords that show up on 3 different SERPs?
Keyword Research | | 13375auc30