Search for keywords on a topic. What are keywords? What are the keywords?

Greetings, friends. The phrases “keyword” and “key query” are found regularly on the Internet, but often beginners do not know what it is or have a superficial understanding. And, for the readers of my blog site, I decided to make a post about what the term “keyword” means. And for practical application I will also show you these concepts and where to look at keyword statistics and how to select them.

Online key queries are the basis for successful SEO promotion websites and effective advertising campaigns in networks contextual ads– Yandex Direct and Google Adwords.

What does the term "keyword" mean?

Our language, both spoken and written, is replete with unnecessary words, the exclusion of which will not affect the meaning in any way, but will complicate perception - scientifically this is called redundancy.

So, keywords- these are words that cannot be removed from the text without losing its meaning. In essence, it is a skeleton that carries the whole essence, and the remaining words are additional connectives and secondary characteristics.

A keyword (key, keyword) is a word or phrase that, together with other keywords, characterizes a document, forming its subject and meaning. The set of keywords is similar to summary articles with cut connectives and missing sentence structure.

For example, in the text “Last week we went fishing and caught a lot of all kinds of fish” the keywords would be:

• Last week;
• Fishing;
• Caught;
• A lot of fish.

Based on the set of keywords included in a document, search engines recognize its topic (what it is about) and, based on this analysis, decide for which keywords to show it in the search results.

A key query is almost a synonym for “keyword,” but it characterizes not a document, but what we are looking for through a search engine. By entering a key query in the search, we get sites containing the searched or keywords that are similar in meaning.

Selection of keywords for promotion

In this part of the article we will look at keywords in the context of Internet promotion, since it is on the Internet this concept has found its main application.

You have to work with keys in two main planes:

• When preparing web pages for their search engine promotion;
• When creating an advertising campaign in contextual advertising systems.

In both cases, several important points must be taken into account. If you skip them, you will be wasting your time and advertising budget. The rules are as follows:

1. Keywords must strictly correspond to the topic you need, be precise and not imply double meanings. This will allow you to work strictly target audience and do not attract deliberately low-quality traffic.
2. How more words in a key phrase, the more precise the semantic meaning it takes.
3. The request must be in demand - prepare turnkey pages that no one is looking for pointlessly, as well as setting up water for them advertising campaign. Depending on the niche and specific features of the business, the frequency may be different, but the demand must be present. We'll look at where to get keyword statistics below.
4. High competition raises promotion costs, both in organic search and in advertising services. Evaluate the potential of each request based on the ratio of your costs to the projected return. Compliance with points 1 and 2 will help reduce costs. The request “buy a door in Moscow” will be much more difficult to promote than “buy an interior door made of wood with frosted glass in Moscow” (an abstract example).

Conventionally, keywords are evaluated according to two criteria:

• Frequency – HF (high frequency), MF (mid frequency) and LF (low frequency);
• Competition – low, medium, high.

In order to determine the level of competition there are different services, taking into account many parameters (links, number of sites in search results, quality of sites in search results, etc.).

The easiest way is to open a search engine, see how many pages appear for the search query and look at the TOP 10-20 sites. It will immediately become clear how hard you will have to work to get into the ranks of the leaders.

Another important point– see what kind of sites are in the first positions in the search results (shops, aggregators, information, etc.). If the entire TOP is occupied by article writers, then most likely this request will not be suitable for an online store.

When working with Yandex Direct or Google Adwords, use a negative keyword system.

Negative words or stop words are words added to a key query in order to prevent ads from being displayed for them. For example, you sell a program you developed for and advertise it for money. In this case, you don’t need requests containing the words “download, free or crack”.

Keyword statistics – where to get it?

Now let's move on to the frequency of key queries - the volume of demand is key. First they look at the prospects, and only then evaluate the competition and everything else.

It's best to get keyword statistics from yourself search engines– they know what and how often people search.

For these purposes, there is Yandex Wordstat - wordstat.yandex.ru

Using the service is simple - open it, enter a search query into the line and get the numbers. But there are several nuances. Wordstat shows by default general statistics key query, including all its word forms and phrases in which it was contained as part. In the example below, you can see that the request “ ” was included in the statistics of the request “keyword” - this is confusing and gives false expectations - it seems that the potential traffic when the site gets to the TOP is several tens of thousands, but in reality this will not be the case.

