Curious if you’ve found a way to efficiently find underperforming keywords? Currently I have to manually click on each and every keyword to calculate it’s Keyword Competitiveness. Frustrating clicking it hundreds or even a thousand + times. I’d rather just add it as one of the scan settings and wait 8 hours for it to run all 1000 than having to manually click them for an hour and then waiting…

Once I have a list of phrases, rankings, and volumes from these tools, I'll look to internal tools (maybe Excel, Access, or another database) to organize, classify, and forecast opportunity. This is where I'll estimate a competitor's traffic based on volume & position CTR, set goals for a target position, and estimate traffic based off that position's CTR and keyword volume.
The WordStream suite of Keyword Tools is an integrated and actionable set of keyword tools designed to help search marketers with keyword search, keyword suggestion, keyword grouping, PPC keyword research, keyword analysis, long-tail keyword research, and negative keyword discovery, going beyond the capabilities that a typical free keyword tool can offer.
Use the Keyword Planner to flag any terms on your list that have way too little (or way too much) search volume, and don't help you maintain a healthy mix like we talked about above. But before you delete anything, check out their trend history and projections in Google Trends. You can see whether, say, some low-volume terms might actually be something you should invest in now -- and reap the benefits for later.

Brian, thank you for all of these informative guides! I started out as a digital marketing intern and everything that I learned from your site has helped me land a job as a marketing specialist. I’m truly grateful and enjoy everything that you published so far. If you have a chance, I’ve started using this tool called SEOClarity, I was wondering what’s your take on it? Have you used it before or know anyone that has?
It would be great if you can provide comparative analysis of this tool with Google Keyword Planner. Since you’re using this tool so you can provide best comparison. One differentiation which I understood is that this tool works for yahoo and bing as well whereas Google keyword planner works only for Google but Google being a dominating search engine, gives the highest returns, so only this reason may not be enough to buy it.