Nerdy Affiliate Adventures In Affiliate Marketing Land

Prosper202 Mod: LP Clickthrough for Text Ads/Keywords

Posted by JasperP on May 7th, 2009

**[EDIT: 7/6/09] Here’s an update to the code: Prosper202 LP CTR Version 2 **

Since Prosper202 went open-source, I decided to poke around in the source code.  One feature that I wanted was to be able to know which keywords and text ads clicked through from the landing page to the merchant’s offer.  Before that, I was using Google Analytics and looking at the bounce rate to determine the effectiveness of a keyword.

Now that Prosper202 is open-source, I created my own modifications for it.  If you notice at the top, I added links for “Keywords LP CTR” and “Text Ad LP CTR”.

The next thing I did was I added two columns, one for the number of clickthroughs and one for the clickthrough percentage of clicks into the LP and clicks out to the offer.

Keywords:

Text Ads:

Here’s the download for it.  Take a look at the source code, I put a bunch of comments so that anyone can understand the changes that I did.

Keyword-Text Ads LP CTR Mod

Here are the instructions from the included 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)
6.) Make sure to add the tables below using the SQL tab in PHPMYADMIN in your webhost.

// Create Table: 202_sort_keywords_lpctr

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: 202_sort_text_ads_lpctr

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 ;

Related Posts

• Prosper202 Mod: LP Clickthrough Version 2
• LP CTR Mod for Prosper 1.3.2
• Project Yahoo: YSM -> CPA Networks
• Prosper202 Modification: Redirect to any Tab
• Project Yahoo: Campaign Progress And Dating Niche Launch

RSS feed | Trackback URI

39 Comments »

Comment by Steve Howe

2009-05-07 06:19:54

Nice Post Jasper! Thanks for sharing your modification to 202! I am definitely going to point this little GEM out to some affiliates =)

Reply to this comment

 

Comment by Ian Fernando

2009-05-07 07:54:41

damn this is a nice mod – I thought my p202 had some good mods to it already.

Reply to this comment

 

Comment by Affbuzz

2009-05-07 08:23:11

Very sweet, looks like I now have another item to add to my to-do list today.

Reply to this comment

 

Comment by Logan

2009-05-07 08:30:08

Sweet mod! That is awesome. Nice job Jasper.

Reply to this comment

 

Comment by Tim

2009-05-07 11:17:03

This is awesome, thanks so much for releasing this Jasper. Great comments in the code as well, very helpful!

Reply to this comment

 

Comment by JasperP

2009-05-07 11:18:27

Thanks for the feedback!

Reply to this comment

 

Comment by Anxiolytic

2009-05-07 14:45:14

I recently began adding LP CTR to 202 as well. Nice to see others modifying this app. You have it hosted anywhere? If not, why not add your modifications to the unofficial public repo? I put it up on github ..

http://github.com/lsd/prosper202/tree/master

Reply to this comment

 

Comment by James Seligman

2009-05-07 16:54:47

Very nice mod Jasper! I am going to add it to my P202 tonight. Thanks for sharing it.

James Seligman’s last blog post..My Own Weight Loss Challenge to Myself

Reply to this comment

 

Comment by Indo Contest

2009-05-07 21:43:56

I’m gonna try this for my P202!!.
Thanks a lot Nerdy…

Reply to this comment

 

Comment by zalds

2009-05-08 22:35:16

nice one.

I used to plot this data to excel manually now I can let the 202 gather it automatically – really a sweet mod

Thank you for sharing kabayan.

zalds’s last blog post..The Google Ad Auction

Reply to this comment

 

Comment by Daehee

2009-05-09 07:34:22

Awesome, install was a breeze. Thanks!

Daehee’s last blog post..Former Kairos Society Officer Arrested for Ponzi Scheme

Reply to this comment

 

Comment by ImagesAndWords

2009-05-10 10:51:35

This will definitely come in handy, thanks.

ImagesAndWords’s last blog post..How To Split-Test Landing Pages with Tracking202

Reply to this comment

 

Comment by huge

2009-05-11 17:33:19

awesome mod thanks!

huge’s last blog post..top secret formula for easy money huhu

Reply to this comment

 

Comment by Jake

2009-05-11 19:57:16

Thanks Nerdy!

Jake

Reply to this comment

 

Comment by Lars

2009-05-11 22:01:29

Thanks very much! JUST what I’ve been wanting but had no idea how to code.

2 minute install (and this from someone downright dangerous in phpmyadmin).

Reply to this comment

 

Comment by MarcusFunbox

2009-05-11 22:10:02

Thanks Jasper! Thats a cool mod

Reply to this comment

 

Comment by Scott

2009-05-12 07:44:44

Jasper .. Thank You!! I was actually about to do this manually … You are awesome!

I have a request .. I saw that you are doing a Yahoo test.