To see the real picture, you need to use a special syntax. In most cases, it is sufficient to use two operators:

• Quotes – shows data only for a given phrase, removing all additions and tails, for example, “keyword selection” will no longer be taken into account;
• Exclamation marks – exclude word forms from the statistics, for example, “keywords” will not be included in the “keyword” statistics.

When using quotation marks, out of the original 62 thousand requests, only 1906 remained - this is closer to the truth.

And accurate statistics tell us that users entered the query “keyword” into the Yandex search bar 411 times.

62 thousand and 411 is a huge difference, which many novice Internet entrepreneurs mistake out of ignorance.

Recording a webinar using search queries

The webinar details where to get it and how to use it. search queries(keywords) for the successful development of the site.

Summary

Now you know what keywords and queries are, you know how to choose them correctly to promote your projects, and you know how to look at statistical data correctly. This information will help you assess demand and calculate your strengths when choosing an advertising strategy.

Useful articles:

• 
  How to make money on the Internet for a beginner - 23...
• 
  What is a blog, how to create it, promote it and how...

Keyword- these are one or more words (key phrases) that briefly describe your content. These are a kind of “shortcuts” or “tags”.

What are “key phrases” in Yandex and Google and why are they needed?

The order of words, the grammatical form of words, the case of letters do not matter. Functional parts of speech and pronouns are ignored.

For example, you have the keyword " facing brick Moscow" Then your ad will be shown for all queries that contain this phrase, for example:
- facing brick V Moscow
- buy facing bricks V Moscow
- facing brick V Moscow inexpensive from the factory

In what cases can keywords cause an ad to be displayed on YAN?

What are the types of keywords for Yandex Direct and Google Adwords?

Key requests for heat

Hot Keywords lead to the site « “hot” visitors, that is, those closest to purchasing. They are the most likely to make a profit. If your budget is very limited, you should start with hot keywords.

“Hot” queries can be identified by the presence of certain words in them - these are ““, such as buy, order, delivery, urgently and others.

Warm Keywords show that there is interest in a product or service, but the person is not yet ready to buy. on your topic, it is recommended to cover them in most cases.

Cold keywords called general queries(for example, “smartphones” if you sell iPhones), information requests and queries from related topics. The chances of making a profit from them are lower than those of warm ones. Cold keywords should be covered if you have already made the most of hot and warm keywords.

Key phrases by frequency

All keywords have a frequency. This is the number of searches for this phrase over a period - usually per month or per year.

The Yandex.Wordstat service provides data on the frequency of keywords in Yandex.

Ultra-high frequency keywords (microwave keys):

High frequency keywords (HF keys):

10,000 – 100,000 requests per month. Usually consist of 2-3 words. I have been collecting for best files and instructions for Direct. You can download them if you are looking for features:
- configure and improve Direct qualitatively step by step
- attract maximum “hot” clicks
- save up to 80% advertising budget(there are ways to qualitatively reduce costs in 10 minutes)

For those who work with text, it is very important to find keywords in it. What is a keyword in the text? Let's figure it out.

Definition of the concept

If you correctly find keywords in the text, it will not be difficult to restore the entire text. Alexander Blok said something like this: a text is a blanket stretched across several pegs. Keywords are supporting fragments of text that carry the meaningful load of the entire statement and are arranged in a certain order.

If they are found and located correctly, then the meaning of the text will be clear and understandable.

Key words in the fairy tale “Ryaba Hen”

Let's take as an example the most famous text - the fairy tale “Ryaba Hen”. Each sentence contains keywords:

1. grandfather and grandmother;
2. chicken Ryaba;
3. testicle;
4. golden
5. not broken;
6. mouse;
7. it broke;
8. crying;
9. I'll take the simple one.

Using these supporting fragments, the entire text can be easily reconstructed.

How to find keywords

What is a keyword in the text? Usually it is the main member of the sentence, or at least one of them. If you choose a keyword from the stem, it is recommended to choose one that is related to the subsequent context. Usually, minor members are also elected as supporting members according to this principle - in connection with the following proposal.

Finding keywords using an example text

Let's turn to specific example and find the supporting words in it:

