web analytics
'; winimg.document.writeln(doc); winimg.document.close(); } //]]>

Nerdy Affiliate Adventures In Affiliate Marketing Land

RSS Subscribe


TwitterCounter for @JasperP

Subscribe via Email:

Top 10 Popular Posts

  • Prosper202 Mod: LP Clickthrough for Text Ads/Keywords
  • My Experience on “The Price is Right”
  • ASW 2009 Recap
  • LP CTR Mod for Prosper 1.3.2
  • Prosper202 Mod: LP Clickthrough Version 2
  • FREE 15.4″ Macbook Pro from CashTactics.net
  • I am NOW a SUPER AFFILIATE!
  • EXCLUSIVE: Ryan Eagle Revealed – The Man behind the Money
  • Calculating CPM vs CPC (Great for Facebook CPM ads!)
  • I’m Elite with Elite Clicks Media
  • Top Commentators

    Recent Posts

    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 ;


    Fatal error: Call to undefined function wp_related_posts() in /home2/nfmtech/public_html/nerdyaffiliate.com/wp-content/themes/bwdec2007-10/articles.php on line 21