Nerdy Affiliate Adventures In Affiliate Marketing Land

Prosper202 Mod: LP Clickthrough Version 2

Posted by JasperP on June 15th, 2009

***EDIT (8/23/10) – New Version for Prosper 1.5-1.6 here:
http://nerdyaffiliate.com/pay-per-click-marketing/prosper202-lp-ctr-mod-for-1-5-x-1-6-x

After releasing my modification of Prosper202 with LP clickthrough for Keywords and Text ads, I’ve had a couple of requests to do the referers as well.  It’s been on my to-do list for awhile, but lucky for you guys, someone already did it for me!

B-Scan.net recently released the modification for the LP CTR for referers.  This can be useful for content network and display ads to help determine what sites respond well to your landing pages.  So a BIG THANKS goes out to Tomislav from b-scan.net for modifying that for the affiliate marketing community.

Check out B-scan.net’s modification: LP CTR for referer Mod

***NOTE: IF YOU HAVE PROSPER202 1.3.2, DOWNLOAD THE UPDATE MOD AT: LP CTR Mod for Prosper 1.3.2

For your convenience, I combined the Keywords, Text Ads, and Referer Modification in 1 download.  You can just overwrite the “tracking202/_config”, “tracking202/ajax” and “tracking202/analyze” files.

Download the new version with referers added: kws-txtads-ref LP CTR

Here’s what the top menu should look like now:

Referer LP CTR:

Here are the instructions from the readme.txt file:

1.) Make a backup of top.php in the tracking202/_config folder
2.) Copy top.php to the tracking202/_config folder
3.) Make a backup of index.php in the tracking202/analyze folder
4.) Copy index.php to the tracking202/analyze folder
5.) Copy contents of tracking202/ajax and tracking202/analyze to the corresponding folders (no backups are required since it doesn't overwrite anything)
a.) You can just overwrite the existing files in the _config, ajax, and analyze folders.
6.) Make sure to add the tables below using the SQL tab in PHPMYADMIN in your webhost.

CREATE TABLE IF NOT EXISTS `202_sort_keywords_lpctr` (
`sort_keyword_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`keyword_id` bigint(20) unsigned NOT NULL,
`sort_keyword_clicks` mediumint(8) unsigned NOT NULL,
`sort_keyword_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_keyword_ctr` decimal(10,2) NOT NULL,
`sort_keyword_leads` mediumint(8) unsigned NOT NULL,
`sort_keyword_su_ratio` decimal(10,2) NOT NULL,
`sort_keyword_payout` decimal(6,2) NOT NULL,
`sort_keyword_epc` decimal(10,2) NOT NULL,
`sort_keyword_avg_cpc` decimal(7,5) NOT NULL,
`sort_keyword_income` decimal(10,2) NOT NULL,
`sort_keyword_cost` decimal(13,5) NOT NULL,
`sort_keyword_net` decimal(13,5) NOT NULL,
`sort_keyword_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_keyword_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`keyword_id`),
KEY `sort_keyword_clicks` (`sort_keyword_clicks`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `202_sort_text_ads_lpctr` (
`sort_text_ad_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`text_ad_id` mediumint(8) unsigned NOT NULL,
`sort_text_ad_clicks` mediumint(8) unsigned NOT NULL,
`sort_text_ad_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_text_ad_ctr` decimal(10,2) NOT NULL,
`sort_text_ad_leads` mediumint(8) unsigned NOT NULL,
`sort_text_ad_su_ratio` decimal(10,2) NOT NULL,
`sort_text_ad_payout` decimal(6,2) NOT NULL,
`sort_text_ad_epc` decimal(10,2) NOT NULL,
`sort_text_ad_avg_cpc` decimal(7,5) NOT NULL,
`sort_text_ad_income` decimal(10,2) NOT NULL,
`sort_text_ad_cost` decimal(13,5) NOT NULL,
`sort_text_ad_net` decimal(13,5) NOT NULL,
`sort_text_ad_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_text_ad_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`text_ad_id`),
KEY `sort_keyword_clicks` (`sort_text_ad_clicks`),
KEY `sort_keyword_leads` (`sort_text_ad_leads`),
KEY `sort_keyword_signup_ratio` (`sort_text_ad_su_ratio`),
KEY `sort_keyword_payout` (`sort_text_ad_payout`),
KEY `sort_keyword_epc` (`sort_text_ad_epc`),
KEY `sort_keyword_cpc` (`sort_text_ad_avg_cpc`),
KEY `sort_keyword_income` (`sort_text_ad_income`),
KEY `sort_keyword_cost` (`sort_text_ad_cost`),
KEY `sort_keyword_net` (`sort_text_ad_net`),
KEY `sort_keyword_roi` (`sort_text_ad_roi`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

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;


Be Sociable, Share!

• 

RSS feed | Trackback URI

16 Comments »

Comment by Clue List

2009-06-15 17:19:28

The .zip file is giving a 404, just thought ya should know..

Also, was wondering how difficult it would be to move the “LP CTR tabs” far right near the “landing pages” tab..

I haven’t used this or the prior yet, nor am I any good at coding.. I have a tidy syndrome.

Reply to this comment

Comment by Clue List

2009-06-15 17:20:34

Also forgot to add thanks to both you and B-scan.. Seems like a very valuable additive.

Reply to this comment

 

Comment by JasperP

2009-06-15 17:31:06

Whoops. Just changed the link… Should be good now.

It’s not hard to change the order…

1.) Open up “tracking202/_config/top.php”
2.) Go to line 44 and Cut and Paste the “Modification” section wherever you want.
3.) In your case, you should paste that after ‘landing_pages.php’