1) Conscience suddenly disappeared. 2) Just recently she flashed here and there, and suddenly disappeared. 3) The inner turmoil and some eternal restlessness of the soul, which the conscience was always stirring up and disturbing with its mere presence, subsided. 3) It became freer and somehow more free. 4) People, having escaped the yoke of conscience, breathed a sigh of relief and hastened to take advantage of the fruits of neglect. 5) They went berserk: robberies and robberies, deception and fraud began. 6) As a result, general chaos and ruin reigned.(According to M.E. Saltykov-Shchedrin)

So, we have to search for keywords in the text, and we will write down parts of the sentence stems or the entire stems:

1) conscience;

2) disappeared;

3) the confusion and anxiety subsided;

4) became freer;

5) people rushed to take advantage;

6) went crazy;

7) chaos and ruin.

To check the correctness of the work done, you need to try to reconstruct the text using these words. Try to do this, if you succeed, then we have completed the task successfully.

Preparation of a supporting outline

When we know what a keyword is in a text, we can use this knowledge in the composing process. Let’s take a simple descriptive text for training:

The night has thrown its blanket over the autumn forest. Silence and peace reigned in him. The trees fell silent in silence. They seem scared. Occasionally, a single leaf falls with a quiet rustle. A milky white fog lifted off the lake and floated to the edge of the forest.

And suddenly a breeze came. He patted the treetops encouragingly and dispersed the fog. And then the mischievous man rushed off towards the dawn.

Stars shine in the sky, giving the picture of the night mystery and splendor.

Here comes the dawn! The world has awakened from sleep. The forest stirred, perked up and stretched towards the sun with joy and delight.

If we are faced with the task of writing a statement, then, having written down during the first reading left side leaf ( reference summary), and when repeated - right side(vivid expressions), we can easily cope with this task.

Keywords - search engine assistants

Nowadays, the concept of “keywords” has another meaning - this is what is the content of the site and what search engines are looking for. For example, I am a seller of frying pans and I have an online store. On my page I post text in which I use this word several times. A person who wants to buy a frying pan will enter the name of this item into the search bar, and my website will come up.

In this case, you need to take into account the density of keywords in the text. If it is too long, in almost every sentence, the search engine will consider the site spammy and will not display it among the first results.

Let's spend practical lesson and try to find keywords in an article from some site, for example, in this one:

This trip changed my life! Altai is truly a fabulous place! It reveals in a person hidden possibilities, which he himself didn’t even know about! Every day of your stay here is eventful: every day brings new impressions. You come to a new place and think: here it is, the most beautiful place in Altai! And half an hour later you are at another point, which is even more beautiful, even more magnificent!

I would especially like to thank Alexander, our guide, conductor and simply a specialist with capital letters. He was able to infect us with love for Altai, and now we are like all relatives, united by one connection - attachment to this magical place. Although everyone is already far from each other, we correspond and communicate, remembering this wonderful fairy tale, whose name is Altai!

Answer: Altai

So we figured out what a keyword in the text is. Without it, it is impossible to imagine a coherent statement, as you can see.

In this article, you will learn what keywords () are and how you can search for them for your site. This will be the second level of search promotion. First comes the website and content, like .

For example, you provide cargo transportation services. To advertise for free on search results, you create a page on your website about this service.

If the service is only in Moscow, then there will be phrases like “cargo transportation in Moscow.” Already part unnecessary people we weeded out. That is, they will no longer contact you about transportation in other cities.

If you offer services for a budget audience, then in addition to the keys we add the words cheap, not expensive, and so on. In general, the right collection semantic core of such requests is necessary to bring the right visitors to your site.

Further, when a person enters in the search “the request for cargo transportation in Moscow not expensive,” then your site may be displayed in the search results. If it is in the top, then there is a high probability that the visitor will visit your site.

In general, keywords for a site are needed so that later, with their help, the same site can be found by a suitable target audience.

This is what I'm talking about now SEO optimization I say. After all, unlike contextual advertising, there are no settings for displaying the site in search results. That's why the only setting These are exactly the search queries.

Fortunately, keyword selection tools allow us to clearly find out which queries will bring traffic and which of them can potentially convert. That is, not just invite a visitor to the site, but bring future clients.

Let's figure out how it all works!

It makes sense to start with brainstorming. The more people you have on your team, the more effective the selection of keywords will be. Try asking questions that my target audience would search for.

