Archive for June, 2009

»Referrer Click-through MOD for Prosper202

Wednesday, June 10th, 2009

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!

Tags: , , , ,
Posted in PHP | 9 Comments »