Nerdy Affiliate Adventures In Affiliate Marketing Land

Sponsored Ads

Random Images

 
img_0177.jpg P4230112.JPG

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 LP CTR Mod Install Video

    Posted by JasperP on December 20th, 2010

    Haven’t posted in awhile, but I just stumbled upon this killer install video on my LP CTR Modification for Prosper202. (Prosper202 LP CTR Mod 1.6.1)

    It was done by Derek at ad-trackr.com: Killer Prosper202 LP CTR Mod

    Check out the video if you need help installing the mod.  Thanks Derek!

    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:

    p202ref1_1.jpg

    Referer LP CTR:

    p202ref2_1.jpg


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

    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 ;

    Tutorial: Keyword Grouping With KeywordPad (Freeware)

    Posted by JasperP on August 20th, 2008

    I’ve been using this excellent free keyword tool called KeywordPad.  You can basically do alot of cleaning, grouping, and modifying with this tool.  The best part is that it’s ABSOLUTELY FREE! You can download it here:

    http://www.goodkeywords.com/products/keywordpad/

    What I’m going to demonstrate is how I do keyword grouping with this tool.  The first thing I did was get a broad range of keywords from Wordze.  I basically just typed in the word ‘debt’ and it returned a list of 3,334 keywords. You can check out that list here:

    WZ_debt.txt

    Anyway, the first thing I do is “IMPORT” this list into KeywordPad.

    Then I “Delete …Duplicates” and “Clean… Unwanted Characters” and Clean… Trailing/Leading Chars”

    At this point, I need to know what keywords to group it by.  So first I “Modify… Sort…Ascending” to view the list.

    The next step is to start creating a “Base Keyword” list that I want to group my keywords by.  Since I’m using YSM to test my campaign, I can afford to have larger ad groups.  If I was using Google Adwords, I would limit my keyword groups to 100-200 keywords for each ad group.

    Here are the keyword groupings that I chose for this list:

    debt consolidation
    debt collection
    credit card debt
    debt relief
    credit card
    debt management
    debt free
    debt reduction
    out of debt
    bad debt

    In order to group, I use the “Highlight…Entries That Contain… Words Anywhere” function

    Then I either “Export… Highlighted Words To Another List…” Or “Export… Highlighted Words To A Text File…”

    I also have to “Delete… Only Highlighted Entries” to make sure the duplicate keywords don’t end up in other ad groups.

    What I end up with is these keyword groups:

    debt_consolidation.txt
    debt_collection.txt
    credit_card_debt.txt
    debt_relief.txt
    credit_card.txt
    debt_management.txt
    debt_free.txt
    debt_reduction.txt
    out_of_debt.txt
    bad_debt.txt

    RESOURCES

    If you want to learn more about keyword research and keyword grouping, I recommend the following links:

    Keyword Research : Go Deep or Going Wide First?

    Keyword Research Secrets to Explode Your Affiliate Business

    Uber Keyword Research

    Think Outside the Box : Actually Don’t Think At All

    Generating Pay Per Click Keywords

    So that’s it! I’ve found KeywordPad to help a lot especially when working with huge keyword lists over 10k.  It’s a tool that’s great for newbies especially, since you don’t have to spend a dime on some complicated and expensive keyword tool.

    Anyway, If you enjoyed this tutorial, go ahead and bookmark it or send me a comment with your thoughts!