Organizing Advertising Space and keeping track of it all

[fretmasters]

Hello.

I have a rather large website with lots of advertising space that uses ads from various companies such as valueclick, adbrite and google. I'm planning on making a database using php and mysql so I can easily organize and replace ad code on the site. I was wondering however if I could somehow incorporate a system that keeps track of cpm and cpc data as well as totals from each company on each adspot so I can easily compare companies and decide which company is best suited and most efficient for each ad spot. Does anyone have any idea of how I could go about setting this up, such as php code that is already designed to do this or software that I could download which would allow me to do this or even a website which allows you to add tracking information from the ad companies? Any help would be appreciated, I basically just want a way of organizing the ads from multiple companies on my site more efficiently so I can see ways of increasing my profits.
Thanks.

[shorebreak]

I believe companies like YieldBuild and PubMatic offer inventory optimization solutions.

[fretmasters]

Thanks

I found a product called openx that looks like it does pretty much exactly what I want. Before I start setting it up and using it I want to ask is it the best choice for what I want to do or are there other products that I could use which are more efficient and easier to use?
Many thanks.

[KevinBoss]

Came here to post about OpenX too. Try it out.

[fretmasters]

I've been using openx for a few days now, it seems good however I would like something which can give me real revenue data directly from the ad companies instead of just calculating it from the cpc value I enter and the amount of clicks I have received.
Is there anything like this?
Thanks.

[rfung]

nope. Pubmatic's probably as close as it gets.