The first and easiest option is to use site hierarchy. Any project has its own structure (hierarchy).

Let's take the example of tourists.

Where are we going? This will be a specific country. Then there is a certain region in it. There is a city in this region. And then in the city we go to a certain hotel.

For example, let's take Turkey. We are going on tours to Turkey. Then tours to Kemer. Then we take a certain village in it. And in this village there is clearly a hotel.

We have already roughly assembled the structure. And there are requests that are directly related to this (for example, buy a tour or hot tours) they will simply overgrow this structure, sinking lower and lower.

Second option - we are trying ask questions type, what is interesting to our users. For example, by what criteria do they choose our products?

When we were selecting semantics for office chairs, the main question that forms the semantics is who is this being done for. For the boss or subordinates.

If we return to the same tours, there will be a question like - where are we flying from? For example, from Moscow or Minsk. In general, there are a lot of questions that we must ask correctly and understand how to answer them.

It is during the brainstorming process that these questions need to be thought up. Some of them may be very rarely requested. But at the same time, they respond to a real human need.

Not set and not provided in Google Analytics

So, brainstorm carried out. We wrote down the questions, formed them and structured them. Next, it makes sense to seek factual information.

Even if the web analytics system is not configured, you will already have banal information about transitions to the site. What problems do we have with the web analytics system?

These are two requests - not set And not provided. Google has decided that we don't need to know what keywords users are using from organic search.

How is this expressed?

All users who come from a logged-in Google account are displayed by keyword not provided.

If we think and remember how many people use YouTube, Gmail, Android, and so on, this percentage will constantly grow. Eventually, great amount we no longer know the requests. But at the same time, we have a historical retrospective. We see what keywords we were searched for in the past.

Not set most often means that we do not have tagging or linking configured correctly Google account Adwords with Analytics. This is what I said in the article about.

This also needs to be done.

Just one more thing to consider. Yandex also scripts ( hides) requests. If Google scripted queries are displayed as not provided, then Yandex ones are displayed as “not defined”. This includes a hodgepodge of everything in the world.

If all this shows up for you, then don’t be upset. You just have to clearly understand for yourself what is falling there. What sources and keywords bring you visitors.

But if we have properly configured web analytics before this, then such a tool turns into a calculator. We can historically look at what keywords people used in general.

You can see what keys people used to log in and then go to the contacts page. Or what phrases people came by, who then ordered something and for what amount.

That is, we already have factual data. You can start from them with the idea that this is not just a keyword that brought a person. And it brought us a client.

In web analytics, all this information is collected, aggregated, and downloaded. That is, we already have factual data.

Where can we get more factual data?

Here the statistics of keywords on Yandex and Google comes to our aid:

• Google Adwords Keyword Planner
• Yandex Wordstat
• Google Trends

They share with us historical information about what people were looking for and how. We type in the desired query and see how many searches there were for that phrase in a certain region.

When you work with search engine optimization and contextual advertising, it is very important to guess the trend. It helps us a lot with this Google service Trends.

Often business has some kind of seasonality. For example, a big decline in new year holidays or for May. This is a trend that almost all businesses have.

Accordingly, our task is to catch a trend specifically using suitable keywords and precisely in our niche. Google Trends helps a lot with this.

If you need to prepare for the high season, then movement should begin 6 - 8 months in advance. That is, if the season is in June, then before the new year we begin to prepare an advertising campaign. In context, it helps in forecasting and budget allocation.

Third party statistics services

Search engines have wonderful tools. But at the same time they provide limited and incomplete information. It is greatly diluted with so-called noise. For example, a person was looking for laptops. And he also looked for bags to go with the laptops. But we are interested in laptops, not bags.

In order to create a clear semantic core that interests us, they can help us third party services. All of them are paid and collect data from searches.

Depending on the market you are working with, you can choose one of them. If you work abroad ( for example, in the English-speaking segment), then it will be . This is one of the leaders. The oldest of the services, which clearly allows you to understand which keywords are best to choose.

You can also see what phrases competitors are advertising for in search and in contextual advertising. In the future, all this can be systematized.

For RuNet it will be SpyWords or SerpStat. They work very well with a quality base. In general, depending on the market, we choose required service and we continue to work with him.

conclusions

