I've done what sparky is trying to do before, but haven't had time or inclination to automate it and thus haven't kept up with it.
The problem is tracking the sales and dollars, phpads and other solutions will tell you where the traffic went and how much of it. It's also excellent for measuring things like the pull rate of various campaigns (spotting banners or ads that flat out dont pull, etc).
But to map it back to dollars, you've got to combine that data with the data supplied by the sponsors stats program. If they provide referer stats so you can match the url, you can cut and paste all of that data into a spreadsheet, access or even mysql.
From there you can export your PHPads data similarly.
My solution was load the referers for each sale along with the name of the sponsor, the site, the dollars, etc into a table in mysql and then write some quick PHP code to build me a report cross referencing it against the tables in the phpads database.
Works great, but the problem is loading that data from each sponsor. It could be scraped and automated, but that's a level of pain I haven't gone to.
|