We work with Yandex Wordstat. Slovoyob: how to set up and use the program Keyword scraper online yandex

The very first thing you need to figure out is what parsing is. Perhaps you know this definition, and even if not, it will be easy to understand. Parsing- means to collect information from any source with subsequent data processing. If we talk about special cases, parsing in seo (in other words, parsing search results) is the collection and analysis of statistics on user queries.

Search engines use parsing too. So, search robots parse, analyzing web pages and entering information about them into the database of search engines.

Yandex.Wordstat is a very useful service in seo. But working with it is possible only if you have a Yandex. It allows you to select keywords based on user queries in order to further compose a semantic core from them.

First of all, you need to define the topic. What do you sell? What services do you provide? Having defined your topic and what you will ask for, you can start using Wordstat.

Enter your query in the search bar. And expand it with the returned results.

The results are presented in two columns. The number next to the request is the projected number of impressions per month that can be obtained by selecting the request you like with a key phrase. The forecast is for the last 30 days before the date of statistics update.

You can configure the search results to be shown by region. If you provide services only in Moscow, select the "All regions" tab (it is located just below search string) and customize for yourself.

In the left column, all phrases with the words of your query, and the words in it, are sorted in descending order of frequency of impressions. It is important for you to immediately select those options for extended keys that will be target for your project. Targeted are those requests for which a user entering a request in search engine, can find what he needs on your site. Target phrases will be of lower frequency, and users who come from search results will be able to find what they wanted, which means they will not leave your site right away. These visitors are important to you, because they are the ones who can perform the target action - buy a product or order a service.

Check the selected phrases - exclude those with a frequency close to zero. To do this, use the ““ (Quotation marks) operator.

Then go to the right column.

The right column shows queries similar to yours. Having collected what you need, do not forget to check the phrases with the operator ““ (Quotes).

Having typed a sufficient number of key phrases, you proceed to the next stage: divide the phrases by frequency. This completes your work with Wordstat.

For some keywords, Wordstat gives incorrect information. How can you check it? Go to the "Request History" tab and take a look at the statistics.

Statistics readings are presented in 2 graphs: absolute and relative.

Absolute indicator- This is the actual value of impressions in different periods of time. And the relative indicator is the ratio of impressions for the query of interest to the total number of impressions on the network. It demonstrates the popularity of the query among all others.

If the graph of the relative value is higher than the absolute one, then, perhaps, there is an automatic cheating of the request, or the interest in the request is higher than normal. Perhaps this is due to the season. So the demand for skis is higher in winter.

The parsing process can be automated. In this case, it is possible to use not only paid and free software but also browser extensions.

1. Browser extension Yandex Wordstat Assistant. Install it in the browser, and when working with Yandex.WordStat, a panel will appear on the left in which you can collect your favorite keywords.

2. Key Collector- the program is paid, but highly functional.

• There is a “Yandex.Wordstat” tab in the settings. By clicking on it, you can set the parsing depth. More keys can be collected this way. But it is recommended to set it to 0 so as not to increase the time. And the keys can be expanded in another way, and it will take less time to collect them. The maximum number of pages for parsing in Yandex.Wordstat is 40. Each page contains up to 50 phrases. Thus, the maximum number of results for one phrase in Wordstat is 2000. And if you want to collect more data, you need to expand the input word list by adding qualifying words. For example, not just "cabbage", but "cauliflower", "cabbage production", etc .;

Download parser archive
This parser collects keywords and frequency into an Excel file from the Yandex wordstat service.
If your frequent tasks include the collection of statistics on keywords from the yandex waterstat service, then one of the ways to optimize the workflow is to delegate the parsing task to the parser keywords.
This parser is not original in functionality, but original in the simplicity of settings and data retrieval by keywords.

Functionality this parser allows you to collect keywords from the wordstat.yandex.ru service, statistics of the request rate of collected keys, the exact frequency of keys, as well as ungroup the collected keys into clusters.

Parser settings:

1. Login from yandex.ru - in this field you must enter the address of your mailbox from Yandex mail

2. Password from yandex.ru - in this field you must enter the password from your mail on Yandex

