Requests by topic. Google Search Query Statistics: Collecting Everything

Hello guys! All of you are well aware that I have long been rummaging with keywords. I mean, I’ve been doing this on a commercial basis for a long time.

All of my services that I described have long been expanded by me many times. Different perverts come up who come up with such tasks that I would never have thought. Well, I gradually become a mother due to the fact that they force me to perform their difficult tasks

Probably everyone remembers that I wrote many times about Shepherd’s databases: I told you a long time ago what this awesome software is - then I told that Maxim Pastukhova (the author of the software) announced the release of the 180 millionth Russian keyword database. It .

But recently, I was doing a project for the site of one respectable person. The project was exclusively for Yandex. I parsed his site, found the keys by which he already occupies a normal position in the issuance, evaluated these keys with the help of the wordstat, rambler, Rookee ... everything is slowed down on this.

The result is a list of good keys. But! From them, many ambiguous keys are obtained. Here they are

That is, take for example the key " radio radio listen online". We look at the frequency of wordstat. The screenshot shows the exact frequency. That is, the operator “! Word! Word” was used. And what do we see? That this key has a frequency of 563141 for my region for which the analysis was done.

The client immediately asks me: “Sergey, what the hell is this? Where did the unfortunate " radio radio listen online"563,141 hits per month?" And the Rookee conversion forecast shows a -1 transition for this key, which means xs how many of these transitions will be. That is, it means that there will be 0 of them.

And then I just dopped what epta, because it’s a great idea for the post - to paint this volley, which is in the Wordstat, especially since Maul recently wrote about it. Only I will tell about it from my bell tower, and also show in addition how this problem is solved.

And what is stuck, then stuck. Here's how to understand what it really is? The first thing that comes to mind is to go to the help of the Wordstat itself, and read what they write about it themselves. But no, the only thing we see:

And what is the result? But nothing! From what is written here, a fig is not clear why blah on request " radio radio listen online"Such a large number of impressions.

But in fact, this volley has a simple explanation. We are opening fresh pastukhov bases for 180 million KEIs, making a selection from the database with the keyword “listen to radio online”

I think those who often delve into the Wordstate are well aware that pulling out such keywords from there is almost unrealistic.

These, by the way, are not the longest keywords. AT shepherd's bases  I added a frequency display by wordstat.yandex. Look, there is more abruptly, or rather, more authentic keys

Or here's another

Clearly, 10 vocabulary " internet radio online listen free europe plus mediaplayer classic»Cannot have a frequency, and if it can, it is so insignificant that it does not appear in wordstat. But the fact is that it’s such verbosities that create this volley with keywords. See for yourself

What do we see here? We see that the ten-word dictionary "Has a frequency of 5967, which in itself seems to be some kind of utopia.

So why is it so?

There is one feature in Wordstat - in it poher  the order of keywords, in connection with which if you do not understand the whole mechanism, then you can stupidly squander the loot, moving in the future keywords that do not give traffic output.

All this is very clearly visible when we add a column with query statistics to the Rambler in the shepherd’s databases, in which the word order no poher. Then the picture becomes immediately clear, and we see for which requests there is a system, and for which not. That is, which queries are introduced regularly, which ones can really be promoted, and which ones simply create statistics for those volleys that I showed above. Here in the shepherd’s bases, it’s especially hurt that you can immediately estimate the frequencies of Yandex and Rambler for a particular keyword

I specifically grouped requests here to make it clear. That is, ideally, if promoted, then take such keys, where there will be frequency according to Rambler and Yandex. But this is ideal.

And yet, how is it that a 10-word query with repeating words can have a frequency of 5967?

I’m honestly, why they didn’t write in the help of the Wordstat help, why can this be so. But the point is this.

As already mentioned above, many requests are introduced in Yandex, among which there are many ten-word queries. And even more. Often this information cannot be pulled from the Wordstat, but all of these keys show the Shepherd’s bases well (note - the project is now closed). And the answer lies in the fact that duplicate words are not taken into account directly in the request.

