PHP Guru Wanted for PPC Affiliate Tracking Back-End

I am an affiliate marketer. I use PPC advertising (Google Adwords & Bing Ads) to drive traffic to my affiliate sites. It's essential to track which PPC keywords result in affiliate sales, in order to optimise advertising spending. HOW I CURRENTLY PERFORM TRACKING Currently, I have a separate AdGroup for each product I promote, in this structure: CAMPAIGN > ADGROUP > KEYWORD > ADVERT I send product-specific keywords to product-specific landing pages. When the user clicks to leave my site and visit the shop, a unique id is attached to the link which is reported in my affiliate sales. At the end of the week, I compare the amount I've spent on advertising, to the income I've made from affiliate sales, for each product. I do this manually by exporting reports from the affiliate networks and importing them into Excel. HOW I WANT TO PERFORM TRACKING I want to quickly and accurately calculate profit/loss for each PPC campaign (broken down into adgroup, keyword, and advert), rather than doing it manually. I don't care about a nice front-end design. The system is for internal use only. Something like this: [login to view URL] - but much simpler. I only need 4 basic reports: 1. Campaign clicks - Campaign spend - Affiliate income - Profit/Loss 2. Adgroup clicks - Adgroup spend - Affiliate income - Profit/Loss 3. Keyword clicks - Keyword spend - Affiliate income - Profit/Loss 4. Individual Advert clicks - Individual Advert spend - Affiliate income - Profit/Loss For flexible date ranges. So if plotting this data, date on the x-axis and GBP on the y-axis (clicks could also be plotted on 2nd y-axis). Just like this: [login to view URL] Campaign would be the highest level chart/report - to give an indication of profit at a glance. But then each AdGroup or even each Keyword can generate its own chart/report. LINKING AFFILIATE SALES TO THE RESPONSIBLE KEYWORDS/ADVERTS Each affiliate tracking ID will need to contain this data, in order to be associated with the correct adgroup. It can follow a standard structure. Something like: campaign_id-adgroup_id-keyword-ad SKILLS REQUIRED - PHP - MYSQL - Google Adwords API - Bing Ads API - Affilate Window API - Ebay Partner Network API - Amazon Associates API - Commission Junction API - Webgains API - Affiliate Future API Note: No front-end design skills are required. I can add fancy flot charts later if required.