Open up the file in excel and select the same count of cells as you pasted in from the top down (AdWords will bring along other suggested keywords but we are only looking for the search volume from our existing traffic driving keyword population).

Copy and paste these counts into C2 in your original analysis document.

Now in column E (your performance column) set cell E2 = D2/C2 and then click the % button to convert this to a percentage.

Select column x and set conditional formatting (specific) to highlight the highest percentages in green, then do the same for column x using the opposite to show the lowest numbers in green.

Notice anything strange?

Cells with #VALUE! means that you are getting traffic for keywords that Google does not return any search volume for, also there's a good chance that you have over 100% of traffic for some of these keywords.

Does this mean that you are acquiring every single search for that keyword? Heck no, but I suspect this means that you are capitalizing on trends that are not constant enough to be reflected within Google's keyword search volume estimates.

Again, this is just a hypothesis, but I did do some spot checking on a few of my top-performing keywords using Google Trends, and here is what they turned up:

For the keyword ios6.1.1:

The search volume is literally at the top of the trends index (100) starting right in the beginning of 2013, and then looking at the geographic area:

100% in Japan, showing that not only did this keyword gain search volume in the very recent past, but that this search volume is siloed within Japan only.

For the term: htc j butterfly htl21 不具合(HTC j Butterfly HTL21 is a cell phone , and 不具合 means 'bug')

Google Trends reports that there is "not enough search volume to show graphs," which is surprising considering this term alone sent almost 1,000 visits (996) via Google to our website over the past 30 days. And it is safe to assume that we are not acquiring 100% of related searches for the terms, so the current search volume must exceed 1,000 local searches.

And then for the keyword: f-10d 不具合(translated: f-10d bug, f-10d is a cell phone from DoCoMo )

Which makes a little more sense, since Google estimated 720 searches per month, even though we've acquire 1,479 visits in the past 30 days.

This leads me to believe that the Google keyword tool is inaccurate for estimating recent trends in search volume when they are contained within specific geographic regions.