Discussion Board

User Tools

Site Tools

Trace: • order_id_format_changed • facebook_application • schemas_setup • rendering_analysis • flash_interactions • core_modifications
merkalt:simple_ads_tracking_system

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
merkalt:simple_ads_tracking_system [2010/08/31 08:51] – dmitriymerkalt:simple_ads_tracking_system [2011/10/28 07:25] (current) – dmitriy
Line 5: Line 5:
  
 Should work like this: Should work like this:
-Ad X will link to merkalt with for example URL  + Each time it is a conversion from the X ad an  
-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.  
-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 +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. ads performance for today, yesterday, this week, this month, last month.
 // //
  
-**TASK DESCRIPTION**+Affiliate sales tracking build on extraction of affiliate identifier from affiliate referrer link and saving it in session variables. The process includes several parts which are the following:
  
-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.+1. Link on affiliate’s website, which contains ad's identifier.
  
-//**The entire development process will take place at the test site, test version of system should be placed in merkalt.com/test/adstracker/ folder.**//+Ad X will link to merkalt with for example URL  
 +http://www.merkalt.no/side.php?ad_id=[ad_id] (ad_id = identifier of ad in the db - eg. 5)
  
-Ads tracking will work only for root instance of merkalt.no site.+Ads tracking works 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 ID extraction from requested page name. 
 +Obviously, there is no such page http://www.merkalt.no/side.php?ad_id=[ad_id] on merchant server. The request will be redirected on another existing page (for instance, index.php), initially requested page name will be parsed and affiliate ID and ad ID  will be added as a parameter to index.php request. This will be done with a help of adding mod_rewrite module instructions in .htaccess file on merchant server (mod_rewrite module should be allowed on merchant server). These instructions are:
  
-2. Affiliate accounts list should contain only one affiliate record with ID = 1. Functionality of affiliate accounts management page should be kept as is.+<code> 
 +RewriteEngine On 
 +RewriteBase / 
 +RewriteCond %{REQUEST_FILENAME} !-f 
 +RewriteCond %{REQUEST_FILENAME} !-d 
 +RewriteRule side\.php index.php?%{QUERY_STRING}&affiliate_id=1 [L] 
 +</code>
  
-3. Ads management page must be created by analogy with the list of affiliate accounts. It must include: +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.
-\\ 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.  +3. Completed sales tracking. 
-\\ 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; +If customer purchases some product on merchant’s web site, on payment completion, affiliate ID and order data will be sent on tracking script for transaction registration. Order data includes unique order ID and order total sum. 
-\\ b) listing table must include only 'Ad ID', 'Ad description' and 'Number of sales' columns;  +Tracking code (which sends needed data on tracking script) should be placed on “thank you” page that appears to customer when order is made completely. Tracking code is a JavaScript which could be placed in page header:
-\\ 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: +Here: affiliate_id – affiliate ID from customer session variables, order_id – order unique identifier, order_total – order total sum, analitics_url – URL of the script which performs transaction registration.
  
-http://www.merkalt.no/adtrack.php?=1+File ad_track.js should be placed on merchant server and should be accessible from “thank you” page.
  
-the using of mod_rewrite required. Such request should be redirected on http://www.merkalt.no/index.php page. +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:
- +
-//**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; \\ a) creation of template for this system;
 \\ b) creation of affiliate class for this system (in affiliation/ folder); \\ 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); \\ 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. +**Administrator section of tracking system** 
-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.+ 
 +1. Main menu in admin section include only two options: sales report and affiliate accounts 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 - ads list with 20 ads will be pre-defined in database with default description being Ad 1, ... , Ad X  
 + 
 +4. Sales report - 
 +\\ a) 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 include only 'Ad ID', 'Ad description' and 'Number of sales' columns;  
 +\\ c) sales report 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; 
 +\\ e) total number of sales in the bottom of ads list; 
 +\\ f) pagination links set; 
 +\\ g) ad search function - by ID and description; 
 +
merkalt/simple_ads_tracking_system.1283244708.txt.gz · Last modified: (external edit)