Project Brief I need a php script that will do the following: 1) Allow our staff to key in a range of keywords in a form box and store these keywords in a mysql table 2) The php script goes off and searches/scrapes Google paid listings for those keywords entered in step 1 above. 3) Downloads all of the paid listings and stores the information in a mysql database. a. This must include the full copy of the ad, (title description, display url and destination url) b. Ad variations - so if an advertiser is testing 2 (or more) ads that are rotating we would be able to store all of the ad variations c. Cost per click data (this could be pulled from the other Google estimation tools available) 4) The script would then do the same again each day for all of the stored keywords. 5) The results page would then (selectable by keywords as in step 1) show the all the paid results, the number of days the script has been tracking the keywords and the number of days each advertisers ads have been showing during the tracking period. This data would be in a table format with the approximate cost per click data as highlighted in step 3c above.
Pre requisites 1) The tool must be developed to work on any LAMP platform with PHP 4+ 2) The tool must be able to track a limitless amount of keywords and keep the information on a continuous basis 3) There must be options to delete / archive keywords that we no longer wish to track 4) The tool must be configurable to ‘scrape’ Google paid listings in various countries 5) The results page(s) must be in an easily understood table format 6) The process of analysing the keywords on a daily basis must be automated 7) We are not too concerned about fancy graphic design, we just want a fully functional tool that is automated and reliable and configurable as described. 8) We may add to the project over time so the developer must be able to help us with subsequent phases if we want to expand past this initial first phase. Although this sounds fairly complex it is a relatively easy project for a strong php developer who is used to working with APIs or scraping results. Please submit your best bids and provide an overview (wit examples) of php development projects undertaken in the past with links to examples where possible. Also indicate the amount of time you expect this project to take. Strict terms ??" 50% of payment on release of first version prototype (on our servers, must work), 50% on full completion of project to our specifications.
Linux, Apache, Mysql, PHP