The program for the selection and analysis of keywords. Program for the selection of keywords online. Rambler statistics on search queries
total
Introduction
Drawing up the correct semantic core, one of the main tasks SEO optimization... Self-selection of keywords of the semantic core is difficult to implement, without analytical and statistical services that collect information on search queries Internet users.
17 keyword selection services for Russian-language sites
And it is done to optimize the site for certain search engines. For this, the statistics of queries stored in the database of search engines and services are used.
Yandex keyword selection
(wordstat.yandex.ru)
Free service for the selection and analysis of search queries made in Yandex.
Yandex advanced search
yandex.ru/search/advanced
Advanced search allows you to analyze the results for low-frequency queries in Yandex. Compilation of an extended semantic core from search phrases of 3-4 words.
Yandex Direct
https://direct.yandex.ru
Clarification of the competition of search queries for advertising phrases used in advertising on Yandex.
Yandex Webmaster
https://webmaster.yandex.ru
Correction of the semantic core: identification of popular queries of the published site.
Google AdWords
(//adwords.google.com)
Selection of keywords and analysis of search traffic in the Google search engine. Analysis for registered users only. Selective analysis of requests by country.
Google advanced search
https://www.google.ru/advanced_search
Refinement of results for search queries in advanced search.
Rambler statistics on search queries
wordstat.rambler.ru/wrds/
Statistics of search queries made in the Rambler search engine. Disadvantage: Query statistics are rarely updated.
http://seobudget.ru/tools/keywords/
Multifunctional service for website optimization and search results analysis. One of the tools: Selection of phrases of the semantic core. The selection cost is 3 rubles per request. The number of selected phrases is unlimited.
Online.seranking.com
Another multifunctional service for webmasters. Registration is required to work. Analysis and word matching tools are available for 14 free days. Further, for the selection of keywords, payment of 50 kopecks for one request from the service database (20,000 results) and 1 ruble from the Yandex.
Megaindex keyword selection
keywords.megaindex.ru
Megaindex service is a multidisciplinary service for website analysis and promotion. One of the best keyword selection services.
The selection of keywords is done after registration and adding a project (site). The tool is free. In addition to the selection of phrases of the semantic core, analysis of site visibility in search results for queries (2) and analysis of thematic queries (3).
Provigator, search phrase competition analysis
prodvigator.ua
Analysis of competitors for a search phrase. Can be used to indirectly analyze the competitiveness of search queries.
Keywordtool service
http://keywordtool.io/ru
Shows the analysis for a search query and a key phrase for this query in google search engines, including separately in Google.ru, Bing, YouTube. Selection of phrases and keywords is free, however, query statistics, CPC (cost per click in advertising) and the level of competition for a phrase in Google, only in the paid version.
Advodka.com service
https://advodka.com/wordlist/
A free service that has a tool for selecting phrases and words of the semantic core for search engines Yandex and Google. There is an analysis of the geography of requests.
Search Trends on Google (Google Trends)
https://www.google.ru/trends/
Service of the popularity of search queries per month, year by sections and countries. Shows only requests made to Google.
Mutagen service
mutagen.ru
Keyword selection service for Runet sites. In addition to the selection of key phrases, it gives the degree of competition between phrases. There is a bulk verification of keys.
Registration and balance replenishment by 1 ruble are required for verification.
Rush Analitics service
A good service for site analysis, keyword selection, query clustering.
Grouping requests
coolakov.ru/tools/razbivka
Free service for clustering (grouping) search queries.
Service seolib.ru
17 keyword search services: seolib Multidisciplinary service for website optimization and analysis. One of the services: free selection of 25 keywords per day from one IP address.
Ladies and gentlemen, ladies and gentlemen, seniors and senoritas, I am pleased to present to your attention my next mega-post dedicated to tools that allow you to select keywords for free to optimize and promote your website on the English-speaking Internet.
First, a small announcement: colleagues from Promodo invited me to two conferences "SEMCamp" and "Search engine optimization and website promotion on the Internet". Unfortunately, I cannot go, I have become old, my legs can no longer walk, I will be in my Siberia. But maybe some of the readers will find it useful.
Megaposts are large and voluminous articles that I spend several days writing. I originally wrote this post in English for my English-language blog. It's already published, you can take a look at it: Ultimate List of 42 Free Keyword Research Tools. It took me 5 days to write it.
I thought the topic was relevant and interesting, and translated the post into Russian. I am already preparing a similar post with a detailed list of tools for Runet.
Keywords (they are also called search queries, or keys) are needed in order to optimize the existing pages of the site for them, to use queries when creating new materials for your site, as well as to compose the texts of external links and articles when placing them on others resources.
There are paid and free methods... Today I will talk about paid solutions, which include online services, browser extensions, and desktop programs (free and paid with a free trial period).
Free online services for collecting search queries
Perhaps this best service for the selection of keywords for promotion in Google, because it is a "native" Google service. It is suitable for both the Russian Internet and the English-speaking Internet, you just need to select the desired country and language:
A lot of services and word selection programs use data from this particular service.
This service has options that allow you to select requests for both desktop computers both laptops and mobile devices:
I advise you to activate all columns to get information on keywords. To do this, on the right side of the page, click on the Columns button and check all the boxes: Competition, Global Monthly Searches and Global Local Searches, Ad impressions (Ad Share), Search Engine google network (Google search Network), Search Share, Approximate CPC (cost-per-click bid), Local Search Trends graph, Extracted From Webpage ).
Here is a screenshot in the English interface that I prefer to work in:
The columns in the menu shown can be dragged with the mouse and swapped, which is very convenient.
I also recommend playing with the match type in the left column to get the desired results and additional ideas for your search queries (try collecting keywords by alternately checking the Exact, Broad and Phrase boxes).
The received data can be saved in CSV format (as well as in several other formats), for this click on the "Save to file" button. I sincerely recommend using this service as it has all the features you need to collect keywords.
A useful and free service for collecting keywords that uses Google Suggest and other resources. You can select the country and source (Web, News, Shopping, Video or Recipes). Ubersuggest allows you to get search queries from both regular and vertical search. This resource works according to the following scheme: it takes the query you entered, adds a letter or number to it, and collects all possible queries. This way, you get the opportunity to find more ideas for keywords, especially for low-frequency queries.
For example, I collected 344 searches for the phrase "search engine optimization" and 377 for "photoshop tutorials".
Saving the received data is done in an original way. Click on the "Select all keywords" button. By the way, how do you like my new watermark? As they say in Florida - Style! π:
Then click on the "Get" button on the right side:
And a window will appear with all the collected keywords.
There are two options for using the Youtube keyword selection service: enter the desired query or insert a link to the video for which you want to select words and phrases.
I found that the Youtube Keyword Tool service does not work correctly and for many requests it shows a message that there is not enough data. I came up with a solution like this - register or log into your google account AdWords and insert a link to a video that is relevant to your keywords. Then set the price to $ 0.01 per view and you will get all possible search phrases. I also recommend playing with the Broad, Phrase and Exact match type for best results.
Another useful tool for collecting keywords from Google. It allows you to compare data across categories, countries, and time periods. You can apply filters Web Search, Image Search, News and Product Search.
AT Google Insights there is one more interesting function - you can watch the dynamics of queries over time and on the world map (click on the item "View change in time", there you can even turn on animation):
For example, I found out that the query "search engine optimization" in 2004 was the most popular in the US, and now the country where this phrase is most requested is India.
Cool service for collecting search phrases, which is also free. It shows data from popular worlds of internet resources (Google. Amazon, Wikipedia, Answers.com, Yahoo, Bing, Youtube, Netflix, Ebay, Buy.com, Weather.com) and displays phrases in an original manner as you type your request in it. Try it, you will like it! π
I found a tiny button to save the results, it is in the upper left part.
A well-known analytical resource Alexa.com, with which you can find search queries of a particular site for free. We go to Alexa.com, select the Site Info tab and enter the address of the site we are interested in. Then click on the Get Details button:
On next page select the Search Analytics tab:
At the bottom of the page there will be a list of the most popular search terms for which this site gets visitors from search engines.
The Bing search engine selection service allows you to collect data from organic search and study statistics for the last 6 months for free. You can filter the received requests by language and country. In order to use this service, you need to register in it.
Another free service for collecting keywords from Google. You can compare multiple queries, to do this, write them separated by commas. You can compare up to 5 queries.
And another free tool from Google. Google Corellate lets you find key phrases based on popular global trends, which can be very useful for many webmasters and SEOs.
Google Correllate also shows search activity maps. For example, I use it to find out the popularity of a particular query in various US states. Just hover the cursor over the required state and you will see information on it. I pointed to my beloved Florida, where I lived for 4 years:
A popular free tool among foreign optimizers. The data is taken from the Wordtracker service. In order to start using it, you need to create an account. You can save received requests in CSV format.
I met a couple of times that in runet the name of this instrument is translated as "Stupidly generator" π. This is actually a typo generator. Some of the queries users have always entered, enter and will enter them with typos. Therefore, typos can be used to get additional targeted visitors. This tool just allows you to receive keywords with typos.
Browser extensions for keyword searches
Search queries can be received not only from various online services... You can also study those pages of competitors' sites that already occupy the first places in the topics of interest to you and receive keys from them based on the density of requests. This method allows you to get additional ideas about what words and phrases can still be used in the text of the pages you promote. There are browser extensions for this, which I will discuss next.
I have been actively using SeoQuake since 2007. This extension is available for browsers Google chrome, Mozilla Firefox, Opera and Safari.
With the SeoQuake extension, it is very easy to analyze the keyword density on any page of the site. To do this, go to the page you are interested in, click on the SeoQuake icon and select the Keyword Density item:
On the next page, you will see detailed information about which keywords are used to optimize this page:
You can analyze one-word, two-word, three-word and four-word queries (which is very useful for selecting low-frequency users), as well as a keyword cloud:
I found a video that shows this process in detail in SeoQuake:
KGen (short for Keyword Generator) is an SEO addon for mozilla browser Firefox, which allows you to find out what search queries are used on a particular page to optimize it. The essence is the same as in the previous extension.
KGen scans the page and displays information about how many times a particular request is encountered, as well as its weight and the average position of the request on the page.
To select keywords, just go to the desired page, click on the KGen icon (I have it in the lower right part firefox browser) and in the window that appears, click the "Scan" button.
Free versions of paid online services for collecting search queries
This is one of my favorite tools for site research and keyword research when promoting in Google (I use the Professional plan). It has a fairly functional free version, with which you can get very valuable information about the requests and links of competitors.
For example, you can find out for what queries the competitor you are interested in is promoting this or that inner page your site. To do this, go to the SERP "s Analysis tab, select Organic Keywords and enter the address desired page... You will receive 10 search queries for free, for which this page is in the results of Google. Data is available not only for Google, but also for Bing and Yahoo.
I did a detailed video review of the Ahrefs.com service for 40+ minutes in this post:.
In the free version, Wordtracker issues up to 100 search queries. Please note that it shows the frequency of impressions per day. If you need monthly data (like me), then simply multiply the results by 30.
Another useful tool from the Wordtracker service. Enter a request and get 100 questions that fit it. This is a great help when searching for new ideas for keywords and writing articles. Questions can be used when writing assignments for copywriters.
Service from the famous blogger Dimka in runet. Actual Keywords allows you to get 100 keywords for any request for free. There are also keyword selections available for free download on several topics (Auto Loan, Digital Camera, What Is and How To).
The popular Semrush service allows you to enter 10 queries per day for free and get 10 results for each query. This service has its own database of 95 million keywords and 45 million sites.
Like other free versions of paid services, Keyword Discovery produces 100 searches. Data is collected from over 200 resources around the world.
Another way to get 100 requests for free. Data from Google is available for several countries: AU, BR, CA, DE, ES, FR, IT, RU, UK and US.
I found an interesting feature in Keyword Eye - the search query cloud. This is how it looks:
Wordpot shows data from various search engines by frequency of impressions per day.
This service allows you to create 1 project for free and make 25 requests per day. Synonyms, similar queries and associative words are also limited - up to 5 per day.
If you are involved in affiliate program Amazon.com, then this service will allow you to find search queries from Amazon, which is especially valuable for finding specific low-frequency queries... Please note that in the free version you can only enter 3 queries per day.
Like the other services above, WordStream gives us 100 requests for free. It is upsetting that the received data cannot be downloaded. But you can send them to your e-mail. Although I personally do not like this moment - what if a newsletter I don't need will come?
This service collects data from eBay.com. Enter the required query and you get such a table (there is still information there, I did not begin to capture it in the screenshot to show this particular table in detail):
This service reminds me of a closed project from Google - Wonder Wheel. Looks like it, doesn't it?
Terapeak allows you to find search terms for specific countries. There is a free trial period for 7 days.
And another way to get 100 keywords for free. I have not found a way to save the received data, because this service is inferior to those that I described above.
Niche Bot issues 20 searches per day.
And this one is only 10. The fewer requests the service issues for free, the less I write about it π. Will issue 1 request - just put a full stop instead of the description π.
And this tool makes 100 requests. For example, I entered "Photoshop tutorials" and got 110 phrases. But after entering the second request, I received a message about reaching the daily limit "You have reached your daily limit". In the free version, you cannot download the report on the collected keywords, but you can select it with the mouse and copy it, although it is not so convenient.
This service allows you to find out the Keyword Effectiveness Index (KEI), that is, the index of the effectiveness of a keyword, as well as collect queries from sites you are interested in. It also has a module for collecting keywords for which this or that site is in the search results. Wordze has a 30-day free trial.
SpyFu allows you to collect queries that promote any site you are interested in. It is a popular tool for studying competitors on the English-speaking Internet, but it provides very little information in the free version.
Free Keyword Search Software
A useful free program for Windows. The data is collected from the Google word suggestion service.
This program allows you to select search queries directly in the Microsoft Excel interface, which is very convenient for many users. The data is collected from Bing and Yahoo search engines and includes relevance, cost history, frequency of impressions, and country data.
Honestly when I installed microsoft program Advertising Intelligence, I didn't immediately understand how to launch it. There is no shortcut on the desktop, I did not find it in the list of programs either. And only after I started Excel, I saw new tab π. I took the screenshot above where you can see it.
Paid word search software with free trial
The Good Keywords project has created another keyword search solution - the Keyword Strategy Studio program. It allows you to find new ideas for search queries that are based on search data, trends and popularity. Keyword Strategy Studio has a fully functional trial versionwhich can be used for 30 days.
Market Samurai is a very popular program among foreign SEOs. It is paid, but there is a free trial period. The great thing is that Market Samurai's keyword picker continues to work fine after the end trial period, that is, in fact, this function in the program can be used for free for an unlimited amount of time.
Keyword Researcher is literally "Keyword Researcher". This program is well suited for finding low-frequency search queries with low competition and works on Windows and Apple OS X. The screenshot shows that you can set a search query pattern by replacing one word or phrase with an asterisk, and the program will select all possible keyword variations. For example, we make a request like this:
How to * a camera
And the program selects 119 phrases using this template. There is a free period. I suggest watching a video about its capabilities:
This program has free versionwhich has many cool features. For example, I liked the Amazon keyword scraper module (for collecting keywords from Amazon.com). See screenshot:
You can set various filters when searching for keywords and phrases, you can delete brand names with one click, set the range of local query impressions and global impressions, and also set the parameters of the average cost per click (CPC). Also, as in Google Adwords, you can specify the type of match (exact, broad and phrasal).
The Advanced Web Ranking program provides all its functionality for the entire free trial period of 30 days and works on Windows, Mac OS X and Linux operating systems.
Rank Tracker's keyword selection module allows you to determine the level of competition, find words with typos, etc. Data is collected from Google AdWords, Yandex Wordstat, Keyword Discovery, Wordtracker, Bing, and Semrush. You can use Rank tracker for free, but you won't be able to save projects and reports. The program works on Windows, Mac OS X and Linux.
I also want to mention two popular search query tools - Micro Niche Finder (program) and Keyword Ninja (PHP script), but they do not have a free trial period, so I did not include them in the list, I give them for information. Micro Niche Finder has a period of 30 days, but you have to pay for it, so it is not free.
If you know other tools for searching for keywords on the English-speaking Internet, you can write about them in the comments.
If you are interested, I can recommend the services of Alexander Pavlutsky, who is professionally engaged in the selection of keywords for websites (for the Russian Internet). You can find out more details at this link.
Let's talk about collecting keywords in paid and free ways. I will show you what online tools can be used and reveal their main differences.
Let's start talking about collecting keywords in a free way. There are many methods to do this. The most commonplace is brainstorming. Here you need to think for yourself what keywords will be able to bring users from search engines.
I will say that the method is rather primitive. Now it has lost its relevance because we have a whole bunch of free and paid tools in our arsenal.
- Yandex Wordstat
- Search hints
- Link aggregators (megaindex, rookee.ru, seopult.ru)
- Open counters of competitors (Liveinternet)
- Ready word bases (bukvarix.com)
How to use Yandex Wordstat? First, we select the region of interest to us, for which we want to see search queries and their frequency.
In general, we select a region, insert it and click "Pick". Next, we get a complete list of broadly matched keywords.
Of course, this method is quite chaotic since we get a huge number of words, many of which may not suit us. Therefore, it is better to use certain operators in this case.
Search operators Yandex Wordstat
In order to optimize the work with this tool, the search engine came up with the so-called Yandex Wordstat search operators.
What are these operators and how to use them?
Filtering out negative keywords: operator "-"
We can eliminate unnecessary words. For example, we are interested in the query "computer". But we are not interested in words where users want to download something to their computer.
Therefore, we enter the word "computer" in the same form and additionally the negative word "download" with a suitable operator.
Minus operator Search for multiple keywords: operator "Ξ"
We introduced words with the search operator "or" where two keywords are searched at once in broad match.
Search with word grouping: operator "()"
For example, if the first part of the query matches, then it is not necessary to repeat it again.
Grouping operator Keys are not restricted within parentheses. Here you can enter at least the whole range of countries for which we want to get keywords in conjunction with the main key "tours".
: operator "" ""
As a result, we got a set of keys in the left screenshot. In the right is only the key word of interest to us.
The operator helps us in this. double quotes.
: operator "!"
For example, we want to get keywords in which the word price is used in the case in which we enter.
Exact entry operator Yandex Wordstat In the screenshot on the left, we see that by entering "tour price turkey" we find words with the word "prices". In the picture on the right, we see that by adding an exclamation mark before the word βpriceβ, the search engine offers us an exact match.
Therefore, by adding an exclamation mark before the request, you can get the keys exactly in the form in which we entered them.
Also, all these operators can be combined with each other.
You can take keywords as with exclamation mark, and in quotes, inside brackets or with the search operator "or".
This combination allows us to immediately get a filtered list by the required parameters with one request.
Popularity by region in Wordstat
In Yandex Wordstat, you can see impressions and popularity by region. For example, if you enter the query "sell an apartment" and look at the popularity by region, we will see that in Krasnoyarsk it is 3 times more than in Moscow.
That is, in this city there is some kind of pronounced demand.
In general, such a function can help those who are looking for the most profitable region to invest their funds in.
The request history helps us track seasonality. You can see in which periods the request activity was high, and in which periods it was low.
Thus, we can plan in advance the conduct of an advertising campaign on the Internet.
It also comes in handy in SEO optimization.
For example, a few weeks before the start of the season, you can publish posts for the required requests so that later you can receive additional traffic for them. It also helps in drawing up a content plan for publishing posts on the site.
Google Keyword Planner
In addition to Wordstat, I also recommend using Google planner keywords. Typically, we have two main search engines. These are Google and Yandex. Therefore, when collecting keywords, I definitely recommend taking statistics from these two systems.
Google Keyword Planner In the planner, you can collect keywords by phrase, site or category. There are additional tools for search parameters and. As in the case of Wordstat, you can also filter out unnecessary queries here.
When collecting statistics, you are shown suitable keywords, the level of competition and the recommended bid.
Statistics in Google Planner Also shows the number of requests per month.
Unfortunately, Google currently only shows the average search range. More accurate results are only available on accounts with already running paid ads. And then, not for everyone!
Nevertheless, this planner is very well suited for collecting keywords for free. It has a lot of useful features that can come in handy.
For example, if you have a ready-made list of keywords, then for quick data processing you can use the "Get statistics of queries and trends" option. This will save a lot of time.
In the planner, you can even directly create keyword combinations to get statistics. To do this, use the option "Select keywords based on existing lists".
Search hints
You can also use search suggestions to collect keywords online for free. You need to enter the part into the line and wait for the system to offer a drop-down list with prompts.
Search hints If you are selling laptops, you can get additional keys using search clues.
If you are writing informative articles on the site, then using the tips you can pick up additional ideas.
From the screenshot on the right, we can see that users are interested in being overweight, lonely, excessive sweating, and so on.
Also, if we have some kind of news resource, then we can see the current trends. Then you can take advantage of these trends and write articles based on them.
Link aggregators
Free link aggregator functions can be used. Take for example. Having registered in this system and adding your site, you can see an inconspicuous button "Pick up". By clicking on it, the link aggregator will offer us keywords that can be used to promote.
In principle, the keywords are quite adequate and really fit the desired site. From the advantages, it is clear that we are already shown some positions for which our site takes places. Frequency is also visible. He also offers us a page to which these requests can be made.
In general, there are auxiliary functions that are free and useful for us.
Collecting keywords using paid methods
Let's get started with paid methods for collecting keywords. Of course, you have to fork out a little here. However, in this case, you will have special benefits.
Here are the paid tools:
- Competitor analysis (semrush.com, serpstat
- Software for collecting keywords (key-collector.ru)
- Ready word bases (pastukhov.com, roostat.ru)
- Convenient and fast online parsers (Mutagen)
I will not consider each service in detail. They are all good and worth their attention. But for example, let's dwell on one of them. This will .
By injecting the site into the line this service, we get a table with keywords for which the project takes certain positions.
Collecting keywords through Spywords That is, we can select a semantic core for those keys for which the site is already somehow ranking in the search. Accordingly, this moment alone can make much less effort to achieve collection and top.
We see columns like Traffic Share. That is, what proportion does this keyword take from the total list of words that were counted this system within this site.
There is also the number of impressions per month, position and, which is issued when the site is on a given keyword.
There is also a function to compare the domain in organic search results.
Domain comparison function in SERP For example, there are two sites of the same subject. Each of them is promoted by its own set of keywords. The system offers to look at the intersection of these two sets.
That is, we can collect a list of keywords by which both sites are promoted. This is very useful function in seo analysis of those competitors that we want to target.
It also highlights the number of similar words. You can separately look at the non-intersecting parts of the sets. Everything is available for both Google and Yandex.
Also in the Spywords service, you can use smart collection of keywords for the site. He selects keywords, relying on his base and based on those sites (their semantic cores) that got there.
Smart keyword collection The service also shows the number of requests per month. It also shows what bids are made in paid ads on Google and Yandex. That is, you can assess the level of competition for a keyword.
Comparison of paid and free methods
Let's find out how paid and free way collecting keywords. What are the advantages and what is better to use.
Free tools suitable for small sites and volumes. If the site has 20 - 30 pages, then you can easily get by with Wordstat, tips and a keyword planner from Google.
Free methods are suitable for beginners. Since all the paid tools require some kind of immersion, the free ones are quite simple. Here it will be easier for beginners to figure it out.
It should be said that the free tools are very handy. They are really made for a large audience. That is, for those who are still poorly versed in collecting keywords. That is why such systems have been specially designed for user-friendliness.
What are the advantages of paid tools?
Such tools significantly speed up the work of collecting the semantic core. This is useful when you need to find tens of thousands of keywords. It will take quite a long time to select them through Yandex Wordstat.
Paid methods are suitable for high volumes.
If we have a large online store, then free tools it will be very difficult to find a huge number of keys. Therefore, here Key Collector, Pastukhov's base and other paid solutions come in handy.
Also, paid tools allow you to collect those keys that free ones may not even notice. In the same Wordstat, we can not get all the keywords that are set by users.
conclusions
Collecting keywords is not as difficult as many describe it. Small volumes are very easy to collect. Therefore, everyone can do it!
Don't look at the overall frequency. You must always specify the phrase exactly. Then you can see the real picture of how much a given keyword is requested per month.
Search operators make assembly work easier. To do this, I gave you examples that simplify the search and reduce the number of actions for collecting keys.
Do not forget that competitors can be at a glance. And you can be as in the palm of your hand when you rise to the top. There is no need to be afraid of this! It just needs to be taken for granted.
Pavel Lomakin
AT Most of the free keyword research guides will prompt you to manually copy each keyword and then paste it into a text or Excel file. This is pretty dreary, I'll tell you. Some will offer you to use one of the key parsing programs and they really make life much easier, downloaded from 2 dozen RF parsing requests and went to drink tea. But for beginners and if you are not engaged in collecting keys on an ongoing basis, this will not work, sometimes you can quickly collect a bunch of requests without all this. In general, situations are different and you yourself decide when you may need a plugin that I will now describe.
Dother articles on working with statistics:
Hin fact, there are two such plugins, but they are very similar to each other.
- Yandex Wordstat Helper
- Yandex Wordstat Assistant
ABOUTtheir main functionality is the same, but the second plug-in has more capabilities, as you can see, so I use it. See the comparison table below.
TOyou can download each of these plugins for both FireFox and Chrome browsers absolutely free. It is very convenient. Go to extensions or add-ons and enter its name in the search bar:
Pafter installation, we go to the Yandex Wordstat website, it is assumed that you are already familiar with it, since you needed to somehow automate the process, and if not, then you are welcome to familiarize yourself with. As you can see, the plugin added additional functionality to the page.
ATwe run any request and see that next to each of them a plus sign (+) appeared in the search results
Hby pressing the plus signs in turn, you will transfer the request along with the frequency to the block on the left, while the plus signs turn into minuses (-), so that you can see that we have already made such a request.
Eif you click on the minus, then we will remove the request from the block on the left. If you close the page or browser and reopen it, then the requests from the block will not go anywhere. This is very convenient if you suddenly need to distract yourself or accidentally shut it down. To add all requests from the page, you can click on the link at the top: Add all / Remove all
Tas you list each page, add all the requests you need. If the request that you have already added is in the block, then it will not be added and you will be notified that such a request has already been added earlier.
Pby default, all queries in a block are sorted in alphabetical order at once, but you can customize the sorting for yourself. To do this, click on the sort icon.
ANDthe available options are:
- Alphabet from A to Z
- Reverse sorting from Z to A
- Sorted by the order in which queries were added (new ones are added at the bottom)
- Sorted in order of addition (new ones are added at the top)
Dby adding all the queries you are interested in, you will clearly see how many queries have been added and what their total frequency is.
Tnow you can copy requests by clicking on a special button. Copying will be done to the clipboard in the sort order you specified.
ATyou can also make frequency copies if you need to.
FROMyou can move the copied phrases where it is more convenient for you to process them. Text file, Word, Excel and so on. If you transfer phrases with frequency to the table, they will be transferred to two columns. In one column there will be phrases, and on the contrary their frequency in the second column. This is very convenient for later work.
Dbut I almost forgot. It is possible to add your own queries one at a time (already a list) and you can quickly clear everything. I think you will find it without a picture.
Hi hope this tool will save you a lot of time, as it did me. At the time when I discovered it, I was completely delighted with its capabilities and now I use it almost every day, which I advise you. Simple, concise, despite the small functionality, its capabilities will be enough for you. And most importantly, it works very quickly.
This concludes my review of its capabilities. I wish you high performing campaigns, high sales, and cheap leads. Good luck!
To successfully promote your site on the Internet, you need to write content for certain. Everyone understands this. It is very good when the content of your site is interesting to the readers, but in addition to everything, search engines should also like it. Just for this, you need to choose the right keywords for promotion.
There are many various programs, databases and services for the selection of keywords, which greatly simplify the work in this matter. Let's take a quick look at the most interesting and popular databases and services for collecting key queries.
Search engine services
At the initial stage of work, the basis for the semantics of the site can be laid using public and free services from search engines:
- Yandex. Wordstat.Service from search engine Yandex for analysis, statistics and keyword selection. You can set the region of interest and analyze which requests in the selected territory had a high frequency. For the convenience of working with the service, we have written a convenient one.
- Keyword Planner. A well-known tool from Google, in which you can configure the search for queries both from organic search results and from the popular video hosting YouTube.
- Google Trends. Helps in search for trending (gaining popularity) queries and shows the dynamics of their popularity in different regions and countries.
- Google Correlate. Another service from a well-known corporation with which you can select words that correlate (are often entered) with the given ones. The service is based on the behavioral characteristics of users.
- Request statistics from Mail.ru. Mile's search queries that also show demographic statistics. Gives a visual representation of high frequency or low frequency requests.
- Adstat.Rambler.ru. Rambler query statistics with the ability to select a period and check the seasonality of queries.
Keyword databases
Base Pastukhov
The author of this popular database of keywords is Maxim Pastukhov, a well-known Internet entrepreneur and blogger.This huge database of keywords in the hands of a competent optimizer can easily turn into a rather powerful tool for selecting keywords for a website and promoting it.
Now the Russian keyword database contains more than 1.5 billion search queries with data from Yandex Wordstat and Yandex Direct.
In addition to the Russian one, there is also an English database of keywords, as well as Italian, Spanish, German and French databases. They can be useful for those who plan to promote sites abroad.The databases themselves are quite voluminous, so to work with them, you should stock up on a disk for at least 1 terabyte.I will not describe in detail the entire process of working with this database. All this you can see and study on the author's website.
Let's dwell on the positive and negative aspects.
- The main plus is, of course, the number of keywords, as well as a huge number of low-frequency queries that you will not find in Wordstat.
- A convenient program for working with keys, the so-called shell, which allows you to work with keys quickly and without unnecessary headaches.
- It is possible to work from any computer on which the bases themselves are, for this you only need a shell.
- All the work that you do in the program is duplicated on the server, which gives additional protection to your work if your computer suddenly breaks down.
Minuses:
- For me, the main disadvantage of this program is that it does not show the frequency of many collected phrases.
- The size of the database, or rather the space it occupies on disk. This is about 300 GB of disk space.
- This base works only under OS Windows.
The price of a new Russian database for 1.5 billion requests is about $ 300.But if now you do not have the opportunity to purchase it, then you can try to search for Pastukhov's previous keyword databases on torrent services.
UP-base
A popular database of keywords, collected from various sources such as Adwords, Live, etc.Today UP-base in latest version contains 3.25 billion Russian keywords as of June 2016
There is also an English base.
Pros:
- The set includes a special program with the help of which key phrases take place, and you can also remove implicit duplicates and filter phrases by stop words.
- The ability to parse up to 4 topics simultaneously and save the results to different folders.
Minuses:
- Binds only to a specific computer.
- You need a permanent internet connection to communicate with the server.
- A sample limit has been set. No more than 100 million kei per day.
- Paid updates.
Price: $ 120 for the Russian base.
MOAB
Just a colossal database in terms of volume, which was obtained by parsing all open Yandex counters. Metrics.It stands for "Mother Of All Bases". Quite consistent with the content.
Today the database contains more than 3.2 billion keywords.
Pros:
- This is, of course, size. These are really very large-scale amounts of information, about 650 GB.
- Large tails of medium and low-frequency queries, for which sometimes there is no competition at all.
- You can order a test sample or product demo before purchasing.
- Quite a nimble program and the sampling speed is very pleasing.
You can export the received data to CSV and TXT formats.A special program for sampling is supplied with the base.
KeyBooster
A program that shows requests that people have parsed from Wordstat by the Magadan service.There are almost 70 million keywords in the database.Access to the database is integrated into the keywords Magadan.
To use the KeyBooster database, you just need to download the Magadan program. Contains information:
- About statistical data on request for a month.
- Relationships between keywords.
- Seasonal trends, etc.
AmazingDatabases
An impressive database of keywords.
- Base of Russian keywords (1.48 billion).
- Database of English keywords (445 million).
According to the author, the databases are collected from various sources, both accessible and private.After purchasing the database, you will also receive a program for creating Amazing Keywords selections for free.
You can buy this keyword base for 1350 rubles.Updates are free.
Roostat.ru
An interesting database of keywords from the Rookee service, with which you can quicklypick up and analyze search queries using the API.The number of queries in the database today is about 230 million.
The base has extensive functionality and with its help you can:
- select an effective semantic core for any site, any topic;
- for a separate key phrase, select all possible queries in all word forms;
- determine for yourself the most effective and interesting requests for promotion;
- integrate the Roostat database into your programs.
There are monthly updates.
The price depends on the selected tariff.
Online Services
SpyWords.ru
An online service for analyzing queries, selecting keywords, positions, traffic and competitors' budget.
A very effective and feature rich tool. Allows you to collect and analyze the queries that your competitors are promoting. You just need to make the content a little better, optimize it and style it properly.
Pros:
- Very easy to use thanks to its simple, clear and intuitive interface.
- The speed of the service is good.
- The received data can be sorted in ascending / descending order.
- Download reports in the popular SCV format for further analysis.
The only drawback of this service is that statistics for the last month are shown and there is no way to see the situation online.
There are two tariff plans:Pro - 1950 rubles per month,Unlim - 4950 rubles per month.
Semrush
The service allows you to identify the main competitors in Google, evaluate their positions in organic search results, find out the queries for which they are in the TOP.Uses a database of 106 million most popular keywords and these keywords are spread across 26 regional Google databases.This service is perfect for collecting keywords for website promotion abroad.
You can use it for free, or you can buy paid access to advanced functionality.There are rates from $ 70 to $ 550 per month.
Mutagen
An online service designed to collect and analyze keyword statistics. Shows competition, views and tails. Tails help evaluate how deep the topic is on request. If there are many of them, then there is a high probability of finding "tasty" keys.
Pros:
- does not require installation of any program, works online;
- clear interface;
- you can export the results to Excel.
Minuses:
- small errors and inaccuracies in the analysis results;
- bulk keyword validation requires a fee;
- not very accurate statistics on competition (shown up to 25).
Keys.so
The service is used to find the right keywords, analyze a business niche, and plan promotion work.The keyword database contains nearly 200 million queries.
Its capabilities:
- Cleans takes and inaccurate phrases.
- You can get a report not by domain, but by a separate page.
- All sites of a competitor can be viewed.
- In less than a minute, a complete report on the competitor's domain is generated with information on the number of keywords, the number of pages in the SERP, the number of queries in the TOP and other useful information.
Starting rate - 1500 rubles.Basic rate - 4800 rubles
Rush Analytics
In the arsenal there is such a tool as "Collecting tips" by Yandex and Google.
Its features:
- You can select a region.
- Base collection method.
- Parsing depth.
- Use the geo requests filter.
- Add stop words by topic.
- Works very fast.
After the end of the collection, a notification is received by e-mail.Download available in XLSX format.There is a function of collecting the frequency for the collected keys.
Price: 1 kopeck for 1 request for 1 depth.When registering, you will receive a free 200 rubles on your account. Tthere is also an opportunity to discuss an individual tariff.
Advodka
A service that helps analyze key phrases and competitors both in Serp (organic SERP) and in contextual advertising.Quite a young service, while there is a base for only two regions of Moscow and St. Petersburg.Works with queries for which the selected domains were found in the TOP-20 search results.
The obtained data can be downloaded as a CSV file.
The query base is updated once a month.
Paid service costs from 980 rubles monthly subscription.
Topvisor
This service offers its users an absolutely unique keyword collection tool.Topvisor uses 4 main sources to collect semantics:
- Yandex.Wordstat
- Google. Adwords
- Bing Webmaster
- Webmaster Mail
There is a choice of region and the exact occurrence of the phrase.You can check the frequency of requests, sort it as you like, export in csv or txt formats
Programs
Key collector
One of the most used programs by SEO specialists.It allows you to conveniently select keys to promote your site, andhelps to determine their competitiveness and other data.
What Key Collector can do:
- Pick up key phrases from a huge number of services (Wordstat, Adstat, Adwords, Search hints, etc.).
- Determine the value of phrases and their value.
- Analyze the geo-independence of queries.
- Show all frequency options (base, quoted, and exact match).
- Show the competitiveness of keywords.
- Identify the most relevant pages.
- Provide recommendations for linking.
You can export data to Excel.
Price RUB 1700 In my opinion, quite an acceptable price, based on the capabilities of this program.
Slovoyob
If there is no money to buyKey Collectora, then at first you can try to get by with this program, but in terms of its functionality it is much inferior to its older brother.
- The program can only parse the left column of Yandex Wordstat.
- It is possible to use a proxy and export the results.
- However, the program lacks technical support and very infrequent updates.
Magadan
This program helps to work with keywords and with the help of it you can easily organize your work on compiling semantics.The program collects statistics from Wordstat and from the KeyBooster.ru keyword databaseand with the help flexible customization filters makes a convenient selection of keys.You can set the threshold for processing conditions.For example, if you lower it to the level of 100 or 50 queries per month, you can find low-frequency and very interesting queries.
There are two tariff plans:Light is limited in its functionality and capabilities. Pro - 1500 rubles.
Bukvarix.com
This is just a godsend for those who want to quickly and efficiently find keywords for their website.Currentlythere are 461 million queries in the database.
Sources of the current base:
- Yandex Wordstat
- Google and Yandex search suggestions
- Yandex "Live"
Collected selections can be exported to csv and txt formats.
Pros:
- Work speed. A list of 1000 phrases is processed in about 40 seconds.
- There is an additional option - Morphology module. When using this module, the program can display words in other word forms, in another case, etc.
- 80 regions supported
Most recently, the guys got a second base. The new one already contains 1 billion 438 million keywords, but there are no regions (but the frequencies are fresh). Both databases are free, and a full list of differences can be seen.
I hope my selection helped you and you found something optimal for yourself. Good luck!