Now you know what keywords are and what they are needed for. They are our main targeting tool. Therefore, we must constantly focus on working with keywords. We need to look for what queries we are displayed for, see how the trend changes, and so on.

New keywords are also constantly appearing. Some are in a downward trend. So we must track it and correct it on our website pages in a timely manner.

Hello, dear readers of the blog site. I would like to once again touch on the topic of selecting keywords for individual articles and the entire site as a whole. This will allow you to more specifically target the audience that may be interested in your publication.

Potentially. Those. This does not guarantee success, but it allows you to hope for it. In other words, this necessary condition for the successful development of the site, but not at all sufficient.

The most popular tool that allows you to analyze statistics on the use of various words and phrases in search engine user queries is the tool “Word selection” from Yandex(famous WordStat). It is intended for advertisers who advertise on , but this is not important, because the statistics it produces can also be useful for optimizing their own website.

You can work with Wordstat either manually or using special programs. If you need to break through one or two key phrases according to Yandex query statistics, then it will be easier to go to the site indicated just above, but if you want to collect a database of keywords for yourself on the topic you need, then you will not be able to do without automation.

Online service “Word Selection” from Yandex

I understand that there are more than enough publications on the topic of compiling a semantic core on the Internet. But, it seems to me, they were written mainly by those who deal with this matter professionally, i.e. optimizers from SEO firms or freelancers. The methods they describe are quite interesting, because they allow you to automate and simplify the process of assembling the kernel, but personally, they bore me when reading.

The little things and nuances they describe help save time with a large flow of projects that pass through their hands, but if you have a task selecting keywords for your own website, then in most cases excessive automation can even get in the way, because something can be missed or not taken into account.

Here, it seems to me, there is no need to rush. For example, I once bought a wonderful program with Profit Partner bonuses Key Collector. Here. He twirled it, turned it over, and put it on the far shelf. Why? It’s just not for me - it’s difficult to master and understand the usefulness of all the rich functionality it contains. For the same reason, I use Yandex Metrica and not Google Analytics.

Of course, I’m wrong and I had to dig my heels in and achieve an understanding of all the features available in Key Collector (useful of course). But in reality, I downloaded a lightweight version of this word selection program from the same developer’s website, albeit under an unpresentable name Slovoeb(written in Russian letters it is not very printed).

That’s it, now I work exclusively with him, and Key Collector has once again been blocked for me after a system update (it is linked to the computer configuration) and I’m too lazy to contact the author again in order to revive it.

Therefore, today I will only talk about manual use the “Word Selection” tool from Yandex, about using Slovoeb for quick receipt statistics on thousands of key phrases at once and filtering out dummies. There are other tools similar to Wordstat (you can read about them in the article about), but they have not gained such wide popularity.

In general, of course, working with Wordstat is outrageously simple in terms of theory, but quite dreary in terms of practice. By the way, not so long ago they changed their design, but not only that. According to subjective feelings, the parsing speed new version online tool in terms of word choice has increased significantly.

Where to begin? From calmly thinking about the current situation and what you would like to get as a result. You have a topic for your resource (future or existing). For this topic, you can immediately select a dozen or two phrases or words that may be related to it. How do you understand which of the phrases spinning in your head are promising?

You need to look at the statistics of their use when accessing the Yandex search engine. Wordstat is needed for this purpose. True, recently it has been available only for registered users, so you will first have to, and also add to it.

If you already have all this stuff, then it won’t hurt to remember your authorization data, because you will have to enter them into Slovoeb to make it work. Next, enter your first request into the appropriate form on the service page Choice of words :

Oh, how much it turned out. Wordstat displays statistics on keywords for the last calendar month. This means that in a year it will be possible to get an order of magnitude larger number. Although this is not entirely true. One of the reasons may be fluctuations in the frequency of requests depending on the time of year (i.e. seasonality).

This can be checked by checking the box "Request History". For clarity, let’s take, indeed, something with a pronounced seasonality, where the frequency of entering a given keyword in search bar Yandex can change six times depending on the time of year.

If the query you are interested in has a regional link, this will also significantly affect the frequency of its entry into Yandex. To understand this, just click on the link "All regions" and select the geographic location you need.

For example, this is what statistics on a Yandex audience who is interested in pizza delivery in a small town will look like.

