I recently decided to go with ahrefs after using spyfu for a couple years and trialing secockpit. I was a moz client for awhile too about a year ago. I found spyfu data to be sketchy (or just plain wrong) fairly often, and moz, I don’t know, just didn’t seem like they were really into supporting what I wanted to know. secockpit was achingly slow for a trickle of data. ahrefs isn’t nearly so graph-y as spyfu, but they are so blazing fast and the data is so deep. I enjoy it a great deal, even if it is spendy.
Given you have a good idea of where to start and are fairly confident you are speaking the same language as your client, jump start research by generating related keyphrases and long tail variants with the ever so easy to use Google Autocomplete. This tool makes predictions based on what you are typing that are a reflection of Google search activity.
Long Tail Pro helps to assess the strength of your competition and put you ahead of your competitors. It would help you to rank higher than your competitors. When it fetches the keywords for you, it filters it and delivers the relevant ones after filtering them and making them relevant to your domain. This way it would help place your business and your website ahead of its competitors.
So whilst Long Tail Pro has just continued to grow in revenue every single year and comes highly recommended, you may want to check if all the important features are fully functioning before signing up. Especially the KC feature (keyword competitiveness) as it is so fundamental to keyword research and making an informed choice on whether or not to go into a particular niche.