PPC keyword tracking script(repost)

PPC tracking down to the keyword level for adwords, ysm, adcenter. Assign every click a unique id that is then passed as sub id in the affiliate link so i know what keyword made the sale. The script should also allow me to import reports from both the ppc engines and the affiliate networks so I can see one view that shows me clicks, cost, amount made for any level from campaign to keyword. I am a programmer myself so i want well formed, clean, commented code that can be expanded upon in the future. I would prefer to work with someone who is familiar with ppc and tracking scripts. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. This project can be done in either php/MySql or .net 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. 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). 4) Here is a more detailed description of the program The basics: Someone clicks on my ppc ad and is sent to my server running this script. The script logs the information about the click and sets the sub id before redirecting the user to the merchant url More details: When a click comes in the script will parse the referring url and check if keyword is a new/unique group Keyword uniqueness is determined by campaign, adgroup, matchtype etc. The script will save all data related to click such as referring url, domain, adgroup, keyword etc. Interface The interface should be clean and simple. It should be nice xhtml/css so that I can easily modify it at any time. There should be tabs at the top for: Traffic Marketing data Setting/maintenance Features: For any given view I should be able to compare data in graphs Traffic view See updated view of most recent hits for any campaign , adgroup etc Basically a filtered view of log/hits file Sales view: I should be able to view the data at any level Campaign level Adgroup level Keyword level The columns before importing data from the ppc engines and affiliate engines are: Campaign, adgroup, bid keyword, keyword, domain, clicks I will import data from the ppc engine broken down to daily reports that will then be merged with my saved click data. I will also import data from the affiliate reports (date, subid (keyword id), amount). All this data will then be displayed in a table that allows me to see for any given campaign or adgroup or keyword the clicks, cost, amount made etc. By assigning a unique id to everything it should even allow me to look up what referring url made the specific sale Importing reports For now I will just upload them as csv files but I want a stub in case I set up to do it automatically later on When importing reports I will also need a place to specify which timezone they are done in. When viewing the data I want to be able to hide columns.I also want to be able to graph different columns over a data range. For example I would want to see the amount spent and the amount made over a date range. or maybe the cpc vs the amount made over a date range. We will need to talk about this part a little more. There also needs to be a way to clean the ppc reports or affiliate data as well deleting campaigns That covers the basics. I can write a more detailed version of the specs for the winner ## Platform this should run php/MySql or .Net