169926 Pay per click keyword tracking

Hi, I am looking to create a script to help me track my pay per click spending and affiliate earnings. I imagine it will be combination/clone of xtreme conversions, affiliate radar and keyword xray. Basically I want to keep track of every click I receive from my pay per click advertising The script will sit on a tracking page on my server. Every click from adwords, microsoft adcenter and ysm will first call this script before being redirected with my affiliate link and unique subid to the appropriate site. For each new keyword the script will assign a new subid number that I can use for tracking if a sale is made. Here is a basic rundown on what would happen with each click: 1. user clicks on ppc ad 2. user is redirected to my tracking site 3. script records date, referring url and extracts keyword from url 4. based on the url params and depending on the ppc engine script also records bidkeyword {keyword}, matchtype {matchtype}, adID, ad group and campaign. 5. the script then assigns this unique combination an ID. If this unique combination already exists then it fetchs the existing ID 6. The script then redirects the user to what ever site with the new/fetched ID as a subid which will show up in affiliate reports. The script will need to be able to import reports from adwords, adcenter and ysm as well reports from affiliate companies like commission junction. It will need to match the keywords from the ppc engine reports to the keyword id's assigned by the script to the individual keyword combinations Once I have imported the reports from the ppc companies and affiliate companies I want to be able to break down the data all the way to the keyword level. For example for any given keyword I would like to be able to see a graph for any given time period of my costs vs earnings for this keyword. I would also like to be able to do this comparison at any level like adgroup or campaign. I would also like be able to graph clicks, conversions etc. I would also like there to be a way for me to view the live referring url data coming in for any given adgroup or campaign. This would sort of be like hittail. If you questions let me know. I would prefer to hire someone who is familiar with ppc and affiliate marketing. I will be open to someone doing it in either php/mysql or .Net I am programmer myself so i expect good, clean, commented code. I will write more detailed specs for whoever i select for this project.