A PHP clicktracking system and backend to be implemented on Apache WordPress-like affiliate sites that run everything through an index.php file. The click recording system is pretty simple -- code to use the Request URI server variable to figure out where to redirect the user. I expect the front-end to be, maximum, 2 hours of work. The harder part of this project is the backend which uses the click data.
The basic idea behind the backend is generate reports to help administrate the website. Obviously the goal is to maximize earnings and conversion so anything helpful is a desired part of the backend. See below for details.
I am attaching a database structure with some comments for each table and what it is for. I expect the database will be roughly based on my structure but I am okay with some changes if you feel like it will make the system faster or more efficient. I also might have forgotten something.
Requirements Interview Answers: 
To help you bid more accurately, the buyer was interviewed about the requirements for this project. Below are their answers.
Untitled Page
Other Requirements:
Here are the backend reports I'm thinking of:
1. Click through rate (ie, clicks per traffic) on a sitewide and page-level basis with the ability to isolate and combine variables such as OS, country (or countries), entrance method, hit # range, visit # range, etc
2. Sitewide and page-level zone rankings with the ability to isolate and combine variables such as OS, country (or countries), entrance method, etc
3. Sitewide and page-level earning rankings. Page-level earning rankings will be derived from non-default trackers which means non-default trackers have to be page specific. Default trackers will be excluded from page-level earnings rankings.
4. Word-level keyword rankings (with the ability to combine multiple words) in both click-through rate and earnings (non-default trackers only) with the ability to isolate and combine variables such as OS, country (or countries), entrance method, etc
5. Clickthrough rate and earnings by number of visits and hits (specific trackers only)
Geolocation ability will be provided by a licensed ip2location .BIN file to run all IP addresses against. ip2location provides php code to easily do such a lookup.
The code should be clean (good indentation, variable naming, etc) and at least somewhat commented. I don't want you to waste your time with extensive comments but at least a few comments should be present for the complicated parts of the code.
Please let me know if you have any questions.
Categories:
(Note: Like everything else on this page, these categories are part of the original contract for this bid request.)
Web, Database, Language Specific, PHP, MySQL, Software Related (Includes Websites)
Additional Files:
Excellent
Messages summary
Post first reply
Chat log
Status reports
Escrow Log
Work acceptance
Assembla Tools
Mediation / Arbitration
Contact info / receipts
Bid request phase log
Ratings
Brief Summary:
