Sharing is caring - if you like the tool, please let others know
Hello. Welcome to my categorisation tool - useful for categorising keywords quickly and a lot less painlessly. Watch the video (it is around 30 minutes long though) or follow the steps below:
1) Download the data form here (or download a competed data form example here to see how to use the tool and the expected result).
2) Copy your keyword list into the keyword column. This step is not necessary, but if you are only working on one screen you may find it useful to have the keywords on the same page as the category columns.
3) Having looked at your keywords, you'll know, or have an idea about, the sorts of categories you will want to put them in. In the "category 1" column you'll notice 4 columns.
In column 1, the "find column", enter a word you wish the tool to find in the keyword.
In column 2, the "category" column, this is the category where, if the word is found in column 1, categorise it under this category.
For example - if you were categorising clothes, and your keywords were:
tshirt, red tshirt, where can I buy a tshirt, warm jumpers, water proof jackets
You might enter the following in the find column:
And the following in the categorise column"
And the tool will categorise the first 3 keywords into "tshirts". Follow the process for jumpers and jackets.
The fourth column, "priority", is where you can set a priority number. Sometimes keywords might have 2 conflicting words that might otherwise fall into 2 categories. For example, if your company sells steel doors you might have the following categories:
Steel Doors, Fire Exit Doors, Glazed Doors, Domestic Door
And your keywords might be:
Steel doors, High security steel doors, Fire exit doors, Front Doors, See through Doors, Steel Fire Exit Doors, House Doors, Fire Exit Doors
In this scenario your categorisation might look like the following:
Most of those keywords should categorise fine. But what about "Steel Fire Exit Doors"? This could fall into two categories according to the formula. This is where we use the "Priority" column. We would set "steel" as priority 2, and fire as priority 1. Then, whenever both "steel" and "fire" was in the same keyword, the program knows which category to put it in. (NB - category levels can go from 1, to whatever number you want... 1,2,3,4,5 etc etc).
4) You might want to categorise your keywords further, this is what the category 2 and category 3 tables are for. You don't have to fill these are in, but you might want to use these to perhaps further categorise your keywords by colour or location. You can't set priority levels on subcategories however.
5) We would recommend saving this data form spreadsheet as you can use it or add to it whenever you want. Its a template, so if you need to add to your keyword list, you won't need to set up all the categorises again. If you typically work with similar industries, you can keep using the same template to copy and paste into the categorisation tool.
5) Once you have filled in your categories, a formula is generated in the "copy to webform" column. Highlight the whole column and copy and paste into the relevant "Keyword categorisation" tool sections.
6) Click "Categorise" and you should get a CSV with all your keywords categorised.
7) We would recommend adding filters to your headings and spot checking some of the keywords. You may find you need to make some slight adjustments to the priority columns, or additions to the "find and categorise" columns and re-run your keyword list. This is why we would recommend saving the data entry form.
8) The multi match column flags any keywords which could have fallen into two categories. The keywords will be prioritised according to your "priority numbers" but this column shows you the other categories it could have gone into. We would recommend having a quick scan down and see if any are incorrect. You may find you assigned the same priority level to two keywords in which case the tool has just made an assumption. You may wish to change these manually, or alter the formula in the data entry form and re-run the tool.
9) If you'd like to see an example of a filled in data entry form - click here. Have a go copying the data out into the tool, clicking calculate, and observing the results.