What about CTR by referer?

Since you can’t target just yahoo.com, I think knowing this would really help your ROI.

In one niche I’m in I get 70% of my conversions from Yahoo.com, but less than half of my actual clicks.

Reply to this comment

Comment by JasperP

2009-05-12 10:01:36

that’s a good question.

I’ll look into it.

Reply to this comment

 

 

Comment by Feri

2009-05-12 13:12:08

Hi,
I upgraded according to the readme file, and I get this error:

Parse error: syntax error, unexpected ‘}’ in XXXXXX/tracking202/_config/top.php on line 70

When I look into the sourcecode this is on line 70:

I am not a php guru, any advice?
thanks.

Reply to this comment

Comment by JasperP

2009-05-12 13:17:00

That’s strange. top.php only adds the 2 links “Keyword LP CTR” and “Text Ads LP CTR” to the Analyze tab.

I’m looking at line 70 and I’m not seeing anything significant. If it doesn’t work, just put the top.php back.

Take a screenshot if you can.

Reply to this comment

 

 

Comment by Feri

2009-05-12 13:20:55

Problem solved. Didn’t work when I simply overwrote the top.php and index.php files. When I deleted the files (after backup), then simply COPIED the new ones, worked fine… Try this way!

and thanks for the mod!

Reply to this comment

Comment by JasperP

2009-05-12 13:23:24

nice work.

Reply to this comment

 

 

Comment by Wes (MasterlessSamurai.com)

2009-05-13 23:33:49

Sweet update man! I’m using Pro now mostly, but for a few non search campaigns, I still need Prosper. This will definitely help me continue to optimize my landing pages.

Thanks for helping the 202 community!

Wes (MasterlessSamurai.com)’s last blog post..Speed202: How to Integrate Tracking202 & SpeedPPC

Reply to this comment

 

Comment by opinijus

2009-05-14 02:22:21

Hey,

Thanks for the MOD.

There is an error when creating tables: “There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: //
SQL: // Create Table: 202_sort_keywords_lpctr”

I go to SQL query window in the PHPMYADMIN. paste code from .txt and click go. This is the proper way to install tables?

Reply to this comment

 

Comment by opinijus

2009-05-14 02:31:25

Oops, i copied the code with “//”. Everything is fine now. Thanks man for awesome tool again!

Reply to this comment

 

Comment by AmYourPusher

2009-05-14 18:56:34

Excellent! Took about 5 mins to setup. Thanks for the Mod and the very detailed setup instructions.

Reply to this comment

 

Comment by Shock Marketer

2009-05-27 09:20:42

Thanks a ton! Early metrics like this help save cash.

Shock Marketer’s last blog post..Google’s New Search Referral String

Reply to this comment

 

Comment by matt

2009-05-28 15:48:10

thanks for posting this, was surprised when google actually gave a useful link

Reply to this comment

 

Comment by B-Scan

2009-06-10 07:49:25

Hi Jasper.
Thank you very much for such a great contribution!

In order to help you I made Referrers CTR MOD for Prosper202.
Feel free to use it: http://www.b-scan.net/blog/95-referer-click-through-mod-for-prosper202/

B-Scan’s last blog post..Referer Click-through MOD for Prosper202

Reply to this comment

 

Comment by Chris

2009-06-11 16:49:28

Saw this post recommended by Andrew over at CashTactics. Awesome mod and something that I was really wishing Prosper202 could do before. I’m installing it right now.

Chris’s last blog post..PPC Bully 2 Review – Does It Live Up To The Hype?

Reply to this comment

 

Comment by Angila Assembly

2009-06-25 10:01:49

This script looks awesome. I’m sure it help to minimize CPC and also helps to track down the profitable keywords and save $$$’s. I’m downloading right now to test.

Angila

Reply to this comment

 

Comment by Chris

2009-06-29 07:12:22

Nice hack. Thank you. Had no problems getting it installed at all. Now just waiting for more data to come in.
Chris´s last blog ..SpeedPPC – It does not end after your Purchase

Reply to this comment

 

Comment by Ilya Ripa

2009-09-23 09:31:46

Awesome mod. One thing though, Can’t export the data to excel when in Keywords LP CTR mode. Can someone look into that?

Reply to this comment

 

Comment by Buy Text Link Ads

2009-10-16 06:49:48

Does the ‘leads’ indicate conversion ratio? Does this software track conversion ratio?

Thanks.
Buy Text Link Ads´s last blog ..Angela’s Links Don’t Work (and neither do link wheels)

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

Trackback responses to this post

• links for 2009-05-20 « On New Media
• Referer Click-through MOD for Prosper202 | B-Scan.net
• Apply this Free PPC Tip Immediately
• Maverick money makers
• DIGITAL INFRARED PHOTOGRAPHY