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
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
-
Targeted keywords for landing pages but keyword has a lot of synonyms, how is the best way to approach this?
I'm trying to target one page for one broad 2 word keyword, however, because our niche revolves around this keyword and it's synonyms, the keyword is used on every other page, thus creating the issue of non-targeted pages taking the rank instead of targeted page. I've thought of using synonyms on each page, so that no one page uses the same keyword, but felt this could be seen as spammy or could just hurt overall relevancy towards the main keyword, thus a loss of rank. I understand page authority also plays a part, but also seems that every page other than the page I want get's targeted.
Keyword Research | | Deacyde0 -
Internal URLs competing for keyword
I have an affiliate site where we have reviews of bookmakers, which are optimized for the bookmakers name as a key word. We have seen a drop in rankings and at this point we are out ranked by a lot of pages including our own. We also have a community forum and write news and articles about the the bookmakers. The thing is, that these forum threads and articles often out rank our review pages, which are the pages we need people to land on in order to convert. This page: http://www.betxpert.com/bookmakere/bet365 is optimized for "bet365" and is at this point outranked by http://www.betxpert.com/artikel/ny-funktion-hos-bet365-afslut-vaeddemaal-foer-tid. This page actually links to the review. What should i do in order to increase ranks for my pages? Make the forum threads and articles crappy for the key word? Would it help to add a canonical link to the articles? Would it help to remove the meta tag for update time of the review, such that Google does not downrank for not being recent? -Rasmus
Keyword Research | | rasmusbang0 -
Price Comparison Website And Keywords
I run a price comparison website for a small niche at http://cdkeyprices.com I am targeting keywords for the specific products I am comparing the price/merchants on. On a typical page I would have a price column, product name, the merchant and a buy button. Buy button is affiliate linked to the merchant. The product name in the product column is the name from the actual website I am tracking. As such, my keyword was appearing sometimes up the 30 times. I've took it down some months ago but was wondering if this was a bad move. I was concerned Google would think I was stuffing the keyword. I've only just gotten into SEO the past few months so was not able to see any changes. Should i put the product column back up or would it be considered over optimization?
Keyword Research | | MrPenguin0 -
Ranking for more keywords - Noob question
Hi, I've noticed recently that our site is ranking for a fraction of the keywords that our competitors are ranking for. In terms of increasing the number of keyword rankings per page would it simply be a case of adding optimised copy to each page? Thanks, Dan
Keyword Research | | Sparkstone0 -
Should i go with 50% Keyword Competition ?
I just checked through seomoz keyword tool and found one of my keyword which "Photoshop Stroke Brushes" have around 50% competition.. should i continue to go with or can you suggest me any same keywords ?
Keyword Research | | xplodeguru0 -
Keyword management - where do i start?
Hi all, i am a starting out SEO. I have recently been browsing our keyword rankings report and noticed that we are very low down on some quite key search terms. I therefor want to focus over the next few weeks, on bringing us up the rankings for these specific terms. Apologies if this is a very basic one, but**,.... I dont know where to start!** I would be very interested if anyone can give me some advice on a plan of action. What actions should be in my action plan? For example, if i wanted to improve our rankings on the following: English school in malta Learning english in malta English classes in malta
Keyword Research | | Exp0 -
Duplicated string in the google keyword tool
Is it possible that the google keyword tool is wrong? It's the first time I realize that for many keywords the google keyword tool reports a big volume of searchs for a keyword as if it were tiped two times. In some cases, as the attached image, it's the same volume, in other cases is even bigger the one with the duplicated string What should I think of that, that, "champagne champagne" has really 4 million searchs? if champagnechampagne.com were an available domain name, should it be a good idea for a microsite? Thank you! t9Jwn.png
Keyword Research | | gvnns0 -
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