Nerdy Affiliate Adventures In Affiliate Marketing Land

Sponsored Ads

Random Images

P4260177.JPG P4230105.JPG IMG_8993.JPG

RSS Subscribe


TwitterCounter for @JasperP

Subscribe via Email:

Top 10 Popular Posts

  • Prosper202 Mod: LP Clickthrough for Text Ads/Keywords
  • ASW 2009 Recap
  • My Experience on "The Price is Right"
  • FREE 15.4" Macbook Pro from CashTactics.net
  • I am NOW a SUPER AFFILIATE!
  • LP CTR Mod for Prosper 1.3.2
  • It's Been A Month.. What's Going On?
  • Tutorial: Keyword Grouping With KeywordPad (Freeware)
  • I'm Elite with Elite Clicks Media
  • Pitchmen - Lessons in Direct Response Marketing
  • Top Commentators

    Recent Posts

    Latest Twitter Posts

    My Twitter

    Tag Cloud

    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”.

    p202_1.gif

    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:
    p202_3.gif

    Text Ads:
    p202_2.gif

    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 ;

    Share and Enjoy:
    • Digg
    • Sphinn
    • del.icio.us
    • Facebook
    • Mixx
    • Google Bookmarks
    • BlinkList
    • blogmarks
    • BlogMemes
    • Blogosphere News
    • Blue Dot
    • De.lirio.us
    • email
    • Furl
    • Propeller
    • Simpy
    • SphereIt
    • Spurl
    • StumbleUpon
    • Technorati
    • TwitThis

    Related Posts

    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 =)

     
    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.

     
    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.

     
    Comment by Logan
    2009-05-07 08:30:08

    Sweet mod! That is awesome. Nice job Jasper.

     
    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! :D

     
    Comment by JasperP
    2009-05-07 11:18:27

    Thanks for the feedback!

     
    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

     
    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

     
    Comment by Indo Contest
    2009-05-07 21:43:56

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

     
    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

     
    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

     
    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

     
    Comment by huge
    2009-05-11 17:33:19

    awesome mod thanks!

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

     
    Comment by Jake
    2009-05-11 19:57:16

    Thanks Nerdy!

    Jake

     
    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).

     
    Comment by MarcusFunbox Subscribed to comments via email
    2009-05-11 22:10:02

    Thanks Jasper! Thats a cool mod :)

     
    Comment by Scott Subscribed to comments via email
    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.

    Comment by JasperP
    2009-05-12 10:01:36

    that’s a good question.

    I’ll look into it.

     
     
    Comment by Feri Subscribed to comments via email
    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.

    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.

     
     
    Comment by Feri Subscribed to comments via email
    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!

    Comment by JasperP
    2009-05-12 13:23:24

    nice work.

     
     
    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

     
    Comment by opinijus Subscribed to comments via email
    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?

     
    Comment by opinijus Subscribed to comments via email
    2009-05-14 02:31:25

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

     
    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.

     
    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

     
    Comment by matt
    2009-05-28 15:48:10

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

     
    Comment by B-Scan Subscribed to comments via email
    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

     
    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?

     
    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

     
    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 My ComLuv Profile

     
    Comment by Ilya Ripa Subscribed to comments via email
    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? :)

     
    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) My ComLuv Profile

     
    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.
    CommentLuv Enabled

    Trackback responses to this post