These sites spider google with a search query. When doing this, they mimic the behavior of a real user: browsing speed, user agent, …
After parsing information they can construct a ranking.
You can do this yourself in PHP, using the cURL library.
I can recommend “Webbots, Spiders and Screenscrapers”. I contains really everything you need to know on this topic and includes a library for the easy parsing of web pages.
Wow, this thread has some great info and links to some interesting tools. this will keep me busy for a whole afternoon, figuring out what I need to do for my sites to improve the user experience, as well as the search engine optimization.
I’m not sure that there is a ranking report for keywords in Analytics. Google Webmaster Central has one although it is limited in that, you can’t put a keyword and see where you rank for that keyword, instead it gives you a list of keywords that have generated traffic and where you rank with those keywords.
I am loving the tools available here. You can even add a rss feed to your page to watch the tracking. You can set it up to track monthly, weekly or daily. I look forward to seeing how it works over the next month or so.