Nerdy Affiliate Adventures In Affiliate Marketing Land

LP CTR Mod for Prosper 1.3.2

Posted by JasperP on August 5th, 2009

It has to come to my attention that the LP CTR mod doesn’t work with the new prosper202 1.3.2.  I’m still trying to understand what changed in the code.

Hopefully, I can get it fixed before ASE.

Stay tuned…

***EDIT (8/5/09): Found out what the problem was.  It was pointing to the wrong location of the script.  

I corrected the relative path in keywords_lpctr.php, referers_lpctr.php, and text_ads_lpctr.php.  (Added ‘/tracking202/ajax/’ to loadContent() function)

***EDIT (8/6/09): “Referrers LP CTR” might not be working for some people.  I made another change in referers_lpctr.php.

***EDIT (8/7/09): Found an error in the “OVERVIEW” tab.  The day-parting, week-parting was not visible because it was using the older Prosper 1.2 version.  Fixed it again.

Sorry for all the updates.  I guess I was in a rush to fix the problem without thoroughly testing it.  I would suggest anyone to wait a week or two to see if any more bugs show up.  Thanks.

***EDIT (8/17/09): Thanks to Daniel Brady, another error was  found in the script.  I’ve corrected and tested it for a couple days and so far so good.  I’ve updated the new download.

***EDIT (8/18/09): Thanks to Tony Tsai, he found another error when clicking on the columns to sort the clicks, clickthroughs, etc.  It’s pretty much the same error as before, which required me to make sure the entire path to the php files are referenced.  Basically, the path “/tracking202/ajax/” needs to be inserted in every instance that I refer to the sort_.php files. 

Download it here: LPCTRModV3.zip for Prosper202 1.3.2

Prosper202 Modification: Redirect to any Tab

Posted by JasperP on July 16th, 2009

Here’s a small mod that I’ve been using for my Prosper202 installations.  This is a pretty simple one. The basic idea is that the mod redirects to any tab you want in tracking202.

Originally, when you logged in, you have to type in your username and password, THEN you have to click on the “tracking202″ link and THEN click on the tab (overview, analyze, visitor, etc) and THEN click on the sub-category of that tab (keywords, referer, etc)

This mod allows you to login and automatically redirect (meta refresh) to the stats that you want.

It’s a fairly easy installation, you basically configure template.php, backup the original one, and then copy it over.

Here’s the readme.txt:

Installation Instructions.
1. Configure template.php *SEE CONFIGURATION INSTRUCTIONS BELOW*
2. rename /202-config/template.php to /202-config/template.php.bak
3. Copy /202-config/template.php to /202-config folder.

Configuration Instructions
1. Open template.php in a text editor.
2. Change the $refreshtime to redirect after X seconds.  Default is set to 2 second.
Example: $refreshtime = 5; // Redirect to the page after 5 seconds.
3. Change $tab_page to the page you want it to redirect to:
Example: $tab_page = "3c"; // Goes to "Text Ads" page

1-"Setup" page

2a-"Overview >> Campaign Overview" page
2b-"Overview >> Daily Overview" page
2c-"Overview >> Hourly Overview" page

3a-"Analyze >> Keywords" page
3b-"Analyze >> Text Ads" page
3c-"Analyze >> Referers" page
3d-"Analyze >> IPs" page
3e-"Analyze >> Landing Pages" page
3f-"Analyze >> Keywords LP CTR" page
3g-"Analyze >> Text Ads LP CTR" page

4-"Visitors" page
5-Spy page
6-Update page

Also, if you ever wanted to access that page, just hit the ESCAPE key to prevent the redirect from forwarding you to the OVERVIEW page.

Here’s a sample of the mod code from template.php:

if (($navigation[1] == '202-account') and (($navigation[2] != 'account.php') and ($navigation[2] != 'administration.php')) ) {

// Set $refreshtime to the # of seconds to wait until redirecting
//
// Set $tab_page to the page to be redirected to: (Default is 2-Overview page)
//   1-"Setup" page
//
//   2a-"Overview >> Campaign Overview" page
//   2b-"Overview >> Daily Overview" page
//   2c-"Overview >> Hourly Overview" page
//
//   3a-"Analyze >> Keywords" page
//   3b-"Analyze >> Text Ads" page
//   3c-"Analyze >> Referers" page
//   3d-"Analyze >> IPs" page
//   3e-"Analyze >> Landing Pages" page
//   *3f-"Analyze >> Keywords LP CTR" page
//   *3g-"Analyze >> Text Ads LP CTR" page
//
//   4-"Visitors" page
//   5-"Spy" page
//   6-"Update" page
//
// *NOTE: 3f, 3g are used if you installed the LP CTR script.

$refreshtime = "2";
$tab_page = "2a";

switch ($tab_page) {
    case "1":
        $tab_page_url = "/tracking202/setup";
        break;
    case "2a":
        $tab_page_url = "/tracking202/overview";
        break;
    case "2b":
        $tab_page_url = "/tracking202/overview/daily.php";
        break;
    case "2c":
        $tab_page_url = "/tracking202/overview/hourly.php";
        break;
    case "3a":
        $tab_page_url = "/tracking202/analyze/keywords.php";
        break;
    case "3b":
        $tab_page_url = "/tracking202/analyze/text_ads.php";
        break;
    case "3c":
        $tab_page_url = "/tracking202/analyze/referers.php";
        break;
    case "3d":
        $tab_page_url = "/tracking202/analyze/ips.php";
        break;
    case "3e":
        $tab_page_url = "/tracking202/analyze/landing_pages.php";
        break;
    case "3f":
        $tab_page_url = "/tracking202/analyze/keywords_lpctr.php";
        break;
    case "3g":
        $tab_page_url = "/tracking202/analyze/text_ads_lpctr.php";
        break;
    case "4":
        $tab_page_url = "/tracking202/visitors";
        break;
    case "5":
        $tab_page_url = "/tracking202/spy";
        break;
    case "6":
        $tab_page_url = "/tracking202/update";
        break;
    default:
    	$tab_page_url = "/tracking202/";
}

You can download the mod here: p202redirectV3.zip

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;


Calculating CPM vs CPC (Great for Facebook CPM ads!)

Posted by JasperP on May 27th, 2009

On facebook, you have the option of choosing CPC or CPM for your ads and you should always test your text ads with CPC first.  But when do you turn them into CPM ads?

To answer this question, you need to collect some data from your ads and determine the maximum CPM you can pay based on the clickthrough rates and CPC for your ads.

maximum CPM = CPC * CTR * 1000

For example, if you are paying 0.30 CPC and getting a CTR of 0.25% then your maximum CPM that you should pay should be:

maximum CPM = $0.30 * 0.0025 * 1000 = $0.75

Now, I like to think in terms of CPC, so I can change the CPMs to see the different CPC costs I would be paying.  The magic formula for that is:

CPC = [ CPM / (CTR * 1000) ]

Using the same example as above with the 0.25% CTR,  I can plug in different CPM of $0.70, $0.50, $0.30 to see the different CPC costs:

CPC = [ 0.70 / (0.0025 * 1000) ] = $0.28
CPC = [ 0.50 / (0.0025 * 1000) ] = $0.20
CPC = [ 0.30 / (0.0025 * 1000) ] = $0.12
CPC = [ 0.20 / (0.0025 * 1000) ] = $0.08
CPC = [ 0.10 / (0.0025 * 1000) ] = $0.04

So you can see the potential of using CPM to lower your costs.  By writing compelling ad copy and images that grab attention, you can lower your CPC costs dramatically.

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 ;

« Previous Entries