Referrer Click-through MOD for Prosper202

Posted by on Jun 10, 2009 | 9 Comments

Through Richard’s blog I stumbled upon on MOD for keywords and landing pages click-through for Prosper202.

That was part that was absolutely missing in that open source affiliate tracking software. Since Jasper made such a great contribution to open source community I wanted to also help because Prosper202 is software I use.

So here you can download MOD for Prosper202 which will show you referrers CTR.

NOTE: To install this MOD first you need to have installed
Prosper202 Mod: LP Clickthrough for Text Ads/Keywords!

Installation

1. Run this SQL query:

CREATE TABLE IF NOT EXISTS `202_sort_referers_lpctr` (
  `sort_referer_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) UNSIGNED NOT NULL,
  `referer_id` BIGINT(20) UNSIGNED NOT NULL,
  `sort_referer_clicks` mediumint(8) UNSIGNED NOT NULL,
  `sort_referer_click_throughs` mediumint(8) UNSIGNED NOT NULL,
  `sort_referer_ctr` DECIMAL(10,2) NOT NULL,
  `sort_referer_leads` mediumint(8) UNSIGNED NOT NULL,
  `sort_referer_su_ratio` DECIMAL(10,2) NOT NULL,
  `sort_referer_payout` DECIMAL(6,2) NOT NULL,
  `sort_referer_epc` DECIMAL(10,2) NOT NULL,
  `sort_referer_avg_cpc` DECIMAL(7,5) NOT NULL,
  `sort_referer_income` DECIMAL(10,2) NOT NULL,
  `sort_referer_cost` DECIMAL(13,5) NOT NULL,
  `sort_referer_net` DECIMAL(13,5) NOT NULL,
  `sort_referer_roi` DECIMAL(10,2) NOT NULL,
  PRIMARY KEY  (`sort_referer_id`),
  KEY `user_id` (`user_id`),
  KEY `keyword_id` (`referer_id`),
  KEY `sort_keyword_clicks` (`sort_referer_clicks`),
  KEY `sort_keyword_leads` (`sort_referer_leads`),
  KEY `sort_keyword_signup_ratio` (`sort_referer_su_ratio`),
  KEY `sort_keyword_payout` (`sort_referer_payout`),
  KEY `sort_keyword_epc` (`sort_referer_epc`),
  KEY `sort_keyword_cpc` (`sort_referer_avg_cpc`),
  KEY `sort_keyword_income` (`sort_referer_income`),
  KEY `sort_keyword_cost` (`sort_referer_cost`),
  KEY `sort_keyword_net` (`sort_referer_net`),
  KEY `sort_keyword_roi` (`sort_referer_roi`)
) ENGINE=MyISAM;

2. Make a backup of top.php in the tracking202/_config folder
3. Copy all files to places where they belong (all from tracking202 folder from this mod to tracking202 folder on server)

Preview

Enjoy!