Keyword Research: Use Categories

The most important and paramount part of the search engine optimization process is the research of keywords and phrases. Keyword research helps answer an important question: “What queries do people use in search engines to find products and services on a website?” Your research process will ultimately determine the method that will be used to structure the resource on the web.

You must be absolutely confident in the collected data, since website promotion has global temporal implications, and in order not to waste such a valuable resource as time, it is necessary to approach this task with all possible responsibility.

To make keyword research more feasible, you need to be able to categorize, group, and filter for keywords. A deep understanding of the category on which search engine behavior is based can make your research much more effective.

Collect your keywords

First of all, you must build a list of keywords. Let’s try to list the sources of keywords: you can get a great start with Google Analitycs, the Wordtracker keyword suggestion tool, the Wordstream tool, and with Ubersuggest. If you have access to PPC data, use that as well.

Calculate search volumes

Thus, having received several thousand keywords at the first stage, you will have to calculate the search volume for them. You have several options, which you go through Google’s keyword tool one at a time. Since there are thousands of options, you might even panic and revert to your old manual keyword processing methods. But it really will surprise you how quickly you can collect a lot of keyword data. 

When using the Google Chrome browser, you can create a downloads folder full of CSV files, each containing 100 keywords at a time. And when used wisely, you will quickly get all the insights you need for your analytics.  

Obviously, this stage requires some effort. It’s worth becoming a freelance developer of specialized resources like that automate the process of collecting keyword data through services like Mozenda. The ability to collect data for approximately 50,000 keywords at a time does indeed allow you to do some interesting things, such as capturing 10 related keywords suggested by the API and manipulating them through the API’s search volume.

Create Categories

Now it’s time to create categories of keywords, and then use the Excel set formula to categorize each of the keywords in our set. For example, we are really interested in filtering for each of the keywords that have a location, brand, and keyword based “condition”.


Create a category table with headings for each of your category names and add “markers” to each of them. Then, on a separate Excel sheet, create your keyword search volume table. Create columns for your keywords, search volumes, and category titles.

Next, you need to use an Excel set formula to identify the categories to which the “keys” belong, according to the sequences of text between the category markers and the data contained in the keyword list. The formula will look something like this: {= IF (SUM (NOT (ISERROR (FIND (“Keyword Types”! $ A $ 2: $ A $ 7, $ A2))) * 1)> 0, P $ 1, “Non -” & LOWER (P $ 1))}, where “Keyword Types” [CELLRANGE] ”refers to the category column that corresponds in the category table,“ $ A2 ”is our keyword, in this case“ key1 ”and“ 1 P $ ”are the name of our category column, in this case, “key2”.


At the end of building the table, you just have to analyze the data and use it in search engine optimization.

Share on facebook
Share on twitter
Share on linkedin

Table of Contents

Keep Learning
Save this Post for Later
Received your newslatter to stay on top of the latest blog