How to stay organized for keyword research?
-
As most of you know keyword research can be quite taxing. I have been trying to get organized and do extensive keyword research. But trying to stay organized is proving to be more and more difficult. Can I get some expert views from experts in the community as to how you all go about organizing your research and how you track things over time.
Thanks
-
Here is my go-to from the good folks at seomoz:
http://www.seomoz.org/blog/how-to-build-an-advanced-keyword-analysis-report-in-excel
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
-
Relevant but not-relevant keywords impact to SEO
Hello, I would like to know if the selection of individual keywords(that are not primary, secondary or tertiary) are important for SEO regardless of the relevancy to the page topic. I am wondering how much of a contribution a non-P1/P2/P3 can make in terms of SEO? For example it is a product page and I have built my content with P1,P2&P3 based only on the product and its properties itself. Do you think that a content gap for the page could be the production process of that product? So even if it is a product and its properties page, I can add 2 sentences about the production, so that I can drive more traffic by including these 2 informative sentences.? EXAMPLE:
Keyword Research | | Siir
So lets' say my topic is "hair types" (P1) and my subtopics are "Straight," "wavy," and "curly"(P2s) which I used as subtitles. But throughout the page, I am planning to add some relevant but not-directly-relevant keywords here and there since they have high metrics and volumes. For example a potential sentence I can add: "innovative hair products these days can offer amazing results for the desired hair types". It is not specifically about "hair types" but I am using the keyword "innovative hair products" (good metrics keyword) which may help for the traffic... Another potential not-so-direct sentence can be: "For all hair types, the hair damages are common: heat damage, chemical damage and mechanical damage". Would adding this extra sentence where I am not specifically talking about "hair types" (my topic) but "hair damages" and damage examples (off-topic high metric keywords) help me to drive traffic to my website? And how much of an impact would it be?0 -
Compare clicks per day per keyword on organic and PPC
Hi, Im trying to see the clicks onto my site using specific keywords each day over the course of a week / month in both organic and PPC to compare them to each other. Any help would be much appreciated, Thanks!
Keyword Research | | AlistairD0 -
Documenting keyword research results
I really struggle to document my keyword research results in a usable way. I know the strategy for finding keywords but I wonder if there's a spreadsheet template or some guidance on the process that could help me organise things better
Keyword Research | | Lazeh0 -
National keyword results v local keyword results
If the keyword contains the location term like "SEO company London" is it better to use the wider results over local? Additionally, some best practice examples of national v local result tracking would be great 🙂 Darren
Keyword Research | | SEODarren0 -
Newbie Keyword optmization question
I'm optimizing this page: http://gainesvilleholistichealthcare.com/treatment-options/acupuncture/ This is for a local, Gainesville, Fl acupuncturist. The words that show the most search volume on GKT for the city of gainesville are "acupuncture" followed by "acupuncture gainesville fl". Will optimizing for "Acupuncture in gainesville" or "Your Gainesville Florida Acupuncture solution" optimize it for both of these important terms? I guess my question really is, how specific does the match between the searcher's phrase and the KW's I use need to be.
Keyword Research | | Graphbyte0 -
For an e-commerce page with more than 2,000 products, how should I conduct my initial keyword research?
Hi all, A confused and frustrated SEO noob needing a little guidance here 😞 I'm a bit lost on how I should conduct my keyword research for a start-up e-commerce site selling dietary supplements (~200 brands and ~2000 SKU's). From my understanding, there are two different types of pages I have to optimize for other than the Homepage & CMS pages: Category pages and product pages. As part of the fundamental on-page optimization, I'm planning to write unique category/product descriptions for better visibility (as well as to avoid duplicate content issues) on SE. Consequently, this process has prompted several questions related to my keyword research. My questions are: How would I determine which keywords to optimize for? How many keywords should I target per product page? per category page? Should I include product / brand name as keywords? The site isn't live yet, but is set to launch in mid-August. Any ideas on how I can conduct my keyword research to be used for category/product level pages? Thanks all.
Keyword Research | | byoung860 -
Keyword Research, Feels like my head is about to explode in 1.2...
Hello fellow Mozzers! I've been reading quite a few books and forums on SEO for past few years. Finally a few weeks ago I decided to dive into SEO a lot more seriously and start building and optimizing our ecommerce site. We sell brand name servers, workstations, storage and related replacement and upgrade parts for them. I've read many articles, browsed all the popular SEO forums, watched SEO training videos religiously. I'm happy to say that I now (more or less) understand how to optimize a site/page for SEO (On page optimization, unique content/blogging, link building, social sharing, off page optimization, etc...) However the biggest challenge I'm have with is Keyword Research (which I think is the first and most crucial step). I can't seem to find a tool that will help me find good keywords/phrases that I can target in my business profile. Since its an ecommerce site, and we have about 2500 products which means about 2500 pages. the good thing about product pages is that there are part numbers which get searched quite often so I have no problem with selecting keywords for product pages, however for the home page its a NIGHTMARE. I searched the word "server" in Google keyword tool, and it shows that it has 40,000,000 monthly global searches with low competition. That's great news (right? high search volume, low competition) However when I google server or servers, the 1st page is filled with sites like: Dell, HP, IBM, Wikipedia, and a few more with a very high domain authority and thousands of links. So I'm assuming trying to target "servers" as my keyword for the homepage is probably a bad idea, correct? When I google "buy server" i get mostly irrelevant content like "how to start a calling card business, a few articles(also irrelavant). I guess my question is this: Can you please provide some advice or information on the keyword research articles and/or tools you use? Something that would provide relevant keywords based on a main keyword. Or am I not using the Google Keyword Tool properly I also checked out our main competitors site to see which keywords they use, to get an idea, but when trying to google the keywords they're targeting they're not being displayed on Google for those keywords on the first few pages. We are almost done building our new site which will have a few tools like online server configurator, Q&A section, Server Talk (Forum), Quick Product Finder(Suggests products based on entered criteria) and a few more Which most of our competitors don't have, and I pretty much have an idea on which keywords to use for those pages and sections of the site, but I am completely clueless on the keywords to use for the home page. Any help is greatly appreciated! Also forgot to add, should I just use the company name and a few simple keywords for the home page like servers, buy servers and then write weekly or biweekly article that are server related like Does a small business need a server? How do I choose a server for my business? Should I upgrade my server or buy a new one? Do I collocate or host in-house? Should I virtualize my server? Obviously adding links to products and services within these articles and try to create brand awareness that way?
Keyword Research | | igor.pinchevskiy0 -
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