Hi,
Please take a look at the XLS that I've attached (XLS 2003).
What you are supposed to be able to do with the XLS is enter a list of keywords and it gets the keyword data from Google Keyword tool via their API - <[login to view URL]> Just to be clear that's columns Competition, Global monthly searches, local monthly searches. CTR is taken from the tab - 'CTR %s'. Sheet1 shows what the output should be. Column L & N have complex algorithms that make the calculation of change.
So to sum up, we're trying to calculate how much of an increase in results we are to get from putting all this data into a pot.
So what we need to do is fix all these issues and allow an input where a user can enter the keyword(s) and get the output as a chart + the raw data.
This will need to be a web script. PHP if possible.
I have a VPS that you can have full root access to.
The API connections do not work at present, so:
#1. Fix connection to Google API - <[login to view URL]>
#2. Create connection to Authority labs API for rankings - [[login to view URL]
H][1]appy to answer questions.