First, I want you to build me a mySQL database where I can upload into it an excel spreadsheet containing over 10,000 keywords that I receive monthly and store it there in with the previous months data, so over time I am able to see which phrases are consistently in the lists and unlikely to disappear. This way I can see who are the long term performers.
Second, I want your system to cross check each phrase AUTOMATICALLY with the number of pages currently indexed in google, and store this number in a separate column/cell, so I can see how much competition there is for a each keyword/phrase. The point of this is to locate keywords with less competition for the keyword/phrase.
Third, I want a 2nd separate SQL database that stores [google trends data][1] hourly which has an RSS feed. I have an example of how I'd like this to look, I can show you if you ask. It is to constantly cross reference with the FIRST database to see if a keyphrase is found to appear in the Google trends history database, and flag it as hot. If there's less than a million indexed pages I need your system to further flag the keyword/phrase as a higher importance.
So to recap... FOR SURE 2 mysql databases, PLUS something that cross references these two for hot keywords AND will save "hot" keywords/phrases in a spreadsheet or what ever you determine to be a good place to store it (possibly a third database)
## Deliverables
This needs to be portable so I can copy/paste it to other people's comps or web servers.