Forum Moderators: open
As nice as it would be to think that such a thing existed, sadly if it did then the niche keyphrases would not be niche anymore because everyone would get to know them.
Wordtracker have their top 500 list, available free, they have other numbers top 1000, top 5000 etc.. available to sell to you.
Here's a bit of advice. Write a bunch of single words on some fridge magnets relevant to your sector, the more you can get the better. Stick them on a whiteboard and just shuffle them about, then try them out on the suggestions tools, google sandbox, wordtracker and then submit. Because the data is always historical you may find a keyword does so much better than it should.
Good luck
I'm a bit confused - if you study your logfiles, and find unusual keywords there, aren't your pages *already* optimized for those keywords, since some searcher was able to find you using them?
Often you can find hits for keyword/phrase combinations that you didn't optimize for. For example, someone may have found your site while digging through multiple listings for a relevant (but un-optimized) combination.
Without any optimization you're getting some traffic for a term you never intentionally focused on. Often, just a bit of on page tweaking, or creating an entirely new optimized page, can shoot you straight to the top for this targeted keyword niche.
Yes, after reading this yesterday, I gave it some thought and decided to use my NetTracker to evaluate all the keywords being used over the past several months. I was able to isolate single words which are very popular and combine them with each other to make phrases I am not currently well ranked for. It was a fun exercise and I immediately put a page up for a keyword I didn't know I was missing out on. I also found some minor keywords where I can have relatively little competition if I tweak things right. Thanks!
-webwoman
I think there is no general way of saying a german would search this way and a french person would search that way. For your topic the search usually goes for "action" and "location". So try to get these keyword combinations into your content and come up with lots of related stuff as well.
Good luck and happy diving (... into your logs)!