Search Engine Optimization March 27th, 2015
Brave yourselves for a long, yet necessary and useful introduction which starts with just one question: what’s the most important thing about promoting a website on Google? Well, there are a lot of factors, but success depends on how much preparation you have done first. A keyword list is the basis for any promotional activities.
So, what is a keyword list? It’s a list of all the possible search queries and combinations thereof that your potential customers may type into a search engine to find your website. I said “all possible queries” for a reason. Let’s define the two types of keyword lists:
The task is to make a practical list that is as close to a perfect list as possible. Remember that it’s important to make a huge list of keywords. It must cover all your potential customers. It may include thousands or even tens of thousands of queries. It must be global.
Also on TechWyse
Sometimes a situation happens when a customer or a contractor wants to focus on, let’s say, 50 keywords. These are very high-frequency and competitive keywords. Imagine you have recently launched an SEO blog. Would it be wise to only promote it with three keywords, such as “SEO”, “SEO blog”, “SEO tips” and so on? I don’t think so and neither do search engines. Just like a keyword list is the basis for promotions, long-tail keywords are the basis for a keyword list. It’s easy to understand:
You’ll probably disagree with the last point, but let’s make it clear. What do we know about users who searched for “flight tickets”? Nothing. Do they want to buy tickets or just compare prices? Where do they want to fly to? When do they want to fly? What class do they prefer? Queries like “cheap flight tickets to Bangkok May 2015” give us more detailed data, which makes it easier to build a behavioural scenario and reach necessary conversion rates.
One more time: Long-tail Keywords are the Basis.
Of course, it doesn’t mean that you must ignore high-frequency queries. The thing is that you shouldn’t focus on them.
You are almost ready to start collecting keywords, but there are some things you must pay attention to:
So, how do you collect them all? Let’s move from theory to practice!
The most obvious option. It provides a list of suggested keywords based on parameters you enter. Go to Keyword Planner (make sure you are logged in your Google account first), then choose “Search for new keyword and ad group ideas”, enter the necessary parameters and click “Get ideas”.
Don’t forget to enter as much data as you can. This is what you’ll come for:
There are two tabs:
As you can see, you can sort them by several metrics. Try sorting by ‘competition’ and you’ll find a lot of low-competitive long-tail keywords. What you want to do now is to click the “Download” button right above the “Ad impr. share” column. After downloading a .csv spreadsheet, open and check it. As far as you’re not using AdWords, you can leave only the Keyword column .Got it? Check your spreadsheet and then put it aside – you’ll need it later. Now let’s move on.
Another popular keyword research tool. You can find it here. Choose the search engine you are targeting (it’s Google in our case), country, language, and enter a topic. You’ll get a great number of suggested keywords. It’s easy to browse through the list with help of the alphabetic order panel. There is also a button to copy all the suggested keywords, or you can copy the necessary queries manually by pressing the plus buttons at the right.
Unfortunately, it doesn’t provide such insightful data on keywords, but still it’s one of the most popular tools, because it’s easy to use and works pretty effectively. Just copy the necessary keyword (or all of them) and paste them into a spreadsheet from the previous point.
This works almost like Keyword Tool, but with some minor differences. Go here, type a topic, choose a language and a source – this is where differences take place. With Ubersuggest you can choose a source to search for suggestions like web, images and so on.
There is another difference, or maybe it’s better to say an additional option – by clicking on suggested keywords you’ll get even more suggestions – you definitely must check out this feature. Have you selected your necessary keywords? Great. Click “Get” at the right and copy & paste them into our spreadsheet.
Simply enter a term and get suggestions. You can use * to make Google fill in the blank. After that, add all the selected keywords to the list and click download. You will get another .csv spreadsheet – copy the data and paste it into the previous one.
You can find it here. It’s a nice tool to collect keywords, but it’s paid for. Free users can only make 3 searches a day. Pricing starts from a $19 one-time payment for 50 searches a day. Is it worth it, if you can use more powerful tools for free? Use it as a secondary tool.
This tool requires registering with. It’s free and takes less than a minute to do. Enter a basic term and choose the desired options:
I recommend choosing Fuzzy match and G Trends for keyword researching purposes – this way you’ll get as many keywords as possible. Choose More if you want to find some additional information on a term.
That’s it. Now click Submit.
Submitting our term and…
Then you can download a list in .csv, but it’s not very convenient – all the data is written in one column. Just look at this:
What you want to do now is to import data from this file to your current, well-organised spreadsheet. Open it, go to Data – From text. Then select a .csv file you’ve downloaded from the SEObook Keyword Tool, click Next (you’ll see that Delimited option is selected by default, it’s ok) and select Comma in the next window. You’ll be shown a preview of the imported data. Click Finish and that’s it – you have successfully imported your data.
Delete all unnecessary columns and you are ready to move on.
Now you have a spreadsheet full of keywords. What should you do next? First of all, you need to remove any duplicated keywords. Open your spreadsheet, choose the Keyword column, go to Data – Remove Duplicates.
Excel will show you how many duplicates were removed.
Now it’s time to clean up your list. Duplicates have already been removed, but there’s still a lot of work to do. Go through the list and check it for irrelevant keywords, keywords in other languages and so on. For example, I found the following inappropriate keywords in my test list:
agencias de internet marketing – other language
brian g jonhson internet marketing – no, that’s not for me; irrelevant
internet marketing Kenya – this isn’t the keyword I’m looking for; irrelevant
How do you find irrelevant keywords? That’s simple. For example, you’re researching keywords for a website that sells furniture building services. Why would you need something concerning furniture which is already built and ready for sale, or keywords like download furniture and free furniture online? Delete them.
What’s the purpose of cleaning your list, if I said that it should contain as many keywords as possible? That’s right, but these keywords should also be as relevant as possible. By including irrelevant keywords, you’ll be getting non-targeted traffic – people who search for turnkey furniture solutions will visit your website, see that it’s not what they were searching for and quit it. As a result, your bounce rate will increase, which significantly hurts your websites ranking.
It’s time to completely reorganise your list. You can work with the current spreadsheet or create a new a new one and copy the data there – use what’s more convenient to you. Create a list of pages you need to promote and create sections for them in a list. Put the pages’ titles in the Keywords column and rename it to “Pages/Keywords”. It looks something like this: you go through the Pages/Keywords column, you see a page’s title (highlight it in yellow to make it more eye catchy) and then comes a list of necessary keywords.
What you want to do next is to add a column for URL’s. Add the URL of a page you want to promote for each section’s or page’s name. You still have a free space in the URL column for keywords themselves. Here you can use the following indications if necessary:
Look at the screenshot below to make it clearer.
Congratulations, you have collected an awesome list of keywords!
After a keyword list is ready, it’s time to learn what you should and should not do:
Sounds obvious? Indeed, but practice shows that these are the mistakes which beginners make when researching keywords. Follow these simple rules to optimise your keywords experience.
…you may say. And you’d be right. However, keep in mind that each hour that you spend researching keywords is worth additional profit. The only way to win in highly competitive conditions is to work hard on planning, developing and implementing.
The Uncensored Guide to Building a Keyword List for BeginnersRead time: 8 minutes