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;


Tracking202 Pro Is Finally Available To The Public!

Posted by JasperP on March 25th, 2009

In case you didn’t know already, Tracking202 Pro is finally out of beta and released to the public.  This is the hottest tracking system for search marketers and if you know the reputation of Tracking202/Prosper202, then you should know that this is a quality tracking system.

What is Tracking202 Pro?

Tracking202 Pro is a fully automated tracking system that pulls in data from the 3 major search engines as well as CPA networks to reconcile the revenue and cost data.  This means you can see the profitability from each search engine, keyword, text ad, etc without having the manually log the data in yourself!

Sounds interesting, what are some of the features of Tracking202 Pro?

• Full Integration with Google Adwords, Yahoo! Search Marketing, and Microsoft AdCenter
• Full Integration with the Affiliate Networks
• Check out your stats from an iPhone or web-capable mobile phone
• The system updates all of destination URLs and pulls creatives automatically
• Content network and search network can be viewed separately
• Conversion tracking down to the keyword level
• Bidded Vs. Searched Keyword Analysis
• Real Time Spy View 

I have Tracking202 already, why should I get Tracking202 Pro?

T202Pro and T202 are completely different tracking systems.  This means that Pro is not an “UPGRADE” of the regular version but a different way of monitoring and optimizing campaigns.  

If you have been using Tracking202/Prosper202 for awhile, you know the pains of searching for converting keywords in your campaigns and determining the profitability of them.  This system completely automates the cost analysis of your ads and keywords without having to go and look for them.

How much does it cost?

Tracking202 Pro is very affordable for the affiliate marketers looking to take it to the next level.  Now if you haven’t made your first sale yet, then I would probably stay away from this platform.  The pricing is basically a fixed monthly fee based on the number of clicks plus API fees and a fixed $0.004 click charge.

Also, you get a 7-day Trial to check out some of the features of Tracking202 Pro.

Check out the pricing by visiting the Tracking202 Pro page: 

I’ve never heard of Tracking202, what kind of reputation do they have?

I’ve personally met Wes and Steven and I can say that these two guys are one of the most respected and well-trusted people in the affiliate marketing industry.  They’ve put out a free tracking system (Tracking202/Prosper202) that has revolutionized the way we build our campaigns.  The Tracking202 Pro system is another quality tracking system that will take affiliate marketing to the next level.

Here are some of the reputable businesses that are sponsoring Tracking202 Pro:

WebTraffic2Go offers the most responsive and compliant offers out there with competitive payouts. Our constantly growing network is a favorite for many reasons including strong personal affiliate relationships. We strive to do our best to maximize benefits to our affiliates including providing the best offers (even when we don’t have it, we’ll get it) and go as far as to create personalized, custom offer pages to meet your needs. We bring true exclusive offers and direct advertiser relationships in many sought after verticals and have a team of dedicated and experience managers to meet the both the demands and needs of our affiliate. Let us help you optimize your online marketing campaign. See for yourself what our knowledge, offers, and experience can do to boost YOUR ECONOMY!

Neverblue is a premier global lead generation network that delivers millions of profitable customers to clients from all over the world, including members of the Fortune 1000. Neverblue values strong affiliates, because they’re what make us better! Neverblue is a wholly-owned, Canadian subsidiary company of Vertrue Inc., an $800 million internet direct marketing services company. Check us out today!

eAdvertising is one of the leading premier networks that specializes in Acai, Colon, and Facial offers among others and offers exclusive media buy help and expertise for those looking to expand on traffic sources. With so much to offer, take a look at what eAdvertising has to offer today.

AKMG prides itself in personal affiliate relationships, solid offers, and personalize attention. AKMG will work with affiliates to ensure that they will profit and prosper. Come check out AKMG now.

One of the oldest networks around, Affiliate.com has plenty to offer new and veteran affiliates. Come by and check us out.

The Epicenter Network is a company that was built from the ground up to help Affiliate Marketers succeed. We’ve built several platforms and tools to accomplish this, including DM2, an affiliate-targeted website building and marketing platform, and EpicenterAds, a contextual advertising platform. Our CPA network, Epicenter Select, is an elite, invite only, performance-based online advertising network. Striving to deliver the highest quality traffic on the web, Epicenter Select limits traffic sources to search, email, and display. At Epicenter, our publishers always come first. We provide exclusive and direct campaigns, top payouts, flexible payment terms and methods, personalized customer service and reliable, easy-to-use systems.

In conclusion, Tracking202 Pro is a great system for the intermediate and advanced affiliate marketer.  Check out their website for more information.

Tracking202 Pro Website

Advertiser vs Publisher: What Am I?

Posted by JasperP on January 17th, 2009

“What’s the difference between an advertiser and a publisher?”

This was a question that my brother asked after the trip to ASW.  I remembered when I first got started in affiliate marketing with CPA networks, I was kind of confused which one was which. Thinking about it now, I realize that I am both a publisher and advertiser at the same time.  It just depends what type of network I’m  working with.

Most of the time, CPA Networks are going to refer to affiliate marketers as a publishers.  So if you apply to a CPA network like Convert2Media, then you need to apply as a publisher.  As an affiliate marketer, you are taking the offers and you are publishing them for visitors. Therefore, to the CPA network, you are a publisher.

However, as an affiliate marketer, you may publish the offer in an Ad Network such as Google Adwords or Adbrite. In this case, you are an advertiser since you are utilizing the impressions and views from a web site. Google Adwords has web site owners (in the content network) that are publishers because they provide ad space for you as the advertiser.

So, to recap, if you’re an affiliate marketer and…

• … you’re applying to a CPA network such as Convert2Media, then you’re a PUBLISHER
• … you’re applying to an ad network such as AdBrite or Adwords then you’re an ADVERTISER.

Make sense?

Cool.