3. File with keywords - this field specifies a file with a list of keywords (the file must be saved in utf-8 format, each key on a new line), if you plan to activate clustering of queries after collection, then in this file there should be only 1 base passphrase (all words are only in lower case (in small letters))

4. File with negative keywords - this field specifies a file with a list of negative keywords (the file must be saved in utf-8 format, each negative word on a new line)

5. The depth of capture - to what depth to parse

6. Explore results - this option activates the stage of query clustering after the keys are collected by the base phrase (by activating this option, you must specify the file to save the study)

7. Check for exact frequency - this option activates the collection of the exact frequency for the collected keys

8. Deep Scan - this option activates deep scan

9. Key for captchas - optional

10. File for saving keys - Excel file, into which keywords from the wordstat.yandex.ru service will be saved

11. File for saving the study - Excel file in which the grouped clusters will be saved after clustering

If you have any questions or wishes - write to the mail [email protected]
skype - vipvodu
Download parser archive

An example of a file with clusters by key is a client base.

Advice:
1. Check the settings carefully before starting.
2. If the program, after pressing the button - start - turns off - then most likely something is wrong with the settings, or there are hanging processes after the previous interrupted parsing, the hanging processes must either be killed in the task manager, or restart the computer.
3. Do not interrupt parsing, wait for the inscription - All data is saved

One of the most popular modules in Rush Analytics is the Yandex Wordstat parser, and this is no coincidence. When collecting semantic core you need to know exactly the frequency of collected requests in order to correctly prioritize promotion and get rid of "junk" and zero requests. Often the task is to break through tens of thousands of requests for frequency in Yandex, but this is not an easy task for self-written Wordstat parsers and desktop programs, and here's why:

1. Yandex Wordstat has good protection from parsing, for example, banning IP addresses from which parsing is carried out and throwing out captcha in response to requests from bots. To efficiently collect data from Wordstat, you need an efficient IP address connection algorithm and other tricks.
2. To parse a large amount of data using desktop programs, you will need a lot of IP addresses (proxies), which Yandex can easily ban if the connection algorithm is not optimal, and proxies are not cheap
3. Also, for parsing, you will need to automatically enter a large amount of captcha (for example, connecting Antigate for this task). This factor, with a non-optimal parsing algorithm, can make the parsing itself unprofitable, since the cost of the captcha will be too high
4. Most desktop programs have no data loss protection during collection. So, for example, having collected half of the data and spent money on it, if the parser fails, you risk not only not getting the remaining data, but also losing the data already collected

Parsing Yandex Wordstat in Rush Analytics

Taking into account all the difficulties that may arise when parsing Wordstat, we made our Wordstat parser as fast, convenient and resistant to maximum number parsing problems:

• No proxies or captchas! You no longer need to think about banning your proxies or a huge amount of captchas issued by Yandex. Just create a project, upload keywords and wait ready file with the result
• High parsing speed. Our algorithms use the optimal IP connection scheme and other tricks to make the parsing speed phenomenally high - you won't even notice how your project gets done!
• Data safety. By creating a project in our parser, you can be sure that it will be successfully completed and available for download at any time and from anywhere in the world - all data is stored in the cloud!
• Support for all Yandex regions. Many users have a need to determine the frequency of queries in Yandex not only by the region "Moscow" or "Russia", but also by others, including "Ukraine" and "Belarus". In Rush Analytics, you can determine the frequency of requests for any region that Yandex currently supports.

• Collection of all frequencies. With the help of our parser you can collect all the frequencies: search query, "search query", "! Search! Query".

• Collecting the left column of Wordstat. In addition to checking the frequency of requests, it is possible to collect keywords from the left column of Wordstat with a parsing depth setting from one page to collecting all pages in the left column.

• Collecting the right column of Wordstat. Collection of keywords is available from the right column of Wordstat.

If you need high-speed collection of frequencies Yandex Wordstat- Rush Analytics is the best solution, especially if you need to collect large amounts of data. Individual conditions are provided for users with the need to collect more than 100,000 requests per month, just write to our support at

