I need a click tracker for my websites. It has to be able to pick up the keyword phrase that the user comes in on from Google or MSN, and detect when they click on framed content within the web page. It should write back to a centralized MySQL database. This will have to be installed on multiple websites and write back to a single database.
Within the program itself, I need to be able to define "campaigns" so that I can identify each page that the code runs on. So for instance a web page about widgets would be the "widgets" campaign, and clicks on that page would be recorded there. From a reporting standpoint I need to be able to look at a campaign and see the incomming keywords and the number of outgoing clicks each keyword receives. I should be able to view this as an aggregate number or on a day by day basis. It would be good if I can define the length of time data will be retained.
Additional items that would be nice to have:
1) Breakdown a campaign/keyword by traffic location (geographic). So I can see how well U.S. traffic converts to clicks vs Canadians.
2) Ability to print reports
Important note: I do not have sontrol over the content in the frame. The code must go on the master page that contains the frame. All I need to do is detect that someone clicks in the frame, not what they click on.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
MySQL, IE, Firefox