Interesting New Google API Related $50 Project

Just before Christmas (Merry late Christmas, by the way...) I received a request for an interesting new Google API-related $50 project.

S_ _ _ _ requested the following data be returned into an excel spreadsheet for each of a list of up to 300 or so keyword phrases:

• The number of websites competing for the search term keywords, as well as intitle:keywords and allinachor:keywords;


• The number of backlinks of the 1st, 3rd, 5th, and 10th ranked competing sites for the search term keywords;


• The pageranks of the 1st, 3rd, 5th, and 10th ranked competing sites for the search term keywords;


• The URLs of the 1st, 3rd, 5th, and 10th ranked competing sites for the search term keywords;

And some bonus optional data S_ _ _ _ would like are the number of searches in Overture Database and the number of searches in Wordtracker Database (using the WordTracker API, with which I'm not terribly familiar).

I'll get right on it, S_ _ _ _, and I'll see what I can do.

Excel_Geek