If you have major project with a semantic core for several hundred or thousands of requests, you must agree, sitting in Wordstat and selecting them manually will seem like a sophisticated torture. It is good that there are helper programs that can take over the bulk of the routine work. One of these programs is called Slovoyob.

What is Slovoyob

Slovoeb- a free (and significantly reduced in functionality) version of the program, which is loved by professional optimizers. Most of KeyColletor's functions ordinary user hardly needed, so you can get by with Slovoyob to solve the main task - the selection of keywords.

By the way, the paid KeyCollector also allows you to parse words from Google AdWords - this is especially useful if your site is focused primarily on countries where Google provides the main traffic. Free Slovoeb is limited only by Yandex.

First you need to download the Slovoyob program. You can do this by following the link on the SEOM.info blog.

The program does not require installation. Just unzip the archive to any convenient place on your computer and run Slovoeb.exe. In the future, all your settings will be stored in the selected folder. Before starting work, do not forget to read the material about - the information in the article is relevant for this program as well.

Slovoeb setup

Here's what we see after launch:

Before getting started, there are a number of settings that need to be made. The first is to specify Yandex accounts for keyword parsing. Let me remind you that you can work in Wordstat only after authorization. Therefore, I advise there are about five accounts specially designed for Slovoyob. Do not use special characters inpasswords of these accounts!

I do not recommend using your real account, as the program makes a lot of requests to Yandex per unit of time, for which you can get sanctions.

Click on the gear icon in the upper left part of the program window and go to settings.

Select the Yandex.Direct tab and enter the account data in the format Login: Password... Optionally, you can specify a proxy. Be sure to read the memo in the settings window!

I advise you to study and change other software settings.

Automatic captcha recognition

The next step is to automate captcha recognition. Agree, what's the point of the program if it requires you to manually enter the captcha issued by Yandex every time. Since Slovoyob will send requests to Yandex many times in a short period of time, captchas are inevitable.

I use the service Antigate... If you wish, you can use other programs. Slovoeb supports the following:

• Antigate
• CaptchaBot
• RIPCaptcha
• ruCaptcha
• SocialLink

I had never heard of many of them before.

In the case of Antigate, there is a caveat: they moved to a new site (although the old one is still available). They use a common database, so there is a single account on both sites. Which one to register on is up to you. The first one is more classic, spartan, more familiar to experienced webmasters. The second is more modern.

Please note that Antigate is paid. But inexpensive. 1 dollar is enough for me for 2 months of work (or even more).

Go to the anticaptcha settings page by clicking on the tab on the left side of the settings window.

In field Antigate key enter your anti-captcha key. You can get it in the Antigate profile settings.

On this basic setup Slovoyob is completed.

Selection of keywords with the help of Slovoyob

It's time to proceed directly to the selection of requests. To do this, you need to create a new project. All his data will be saved to a file. There can be an unlimited number of such files, so you can easily switch between projects.

Click on the "Create Project" button:

In the window that opens, choose where to save the file and how to name it. I usually name the files by the name of the site and save them to the project folder (where all other data on it is located). Someone keeps all Slovoyob files in a single folder. Whom it is more convenient.

The next step after creating the project is setting up the region. If your site is focused only on a certain region (or regions), you need statistics search queries precisely according to him, and not around the world. Click on the region selection button and check the boxes you want.

Here everything is the same as in the Wordstat interface:

It's time for keyword research!

To start selecting requests, click on the button “ Batch collection of requests from the left column of Yandex.Wordstat“As shown in the screenshot.

In the window that opens, enter the keywords based on which you want to select queries. Everything is exactly the same as in the Wordstat interface. The main difference is that in the program you can enter several words at once, and the program will work with them in turn, while in Wordstat you need to work with each word in turn, manually, which significantly increases the work time.

Click on the “ Start collecting“. Hooray, now you can go make coffee or switch to other tasks. Slovoyob will take time to collect requests.

Stop words

