We need a script developed in PHP/MySQL that will help us aggregate and process data for keyword searches. The purpose of this script would be to help us select keyword phrases to use in search engine marketing. (It may sound complicated, but other than the API queries, it will just be a straightforward database with php interface.) Here is an overview of what the script will do: We will upload lists of keywords in csv format (obtained from the Google keyword research tool) that includes the keyword phrase, PPC competition level, and monthly search volume. The script will dump the keyword data into a database, and query Yahoo Search API to the number of results returned for "intitle:[keyword]" for each keyword. The keyword phrases, along with the PPC competition, intitle counts, and monthly search volume counts can then be viewed in the system. Here is a function by function list of how it should work: Homepage will have the option to add a project (a project would just be a group to allow keywords to be grouped and organized) and will list projects in the system. When you click on a project name, you will go to the project page... Project page will: 1) Allow you to upload csv files with keywords to the project. 2) Link to click to view all keywords and associated data in the project. 3) Filter options to sort/filter keywords & data in the project by intitle count, search volume, or PPC competition level. Will use Yahoo Boss API - [login to view URL] The query limit is relatively high, so that should not pose a big problem. Querying the API when keywords are uploaded, though, would take too long. Perhaps the script could be set to query (for example) 30 keywords per minute until the batch is processed. I'm open to whatever setup would be easiest and work best. No design work is required. Just plain, functional HTML is fine. No user/login management required. I will just set a password via htaccess.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
PHP/MySQL