This is an old revision of the document!
SIMPLE TRACKING SYSTEM
// Tracking performance of ads.
Should work like this: Ad X will link to merkalt with for example URL http://www.merkalt.no/adtrack.php?=1 (adtrack should be a norwegian common word instead.) Each time it is a conversion from the X ad an counter should increase by one. The date and time for the sale should also be saved. In admin it should be a simple overview of each of the ads performance for today, yesterday, this week, this month, last month. //
TASK DESCRIPTION
This addon will be realized on the basis of daycare centers affiliate system. Addon will be installed into merkalt.no/adstracker/ or something like this.
The entire development process will take place at the test site, test version of system should be placed in merkalt.com/test/adstracker/ folder.
Ads tracking will work only for root instance of merkalt.no site.
Required changes and additions for Administrator section of tracking system
1. Main menu in admin section should include only three options: sales report, affiliate accounts list and ads list. Sales report should be set as default page.
2. Affiliate accounts list should contain only one affiliate record with ID = 1. Functionality of affiliate accounts management page should be kept as is.
3. Ads management page must be created by analogy with the list of affiliate accounts. It must include:
a) list of existing ads which could be sorted by ad ID, ad description and ad status;
b) list management functions - add new ad, edit, delete, deactivate / activate links for existing ads;
c) mass operations functionality - check box for each ad row, 'select all' check box in the list table header, mass delete and mass toggle status buttons at the bottom of ads list;
d) pagination links set.
e) simple form page for adding / editing ad information: ad description and ad status. Ad ID should be displayed on this form but should not be editable;
f) delete operation and each mass operation should require user confirmation;
g) search function (by ad ID or ad description) should be implemented too;
4. Sales report should be created on the basis of Commission report.
a) first of all, selector of the reporting period should be implemented for this report. It could be realized like a group of select controls + 'Apply' button. First three select controls allows to select day, month and year for the start date of report. Next three controls allows to select day, month and year for the end date of report. Selected options should be saved in cookies on 'Apply' button click and should be restored on the next page visit as default. If no selection has been made yet, current date should be set as default selection for both of dates;
b) listing table must include only 'Ad ID', 'Ad description' and 'Number of sales' columns;
c) sales report must contain a list of ads which have recorded sales for the selected reporting period. The number of sales for each ad should be shown in 'Number of sales' column;
\\** d) 'View details' link in each row should lead to page with individual detailed list of sales for each ad for the selected reporting period. In other words, all sales which was counted for current ad for the selected reporting period should be shown on this separate page in details; NOT SURE IF THIS WILL BE NEEDED**
e) total number of sales in the bottom of ads list;
f) pagination links set;
g) ad search function - by ID and description;
Required additions for the front-end scripts
1. Affiliate and ad IDs registration. Since tracking link should have the following presentation:
http://www.merkalt.no/adtrack.php?=1
the using of mod_rewrite required. Such request should be redirected on http://www.merkalt.no/index.php page.
As far as I remember, there was a problem with mode_rewrite on merkalt server. This means such a link really would not be used.
Anyway, the link will contain two parameters: affiliate ID and ad ID. Both of these parameters should be saved in user session on index page.
2. Tracking code for this tracking system will be built-in as a part of existing schema of plugging of affiliate systems on merkalt.no (like as euroads, affiliate pro, etc.). This task will include:
a) creation of template for this system;
b) creation of affiliate class for this system (in affiliation/ folder);
c) creation and setting up of section in settings.inc.php file (root instance only);
Required changes in transaction registration scripts
The set of data to be passed to transaction registration script should be expanded - ad ID should be added to transaction data. This means the structure of transactions table should be changed. Scripts reg_trn.php (in scripts/ folder) and dc_processor.class.php (in libs/ folder) should be re-worked too.