That is, the request "! Radio! Radio! Radio! Radio! Radio! Radio! Radio! Radio! Radio! Listen! Online!"", Having a frequency of 5967, in fact, in exactly the same form is not shown as much as the Wordstat displays. Only the phrase “listen to radio online” is taken into account here. That is, the last three words. And instead of the previous 7 words “radio”, completely different words can be used. And all this creates statistics for this ten-word dictionary. I specifically in the pastukhov databases made a selection of the results on "listen to radio online." There you can sort by the length of search queries, and by the number of words

And in the end, we get all (or almost all) of the ten-word keywords that make statistics for our "! Radio! Radio! Radio! Radio! Radio! Radio! Radio! Radio! Radio! Listen! Online!"". Here they are:

And there are more than enough of these ten words. That is, I repeat once again that instead of the word “radio” there can be any other word, as long as it is included in the ten-word dictionary that contains the phrase “listen to radio online”.

The situation would not be so ambiguous if the wordstat showed the keywords in exactly the same order as they are requested. But no. In our ten-word dictionary instead of the word "radio"  there can be any other words, and all of them can change places inside this ten-word book, thereby winding up its indicator in the word-word.

That's why it turns out that the request is " radio radio listen online"In fact, in exactly the same sequence and with exactly the same words as indicated here, it does not have a frequency of 563141 and never had. And such a figure is obtained, because instead of the first word “radio” there can be any other, and it can stand anywhere within the framework of this four-word dictionary, which ultimately forms such a large number in 563141. And there are a great many such four-word words of different interpretations

A huge role in the search engine promotion of the site is played by the literacy of the semantic core and the distribution of search queries across the pages of the resource.

The fate of the project will largely depend on this, for this reason it is important to pay special attention to the selection of key queries for which it is planned in future in Google and Yandex, I have covered more than one article on this topic, but I think that for beginners you need to chew even more details , for example, one of my articles - there I talked about selecting keywords and assessing their competitiveness in the Google system - adwords.google.com and today on the blog, we’ll take a closer look at all this.

But with all this, look, do not overdo it with the richness of keywords on your online project, read -.

1.1.Frequency of search queries

The popularity of a keyword can be determined by its frequency. The higher the frequency, the more profitable it is for a search query, since more visitors can get to the resource through it.

Frequency can be determined by special services of statistics of search queries. Such services contain information about how often users enter a particular key in a search engine (key request).


In the picture above, you can see the statistics of the key expression “site promotion”. In such cases, the wordstat.yandex.ru service can be used, which displays how often users typed this request in the Yandex search engine.

Here is a detailed video on working in wordstat.yandex:

Since approximately 55% of Internet users use this service, the exact statistics of the key can be determined by adding the missing 40% to the received figure.

In addition, in terms of frequency, key queries are usually divided into three large groups:

  • high frequency;
  • midrange;
  • low frequency.

There are no strict numbers and frames in such matters, everything is only approximate. But, as a rule, it is customary to consider low-frequency queries as indicators with an indicator of less than 1000 queries / month, medium-frequency queries - 1000-5000, while high-frequency ones - more than 5000.

Sometimes you have to come across a term such as ultra-low-frequency queries, which implies queries with an indicator that does not exceed the value of 30-100 queries per month.

Meanwhile, such a division of requests into groups will depend on the subject matter of the request. For example, for requests for commercial topics, the indicated bar will be lower, while for entertainment - higher.

It is necessary to mention the LongTail requests, which contain a huge number of words, from which the name came (“long tail”). This type of request makes no sense, due to their low frequency.

But such keys can lead to the site 50-80% of all visitors. As a rule, in such cases, the site is promoted independently, without requiring additional costs and seo optimization, that is, you wrote and optimized an article for one key request, and it went to the top for thousands of micro-frequency ones (1-10 requests per month) called - LongTail - long tail of requests !!

2.2. Google Operators

The table below shows the Google search engine commands. You can familiarize yourself with the operators here.

2.3. Keyword Selection

In most cases, search queries are selected using statistics services, but there are other techniques.

3. Statistics services for the selection of search queries

Today it is the most popular way to obtain statistics on search queries. Such services are free, which made them popular. But you need to remember that the service only reflects the data that is available to it.

  1. Yandex Wordstat   . The service covers about 55% of the data on the main search queries, which made the service popular when compiling a semantic core for sites in Russian. You can select the basic and associative queries.
  2. Google. Adwords   . The service processes approximately 30% of search queries. Today it is the second most popular statistics service. The functionality is similar to the service from Yandex.
  3. Rambler. Adstat. Service ranks third, but its result is only 5%. Rarely used by webmasters.

3.1. Search for prospective queries

These services are not the only ones, so sometimes you can use more original ways.

3.2. LiveInternet Analysis

This is the service of the famous counter, which contains a huge statistics of search queries, which can be freely analyzed. In addition, in this case, you can more accurately predict the potential success of the site than with the services listed above.

First way

First, go to the statistics link   , then select the section of interest, the list of which is on the left side:


Now you can start -competitors by borrowing search queries for yourself. It is recommended to choose sites located beyond the 10th page of the service.

Pay attention to the color of the icons. By color, you need to choose light sites, since dark ones are sites with closed statistics and they are useless to us.


Now it remains to find those sites whose statistics are completely open, we are most interested in "search phrases":


Second way

In this case, you need to analyze the TOP of search engines. First, the key of interest is entered in the search bar, after which the sites in the TOP are analyzed.

3.3. MegaIndex Analysis

MegaIndex   - This is an automatic promotion machine, which, thanks to the huge and free functionality, allows you to find interesting search queries.

In the framework of this article I will not talk about this, since I have already said a lot in the article - there is a detailed video from the MegaIndex company itself.

4. Analysis and screening of key queries

Collected queries should be carefully analyzed by removing “dummy queries”, treble, and ineffective phrases.

Or, before starting, you need to compose a semantic core. It sounds scary, but in reality it’s just requests for which users will search for your services or products in search engines. If you select the right key queries correctly, your site will quickly rise in issuing Yandex and Google and bring you customers. To understand in which direction to move, think about how you yourself would look for your products, in which phrases. You can write 3-5 main topics and build on them. But in order not to rack their brains and not to invent a bicycle, they created an assistant - Yandex Wordstat.

Wordstat (Wordstat) shows statistics of user queries. The service displays all phrases with the entered key and the number of users who searched for this key request. In this article, I will talk in detail about the service and about what nuances should be taken into account when working with it.

Yandex Wordstat to the rescue

To see the statistics of a query of interest, you need to enter it in the search bar, click "Select" and the service will display the result. Below are the main blocks of the service functionality schematically.

  1. Search phrase.
  2. Last update.
  3. Total impressions per month.
  4. The number of impressions for a specific phrase.
  5. Related queries.

You can search phrases by:

  • words;
  • regions
  • query history (by month, week, etc.).

The service shows the result not only by the entered query, but also similar phrases that users searched for.

Key Operators

To understand the principle of operation, we introduce the query "Italian pizza":


The service gave us the result that this request was entered 16,654 times per month. But is it really so? Not. It should be borne in mind that users could search for a request in various variations, for example, “buy Italian pizza” or “cook Italian pizza”. Some queries are clearly not worth considering. And to see a more truthful picture, the service has basic operators.


1. Quotation marks:"Word". This operator allows you to see the exact number of impressions for this query, but for all possible endings and word order.


Now, instead of 16,654, we see 1,152 impressions per month. This is a more plausible figure.


2. Exclamation mark:  ! Allows you to view the number of impressions on demand, taking into account the end.


We changed the ending of the request, and we see that only 225 times users searched for this phrase and with this ending.

Helper Operators

There are additional operators in the service that open up more possibilities when analyzing and selecting queries.


1. The operator "OR".  Helps combine queries, compare multiple phrases.
Designated(|).


In the figure on the right, we see how many requests for each phrase were made in a month.


2. The operator "Square brackets".  It fixes the word order, while all word forms and stop words are taken into account. It is designated.



3. The Plus operator.  Searches for the query itself plus an additional word. It is indicated by the + symbol.



4. The operator "Minus".  Gives the result without the word that comes with the - sign. It is indicated by -.


Using this operator, we removed all queries containing the word dodo (dodo, this is a brand of pizza).


5. The operator "Grouping".  Used when you want to group several operators. It is designated ().


Additional features