After the program has parsed the keywords, it is necessary to filter them, discarding combinations and formulations that are not of interest to us. This can be done using stop words. Click on the big button “ Stop words”With a picture of a shield. In the window that opens, click on the button “ Add as a list“. In another window that opens, list the stop words (each with a new line) that should not be in your search query. For example, we are not interested in queries with the words “download”, “torrent”, “ a new version”, “latest version”And so on, since we do not distribute the program itself, but only its description.

After entering the stop words, click on the “ Mark phrases in the table”In the lower left corner of the stop words window.

Working with frequency in Slovoeb

There is one caveat left: the frequency of requests displayed in the column is the base frequency, that is, a phrase with all word forms. To determine frequencies using operators, click on the button with the magnifying glass and select “ Collect the frequencies of the form ” ” “.

Yandex Wordstat is a Yandex service used to select keywords by analyzing user search queries.

Why do you need Wordstat

It is mainly used to compose the semantic core. Wordstat is free, it is multifunctional tool, but so simple that even a beginner can figure it out. With the help of Wordstat, it is possible to find out detailed statistics of requests in the Yandex system for the last month, and to compile not only the structure of the whole site, but also its individual pages. In practice, the service is used to solve the following problems:

1. Collecting the most complete semantics through query extensions;
2. Checking the frequency of requests, including regional;
3. Checking the seasonality of requests.

This is the most basic, but of course there are also smaller tasks that Wordstat helps to solve.

How to use Wordstat correctly

First you need to register there. Here is a link to the service, you can enter words in it without registration, but you can find out the results only after registration. Otherwise, the following garbage will pop up:

It is also important that your Yandex profile indicates your region for which you are going to view query statistics. Otherwise, if you are looking for how many customers for your business are entering the word "fishing rods" in your Nizhniye Vasyuki, and you have the Moscow region, then you may be given that hundreds of thousands of people are looking for fishing rods. You will buy a hundred thousand of them, and only a couple of cripples are looking for them in Nizhniye Vasyuki.

After you register, enter a word there and click the "Find" button. You will get results like this:

As you can see, we have entered the word "brother", and in the left column there will be queries in which the phrase "brother" is present. These requests are entered by real users. In the right column, there are similar queries. The numbers next to each request is their frequency (that is, how often users enter them). But this is not an exact frequency, but an approximate one. That is, the very phrase "bro" in this form can be entered 20 times in total (that is, the exact frequency of her 20 then), but together with the phrases "bros", "bros 90", "come on bros" and others she has a frequency of 27 080. We will learn to determine the exact frequency further.

Basically, they work with Wordstat through special services and programs. Thousands of them! The most famous is Kay Collector. All these programs increase the usability of this tool at times.

They rarely work directly with Wordstat, but I heard awesome stories that in Ashmanov's studio, one of the coolest SEO studios, there are monkeys who enter each request into Wordstat by hand and copy the output to a .txt file. I immediately imagined a hundred slaves who perform the same amount of work per day as one SEO with Kay Collector.

Let's now take a look at the rest of the interface functions:

In block 1- switching between the type of devices. I personally don't use. I make my sites convenient for all types of devices.
In block 2 Is a very useful switch. With its help, you can see, firstly, the regionality of the request (in which region it is entered more often, in which - less often). You can get seriously stuck on this instrument. And secondly, here you can see the "History of the request" - and this is really sometimes very necessary to determine the seasonality of the request and to track the trend.
In block 3- the date when Yandex last updated statistics on requests. In most cases, we don't need this.
In block 4- select the region / regions.

By region

You can see what they are looking for where. It's a funny thing. Here, for example, you can find out that thieves' songs on average per capita are most searched for in Russia, and in Greece and in Israel:

And if you click on Russia, you will see that blatnyak is in demand everywhere, but especially in Dagestan:

Request history

In the query history, you can define seasonal queries and trends, as I said. For example, we can only envy those webmasters who managed to write articles about Trump, because now (late 2016) their traffic has started to grow:

But the most professional thing starts when you work with operators.

What operators are useful when working with Wordstat

You need to know how to use Yandex Wordstat operators in order to work most effectively in the interface.

Basic Operators

Two basic operators- exclamation word and quotes. This is the basics of the basics.

Look, without them we have 25,655 impressions. These are displays of all phrases with the word "brother".

