Google Keyword Research Script
Hello,
I am in need of a script that will automatically do keyword research for keywords that I select. What I would like this script to do is allow me to input a batch of keywords and this script go out to Google and return results for 3 different queries per keyword. I want it to search these 3 things:
1. In google.com, I want it to tell me the # of results of the keyword as a phrase match (type “KEYWORD” in search box and tell me total # of results from top right corner). It should then assign this metric a score of (results X .2) to be added together with other scores in 4th column of spreadsheet results.
2. In google.com, I want it to also tell me the # of results for allintitle (type allintitle:”KEYWORD” in search box and tell me the total # of results from top right corner). It should then assign this metric a score of (results X .5) to be added together with other scores in 4th column of spreadsheet results.
3. In google.com/insights/search I want it to search for each keyword and return to me the # associated with each term (type keyword in the search box and tell me the # associated with that search), which requires you to be logged in to a google account, so the script will need that capability (some type of ability for user to login to google 1st before running script). It should then assign this metric a score of (results X .3) to be added together with other scores in 4th column of spreadsheet results.
Once the script has run these queries, I would like it to compile the data in a spreadsheet so that I can see it in excel, and I would like it to assign a score to each keyword as shown above and added together in the 4th column of the spreadsheet. I dont know anything about programming, so it is up to you to tell me what language you will program this in. I would prefer a desktop application, but if a web-based application is cheaper, that is fine as well. Please let me know if you have any questions…
