I would like a reporting module designed w/in a look and feel that looks like the google adwords interface.
There are two main tables that keep track of clicks and assigns keywords to those clicks. Each keyword is associated with a campaign and a sub campaign.
Another table keep track of the date the click took place and if there is any sales/actions that took place.
I would like a reporting module that calculates the ROI. The basic calcualtion is simple, take the number of clicks multiply it by a CPC (cost per click factor) that the user enters and that would be the total cost. Each action is assigned a $$ value by the user. You take the # of actions * $$ amount and that's the profit.
This needs to be done at the campaign, subcampaign, and tracking id level within the specified timeframe.
The user need to be able to enter/edit the CPC, # of actions, value of action in the user interface and also through a file upload.
There would be two areas. An area where a user can play w/ the data and see how the numbers work, and an area that calculates the data based on what the user has entered or uploaded from the file.
You can create as many tables as you'd like to manage the ROI reports.
I've been using PHPMaker4.0 and you're welcome to use my license for it. It makes things a LOT easier.
The UI needs to be user friendly and easy to navigate.
I'd like to use this project to build a longer term relationship w/ a company that will serve my programming needs as well as support the programs developed and provide training and documentation materials for them.