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
-
Optimizing a Webpage without keywords
Hi all, I’m really running into a challenge internally lately in that we have a lot of teams redesigning or building new pages (specificially one team) that do NOT loop our teams in. When we finally get them to work with us, to drive traffic to the pages, they disagree that there must be other ways of optimizing the pages than focusing on keywords with search volume that are relevant to the page. We usually land that they will choose a keyword or two they think a user will search for, we do keyword research and pick something close (because they don’t want to utilize a term that doesn’t make much sense, as they have written the content without involving us from the beginning, but then our search volume is declining). They keep saying there are other ways than changing the paired down content on their page and adding in keywords to the H1 headers, content on page. they mentioned semantic search at one point. For example, https://www.entrust.com/products/entrust-getaccess/ currently ranks around #10 for "single sign on solution." This keyword was on the previous page quite a few times in headers and body copy. Now it appears on the page 3 times after the redesign and is not in the h1. The team does for example want to optimize for this term, but there’s lots of pushback as they want a page with minimal content and little design. Just wondering your thoughts on this. IS this a common challenge you deal with too and any idea on answers as I've tried many with the teams? Thanks, Laura
Keyword Research | | lauramrobinson321 -
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 -
Google search not grouping keywords properly
When is a 'Repair' not a 'Repair'...? When it's a "Service" (... cue rapturous applause and laughter!) We run an air conditioning website and we have recently noticed that Google is assuming the keyword "Repair" also means "Service". For example if you type in (in the UK) "Air Conditioner Repair" the first page of Google it puts the word "Service" in bold. E.g: 1. Check this before calling for air conditioner service - YouTube 2. Halfords Autocentres| Air Conditioning Service for all car makes and 3. Service Your Air Conditioner for Summer Comfort « Sustainable Now... why do I find this annoying. I had a amicable dispute with a colleague last year before all of this happened. I noticed that our Google Adwords campaign was showing a high bounce rate for our /air_conditioning_service page. He explained to me that if someone wanted and 'air conditioning service' it was because they wanted their air conditioning fixed / cleaned etc. My argument was that a fair few of the people bouncing off were actually looking for a company to provide a service (of air conditioning) that they were looking for. We split the page in half (half linking through to a repair page and the other half to a page about the service that we offer) and ran a test against the original. I was only expecting a small percentage of people to click on the new option we had added to the page, however, the difference was far greater than ever expected. It was a 60/40% split in favour of the new option not people wanting their aircon repaired/serviced! So in conclusion... very annoyingly, Google is recognising my service page rather than my far more relevant repair page, and there seems to be nothing I can do about it (other than make my service page more relevant) Rant over... but has anyone else experienced anything similar? Is there anything you can do about it?
Keyword Research | | trickshotric0 -
Keywords and On-Page Optimization
Hi i have quite a few keywords i want to rank for which are: how to lose 10 pounds fast how to lose 100 pounds how to lose ten pounds how to lose 30 pounds I can either make separate pages for each of these keywords, but i would prefer to create a single page since most of the content would be very similar, plus i don't think Google would like the fact i'm 'targeting' these keywords individually. Anyway if i do decided to create a single page for all these keywords, what advice do you have? For the URL i'm going to have the keyword 'how to lose weight' or 'how to lose pounds', something generic. Then i'm going to have content which pretty much answers each search query. Now i guess the negative is the fact, i can't optimize the page for each keyword (e.g. keyword in URL, title, or on the actual page itself) So my question how would you approach this issue? How do i tell google (besides backlinking, i will be including these keywords in anchor text) my page is about how to lose 30 pounds or how to lose 100 pounds, when i'm not doing anyway on-page optimization for the keywords individually. Regards, Chris
Keyword Research | | monster990 -
Newbie has various questions about keywords
Hi All - Im just learning, would appreciate some clarification on how keywords work. Specifically: For a phrase keyword, does order matter? E.g. is 'Bridging loans UK' the same keyword as 'UK bridging loans'? Again in a phrase, do the keywords need to be adjacent? So if I had a an H1 tag on my page which was 'We provide Briding loans for the entire UK', would this be considered a match for the keyword phrase 'Bridging loans uk' ? As I understand it, optimising your site for a certain keyword involves 2 things at a basic level:a) Including that keyword on your site, and b) Getting relevant inbound links from other sites with that keyword as the anchor text. Is this correct? Are there other large scale factors? What is the balance between those 2 (or more) main factors? Which is most important?
Keyword Research | | nebbisch0 -
Is it important to have exact keyword in your URL
I have researched exact keywords and noted a four word phrase which has fairly good numbers for exact keyword local searches a month with low competition. If I was to make it as my web address it would mean having www. (18 letters).co.uk Is it important to have the exact keyword in the URL for ranking purposes? Is an 18 letter web address either side of the www and .co.uk too long?
Keyword Research | | TCWorkouts0 -
Keyword domain names
My two best key words are "gps tracking" and "vehicle tracking". For the Irish market I have got the two domain names: www.vehicletracking.ie www.gpstracking.ie Have a very poor landing page on www.vehicletracking.ie and just redirecting www.gpstracking.ie to our site. I am wondering what I should do thie these two assets? Should I be running them as micro sites? re directing them? Or something else? Let me know what you think. Andrew
Keyword Research | | fleurya0 -
How do you do Keyword Research for a company that creates a lot of content
I work for a media company that owns 4 magazines. Our company is constantly producing new content. How do you do Keyword Research when the subject of your content is constantly changing? Do you need to do Keyword Research or do you simply optimize every article that you write for the web? Any ideas?
Keyword Research | | DerekSwanson0