Leave a request
In a previous article, I shared the process of downloading keywords from competitors. Today we will discuss the important topic of clustering key queries.
Clustering is the process of distributing key phrases into groups (or pages) for the purpose of their subsequent promotion. It is important to remember that requests from different groups cannot be promoted on the same page, otherwise this will lead to confusion and poor results.
Typically, the cost of clustering 1000 keywords varies from 500 to 1500 rubles. However, in the end you end up with a list of groups without taking into account frequency, and you will have to do some additional work with the result in Excel.
If the difference is not significant for you, why pay more for a similar result? There is a free keyword clustering tool that you can use at no cost. It is also recommended to share your xml limits with thanks for use.
Simple process: copy the keywords, paste them into the tool and you're done!
For commercial requests, it is optimal to select a threshold of 3 or more. For information requests, the threshold can be set at level 1-2.
Using the VLOOKUP function in Excel, you can combine the frequency table and clustering results, allowing you to get a more accurate and complete analysis.
Clustering results obtained automatically require additional refinement. Be sure to look at each cluster and combine those that have similar meaning to improve the accuracy of the data.
Yes, this method is not ideal! Paid clustering services have the ability to work with larger cores (over 1000 queries) and exclude aggregators from the results that can distort the conclusions. However, as they say, free tools can also be put to good use!
If you have any questions about SEO or clustering, you can contact the SEO studio "SEO COMPUTER" for any question by email info@seo.computer.
ID 4332