At the beginning of the article, I mentioned that Wordstat has the ability to search and analyze queries by word, by region and by history. Let's start with the query history.

Request History

Soon the New Year and you are already wondering when to start notifying your subscribers about New Year's promotions and sales. To track when people become interested in this topic, go to the "Query History" tab and see the seasonal variations of the "New Year" request.


If you look at the graph, you can see that the peak falls on December (12 month). But they begin to be interested already at the end of October.

Number of requests in a given region

In this tab, you can see the number of impressions of the request in the region or city. You can also rate popularity as a percentage. The higher the percentage, the higher the interest.



In the "Map" mode, you can see the number of requests and their popularity by country on the world map.


Collection (parsing) of requests of a given length

Sometimes it becomes necessary to search for queries of a given length (from 2, 3, 4 words, and so on) with the occurrence of a keyword.

For example, we want to find a phrase with the keyword "pizza" and a length of 4 words:



Requests from 2 to 7 words in length can significantly increase audience reach.


The article examined the basic functionality of the WordStat service. Now all that remains for you is to correctly apply the acquired knowledge in practice. Be sure to use this tool in your work, if it is important for you to qualitatively launch effective and.

It is very important to make sure that the queries that you are going to advance are generally sought by someone. If you type “semantic core”, where all keys will be with zero frequency, then your site will be zero. Therefore, let's not bend the ox, but proceed.

What is keyword frequency

Obviously, various queries have different popularity among users of search engines. The number of entering a specific request into the search engine is taken in one month. In this way, keyword frequency is the number of monthly query entries.

It is possible that even here there are dummy requests

To promote your site you need to create original content. For example, if you write articles, the uniqueness of your text should usually be above 90%. In theory, unique content brings a high traffic rate, consisting largely of conversions from Yandex and Google. However, in the real world of ranking, writing a unique article is only half the success.

Search engines pay attention not only to the uniqueness of the text, but also to the content of key queries that correspond to the subject of the article or any other textual content. The correct distribution of keywords in the article is called text optimization. A unique but not optimized article containing vague queries may not attract visitors to the site at all. Such a situation would mean wasted time and resources on creating content.

For optimizers, frequency is a criterion for choosing a particular request for its use in the text. Depending on the frequency, for high-frequency (HF), mid-frequency (MF) and low-frequency (LF) requests. When optimizing the article, first of all, pay attention to the RF and midrange queries. However, every year the promotion of new sites becomes more difficult, and optimization is thinner. Now it is believed that the use of low-frequency keys can also bring some traffic.

How to check request frequency

The frequency of keywords can be found using the appropriate services of search engines, as well as special programs for compiling the semantic core. Search engines provide their services with the calculation of the selection of queries for contextual advertising.

Wordstat (Yandex)

Wordstat - Yandex service for determining statistics of key queries. Wordstat uses most optimizers not only to compose commercial requests for advertising, but also to extract keywords in the framework of regular text optimization. Wordstat has three types of frequencies:

  1. Frequency WS is the base request frequency in Wordstat.
  2. Frequency "" WS - frequency of the exact input of the request. For example, statistics for the query [“car”] would match the query [car] without adding any other words.
  3. Frequency “!” WS - frequency by the exact input of each word in the query, excluding declination, etc. The query [! Chinese] means that statistics on the word [Chinese] will be issued without possible declensions (Chinese, Chinese).

At the request of [car], the current frequency exceeds ten million impressions. However, the basic indicator involves the addition of all kinds of words to the keyword by which the article will be ranked.


  If you enclose the request in quotation marks, then the statistics will be reduced from ten million to 28 thousand. For the optimizer, a right-hand column with similar queries that complement the semantic collection may be useful.


  The “By words” tab means that statistics are given for the total impressions of the entered request. The tab "by region" displays the statistics of impressions in different regions of the country. And on the “Query History”, you can track the change in the frequency of the request during the month or week, as well as statistics on requests via PC or mobile devices.

Google

