Although more and more keywords are getting encrypted by Google every day, another smart way to come up with keyword ideas is to figure out which keywords your website is already getting found for. To do this, you'll need website analytics software like Google Analytics or HubSpot's Sources tool. Drill down into your website's traffic sources, and sift through you organic search traffic bucket to identify the keywords people are using to arrive at your site.
I also want to emphasize that Microsoft Excel and Google Docs perhaps play an equal, if not more important role in keyword research than any of these tools, because at the end of the day, the mountain of data you end up with is of no use if you can’t perform calculations, sort, filter, present or store it in a way that’s best suits the task at hand. Head over to Distilled for a comprehensive Excel for SEOs guide. Alternatively, bug this guy—he’s the Sensei who trains Excel ninjas in the dark of the night.
Quick question… in your review you mentioned focusing on some products like ProductNamethat are spelled as Product Name and are low competition. My question is how would you tackle a review using a keyword like that? Would you make that the primary one that is misspelled? Would you mix them with the spaced spelling and correct spelling? I’ve found some good ones and would appreciate some direction on how you’d handle writing a post to rank for the spaced keyword?
The limit on manual keywords could be higher. I personally wish we could input 10,000 keywords at a time, instead of 200. However, I understand the costs that Long Tail Pro has to maintain each time a new manual keyword is input. Not a deal breaker, I just wish the limit was higher. (To be fair, I don't think most keyword tools have a bulk manual option at all).