There are only 832 with quotation marks. The quotation marks fix the phrase. This means that 832 impressions - for the phrases "brother", "brother", "brother", taken together, that is, this phrase with a different word order and endings, but without adding other words to this phrase. That is, it does not include displays of the phrases "we are brothers", "we have filled up a brother" and so on.

WITH exclamation mark- 7409 impressions. He fixes the word form. That is, this includes showing the phrases "brother", "nishtyak brother", "hold on, brother" and others with the same ending. And the displays of the phrases "call the brother", "download a song about the brother" and so on are not included.

And here we have only 152 impressions. This is because with exclamation mark and quotation marks, only impressions of this phrase and only in this form are counted. But with a different word order in the phrase. That is, if we enter "nishtyak brother", then Wordstat will show us the sum of impressions "nishtyak brother" and "brother nishtyak".

Auxiliary Operators

A plus. The "+" symbol forcibly respects stop words. By default, Wordstat does not take into account prepositions, and for the query "how to buy a TV" it will show you mostly commercial queries:

If the "how" particle is important to you, then fix it with a plus and Wordstat will give you the following data:

OR operator. Forward slash "|" - if two phrases are separated by this operator, it will show all variations with these two phrases.

By the way, it allows you to compare two queries, for this I mainly use it.

Minus. The "-" character excludes a specific word from the request. Example: "buy a car in Moscow -bu". Requests without the use of the word "bu" will be shown.

Parentheses "()" - groups the use of multiple operators.

Square brackets "" - fixes a sequence of words in a search phrase. This operator was introduced not so long ago. That is, we get the opportunity to find out with what word order the phrase is entered most often:

As you can see, almost no one enters the phrase with the wrong order:

Plugins

Working with bare Yandex Wordstat is generally inconvenient. To make your work easier, you can install a special plug-in in your browser designed to work in Wordstat. Plugins for Chromium browsers (Yandex, Mail, Amigo, Opera and Google Chrome) are the same, but for Mozila there is a separate plugin, all are free and available for download, you can install them directly from the browser. The most popular plugins are Wordstat Assistant and Yandex Wordstat Helper.

Yandex Wordstat Assistant

Perhaps the most best plugin for wordstat.yandex.ru. I use it myself. It's easy to use, practical, and doesn't get in the way when you work on other sites. The installed wordstat assistant is launched only if you go to the Wordstat page. By clicking on the plus signs, the required keyword can be added to the list (it is on the left). The assistant has the ability to sort the selected keywords, and delete unnecessary ones. Just copy the resulting list to the clipboard and transfer it to Excel for further processing. By the way, the convenience of using the plugin also lies in the fact that when you add phrases that are already there to the list, duplicates are automatically deleted, which significantly reduces the work.

Yandex Wordstat Helper

This plugin is simpler than the previous one, but no less popular, it can also be installed directly from the browser. The helper is made in the form of a widget that is added to the wordstat page immediately after installation, you just need to refresh the page and you can start working. Its functions:

1. Ability to automatically sort alphabetically;
2. Checks for duplicates by deleting the last ones;
3. It is possible to process different requests in several browser tabs. The required words are added to the same list;
4. There is a word counter;
5. The ability to copy a ready-made list into Excel, bringing everything together according to the initial phrases.

Before deciding which plugin to use, try both of them in action, this will allow you to make the right choice.

Wordstat parsers

To save time when selecting keywords, they often use specially designed for this automatic programs- parsers, which can be either paid or free.

Some guys order parsers and purely for their needs.

The best paid Wordstat parser is KeyCollector. It is used mainly by those who are professionally involved in the compilation of semantics. The free analogue of KeyCollector is the Slovoeb program. Its functions are truncated, but it is quite possible to compose small kernels with its help.

Magadan is also a fairly popular Wordstat parser, which can also be downloaded for free. It selects and analyzes requests, there is support for regions, and is designed for parsing Yandex Direct phrases.

In the end, I would like to note that Wordstat provides only the data that Yandex has. Therefore, for example, the frequency in Google and other search engines may be completely different.