The Google AdWords service itself is more focused on contextual advertising than Wordstat. In the "Tools" section, you can select the necessary keys for the desired request. The “Targeting” column sets the desired impression region and language. You can also specify negative keywords.


  Unlike Wordstat, which shows statistics for the month, in AdWords you can select the monthly range of impressions in the "Date Range" column. The disadvantage is the average number of results. The statistics themselves are divided into two blocks:

  • Key words - analog of frequency “” of the Wordstat;
  • Keywords (by relevance) are an analogue of the base frequency and similar WS queries.

The advantages are the presence of a level of competitiveness, as well as the ability to download selected words in a CSV file or on Google Drive.

In addition to AdWords, Google has another query analysis tool called Google Trends. This service estimates the popularity of an entered request for a certain period of time and presents statistics in a graph. You can compare several key queries with each other. Regional statistics are also displayed.


  For the graph, not exact numbers are used, but relative numbers, based including on relevant queries.

Mail.ru

Mail.ru also has a search engine statistics tool in the webmasters service. In addition to general impressions, the table shows the distribution of queries by gender and age of users.


  It's no secret that Mail is working with Yandex, as the search engine places Yandex ads.

Rambler

Rambler loses its popularity every year, but their Wordstat can be very useful. The fact is that query statistics in Yandex and Google can not always reflect the real state of things. Many companies can enter “idle” commercial requests in order to spy on competitors, i.e. for analysis of TOP, titles, etc.

Due to the low popularity of Rambler, the statistics of their Wordstat are less spammed and may bring some clarity to optimizers. In general, as an additional tool it will fit perfectly.

How to check mass request frequency

Most optimizers choose programs such as Key Collector or Slovoeb for collecting and analyzing the semantic core. There are also online frequency determination services.

Key collector

You can get the necessary keys for the semantic core and mass-check their frequency using the Key Collector desktop program. We open Wordstat, in the field we enter the main keys from a new line according to your subject and click "Start collection".


  In the settings, you can set the desired region for the collection, as well as stop words. After the keys are collected, we determine the frequency through Direct.


  As a result, you will have a table with keys and frequency of impressions. Immediately delete all keys whose exact frequency “!” Is zero. To do this, we do the filtering in the "Frequency!" Column. Click on the blue icon. A window with a filter will appear. Choose "greater than or equal to"\u003e "1" and click "Apply."


For a larger list of keys, you can collect search hints from Yandex. Make a new group (window on the right). Also make sure that the checkbox "Collect only TOP tips without busting ..." is enabled. Now we click on the created group - a new empty tab will open. Click the icon for collecting search tips.
  After collecting the phrases, we do the same as when parsing Wordstat: we remove the frequencies, remove inappropriate phrases and phrases where the frequency “!” Is zero.

Similarly, using Key Collector, you can collect keys and frequencies from Google.

Rush analytics

Rush Analytics is an online alternative to Key Collector. The advantage of the key collection tool is the lack of the need to use proxies, anti-captcha, etc.

To collect frequency from Wordstat, you need to go to the tab "Frequency collection" and check the box opposite !keyword, that is, the exact frequency. Next, enter the keywords. After the service calculates the costs, click "Create a new project."


  Results can be saved to an Excel file.

Before starting work on creating a new Internet project, experienced webmasters evaluate its prospects - does it make sense to invest time and money? It may happen that a large-scale undertaking will end in failure due to the fact that a niche is absolutely not in demand.

Knowing the most popular queries on Yandex or other search engines that you are promoting under will help you choose a niche with a large target audience from the very beginning.

  • topic popularity on the net;
  • solvency of the audience.

First of all, they look at popularity, because good traffic can be monetized in any case, for example, by adding a site to the Yandex Advertising Network (YAN) or Google Adsense.

Topic popularity \u003d many searches in search \u003d high-frequency keywords

So, we need to find out the frequency of the words and phrases that interest us.

How to find out the frequency of specific queries

If you already have certain blueprints for the future topics of the site, then it’s enough to sketch out a preliminary list of the most popular queries in this topic and “break through” their frequency through the wordstat.yandex.ru service.

For example, it came up with the idea of \u200b\u200bcreating a site for breeding deer, you can see how many people are looking for "how to breed deer."

The popularity of the request in the Yandex search engine will be expressed in specific numbers, and then you yourself will evaluate how it fits into your business plan.


