Bulk Keyword Categorisation and Classification

Categorising a large keyword list in bulk takes hours to do, unless you do it a special way. Learn how to categorise thousands of keywords in seconds through the use of a magical Excel formula.

You can categorise anything you want with this formula, it doesn't only work on keywords. Another popular use of mine is to categorise landing pages, which can significantly help with showing how ranking performance has improved certain landing page's traffic.

Download the Keyword Categorisation Template!
  You will receive a download link via email. We hate spam and never share your details.

 

2 Comments

  1. Hello Sam,

    and thak for you fabulous tools

    Is it possible to add a category type 4 and 5 ?

    I tried to add a fourth category by copying sticky but it did not work

    Thank in advance

    Reply
    • Hey Laurent,

      No worries, hope it’s saving you lots of time!

      You can definitely add as many categories as you want, you just need to modify the two table columns to match a new table.

      1 – Copy an existing table, and create a 4th and 5th table, and give them names
      2 – Open the cell, and copy the formula (not the cell)
      3 – Create a new column, and paste the formula into it
      4 – Change the formula to reference your new table.

      So when changing the formula, instead of it saying ‘category1’, if you changed the table name to be ‘category4’, just replace the mention of ‘category1’ to be ‘category4’.

      Let me know if that helped.

      Thanks,
      Sam.

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Download the Keyword Categorisation Template!
  You will receive a download link via email. We hate spam and never share your details.
Download the Google Analytics Dashboard
  You will receive a download link via email. We hate spam and never share your details.
Download the Excel Reporting Templates
  You will receive a download link via email. We hate spam and never share your details.