I am looking for a script that would take an excel spread list, or text file, of keywords and phrases and do a search for them in Google,? MSN and Yahoo, they will them tell me where they are ranked and give me a printable report, I would like it to keep track for me like did the ranking move in Google from #11 to #5.
I do not want it to do the search with my website in the search phrase, it needs to find my website for me.? Example, put in the key phrase wedding cakes, it should then get the results and then look for my website and tell me what number it is at.? It should show all three engines next to each other so I can compare them.? So the input would ask me the website I am working with, then I can paste into a blank all the key phrases and it should then create the report.? I do not care what this is written in, it could be a cgi, PHP, VB, etc your call.? This is a pet project to make my life a little easier, so I am not willing to pay a great deal of money, nor does this have to be some big project.
PLEASE READ DELIVERABLES FOR MORE DETAILS
## Deliverables
_-_-_-_-_ NEW INFO -_-_-_-_-_-_-_-_-_-_-_-_
?
Here is further info which may clearify:
I would like a script which will do the following,
I own the domain [login to view URL]
It is well ranked in some keyword search terms and poor in others, as a tweek the pages I want to know if my rankings go up and or down so here is the full proceess that I do know and I would like a script to do.
Step 1, I open my webstats page which tells me what phrases people type into google, msn and yahoo to find my site.? I copy this list which here is only a few lines of:
Keywords? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? #of hit? ? ? % of visitors
| suzie s date bar kauai | 5 | 3.3 % |
| kinkos kauai | 5 | 3.3 % |
| kauai florists | 3 | 1.9 % |
| kauai bikini | 3 | 1.9 % |
| kauai java kai | 2 | 1.3 % |
Step 2 Now I open excel and paste this and remove # of hits and % of visitors
Step 3 Now I open Google and do a search on the first line Suzie's date bar kauai which I then find as #3 on the list.
Step 4 I enter this in excel and notice if the ranking went up or down or stated the same, if there is a change I normally change the font color to red for down, and green for up.
Step 5 I open a IE window to MSN and do the same.
Step? 6 Open a IE window to yahoo and repeat.
Step 7 Go to the next line kinkos kauai and repeat steps 3,4,5,6
Then I also have a field where if I make a change to a page that effects a ranking I have a note that tells me when and why, I fill that in.
I would like this process to happen automaticly every 24 hours
The keywords I can paste into the keyword table and I would like it to hold maybe a 1000 phrases or more.? Currently I am up to 468 phrases.
I am hoping this helps sorry for the mis-spelling it is very late.
Thank you
George
## Platform
CGI, PHP, VB, HTML, excel, access