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!

Uff… after being few years in web development I decide to open web developer’s blog. This is not my first blog - but it’s first personal/professional on English. I also have SEO blog on Croatian which is abandoned a bit. B-Scan.net blog it’s my presentation to the IT world.

One of the issues here I know it can be a little problem it’s my “good” knowledge of English. Well, maybe everything will not be so clear spoken or better to say written in sense of natural language - but I hope so it will be written in programming language.

If you like to know a bit more about me you can go to About section of this site.

This post it’s also reminder to myself that I know release date of this blog.

I hope so that you will find some useful posts/code/ideas here and meet some cool IT people in the blogosphere.