Reply to this comment

 

 

Comment by Jason (Prosper202 User)

2009-07-19 10:26:10

Jasper,

This is great stuff! I usually look at overall conversion rates of a keyword (or a referrer) to determine the effectiveness of a keyword, but this modification adds another dimension and allows you to see if you have targeted traffic but need to work on the conversion funnel.

I’ve created a set of tools to use with exported Visitor data from Prosper202. These tools help you refine your negative keyword list, create a dayparting schedule, and spot hot keyphrases and geo locales which convert really well. I’d love to get your feedback and see what you think about these. They can be found at: http://www.domainmethods.com/tools/t202

Thanks!

Reply to this comment

 

Comment by Ilya Ripa

2009-09-23 10:16:36

Great Mod. One thing though. Data cannot be exported to excel when in keyword lp ctr mode- as well as other two modes. Can someone look into that please?

Reply to this comment

 

Comment by Nigel

2009-09-28 06:03:43

Great mod. Tried to play around with my spare p202 on hostgator before moving it to my vps. (It didnt work for Hostgator). I jumped the gun and thankfully, it worked on my vps.

Thank you, Jasper.

Reply to this comment

 

Comment by Russ Jones

2010-07-07 09:10:23

I am getting this error with Prosper 1.5.1

/tracking202/analyze/sort_text_ads_lpctr.php

Reply to this comment

Comment by Russ Jones

2010-07-07 09:11:18

Not Found
The requested URL /tracking202/analyze/sort_text_ads_lpctr.php was not found on this server.

Reply to this comment

 

 

Comment by Neonlights

2010-07-25 18:02:34

Running 1.6 I get these errors:

The requested URL /tracking202/analyze/sort_keywords_lpctr.php was not found on this server.

The requested URL /tracking202/analyze/sort_text_ads_lpctr.php was not found on this server.

The requested URL /tracking202/analyze/sort_referers_lpctr.php was not found on this server.

Reply to this comment

 

Comment by Neonlights

2010-07-25 18:06:41

BTW these are great mods. I was so upset when I updated Prosper and realised they weren’t there.

Thanks so much

Reply to this comment

 

Comment by Sonny

2010-08-18 08:47:17

Does this work in 1.6beta?

Thanks!

Reply to this comment

Comment by JasperP

2010-08-18 13:46:49

I just updated the code. I’m testing it at the moment.

Reply to this comment

 

 

Comment by JasperP

2010-08-23 12:06:50

New LP CTR update at:
http://nerdyaffiliate.com/pay-per-click-marketing/prosper202-lp-ctr-mod-for-1-5-x-1-6-x

Reply to this comment

 

Comment by Josh

2010-08-26 10:40:59

Hey Jasper.. What a great mod.. Are you certain it works on 1.5.1?
.-= Josh´s last blog ..Become a Traveling Affiliate =-.

Reply to this comment

 

Click here to cancel "reply".

Name (required)

E-mail (required - never shown publicly)

URI

Subscribe to comments via email

Your Comment (smaller size | larger size)

You may use <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> in your comment.

Notify me of followup comments via e-mail

Notify me of new posts by email.

Trackback responses to this post

• How does affiliate marketing work?
• Prosper202 Mod: LP Clickthrough for Text Ads/Keywords | Nerdy Affiliate