I begin to notice that I was being provided very low-ball numbers and weren't very useful to clients or myself. A client doesn't want to see that they will get 1 click a day with an open budget for the key phrase "it services" or "it firm". This would be discouraging in any case.

So... I figured I could provide google's estimate and my own on a 1 out of 30 scale (arbitrary number - but would be at a rough 3% CTR). So... if a keyword has been recorded for 60 searches, I would estimate to a client that they would receive 2 clicks.

The problem with using Google is that they dont provide the actual search volume of a keyword - just a graph.

Yahoo! does provide an actual numeric value for the search volume of a keyword. The problem is importing the numbers - at the moment I am stuck hand entering the search volume for each keyword (hundreds of keywords).

I recently purchased KeywordTracker (not impressed) - lame tech support - not intuitive and uglier than hell. Every time I rename a project it dumps my keyword basket - apparently you cannot change the names of projects. Overrated program.

Stuck... I still cant figure out how to give good click estimates (USING 1 TOOL).

Any success stories? any amazing tools that completely solve the problem I am having?