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;


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 ;

Project Yahoo: YSM -> CPA Networks

Posted by JasperP on July 22nd, 2008

I just started working on a new project which involves working with Yahoo Search Marketing and CPA Offers.  I’m not going to state what niches I’m working on, but I’m going to share some of my experiences with it to see if I can make a profit from it.

I’m sharing this info with the guys in the ClickConsultants Forum.  So if you want more information on this project, you can follow along with me in more detail in the forum.  I haven’t made a profit with this project yet, so I’ll keep updating this blog and in the forums in the meantime.

Here are the project guidelines:

• Pick 2 Offers from the CPA Networks.  The network I’m working with is AzoogleAds and maybe NeverBlueAds.
• Generate a huge list of keywords: (at least 10k+ keywords)
• Group keywords with a common keywords 1-3 words long.  For example, if my keywords were “blue dog collars”, “red dog collars”, “black dog collars”.  Then my common keyword is “dog collars”
• Write at least 2 ads per ad group.  Use the common keyword for each ad group name and try to use it in the text ads.
• Upload to Yahoo Search Marketing and optimize campaign everyday.
• Write down impressions, clicks, CTR, # of Leads on daily performance.

Niche #1 Updates:

• 15,257 Keywords
• 36 Ad Groups
• 14 Ads per Ad Group
• CPC: 0.15 (now 0.25 after today)
• Daily Budget: $5.00

Niche #1 just became live today. I uploaded it on Saturday, July 19 and it barely just got approved today.  I guess they don’t approve anything on the weekends.

More updates soon!