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.
Note! Google often shows search results for general meanings, rather than specific words and phrases. When you search for a phrase in Google, you’ll see the keyword bolded in the search results. Look closely and you may find words you didn’t search for bolded in those same search results. For example, a search for “HVAC repair” returns search listings with phrases such as “heating” and “air conditioning.”
All these need to be looked at individually and then compared to the current top ranking competitors. A site which as excessive amounts of backlinks as compared to the competition and that is not ranking, indicates that the backlinks are too spammy or the site content and user experience is very poor or there has been spamor a penalty associated with the site.
The Google Keyword Tool is SUPER helpful for building a foundation for your keyword research strategy. At the end of the day, these search numbers are coming straight from the horses mouth. You can filter down to a hyper-local level and see which keywords are getting the largest search volume. Plus, with it’s integration with PPC you can get a quick idea about commercial intent by looking at the bid and competition metrics. How much are people bidding on KWs, higher = more likely to generate a return. Usually its aligned with search intent. That said, the trending data is a little less reliable. I would still use Trends to analyze the popularity/ seasonality of KW search volume.
Yes solid keyword data dramatically changes the game as far as rankings go. I have seen many tools that provide Cost per click stats and meaningless charts that confuse most users. the data Jaaxy provides helps drive “organic” traffic to your site on a consistent basis which will out perform PPC sites every time. I like how you say thinking like the end user, as I feel that way when I search. I dive into what people are looking for and it really helps drive content idea’s. I have seen great results from that.