Forums Forums White Hat SEO Kw research template

  • Kw research template

    Posted by seohelper on October 12, 2021 at 1:58 pm

    Hi guys,

    Does anyone know a good example of a keyword research sheet so i can track my kw in the most professional manner for my blog?

    I want to build my own sheet but dont know where to start

    It is better to use google sheets or excel?

    Thank you

    mygymproducts replied 2 years, 5 months ago 1 Member · 3 Replies
  • 3 Replies
  • mygymproducts

    Guest
    October 12, 2021 at 2:33 pm

    better to use google sheet.

  • just-wana-help

    Guest
    October 12, 2021 at 3:44 pm

    u/mygymproducts is right. I prefer google sheets.

    * Access them anywhere
    * Easily sharable
    * Work well with other Google products like Docs and Gmail

    For the template, I would try a quick google search, there are lots of free templates. I personally don’t use a template, I use an SEO tool to keep track

  • ILikeChangingMyMind

    Guest
    October 12, 2021 at 6:48 pm

    Personally I just use a google sheet with a separate-sub sheet for each category of content.

    Then, on that sheet, I simply have two columns: keywords and # of searches for those keywords. I also keep a column of notes (eg. if the competition for a given keyword is particularly fierce) and then also, a few columns away, I keep a list of content ideas for that category.

    Finally, I have a “To Do” sheet at the end. Whenever I run low on to do’s I just scroll through the category sheets looking for ones with high search numbers and enough content ideas.

    No idea if this is the best way at all, just what I do.