Nerdy Affiliate Adventures In Affiliate Marketing Land

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 ;

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

Microsoft AdCenter Desktop Tool Now Available

Posted by JasperP on February 18th, 2009

The Microsoft AdCenter Desktop tool is finally out of beta and available to the public! It’s very similar to Google Adwords Editor Tool and should make managing MSN campaigns a breeze. 

Download it and if you have trouble installing it, set your IE browser to default temporarily:

https://maf.adcenter.microsoft.com/desktop/setup.exe

Thanks to Wes Mahler for the heads up.

Networking Is The Key To Success!

Posted by JasperP on February 16th, 2009

A few days ago, Bryn posted a very important topic on his blog titled: “Networking Is The Most Important Thing In Affiliate Marketing.”  I really believe this is critical to your success and will keep you motivated to keep working on your business.  

Some people have asked me if I did consulting and were willing to pay me for it.   I told them “fuck that.. let’s just share tips and experiences!”  I don’t mind helping people out because I can also learn from them as well. 

Anyway, just wanted to post my top places to network with other affiliate marketers:

1.    
   Instant Messaging – I use this regularly and it’s easy to just get in contact with someone and discuss different topics of marketing.  Contact me at JasperP81 on AIM.
2. 
   Meetup202 - The meetup202 groups created by Wes and Steven of Prosper202 are GREAT for networking with other affiliate marketers.  I’ve met tons of people through my local Los Angeles meetup.  Check out if there are Meetup202 events in your area: meetup202.com.
3. 
   Affiliate Summit - Affiliate Summit West and Affiliate Summit East events are a MUST for affiliate marketers.  You get to connect with other marketers on a more personal level. Plus it’s great fun partying and just chillin’.  Mark your calendars: Affiliate Summit East is on Aug 9-11 @ New York City.  Check it out: affiliatesummit.com.
4. 
   Twitter - Twitter is another networking tool that can be used to get in contact with other marketers.  Dubbed as “mini-blogging”, you can reply back and forth with people about topics that they post or “tweet”.  Follow me at twitter.com/JasperP.
5. 
   Blogs - Subscribing to blogs are another way to get in contact with other marketers.  I personally use Google Reader to consolidate all the blogs that I follow.  I use this to keep an eye on the latest news in the Affiliate Marketing Industry.  Currently, I subscribe to about 100 blogs.  Check out Google Reader. It’s free! Then subscribe to this blog by clicking on my RSS link.
6. 
   Social Networking - Facebook and LinkedIn are popular spots to get in touch with other marketers.  I just started to expand my social network so hit me up on Facebook and LinkedIn.  
    
7. Forums - I used to be a bit more active on forums before, however, nowadays I’m not as active as I could be, but there are quite a few affiliate marketing forums out there such as WickedFire, Prosper202, PPC-Coach, Convert2Media, Cash Tactics, Xtreme Profits, etc.  If I’m on there, my username is usually “JasperP”. 

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. 

« Previous Entries