Auto Keyword Tagging and Filtering Tool for SEO

Click here to get the tool!!

“File > Make a Copy”

As SEO’s, we are dealing with a huge number of keywords most of the times and it is hard to filter and tag them even the numbers are not higher than 200, it could be a very boring job for us.

While I am dealing with them, I tried to find quick ways with Google Spreadsheet. I just used mostly basic Google Spreadsheet formulas and “regexmatch” to minimize my manual efforts.

On this Google Spreadsheet I shared, I wanted to combine a few techniques I am using for keyword research processes to show you what you can do and how you can use Google Spreadsheet.

I am always sharing this stuffs with this disclaimer, I am not a programmer, I am not an expert Excel guy and I am just copy/paste expert of Regex. 🙂 But still, I want to share the quick tricks to you, which help me a lot.

How to Use?

First paste your keywords to “Past&Filter” tab.

You can clean your list by using Negative and Positive words. You can see most frequent KWs on “KW Density” section.

On this tab you can filter your keywords. Negative keywords which contain word on Negative part will be removed from your final list. Positive part is for necessary words to be in a final list. You can also see the keyword density to figure out which keywords you will need and which ones you need to be removed.

! All searches work with Regexmatch. So writing “one” to negative may delete your all “iphone” keywords from the list. You can use a few regex things to make betters filters. I tried to give some examples but you can improve with your regex knowledge. Check here for Google regex reference: https://github.com/google/re2/blob/master/doc/syntax.txt

Auto-Tagging” Tab Where you can Tag KWs with Search Terms

Auto Tagging” tab is for tagging your keywords. I tried to add useful examples to make it easier to use. It uses regex search and there is “Exclude” section for better tagging. You can name tags if you want or tag names come directly from “Search Term”. (“|” means or for Regex, as on example above, if you want to tag only “iPhone X”s not XR or XS, you can add xr|xs to Exclude tab just get iPhone X searches.”

At “All Tags” tab you can see the all tags and its keywords.

Get a Tag” section provides you yo choose the tag and get all of the keywords with this tag.

Note: I limited number of KWs with 1.000 but you can extend it. It can be slower with a huge number of KWs but I tried 5K to 10Ks and it worked well but slowly.

Keyword Research Tool v2

Click here to copy the tool! (V2.1.1 Updated)


!!! Update 2.1.1 !!!

There was a little bug, fixed.

!! UPDATE !!

Hi, I have published an update as v2.1. On this new version, you can choose country too! It was an important need for this tool, sorry for the late update.

— Old version spreadsheet: V2


Hi,

I updated my Keyword Research Tool with Google Autocomplete API with some new features I think it will make it more like a real SEO tool and make keyword research easier. 🙂

Here is a demo screenshot:

Quick Tutorial for better understanding but I believe after you start to use it you will get it out easily. Before you start you need to Click custom menu “KW Research” at the top right and click “Configure & Start”. (They will ask too many permissions but you can be sure I will have no access to any of your data, you can check out the codes. I just have a Google Analytics code on the popup when you click Configure.)

1.Write the keyword to start your research:

After the KW Ideas comes to screen you can click the + button to add them to your list!

2. Write new keywords to continue or click main topics:

You can click the main topics to continue with this keyword. It will be copied to Keyword cell. Also you can continue with typing new keywords.

3. You can make it automatic to adding to lists:

You don’t have to click + icon every time if you want to add all keywords to your list.

4. Filters:

Finally, you can use Negative and Positive filters to make your list better. For example on the case of Screenshot, I am doing a KW research for “iPhone 7” so I put it to “Positive” to avoid to see other stuff on my list, and also added some negatives that I am not interested for my content.

So if you want to restart your research click to (-). All saved Keywords will be deleted.

Note: If you have the main topics to choose from the list you can paste them “KW Topics” tab. KWs will be on the dropdown menu.

You can copy this Google Spreadsheet file to start use the tool.

Thanks ^_^

[crypto-donation-box]

NOTE: For somes, Google says it is not secure to use this script. BUT you can check all of the codes that I have no access to any of your data because you are copying the ALL code to your Drive and there is no other possible way to I can see your data.