Academy of Internet Marketing
Contact us
Модальное окно

How to make a list of keywords for your site by yourself

For a person, who works in the SEO-Optimization and context advertising, keyword selection – is a skill, driven to automatism. Asking him such questions as “How to do it?” is often useless, because you will come across the completely bewildered response «It’s easy.”
Especially for those who want to know how exactly SEO specialists select keywords, I decided to write this manual.

On the main page

Go to the main page of your site and formulate by one word about what it is and what it offers to visitors? For example, if you sell handbags online, you can start with these key phrases “shop bags”, “buy handbags”, etc. It is easy to place such requests in a separate column in Excel.


Important! Do not get carried away with too broad and general queries, which can lead you to the website the people who are not ready to buy. If a person is looking in Google for the word “bag”, this does not mean that he wants to buy it. Maybe he needs pictures of bags, a pattern, or the latest fashion trends. And paying for such a person to bring to the site, most likely, you will not even discourage your money, not mentioning the earnings.

Internal pages

Now we one by one go to each section of the site and also describe them with the keywords. For example, the section “Clutches” can be describes with the queries “buy clutches”, “clutch buy”, “clutch price” and so on.
This operation we repeat for each section of the site that sells something :)

Expand the list

Now we need special tools of SEO- specialists. The most classic and free ones are:

  • Scheduler of keywords in Google AdWords;
  • Yandex.Wordstat.

In order to use the “planner”, you need to log in using your Gmail account and go to Tools → Scheduler keywords..
However, more recently, Yandex also terted to request the authorization in its mail for using Yandeks.Wordstat.
At this stage, we need to expand the list of queries for each section.
Google AdWords. Go to Tools → Scheduler of the keywords..
How to make a list of keywords for your site by yourself
Here we need a subsection “Find the variants of the keywords and ad groups”.
How to make a list of keywords for your site by yourself
In it we write your widest keyword. For example, “bags.” It is too general to include it in the list of promoted requests. But on its basis we can construct an extended list of medium- and low-frequency queries.
Do not forget that the geo-targeting should be set exactly on that country where you are going to promote your site.
Once you have clicked “Get the variants”, you need to go to the tab “Keyword Variants” and copy from there to your Excel the file those keywords and phrases that are appropriate to your site.
How to make a list of keywords for your site by yourself
For example, the request “handbags” can suit you rather well, but if you’re trading strictly in retail, the query “wholesale handbags” – certainly is not yours.
Yandeks.Wordstat. This service works on the same principle as Google AdWords. Here you should also choose your region, fill in the search line is the most common key request and to select the strict queries that are suitable for your site.

Expanding the list of internal pages

Following exactly the same methodology we can choose additional keywords for sections. For example, if we take the section “Clutch”, then Google AdWords will tell us such variants as “clutch bag”, “clutch buy Kiev” and others.

Hand expanding of the list

Unfortunately, there is no any service that can give us a complete list of variants and, it means that we have a little more work for our hands. The first step is the adding to the query of singular or plural variants . For example, if we have a request, “buy a bag,” then we add underneath it “buy bags”, to “clutch bags” add “clutch bag.”
First, better to write the maximum, and then remove the recurrences. We also add options with a permutation of words, for example, we wrote “female bag” and manually add another one- “bag for ladies”.
And so on over all previously matched requests.

Regional questions

The word “conditioners” are usually searched along with almost any regional center. A smaller request, such as “clutch” is usually searched only in the format “clutches Kiev.” In any case, try your main keyword to add at least the huge city.

Establishing the order

Now we need to clean up the list, to remove the duplicates and those queries that will not bring visitors. To do this, let’s go back to the scheduler of the keywords in Google AdWords.
Open the subsection “Get statistics of requests for a list of the keywords, or group them by the ad groups”. Load there all the gathered by you list in which each request is recorded in a new line.
Copy it back into Excel with the frequency indicators nearby.
There are only a few details left. Find and remove the duplicates (for more evidence you can sort the list by the frequency) and filter the requests, where the frequency is equal to zero.
Voila! We get a finished list of keywords for the further advancement or setting of content advertising.