In addition, many SEOs and website owners check ) for all sorts of keywords, and do not always use their own for this. And this means that cheating is happening(not special) frequency. Therefore, you should not blindly believe the figures of these statistics and should not take them literally.

And even without this, everything is not so simple. If these were statistics based solely on the use of this one word (phrase) that you entered, then everything would be great. But the Yandex word selection service, when you enter a query into it without any additional operators takes into account in the shown figure all phrases in which this phrase was used (in any word form).

For example, if we return to the first screenshot, we can say with confidence that almost 900,000 times per month Yandex users entered queries in which the word Joomla was found (for example, “templates for Joomla” or “the world’s most popular sites on a content management system Joomla").

This statistics will help you gain perspective creating a website or a separate section on this topic, but when writing specific articles you will need to use other numbers that are more specific. Where can I get them? Good question, which we will now try to answer.

How to collect statistics on the actual frequency of requests (Wordstat operators)

Before starting practice, I want to dwell on those Wordstat operators, which can be used in the Yandex keyword selection service. Actually, there are very few of them. I think that no one can tell about them better than this service’s own help.

Personally, I only use two of them - quotation marks and an exclamation point. You are free to do as you see fit.

So, quotes force the search engine to share statistics on entering only this phrase. However, all possible word forms of the words contained in it (cases, numbers) will be taken into account. For example, like this:

Strange, isn't it? The number decreased three times. How else can you formulate this request search engine? Well, if you think about it, it’s most likely in the plural, especially since the remaining numbers can immediately be seen where they went:

Well, consider the theory done, it’s time to start practicing. All my projects are informational in nature and therefore the seasonality and regionality of requests do not concern me much. If your situation is different, then you will also have to take this data into account in order to understand the prospects.

What you need to consider when assembling the semantic core of a site

Since we are talking about prospects. Assembly consists of several stages:

When developing a semantic core, it is very important to start somewhere (to catch on to something). A few key phrases taken from your competitors, taken from your head, or just obvious ones will become your starting point. But be sure to continue the search process and always have a piece of paper at hand so that you can write down the idea that arises and then look at the statistics in the Yandex word selection service to make sure it is sound.

From any high-frequency query, you can use Wordstat or Slovoeb to get dozens or even hundreds of keywords for your future articles. How to do it? First you need to find such high-frequency speakers. These are the most obvious phrases that users use when turning to Yandex when they want to get an answer to a question on the topic in which you want to get involved in creating a website.

For example, for my blog these could be the words Joomla, WordPress, website promotion, website promotion, earnings, etc. You can start with them. But many people do this, so it wouldn’t be bad if you tried to formulate all the ideas for future articles that come to you into queries that Yandex users could use to find them. We must try to think like an ordinary Internet user asking a question to a search engine.

Selection of words for the seed directly in Yandex Wordstat

OK. You can pour water for a long time. Let's type the query “Site Promotion” in Wordstat and see what it can come up with for you and me.

Amazing. We have received a bunch of information that we now need to try to process somehow. Yandex selected words for us based on the phrase we entered and distributed them into two columns. Both of them are very important.

In the left column of Wordstat All phrases where the entered keywords occur directly are collected. To the right of them is displayed the frequency of their request from Yandex by its users. But don’t rush to rejoice, because this frequency is fake in most cases (). Those. the numbers written there may actually be fiction.

How can you check this? Well, the first thing that comes to mind is to open another Wordstat window in a new browser tab and enter all these phrases from the left column into it one by one, enclosing them in quotes.

Then you will get real statistics (well, or closer to real ones). You can copy these phrases into a Word or Excel document and add the frequencies calculated in this way.

Just? Theoretically, yes, but in practice, after checking a dozen phrases from the left column (from the above screenshot) in Wordstat, opened in a new tab, you will want to forget about all this and go get drunk (or hang yourself).

Routine, not everyone enjoys it. But the left column of the “Word Selection” service window also has page navigation. Imagine, there can be up to 50 pages, which in total will give 2000 selected key phrases. And all of them will need to be checked manually, enclosed in quotes. Perhaps only a few can do this.

And that is not all. We forgot about right column of Yandex Wordstat. But this is simply a wonderful thing. It displays the queries of the same users who entered the phrase from the right column, made by them in the same search session. This will allow you to significantly expand the semantic core of the site, and sometimes even in a very unexpected direction.

What to do with all this wealth from the right column? View its contents and all phrases that are related to your topic, and then try them again open tab browser with Wordstat. In our example, the phrase “site optimization” catches your eye with a high (potentially) frequency.

And what do we see here? And again, there are a lot of interesting things. All phrases from the left column will need to be checked for fakes by enclosing the phrase in quotation marks. And the contents of the right column can be checked to see if there is anything new there that you have not yet added to your semantic core.

And so for many hours you can sit with your eyes open. different tabs browser pages of the Yandex “Word Selection” service, so as not to miss anything from potentially possible clues and at the same time weed out all dummies. After a while, however, you will want to give up all this, because the effort and perseverance needed here are truly not human.

It is precisely against the backdrop of such torment manual selection keywords and you will feel the beauty of Key Collector, or its lightweight version called Slovoeb. What a thrill it is (without exaggeration) to put something that comes into your head into a program high frequency request, automatically parse all pages from the left column of Wordstat, after which also automatically weed out dummies.

The resulting list of actually in demand keys can be sorted in descending order of frequency and saved in CSV format for subsequent analysis and breakdown by article. By the way, the process of distributing keywords among articles can also be automated. I found out about this quite recently from the exchange newsletter ContentMonster(I buy articles Lately mostly only from them).

It turns out that there is online service KeyAssistant under the auspices of this exchange (it’s free, as I understand it), which allows you to distribute keys across pages, and pages into sections. It would take quite a long time to explain its functionality, so I suggest watching a “movie” on the topic and perhaps it will interest you:

Okay, we got distracted, but in the meantime it’s time to get acquainted with our today’s hero with an extremely unassuming name.

How to automate the selection of words from Yandex to Slovoeb

Download Slovoeb you can follow the link provided. It does not require installation - just unpack the downloaded archive and run the Slovoeb.exe file

Immediately after launch, it makes sense to go to the program settings, where in the “Parsing” tabs - “ Yandex Wordstat» to the region “Yandex account settings” You will need to enter at least one login-password pair (separated by a colon and without spaces) to access the services of this search engine. For what? I have already mentioned that recently Wordstat allows only authorized users to use it.

note that It would be better to create new accounts in Yandex(fake, i.e. not the main ones, where you, for example, work with YAN or money). Why? The search engine does not allow parsing its results directly (instead, it provides limits for XML works issuance), so you can get your account banned for showing excessive impudence.

It also makes sense to put it there maximum amount pages from the left column of the Yandex “Word Selection” service, which will be parsed (50). This will be useful when punching through HF requests, because there can be a lot possible options. Sometimes even on last page the total frequency is several thousand, which suggests that not all keys can be collected using Wordstat (unfortunately).

If you don’t want to overload and anger Yandex, then on the first tab of the “General” settings, increase the range of timeouts (breaks between submitting requests to the search engine).

Save the settings and click on the “Create Project” button, or on “Open Project” if you haven’t finished some work before.

Give the project a name, then enter what you are interested in in the line that appears key phrase or word. Did you enter? Okay, press Enter on your keyboard.

Yes, I have Alternative option. Press the button “Left column of Yandex Wordstat” and enter into the form that opens several phrases at once (one per line), the statistics for which you want to parse. Then click the button located below and get several lists merged together at once.

IN modern version Slovoeb will have to wait five or a little less minutes until it docks with Wordstat (this happens only after launching the program, and in further work there will be no such delays).

After parsing of the left column of the “Word Selection” service will begin for a given phrase to the depth (number of pages) that you set in the settings. I always have 50 installed there. As a result, you will receive no more than 2000 keys that include your original phrase.

For example, I took the super HF request “work”. As you can see, even on the last page of Wordstat, the total frequency of phrases exceeds ten thousand. Therefore, in this case we cannot use of this instrument cover the entire pool of requests and much remains behind the scenes. It is probably also possible to pull out the “tail”, but this is much more difficult and less reliable.

So, we just parsed the keys, but we still need to separate the wheat from the chaff, i.e. understand which of these keywords makes sense to continue using in the semantic core, and which to discard due to their extremely low real frequency. The latter is calculated by enclosing the phrase in quotation marks or adding exclamation marks.

In Slovoeb, all you need to do is select the button from the drop-down menu "Yandex.Wordstat frequencies" last or penultimate paragraph. You should already understand the difference between them, so choose what you think is necessary. For some reason I prefer the latter option, but this may unnecessarily limit the results.

Punching the real frequency in Slovoeb is much slower than parsing and, what is important, do not go to Wordstat through the browser at this time, because on which this program It freezes for me. It's possible that this problem only occurs on my computer, but it's still worth warning.

You can follow the process of checking the real frequency with your own eyes - new numbers will appear in the corresponding column in real time. Although it makes sense to let this matter take its course and go do something more useful, but you can only look into the program periodically. Once the collection process is complete, the red hexagon in the top left corner will turn gray.

If you wish, you can stop the process yourself by selecting the appropriate item from context menu this button. The project can be saved and Slovoeb can be closed. And then open the program and the saved project again, and then continue collecting statistics using the method described above. Very convenient and, most importantly, simply outrageous.

Here. After the process is completed, you can sort the results in descending order of frequency by clicking on the column header with statistics of phrases enclosed in quotation marks, or with them and exclamation marks before every word. It will turn out very clearly, because the most promising (even if often unrealistic due to high competition) requests will be at the top of the list.

I advise save all results obtained as a result of selecting keywords lists to file. This is done in Slovoeb using the icon shown in the screenshot, located at the top of the program window. Saving is in CSV format, which, if desired, can be opened in regular Excel, the main thing is to specify the correct column separator so that everything fits together.

If this does not work, then in the program settings on the “Interface” - “Export” tab, select a different saving format (xlsx). There you can also see the separator used when exporting to CSV.

Extra columns in Excel can be deleted (or removed in the same export settings simple removal checkmarks from columns you don’t need - see the screenshot just above) so that they do not reduce visibility. Personally, I leave only the key phrase itself and its actual frequency, and everything else goes into the furnace.

Actually, you can already work with these lists, taking something from there directly, and running something again through Wordstat to obtain new keys (for example, not a complete phrase, but a word or phrase found in it, which in itself can generate lots of options). In general, the process is very creative and, due to its strong automation, not very tedious, especially in comparison with the one described above manual method using the “Word Selection” service.

Other Slovoeb statistics collection capabilities

Yes, I forgot to mention that Slovoeb can also collect search tips. This is what appears when you enter a query into the Yandex or Google search bar.

Among them may also contain quite interesting options keywords, which can then be checked using the method described just above for their actual frequency.

Previously, there was a separate utility for this (SlovoDer) from the same developer (Alexander Lustik), but now this functionality is contained in one program. To collect search tips Just click the corresponding button on the Slovoeb toolbar.

In the window that opens, you need to check the boxes opposite those search engines from where these tips will come from.

Actually, you should also specify the keywords for which these tips will be collected and click the “Start collection” button. The collected keys from the hints will be added to the general list, so that later you can check them all en masse and collect statistics on the frequency of use.

In the general list, they will be marked with a different icon to make it easier for you to work with them and distinguish between Wordstat parsing and search suggestions.

The same applies to collecting words from the right column of Wordstat(Slovoeb can parse it too).

A little higher in the text, I said that when assembling the semantic core, it is very important to pay attention not only to the frequency of selected words and phrases, but also to how high is the competition exists in Yandex and Google results for these queries. The higher it is, the more difficult it will be for you to break into the TOP.

To evaluate it, many suggest using the number of responses search engines give to a given query. I wrote about this in more detail a little higher. So, our wonderful program can parse this very number of answers from Yandex and Google results.

Those. For all the collected words, you can break through their competitiveness using the button KEI on the Slovoeb toolbar:

The KEI parameter is obtained and to rely on it, it would be better to use Key Collector ( paid version given free program with significantly more advanced functionality).

As you can see, even the simplified version of the program has quite rich functionality. What can we say about Key Collector. Another thing is - do you need this functionality? Personally, it turned out to be very difficult for me to find time to master it, especially since I did not see any special prospects in it. I am wrong? Convince me in the comments then.

However, not everyone has the time and energy to conduct similar work(collecting the full seed), but do it anyway absolutely necessary. However, if there is demand, there will be supply. There will always be people who are ready to do this for you; another thing is that they may not always be honest and diligent.

Let me be bold and end with a video taken from Maxim Dovzhenko’s blog, where he talks about settings and word selection in Slovoeb: