home » Consultation » Keyword processing program. Program for the selection of keywords online. Yandex advanced search

Keyword processing program. Program for the selection of keywords online. Yandex advanced search

We have already told you more than once how you can compose a semantic core for a site yourself and even wrote a book (by the way, you can download it for free). Before trying to gather keywords using the services outlined in this article, I recommend reading the book to understand the basics.

The process of collecting semantics is very laborious and time-consuming, especially for beginners.

There are many specialized services and programs for compiling the semantic core. The most popular: Yandex.Wordstat and Google KeywordPlanner, Key Collector, Slovoeb, Megaindex.com, SEMRush, Just Magic, Topvisor and others.

Many of these products are paid, and each has its own advantages and disadvantages. Below we will take a closer look at 2 helpers for collecting site semantics - one paid, the other free.

Rush Analytics is an online service for building a semantic core

Allows you to automate all routine processes when collecting semantics: from key selection to clustering.

Pros:
- No software installation required.
- Intuitive and simple interface.
- Availability of guides for using the service and tips at every stage.
- Clustering reports have a lot of useful data that can be used to create content.
- You can expand the semantic core using the Search Cues tool.
Minuses:

Of the minuses, it can be noted that this is a completely paid service. Only upon registration you will receive a bonus of 200 rubles. If you have a large amount of work, it will cost you a lot. For example, clustering one key request costs 50 kopecks.

Collecting keywords

After a simple registration, 4 tools for working with keywords will be available: "Wordstat", "Collecting Suggestions", "Clustering" and "Keyword Checker".

Now you can start collecting keywords, for this you need to create a new project:

In the tab that opens, indicate the name of the project and the region:

The next step is Collection Settings. Here you need to choose how the words will be collected:

For work, we will choose the first option: collecting keywords from the left column of Wordstat.

The third step is Keywords and price. We indicate the basic keywords of the site either in a list, or upload a file.

For example, we have a site about the rental of special equipment. We enter the main keys "rent of special equipment", "rent of a crane", "services of a crane". This will be enough to collect semantics.

We also indicate stop words. They will help you filter your list and save time and money. There is a convenient "Stop words by topic" function.

For our site we will add stop words "contract", "work".

After a while, our project will be ready:

Now you can download the file in xlsx format:

We got a fairly large list of keywords (1084 words). Some of them are superfluous, so it's best to go through the list and delete unnecessary words.

Determination of frequency

To do this, we create a new project (indicate the name and region), in the second tab, select "Collect frequency", mark the first three options:

Once the collection of frequencies is over, you can download the file. Let's see what happened. We have already written about how to predict traffic by keywords, if you haven't read it yet, read it.

I will only say that I do not advise using dummy requests for promotion, i.e. words for which the frequency with operators "! Key" is equal to zero.

Keyword Clustering

Clustering is the division of keywords into groups in terms of logic and based on search engine results. After distributing requests to groups, you will receive, in fact, a ready-made site structure.

To do this, click on "Clustering" and create a new project:

We call the project "Spetstekhnika3" (any name of your choice), select the search engine (we chose Yandex), also indicate the region:

The next step is to set up collection. First you need to choose the type of clustering algorithm. These algorithms work according to the same principle (comparison of search engine TOPs), but are designed to solve different problems:
- Wordstat - Suitable for creating site structure.
- Manual markers - suitable if you already have a ready-made site structure, and you need keywords for which you need to promote the existing pages of the site.
- Combined (hand markers + Wordstat) - suitable for the task of simultaneously selecting keywords for the existing site structure and expanding it.
Here we indicate the minimum frequency that we use and the accuracy of clustering:

The higher the clustering accuracy, the more keys will fall into one group. For blogs and portals, accuracy is not so important (you can put 3 or 4). But for sites with competitive topics, it is better to choose a higher grouping accuracy.

As you can see from the screenshot, we have selected all acceptable grouping precisions. This does not affect the cost of clustering, but we will be able to determine which group suits us best.

We proceed to the next stage - downloading the file with the keywords:

The clustering result in xlsx format looks like this:

On the basis of this file, you can draw up a Relevance Map, form TK for copywriters.
Slovoeb program

One of the best free programs for compiling a semantic core. Many call her "the younger brother of Key Collector."

Pros:
- The program is absolutely free.
- The presence of tips, a description of the program and its tools.
- Intuitive interface.
Minuses:
- Requires installation on a computer.
- There is no automatic clustering of queries.
- There are no program updates.
Program setting

You can order the development of a SN and a map (look in the section "Optimization and technical support").

Hello! Almost every webmaster uses Wordstat from Yandex when creating a semantic core. Well, not a bad choice - a huge database and free use. But Wordstat is just one source of keywords.

Below I will tell you about 10 free search sources that can significantly expand the semantics. Some may seem trivial to you, you have read about others but have not used them, and others have not even heard of. In any case, it will not be superfluous to refresh your memory \u003d).

Most internet marketers do not use such databases:

some are lazy and do not want to use them;
others have enough wordstat;
still others do not know about them.

So let's go.

As you can see, not everything is limited to Wordstat. There are sources of key phrases that will allow you to create a quality core. Moreover, no one forbids the use of all tools in a comprehensive manner.

Some sources are not very convenient to use. Simple and inexpensive parsers can be ordered for automation purposes.

Since I mentioned Wordstat.Yandex, I will write a little about it.

Use the right column. It will allow you to fully cover the selected topic.
If the niche is wide and the wordstat statistics does not end on page 40, then you need to "run" the received phrases through the service again. In this case, the parsing will be the most complete.
Free tools to help:
- SlovoEB - truncated version;
- https://words.elama.ru/ - ready-made simple grouping;
- Magadan Lite;
- https://arcticlab.ru/yandex-wordstat-helper/ extension for Google Chrome and Mozilla Firefox to speed up work.

What did I miss? What non-standard ways of collecting search queries do you know? Let's discuss the topic in the comments.

Keyword selection has been and remains a central challenge in creating a viable and competitive website. Anyone who has touched this work at least once understands that it will take a long time to collect a large pool of keys. The technology for collecting the semantic core with one click has not yet been invented. In addition to competence, experience and time, you will need tools that make the process easier and faster. Today in our blog is a selection of services and software that will help you in your work.

Key collector

The most famous service among specialists engaged in the collection of the semantic core. Key Collector allows you to parse keywords from various sources (Wordstat, AdWords, web analytics, search suggestions, etc.). It helps to determine the frequency of requests, filter, group, delete duplicates, remove positions and evaluate by several dozen different parameters.

This is a real "combine" that can cause confusion for a beginner because of the abundance of functionality and buttons.The program is constantly being updated. Developers respond quickly to any changes in the connected services.Apart from the wide range of possibilities, one of the main advantages of Key Collector is its affordable price. The total cost of the service is 1800 rubles.

Rush Analytics.ru

A tool to automate the collection and grouping of keywords. As practitioners note, it works faster than Key Collector, session time is an order of magnitude shorter. Doesn't require the use of proxy servers. Parsing of queries through Wordstat, collection of search suggestions and advanced clustering are available.

All work is done on the server side, which means there is no need for a powerful computer if the work is done with a core of tens of thousands of keywords. You can upload the result from anywhere with Internet access.

Compared to Key Collector and other desktop programs, it gives you freedom of movement without being tied to a specific computer on which the program is installed. The price of the minimum package of services is 900 rubles.

Benefits of Rush Analytics:

huge time savings: up to 100 keywords per second via Wordstat, up to 200 search suggestions and clustering up to 10,000 keywords in 10 minutes;
no need to use proxy servers and anti-captcha;
stop-word functionality allows you to delete unnecessary queries on the fly;
any depth of collection of search suggestions;
advanced clustering algorithm with the classification of queries by type (informational or commercial) and automatic selection of landing.

Bukvarix

The service base is over 1.5 billion Russian words and phrases. Users are relieved of the need to parse queries every time from scratch, which saves a lot of time.Bukvarix contains only the minimum necessary functions for filtering. Therefore, the program is used in combination with Rush Analytics and Key Collector for post-processing. Data can be exported to .txt and .csv.

Wordstat data is presented in two versions - broad and exact match. However, these values \u200b\u200bare valid at the time of the base assembly. I would recommend further double-checking the frequency. The main argument in favor of using Bukvarix is \u200b\u200bthat the program is completely free, and it looks like it will remain so in the near future.

Probably the most famous product of this kind on the Russian Internet. Useful for any webmaster. There are several database options available: Russian - 1.655 billion keywords, English - 1.3 billion keywords and Russian hint database - 3 billion queries and links between them.

Unlike Bukvariks, which is updated monthly, the Pastukhov database is updated only 1-2 times a year.It is quite a logical question - why do we need Pastukhov's base if there is a free Bukvarix? Pastukhov has much wider possibilities for creating selections and filtering keys. For example, you can make selections and sorts by numerical data: the number of queries, the number of words in a phrase, etc.

Another important advantage is that online versions of databases have been available recently. This allows you not to depend on a particular computer and its power. It also makes the base cross-platform, so that the owners of MacBooks and other Linuxes are now also in the subject.For an ordinary freelancer, it can be a little expensive, but for those working with large projects and large semantics, the tool is very useful. The usual price for a complete set is 36,000 rubles. On promotions, you can catch an offer of 8900 rubles.

MOAB Keyword Base

Another keyword base, the creators of which seem to have decided to break all records in terms of volume. It includes 3.2 billion requests from Yandex.Metrica, 6 billion requests from Yandex prompts, and more than 2 billion requests from Google EN / USA prompts.MOAB has an exclusive set of key phrases parsed from all Metrica counters currently closed by Yandex. At the beginning of 2015, a Russian search engine "hung" a lock on this information. But a couple of months before this event, the developers of MOAB managed to parse all this stuff.

The key advantage of the service is the ability to receive requests for which real traffic goes. Moreover, with such data as the number of visits, the number of views, the search engine, the bounce rate, the depth of viewing, the time on the site.

Minus - the base is outdated, and is clearly not suitable for trending topics or fresh niches.It is unlikely that it will be possible to collect semantics on it for queries related to the Apple Watch, since the device itself appeared on the market only in April 2015.

The base does not require captcha and proxy, and when integrated with Key Collector, users receive the latter as a gift.

The secret to business success can be pretty simple. See how the competitors have done and do it better! This rule also works for key guessing in semantics. On related sites, you can spy on requests that you yourself did not think of.

SpyWords.ru is a service that allows you to find out competitors' requests in search and context. Determines the visibility of domains and individual pages. Tracks snippets and SERP positions. Moreover, SpyWords collects data on both Yandex and Google.

You can collect Top domains for a specific request and upload keys for them in general or for a specific URL, which is shown exactly for this phrase:

This is a very good opportunity if you are collecting semantics pointwise for a content plan drawn up in advance.A mix of competitor visibility queries with a little hand or tool polish can provide excellent results.

It is possible to find competitors in the search, compare domains by intersection of phrases, and many other useful options. There are three tariff plans: Business, PRO and Unlim. The cost depends on the duration of the subscription: month, half year and year. The minimum price is 1978, the maximum is 44,550 rubles.

Keys.so

A service for analyzing the semantics of competitors' sites, which displays data on domain visibility in Runet, key coverage and the number of requests up to the Top 50.It allows you to collect keywords for the domain as a whole and its individual pages, and also has a number of unique functions. For example, you can use the Adsense ID and other parameters to "see" the entire grid of projects of the owner of the project you are interested in.

At the moment, the site has over 80 million queries and more than 19 million analyzed sites. It is impressive, considering that we are talking specifically about the Runet. It may seem that this is not enough against the background of databases with billions of volumes, however, this is what has been filtered. The developers have cleaned duplicates and removed all keys with an annual frequency of less than 10.

Competitive analysis allows you to find domains that are in the Top Yandex search results for the keys you need. You should especially pay attention to the percentage of matches for keywords, below is an example for an apple-themed website:

Thus, you can weed out the most relevant sites and not be distracted by monsters like otvet.mail.ru and Wikipedia, which are shown on requests for all possible topics.

Many people know him under the old name - "Promoter". After the rebranding, the service is positioned as a tool for comprehensive search analytics aimed primarily at analyzing competitors' websites.

It is worth paying attention to such features of Serpstat as data on site visibility in search, search queries for which the domain is shown in the Top 100 SERPs, the ability to find out which domain pages are the most popular, and which publications generate the most traffic.

From the menu item "Site tree" you can export the list of pages with the highest visibility, the list of keys and their frequency in a form convenient for further analysis:

In the summary report, you can quickly see the history of visibility changes (a way to find rapidly growing projects), find out the closest competitors and compare several domains.It should be noted that the semantics selection functionality is only a part of the tools. Serpstat is evolving as a one-stop service.Primarily focused on working with Google, Yandex data is available only for Moscow, St. Petersburg and Ukraine. The cost of tariff plans is from $ 19 to $ 299 per month.

One of the first tools aimed at webmasters working in the English-speaking segment, under Google.They also have an analytical base on Google.ru, but it is clearly inferior to more highly specialized counterparts such as SpyWords. But for the bourgeois, this service is out of competition.

Using SemRush you can analyze:

keywords by which competitors' sites are shown in organic search;
the dynamics of changes in visibility over a certain period of time;
which pages are shown for a particular request;
top most trafficable and visible documents;
various data on keywords, such as traffic, number of requests, level of competition, cost in Adwords, etc.

There are many interesting tricks, for example, finding competing sites and visualizing this data in the form of a map:

Overall, the service is very interesting and helpful. Provides services for three tariff plans: Professional - $ 99.95, Guru - $ 199.95 and Business - $ 399.95 for 1 month of use.

A fairly simple tool for quickly selecting queries for Google or a rough estimate of the potential of a niche, which can be considered as an alternative to Keyword Planner.The free version allows you to get up to 750 keywords for any of the regional Google searches (com, ru, com.ua, etc.), for different languages, as well as queries from statistics on YouTube, Bing, Amazon and the App Store. A separate tab with interrogative phrases is displayed:

The downside is that, as you can see in the screenshot, data on frequency, cost per click and competition is only available for PRO accounts from $ 48 to $ 88 per month.

For this money, of course, you can find much more interesting solutions, especially if you work for a bourgeois. So I would recommend considering this service only as an evaluation tool.

For a successful business, you need to competently promote your company on the Internet. Therefore, SEO specialists are in demand now more than ever. However, it takes a lot of time to process and sort keys.

Despite the high level of development of computer technology, a powerful semantic core cannot be created by pressing a couple of buttons. Since this involves processing and sorting a huge number of search keys, this operation cannot be performed manually. Therefore, webmasters are helped by a variety of programs and services that help them successfully cope with this task.

To make life easier for other users, I suggest that you read my review of the most famous tools for processing the semantic core and sorting keys. The SEO optimization tools I have considered have various capabilities, some of them are universal, the rest are used only for auxiliary operations.

Key collector

In my opinion, this is one of the well-known and most commonly used semantics guessing programs. With the help of Key Collector, you can simplify the process of automatic processing and sorting of keys to obtain the necessary data from Wordstat, AdWords. Also useful (especially for beginners), in my opinion, will be search suggestions and built-in web analytics.

With this tool, I can quickly detect the frequency, filter and group them, and then remove the duplicate words. You can also take pictures of positions and evaluate them according to many different criteria.

However, I want to warn you that upon first acquaintance with such a semantic "combine" as Key Collector, it will be difficult for beginners to understand all the variety of its built-in functions.

Also, of the undoubted advantages, I want to note that the developers of this tool are constantly monitoring changes to the connected services. Thanks to this, the Key Collector is regularly updated after a few days.

In addition to the extended set of functions, an important advantage of the Key Collector package is its low price, currently it can be purchased for only 1,700 rubles.

The main purpose of this tool is to automate and simplify the process of processing and sorting keywords.

When working with the semantic core, data for parsing is also used by information obtained through Wordstat. It also selects search tips and separates the entire set of queries that have a common theme into separate groups in order to promote landing pages.

The main feature that distinguishes Rush Analytics from Key Collector and similar programs is the lack of binding to a specific computer.

The system is organized in such a way that the processing of the semantic core takes place on the server. Therefore, when analyzing a large number of keywords, you can get by with a computer of average power. At the same time, the results of work will be available regardless of your location, you can view them not only at home, but also at work or in general in any place where there is Internet.

I enjoy using Rush Analytics for the following reasons:

tremendous speed of word processing (when working with Wordstat - up to 100 keys / s), as a result, in just 10 minutes the system will give you about 200 hints for searching and cluster about 10 thousand keys;
you do not need to use proxy servers, you also do not need to constantly enter anti-captcha;
the built-in stop-words function helps to quickly filter out unnecessary information requests directly in the process of work;
when searching for hints, you can set any sampling depth;
when clustering, the program uses an advanced algorithm that quickly divides the array of requests into separate groups, while simultaneously selecting landing pages in automatic mode;
besides this, the system has many other useful functions.

However, all services of this program are paid, although at first glance the prices seem quite ridiculous. So, the selection of words by Wordstat will cost only 0.03 rubles / word, to determine the frequency - 0.01 rubles. for each phrase from hints, key clustering 0.5 rubles / word.

With a large amount of work, you can end up with a substantial amount. Therefore, the developers of Rush Analytics plan in the future to organize access to the service for regular customers by subscription.

It is popular with those who value their time and do not want to parse requests from scratch. The developers of Bukvarix took care of this.

I usually use this tool when making selections, since Bukvarix contains a minimum of filters necessary for full processing of requests. Therefore, I recommend using this system as a finishing tool in conjunction with Rush Analytics and Key Collector, which we reviewed earlier.

The obtained sampling results are saved in files of formats. txt and. csv.

Many SEOs choose Bukvarix because it is completely free to use. And, most importantly, its developers do not plan to introduce a board in the near future.

Base Pastukhov

The most famous system in Runet, which is convenient for users of any level, from beginner freelancers to experienced webmasters. The Pastukhov base includes three sections:

Russian base of keywords - 1.57 billion;
Keyword base in English - 1.3 billion;
Russian base of prompts - 3 billion. Requests (including Links between them).

However, the Pastukhov database is updated irregularly (1-2 times a year), while one of his main competitors (Bukvarix) updates the database every month.

I also want to note the following advantage: the latest versions of the program have access to online databases. As a result, you can use the system from any, even not very powerful computer with any operating system (Windows, MacOS, Linux).

For the average freelancer, this pleasure is not cheap. For a full set of bases now you will have to pay about 200 USD. Therefore, I would like to ask: "Isn't it better to use free Bukvariks instead of the Pastukhov base?"

Of course, everyone chooses what suits him best, depending on the tasks to be solved and financial capabilities. But for those who are engaged in large projects or large-scale semantic analysis, I advise you to work with Pastukhov's database.

Key collector

Rush Analytics.ru

Benefits of Rush Analytics:

huge time savings: up to 100 keywords per second via Wordstat, up to 200 search suggestions and clustering up to 10,000 keywords in 10 minutes;
no need to use proxy servers and anti-captcha;
stop-word functionality allows you to delete unnecessary queries on the fly;
any depth of collection of search suggestions;
advanced clustering algorithm with the classification of queries by type (informational or commercial) and automatic selection of landing.

Bukvarix

MOAB Keyword Base

The base does not require captcha and proxy, and when integrated with Key Collector, users receive the latter as a gift.

You can collect Top domains for a specific request and upload keys for them in general or for a specific URL, which is shown exactly for this phrase:

Keys.so

Thus, you can weed out the most relevant sites and not be distracted by monsters like otvet.mail.ru and Wikipedia, which are shown on requests for all possible topics.

Many people know him under the old name - "Promoter". After the rebranding, the service is positioned as a tool for comprehensive search analytics aimed primarily at analyzing competitors' websites.

From the menu item "Site tree" you can export the list of pages with the highest visibility, the list of keys and their frequency in a form convenient for further analysis:

Using SemRush you can analyze:

keywords by which competitors' sites are shown in organic search;
the dynamics of changes in visibility over a certain period of time;
which pages are shown for a particular request;
top most trafficable and visible documents;
various data on keywords, such as traffic, number of requests, level of competition, cost in Adwords, etc.

There are many interesting tricks, for example, finding competing sites and visualizing this data in the form of a map:

Overall, the service is very interesting and helpful. Provides services for three tariff plans: Professional - $ 99.95, Guru - $ 199.95 and Business - $ 399.95 for 1 month of use.

The downside is that, as you can see in the screenshot, data on frequency, cost per click and competition is only available for PRO accounts from $ 48 to $ 88 per month.

For this money, of course, you can find much more interesting solutions, especially if you work for a bourgeois. So I would recommend considering this service only as an evaluation tool.

Type