Edit product


The Keyword Search Intent Macro

With the launch of my SEO blog post, How To Build a Keyword Matrix [and Why You Need One], I showed examples of an Excel spreadsheet that included a macro for auto-tagging seacher intent.

A few notes about using it:

  • To download it click the 'buy this' item.
  • Enter your email address (this is part of gumroad's checkout, but no spam, promise).
  • Your first time opening the macro-enabled Microsoft Excel file, make sure you click the yellow button at the top to 'enable macro content' or else the intent macro won't work.
  • The file currently contains dummy data that is for example purposes only.

  • I have entered a bunch of the common language I use when tagging search intent in cells B3, B4, and B5. Feel free to try it out or add/edit as you see fit.
  • Make sure you set the 'Last Row' (in Cell H2) to whatever the last row is that you want analyzed, that's where it will stop checking.
  • Click the [Get Intent] button and poof, up to 100,000 rows without breaking a sweat. It will also auto-update every time you change any of the tagging criteria keywords.

You've purchased this product

See it in your library

View in Library
Sorry, this item is not available in your location.
Sold out, please go back and pick another option.

0 ratings

  • Size262 KB


The Keyword Search Intent Macro

Enter your info to complete your purchase


···· ···· ···· 4242
Test card



Use a different card?


pp paypal

or pay with

We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

or pay with

You'll be charged US$20.

Your purchase was successful!

We charged your card and sent you a receipt


    Gumroad Library

    Download from the App Store or text yourself a link to the app

    Good news! Since you already have a Gumroad account, it's also been added to your library.

    Powered by Gumroad