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
-
Can I use my keyword in brackets '( )'
I need to sort my product keywords in the countries: (UK) (USA) (Global) etc. What does putting my keyword into brackets do - does it negatively affect my SEO?
Keyword Research | | crocman0 -
G's Keyword Planner - 800 kw limit on search volume results?
I'm trying to use Google's Keyword Planner to pull the search volume for a large list of keywords (2000+). While you're able to upload a CSV of up to 3000 keywords, the search volume search only returns a maximum of 800 keywords per query, which is an issue as I have no idea which keywords it's cutting out. Is there any way around this? I have looked around online, but haven't been able to find a solid solution. Thanks in advance!
Keyword Research | | RCDesign740 -
How do I use Google Keyword in onsite seo?
Hello to all, I wanted to ask if I am doing this correctly. So I own a Bernese mountain dog website I used the google keyword research tools to view keyword ideas. I listed my results below. So my questions are: 1 - Bernese Mountain Dog Puppies (the keyword) blow away the other keywords. So when you are looking at your sites most popular keywords, do you make the most popular keyword your homepage? Because it gets the most link juice? Like would you build the homepage around the best keyword instead of branding - like the company name etc? Or does it matter? Basically just as long as you use it for one page? 2 - When you have keywords that have parts of other keywords, is it safe to use the longer keyword because it has parts of the other phrases? Such as Bernese mountain dog puppies for sale is a part of Bernese mountain dog puppies for sale in Colorado. So if you use bernese mountain dog puppies for sale in Colorado, it will also hit the bernese mountain dog puppies for sale? ( without the In Colorado) What type of strategy would you use for this type of situation? 3- Lastly, and thank you for your time - I watched a video from a grey hat seo guy. He said to take a keyword or phrase like say Colorado home builders, create a page like example.com/Colorado-home-builders/ Then make you h1 tag - The Best Colorado Home Builders Add The Best Colorado home builders to your meta description and one more time in your h2 tag Then create a Bold, and italic The Best Colorado Home Builders in your unique content paragraphs. So my question is - is this grey hat and bad? Or the standard? I do not want to get hit for over optimizing. So just wanted to ask you opinion first. In the end, I truly thank you for taking the time to read my questions. I appreciate everyone's help and greatly appreciate your knowledge. So my results look like this | bernese mountain dog puppies | 590 | Low | $0.45 | 1% | |
Keyword Research | | Berner
| bernese mountain dog puppies for sale | 90 | High | $0.42 | 9% | |
| bernese mountain dogs | 90 | Low | $0.37 | 0% | |
| bernese mountain dog puppies for sale in colorado | 30 | Medium | $0.76 | 0% | |
| bernese mountain dog breeders in colorado | 20 | Medium | $0.32 | 0% | |
| bernese mountain dogs colorado | 40 | Low | $0.08 | 0% | |
| bernese mountain dog puppy breeders | 10 |0 -
Keyword Moderator List
Hi Moz Community, I'm wondering if anyone has a comprehensive list of keyword moderators that they could share? For example: online
Keyword Research | | IrishTimes
buy [keyword] online
cheap
cheapest
best
top
free
[country name]
[area name]
store
shop
purchase etc... I always find that it's useful to run [keyword + moderator] for search volumes as it sometimes uncovers some exact match surprises that you may not have thought of. Thanks everyone! Gavin1 -
Page keywords
How many keywords should the home page of a Real Estate site be optimized for?
Keyword Research | | bronxpad0 -
Keyword Research tips at State level
Google Adwords Keyword tool Local Monthly searches covers all US and it is misleading for local/regional companies. is there any tool and method you could recommend to find out State Level (for example Virginia) local monthly search volume for Keyword research. I think the methods of Keyword Research for National and Local (state level) level should be different. what do you think?
Keyword Research | | CertifiedSEO0 -
Location-based Keyword Targeting
We are located in Denver, Colorado. I want the majority of the site to be focused on Denver keyword terms but I also think we should branch out to other cities around Denver, as well as around the keyword "Colorado." What's an appropriate way to do this? I've seen site that have a page for every city in the area but it looks terrible and doesn't really fit into the site. How do I cross link to these new city pages (I don't want them in the main navigation)?
Keyword Research | | kylesuss0 -
Evaluating Competition of a Keyword
I'm curious about how others evaluate the competition of keywords when putting together an SEO program: Do you place any faith in the competition listing in the Google Keyword Tool? Do you find value in SEOmoz's Keyword Difficulty tool? What other tactics or processes do you perform?
Keyword Research | | EricVallee340