Kw research template

Forum White Hat SEO Kw research template

  • This topic has 3 replies, 1 voice, and was last updated 7 months ago by mygymproducts.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #27175
    seohelper
    Keymaster

    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

    #27178
    mygymproducts

    better to use google sheet.

    #27176
    just-wana-help

    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

    #27177
    ILikeChangingMyMind

    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.

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.
Scroll to Top