Where do I go from here with my keyword research?
-
Hi all.
I'm wondering if I can get some assistance on keyword research.
I've set out a step-by-step process for myself about how to go about finding a list of keywords we want to optimise our site for. I've used a guide over at http://www.seonick.net/keyword-research to break it down step-by-step.
After using Keyword Tool and Ubersuggest to get a list of keyword suggestions with their local monthly search volumes, I now have an Excel file with 1663 suggestions (yikes!).
It is at this point where I am not 100% sure of what to do with this data & how to figure out which of these terms we should optimise for. I know not to go purely based on the local monthly search volume because that is not based on organic searches.
So how would I go about condensing this into a list of keyword suggestions to target for optimising?
Thanks in advance for assistance on this.
-
Something like this would make an awesome post for YouMoz.
-
So how would I go about condensing this into a list of keyword suggestions to target for optimising?
If this was my list I would have it in excel and sort it by volume.
Then I would look at it, starting from the top to see which ones are most important for the success of my business, focusing on the ones that represent service areas, products and strategic information categories.
Then on small-post it notes I would write these most important phrases.
Then on my planning wall I would draw a vertical axis and horizontal axis. The vertical axis is labeled "profitable", the horitzontal labled "sharable". Then each post-it gets placed on the graph according to how profitable and sharable the topic is for my busness.
The ones that are stick closest to the top right are attacked first with great vigor, the ones that I can produce kickass content for are attacked next with great vigor, then keep working at all of those that are very important.
After you are done there the remainder can be blog posts for the next several years.
This is just one way to think of content categories.
At my office the ones that get done first are the ones that are the most fun to do - because that is where the best work is produced.
-
Heather,
Thank you for your detailed reply.
I'll follow your advice in a two step process:
- Is the keyword relevant to us?
then
- Does the keyword bring up similar companies in Google after a search?
-
Hi Janc
It's a really frustrating process, but totally worth doing: go through every keyword in your spreadsheet, line by line, and ask yourself: "will people use this keyword if they are looking to buy document storage?" if the answer is yes, mark the keyword '1' in a new column.
Then, sort your list by the new column, so that all the keywords with '1' next to them are together- my bet is your keyword list will now be at a more manageable level (probably close to 100).
Then, Google every single one of your keywords to check if the search results are similar companies to yours. For example, if you google "drawers" and the results are all to do with women's underwear, you can cross this off your list as you will struggle to compete for rankings with those results. Or if you google "office document storage solutions" and three competitors are all ranked on Page 1, you know that this is probably a worthwhile keyword to target.
By this stage, your list will be much shorter and much more targeted. Then, look at competition and local monthly searches - based on these, choose your top 30-40 keywords to focus on. Optimise for those high value keywords first - it's a big job. Then move on to the next tranche.
I hope this helps - I am learning all about managing capacity in SEO.
Kind regards
Heather
-
Hi
That's ok no problem. To be honest with regards to the levels of competition for a term we just use the keyword tool and look at the LMS and competition, even though it's not 100% accurate we find that it gives us a 'ballpark' to work from.
Once we have narrowed down the field a bit we also use Google trends to help see the patterns of how people search and use different keywords through out the year. This can lead to some useful topics for targeted blogs through out the year to make the most of the keywords.
I did a quick bit of Google research and came across this site http://www.verticalleap.co.uk/blog/seo-traffic-predictions-how-to-calculate-keyword-value/ which may be of some help to you as well.
Good Luck!
-
Thank you for your reply!
To put what I've done into an example:
Our service is selling document storage to companies in the UK. So I searched for the term 'Document Storage' in the keyword tool and after also putting it into Ubersuggest, I have this enormous list of keyword suggestions.
I'm now trying to condense these into terms worth optimising for for when we launch our new website.
But it is actually this process that I am trying to figure out. How do I know which of these terms (which I'm now filtering into the ones relevant to our service) have lower competition and are easier to rank for, whilst still being searched for by people?
Like I said, I understand that the local monthly searches and competition columns don't give a true estimation on how competitive these terms are.
I'm sorry if I'm not putting across my problem well enough! But as you can see I'm at the very initial stage of figuring out just what keywords we want to try to rank for.
-
Hi Janc
I think it would depend on four main things
- how competitive each keyword was compared to the potential traffic
- how far along the buyer journey the keyword was - you want to be in a mix pf places so that you can build up a brand reputation. It is most important to be at the end stage of the buying process so that you are more likely to convert people as they will just be looking at price/service at that stage. For example compare the term "mountain bike" to "men's red mountain bike for sale" your second customer is ready to buy having done most of the research they now know what they want.
- how the words will fit into your current site structure
- the profit margin/the importance to your business that the keyword relates to
We always start off with a handful of keywords (or group of keywords) for ourselves and our clients and then when we feel that they are working well for us we expand the selection from there.
For example say you had a website selling stationary, when you look at your sales you find that when somebody buys a pencil from your site they always also buy a pencil sharpener, pencil case and ruler to go with them so that they have the set. The traffic and competition might be both middle of the road but the profit margin and the importance to your business is high.
You also might notice that although there is a lot of potential traffic around the keyword phrase 'buy staples' and the competition is low you find that these customer only buy staples and the margin for your business is low.
You would first of all start with the keywords related to the pencil and then expand from there, knowing that the keywords that you were targeting had the most positive affect on your business and led to longer term sales and growth rather than a one off sale.
Hope the above explanation helps, if you have any further questions please let me know and I'll see if I can explain it better!
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
-
Setting Up a Keyword Matrix
Greetings MOZ community!! My real estate web site contains about 500 pages with perhaps 70 pages targeting low volume, somewhat valuable but not very competitive keywords. Three to four URLs target very competitive terms. The following terms are among the most valuable: New York City office space,
Keyword Research | | Kingalan1
New York office space,
Manhattan office space,
NYC office space Such variants as: Office space in New York City,
Office space in New York,
Office space in Manhattan,
Office space in NYC
ETCETERA convert really well How would I match different terms to different URLs? For example I have just re-written the following two critical URLs: www.nyc-officespace-leader.com (home page)
http://www.nyc-officespace-leader.com/commercial-space/office-space (product page) Would it make sense to use "Manhattan office space" and variants on the home page while excluding "New York City office space" variants? At the same time I would use "New York City office space" variants on the "office-space" product page while excluding all mention of "Manhattan office space". Is this logical and does it conform to SEO best practices? For the "NYC office space" terms I would add them to http://www.nyc-officespace-leader.com/listings. This URL has almost no text but a strong potential to rent because of a high number of incoming internal links. Is this approach sensible? In general what measures should I take to prevent URLs from competing for the same keywords? Also, is there a software package or tools that I can use to come up with keyword variants? As a non SEO professional, can I create my own keyword matrix or is this really in the realm of a professional SEO consultant? Thanks, Alan0 -
How many keywords is too many?
Hi there Moz'ers, I run a mens fashion brand called THE AFFAIR, where we craft premium T-shirts and Art Prints inspired by your favourite books. So my problem is that I have no idea what to try to rank for keyword wise because every product is inspired by a different book and author. Whilst I could go very wide and try for terms such as "graphic t-shirts" or "printed t-shirts" they are a) super competitive and b) bear no relation to the primary selling point being the literature inspired basis of what we do. But on the flip side, there's just not that many people searching for "Jules Verne t-shirts" or even "Adventure t-shirts" to go a little wider at the genre level. Basically I'm confused at a conceptual level about how to best select my keywords and desperately need some help before running down the wrong path! For what it's worth the site is built on WP (using WooCommerce) and I have installed Yoast and begin playing around with it... But anyway it's the larger strategy that has me stumped at the moment and I really don't know where to begin. Thanks for your time and all comments very much appreciated. FREE T-SHIRT to whoever has the best solution 🙂 cheers
Keyword Research | | theaffair
Zoltan0 -
Keyword research tool - for off site results
New to Moz, and after playing with keyword research, it seems very comprehensive for analysing keywords based on my site content, and showing me how many people are visiting based on those keywords. However what I'm really looking for is 'alternative' keywords that are 'not' on my site, but still relevant to my sector, and how many searchers are using those. basic example My site is optimised for 'soccer for kids' which Moz shows me getting 50 hits for. Google KW tool reports that every month there are over 2000 searches for 'football for kids' Because my site has no mention of 'Football', Moz doesn't show this as an alternative KW Admittedly my site is new in Moz, so do I just wait a bit longer? or do I continue to use Google KW tool? I'm sure I'm missing the obvious. Thanks!
Keyword Research | | petenorris0 -
Do "search keywords" matter?
I've been getting conflicting accounts about this. We aways fill out the Title Tag, Meta Description and Product Tags(<- for internal purposes) but we are concerned about how important the "search keywords" are. We use bigcommerce and they describe their value as this: "the search keywords are optional, but if entered will be used for two things. First, they will be used along with the product name to create meta tags for search engine (I know meta keywords are not important, so is this what they mean?). Second, they will be used to assist people when searching your products. (Also internal, right?)." For all intents and purposes I think it is NOT super important but I wanted to make sure before I let them take a back burner. Thank you for your help in advance!
Keyword Research | | WNL0 -
What are the checkmarks for on the keyword tool?
I'm looking at the keyword research tool and notice that some of the boxes are checked. I dont really see a reason why? does anyone have this answer? i did attempt look in the Q&A section with no luck.
Keyword Research | | praxiscredit1 -
Comprehensive Keyword Research Report?
I'd like to provide a keyword research report to a client, that includes all of the keywords we're targeting, organized nicely along with relevant data for each (keyword difficulty, search volume, etc.). Is there a way to do this other than running an individual report for each keyword? I'd like to avoid sending them a 50 page document showing all of the keyword research 😉 Thanks for any help! Josh
Keyword Research | | JoshTurner0 -
Why is Adwords Keyword Tool showing zero search volume for popular keywords?
When I try to ascertain search volume for the the words "pills" "drugs" and "medicine" it is showing "-" for all types of search volume, including phrase, exact, and broad. Why is this?
Keyword Research | | nicole.healthline0 -
Do you use broad match or exact match on Adwords Keyword Tool when doing keyword research?
I wasn't sure whether to classify this as a discussion or a question. I'd love "the right answer" but I'm not sure if we're going to get one... Let's try. When you use the Adwords Keyword Tool for doing keyword research, do you use the numbers from "broad match" or "exact match" when comparing relative search volume of keywords? (And yes, I know the numbers need to be taken with a grain of salt, but when it comes down to it, you're using the numbers to compare and come to conclusions regarding the best keyword to use - so which match type gives you the data you're looking for?) To be a little more specific - when you select "exact match" for, let's say the keyword "baking supplies", is that telling you how many people searched for that phrase within quotes <"baking supplies">, or how many people searched for only <baking supplies="">, as opposed to that word within a phrase <baking supplies="" stores="">or with the words reversed <supplies baking="">?</supplies></baking></baking> Based on some keyword research we had done a year ago where any phrase reversals like <water bottles="">and <bottles water="">were coming out with the exact same numbers, even when it wasn't so intuitive that there would be the same search volume, we came to the conclusion - with the tentative suggestion of the SEOMoz staff on the old Q & A - that broad match would include all instances of the keywords in reverse order, so if you wanted to know how many people were searching for <water bottles="">only, you needed to use exact match. </water></bottles></water> That's what we did for about a year (I also think I saw Rand mention that somewhere in a presentation slide recently, although I could be mistaken and I don't recall exactly where it was to check it up) and then based on a recent forum discussion I had where someone was questioning that premise, I did another check with two KW reversals and while <water bottles="">and <bottles water="">still give the same number, <baking supplies="">and <supplies baking="">do not. </supplies></baking></bottles></water> So I'm left with a big question here as to what the best policy is. Google Adwords Help is very vague on what the match type means in the tool (it seems to be talking about only your settings for your campaigns). So - any input after this long saga? Thanks!
Keyword Research | | debi_zyx0