We see that the topic of deer is not particularly in demand, maybe it’s worthwhile for the site to pick up some more popular queries and invest in them.

The maximum that we can extract from this service is to see the popularity of complex key queries (consisting of 2 or more words) with the obligatory occurrence of one of them.

For example, we are looking for what people most often want to buy. Their requests should look like this - "buy ..." (instead of an ellipsis a word). In the field of the wordstat we enter "buy" and in the list of proposed options we will see all the most popular requests to buy in Yandex. A selection of keys for a car tire store may begin with a general “buy tires” request:


The list already shows what and how much they are looking for. From the general query, one can distinguish many groups of narrower specialization. Each of these groups can then be considered individually according to the same scheme and isolate queries from 4-5 words. For an online store, everything will end on the narrowest requests - product cards.

Similarly, you can search for the words “watch,” “download,” etc. If the topic you need has similar unifying words, then you are in luck. It is more difficult when all requests in the topic are not similar to each other. How to fish them out I will tell further.

Where to get ALL search queries

You already understood that the wordstat service will not show us all the statistics on the Internet and will not “burn” the most popular requests, it will only tell you the frequency of what we asked.

Some webmasters recommend using the Google trends service for search, which shows topics that are popular on the network at the moment, but this is ineffective, since there are continuous news of show business, movies and other nonsense - there will be no real clue for a promising site.

There is a real way to get a full selection of all the key queries that search engines processed, but this pleasure is not free - called Pastukhov Bases (pastukhov.com website).

To satisfy the curiosity of the most-popular keys, Pastukhov posted several dozen keys from the TOP right on the site in this form,


but it will not work for work (continuous download, watch, games, films, songs), and for the full version they ask from 200 to 600 dollars depending on different stocks.

If you constantly make a lot of sites, then the database can come in handy, but there is an option to find out popular keywords cheaper, more precisely, for free.

LiveInternet - the most popular queries for FREE

We will use the Liveinternet statistics service for this. Unfortunately, using the data of this service will not give 100% match with the data of Yandex or Google search engines, since not all Internet sites use traffic counters from LiveInternet and not all who use their statistics are open, but the selection there is very large, therefore, for real work is more than enough. In the end, we also need a list, and then break through the exact numbers with Wordstat.

A useful thing in Liveinternet is the ability to immediately sort by category - to dig search queries not across the Internet, but in a specific topic (although it is possible across the Internet too).

We open the site - liveinternet.ru

If we need data on search queries shared over the network, then we go directly to the ranking of sites, if we need key phrases on a specific topic, then we select one of the rubrics.


For example, I selected the computers group. Now we need group statistics - this is such a link with a graph icon on top of the list of sites in the ranking. Please note that we can specify the country and region - for sites that are georeferenced, you need popular queries in a given area.


In statistics, we will see general numbers of attendance and much more, but we are interested in the left column of the menu and, specifically, the item “By search phrases”.


A significant proportion of requests here are hidden under the code name “Others”, but let it not bother you, the most popular are open.

To make the selection as convenient as possible in the settings of the summary table, select "By Month" and "Summary". Below you can configure a certain number of lines that are simultaneously displayed on the page (from 10 to 100).


Thus, we get a list of the most popular queries in a given category. Do not be surprised if non-thematic queries slip among the queries - this comes from the fact that the selection is not based on the actual categories of queries, but on sites that are in the Liveinternet rating. And it often happens that a site is mistakenly placed in the wrong category and its requests are taken into account. It also happens that the site is thematic, but it has a page with text of a different theme, which gives tangible search traffic that does not belong to a given category.

So, the most popular words and phrases you need will need to be selected by hand.

Now we can expand our selection for the selection of specific key phrases for writing articles for our site. To do this, take a list of words written out of LiveInternet and return to your favorite Yandex Wordstat. By adding words one by one, we will get narrower meanings of popular queries, but, most importantly, in the right column we will find similar queries that expand our initial selection.


Here is such a technique for free receiving the most popular queries in search engines without buying any Pastukhov databases and other lists there.

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 ...


  • Wordstat.yandex.ru (Yandex Wordstat) - how to ...
Do you like the article? Share with friends: