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 Research for Low Volume Keywords
Hey friends, I'm looking for a little keyword research direction here, specifically for keywords and phrases with low search volume. I'm just going to give a recent example: I just finished a piece of content on customer experience. I began the process with some keyword research. Based on Moz's keyword explorer, "customer experience" has a monthly volume of 2.9k-4.3k. Sweet. So I move onto related queries and longer tail phrases to narrow my content approach. But just about any relevant phrase shows either a volume of 0-10 or 11-50 and very similar difficulty metrics, making it tough to choose a direction. So "what is customer experience" shows a monthly volume of 0-10. SEM Rush reports ~350 searches a month. I understand SEM Rush uses broader match, but I guess what I'm asking is: how do I perform keyword research with such minuscule volumes and such little data to differentiate? I've looked at Russ Jones' answer to a similar question here on how Keyword Explorer works: https://moz.com/community/q/what-is-a-good-keyword-volume-score ... but I still don't have a ton of clarity. Any advice would be awesome!
Keyword Research | | brooksmanley0 -
Need a keyword tool for the whole company
I alone cannot do keyword research on all of the online content that my company produces. There are about 10 publishing support teams who could do this research themselves, once trained, but I don't know which tool to suggest they use since they can't all use my MOZ login. Right now, those who do any research at all are using Google Trends. Wrong answer, but of course they are used to Trends for their social campaigns. Has your company dealt with this situation? I've looked at a few free keyword tools...each seems to have its plusses and minusses. **What would you recommend...either as a free tool or possible other workaround? **
Keyword Research | | Jen_Floyd0 -
Keyword difficulty report - am I stupid??
Hi, Im a programmer but SEO newbie and I am trying out Moz Pro. To be honest I feel really disheartened right now, I find the world of SEO very difficult and full of conflicting information. Anyway, I am trying to get my head around the Keyword difficulty tool in order to determine what keyword I want to go after and what I would need to do in order to outrank the competitors. The website with the highest PA, most external links to the domain (4000 versus around 80-90), the most linking root domain and the best on page optimasations ranks nr 5. The website that ranks 1 is the only one with good social signals. All of the websites has the keyword in the page title. What am I missing? This makes no sense to me. Is this Keyword tool reliable? VERY grateful for any help from you guys.. /Emma
Keyword Research | | EmmaGrey0 -
How do I make sure my homepage ranks better than my 2nd page when I need the same keywords for both? I don't want them competing against each other for keywords.
I seen here on SeoMoz something about more than one page having the same keywords so they don't compete against each other for the same keywords that makes sense to me. But I would like my main page (homepage) to be ranked better over time rather than the 2nd page or do I just not care about the second page ranking at all and don't SEO the page very well? ,Both pages have similar content so I need the keywords for both. So im very confused on what to do with the second page. Thanks in advance to any helpful answers, i am a newbie when it comes to SEO.
Keyword Research | | DreamKandy0 -
Spammy Industry Keyword Research
Hi everyone, First question posted on here. I have spent a lot time this week going through videos and discussions since I signed up here earlier this week. We're just starting in a particular niche that is powerful (home-based businesses), but EXTREMELY spammy with all the at-home opportunities from stuffing envelopes, to MLM, etc. Then there's the other side which is not as spammy, but just not an overall good business model with the in-home Tupperware, candle, and makeup party sales companies. The people that we help and serve are just people who want to start up a part-time or full-time home-based business doing what they love. Maybe it's a dad who loves golf and would like to start a golf store on Ebay or a lady who is great at making stuff and wants to open an Etsy shop or start selling her goods at craft fairs. Our program is more about teaching them how to start a real home-based business that can either earn them a profit either part-time or fulltime while also doing what they love and spending time with their family. My biggest question right now as we begin the Keyword Research and SEO process part of this, is how do we go about doing the keyword research for this while also dealing with a spammy niche? All the research I've been doing for home-based businesses comes back to all the ugly examples I gave above and that isn't the type of people that we're a good fit for. I appreciate all your help and guidance in advance. Been doing web development for 10+ years but finally taking the tiger by the throat and actually learning the SEO/SEM piece myself.
Keyword Research | | buzzmediallc0 -
Worried about keyword cannibalization
I've been reading a lot about keyword cannibalization and I'm worried that some of my sub pages may be pulling rank from my home page. If I'm trying to rank my home page for the keyword phrase "blue widget manufacturing" and I have sub pages with the titles "blue manufacturing services", "blue widget enginnering", "medical widget manufacturing" is it possible that those pages could be causing me to commit keyword cannibalization? I'm looking at a lot of the results for my keyword phrase and they don't seem to have additional pages with similar keyword phrases. Wondering if I should change my titles so they don't look as optimized.
Keyword Research | | TRICORSystems1 -
Keyword variations
I have a question about keyword variations. To be specific, let's say "blue upside down cars" has low competition but fairly low traffic. However, the shortened variation "upside down cars" has low competition but extremely high traffic. Can I double my bet by going ahead and using "blue upside down cars" whereby in some instances Google would refer traffic based on the entire keyword, but it would also refer traffic based on the the last part of the keyword which has the higher traffic ("upside down cars"). In this case, we would optimize around "blue upside down cars" with hopes of getting traffic for both keywords (the long tail and longer tail). Is there any reason not to pursue this strategy? I hope I made sense!
Keyword Research | | amandahx20 -
Is it bad to optimize for tier one keywords only?
Hello, My site is about personalized cards, and I have optimized (rank A) each sample page to the main topic of the card (eg: sapo pepe). So when people search for that keyword (sapo pepe), my page ranks high. Now, if instead of checking the optimization for "sapo pepe" I check for "cards sapo pepe" I get an F, because the keyword is not there. Thing is that people search for different tier 2 keywords, like "cards, models, examples, etc" and I cannot put that many keywords in the page... My question is: does Search Engines rank you high if you optimize your page for a subset of the keywords people search for? I understand that if someone optimizes for "cards sapo pepe" they would get higher than my site. Hope I was clear, any comment is appreciated! Thanks, MAriano
Keyword Research | | regalatufoto0