Keyword Research tools are usually subscription based, and based on Overture results. Google has recently made it's keyword search data public, and so it should be fairly simple, hopefully, to provide a way of extracting the data from keyword searches automatically.
This will be a windows program that logs onto Google external keyword tool (pause for manual captcha entry) then prompts the user for a keyword. It then scrapes the data which Google delivers for that keyword i.e. searches per month. It then gathers further data, and finally dumps the results into Excel
## Deliverables
Based on a single keyword, the program needs to scrape / extract from Google :-
1. The monthly search volume for the keyword and ALL the derivatives that Google supplies on that screen?
2. It then needs to go and check the search term for each of the above results, then check Google for the number of results for the keyword and every derivative of it
3. It then needs to check the number of results for the keyword and all it's derivatives for the results in quotes
4. It then needs to open excel, and dump all the data into excel
So for instance if I want to check the keyword 'hamburgers' I want to just type in the word hamburger, then wait while the program goes away and does all the checking, then it comes back with all the results in excel in the following format? :-
Keyword, monthly searches, competitor google results, results in quotes,
Derivative 1 - same as above
Derivative 2 - same as above
Derivative 3 - same as above
...
...
...
...
...
Derivative 197 - same as above
It may be useful to also populate another column in the excel spreadsheet to divide the number of searches by the results for the 'competitor in quotes'? which will give the KEI (keyword effectiveness indicator.