Edit product
Your Cart
    Subtotal

    Is this your street address?

    Card

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

    05/18

    Card

    Use a different card?

    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

    Please confirm your location:
    You'll be charged .

    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

      $20

      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

      • Size 262 KB

      Checkout

      The Keyword Search Intent Macro

      Enter your info to complete your purchase

      Card

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

      05/18

      Card

      Use a different card?

      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

      Please confirm your location:
      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