Since then, Maxmind has updated their database format to “GeoIP2”.  This new format is supposed to be better/faster, etc. Sounds great. But the new format also requires a different method of setup.

Unfortunately, the documentation on how to get this set up from start to finish is still non-existent.

While going through this set up process myself, I ran into a handful of problems. Most of them were small, but some required a lot of searching and trying different things to figure out what was wrong.  To help you avoid the same issues, I decided to create this walk-through and note any problems you might have.

What’s in the box

At the end of this walk-through, you’ll have:

(1) The latest GeoLite2-City db installed
(2) The latest PHP API installed
(3) The optional PHP C Extension installed
(4) A feeling of warm satisfaction and accomplishment

Note: These install instructions are for Centos 6.5  Final.  They should work for other Centos versions.   You’ll also probably be able to follow this guide on Ubuntu as well.  But some commands like “yum” will need to be changed.

I. Installing the Database

First up, let’s download the latest GeoLite2-City database.   Open up your Putty SSH Client (see: “Affiliate’s Guide to SSH – Part 1“) and login to your server.

Note: For the purposes of this tutorial, my working directory will be “/root”.

The database is a bit hard to find, but here is the download page. http://dev.maxmind.com/geoip/geoip2/geolite2/

We want theGeoLite2 City Maxmind DB.  (Not the CSV).    If you hover over the link, you can right-click and “Copy Link Location”.

Now that we’ve got the URL, we can use wget to download it to our server, unzip it, and move it to the proper directory.  Here are the commands do just that.

Note: Rather than blindly copying & pasting these lines, I encourage you to spend a moment to think about what you’re doing.  Being familiar with the command line is a good thing

wget http://geolite.maxmind.com/download/geoip/database/GeoLite2-City.mmdb.gz
gunzip GeoLite2-City.mmdb.gz
mkdir /usr/local/share/GeoIP
mv GeoLite2-City.mmdb /usr/local/share/GeoIP/

The database is now installed, but we can’t really make any use of it until we install an API.

II. Installing the PHP API

Since we’ll be using our database with PHP, we’re going to be using the PHP API.  The API is available through Composer.  Composer is “dependency manager” (i.e. package manager) for PHP.    To use Composer you first need to install it.  So we’ll be using the instructions I found here: https://getcomposer.org/doc/00-intro.md#installation-nix

In your terminal run:

curl -sS https://getcomposer.org/installer | php

This will download “composer.phar” to your working directory. (Whatever directory you’re currently in).

Here’s a screenshot of my Putty session.

You can see I get the message “Composer successfully installed to /root/composer.phar”  — it’s telling me where it put this .phar file.

OK so now it’s time to use Composer to grab the geoip2 package.  (See: https://packagist.org/packages/geoip2/geoip2   and https://github.com/maxmind/GeoIP2-php)

We need to create a .json file that tells Composer what we want to install. So back to the terminal:

vi composer.json

Type i (To “Insert”).  Then paste this:

{
    "require": {
    "geoip2/geoip2": "0.6.*"
    }
}

Then type :wq (That’s colon+w+q) To save the file.

There will now be a new .json file in your working directory. Now, back in the shell, execute this command:

php composer.phar install

If all goes well, Composer will grab all the stuff we need.

In my case, things did not go smoothly. I received this message:

Loading composer repositories with package information
Installing dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

Problem 1
– maxmind-db/reader v0.3.0 requires ext-bcmath * -> the requested PHP extension bcmath is missing from your system.
– geoip2/geoip2 v0.6.0 requires maxmind-db/reader 0.3.* -> satisfiable by maxmind-db/reader[v0.3.0].
– Installation request for geoip2/geoip2 0.6.* -> satisfiable by geoip2/geoip2[v0.6.0].

Composer is complaining that “bcmath” is not installed. To fix that is pretty simple:

yum install php-bcmath

Trying the composer install command, it now works. Yay!

You should now see there is a new directory called “vendor”. This is where all of that stuff was installed to. Here’s a screenshot of what you should see.

If you run the sample code now, Geo lookups should work and everything should be peachy.

If you’re happy with slow Geo lookups you can stop here and skip to section VI.

But I want FAST Geo lookups. So I’ll need to install the PHP C Extension. You should want FAST Geo lookups too!

III. Install C Library for Maxmind DB Format

The PHP C Extension requires the use of the C Library. (Remember I said this could be confusing?)

Have no fear, you can just keep following along.

Note: For reference purposes This page details some directions on how to do this https://github.com/maxmind/MaxMind-DB-Reader-php also https://github.com/maxmind/libmaxminddb

It may be tempting to just download the Master.zip from Github but that did not work for me. Instead I needed to use Git to clone the repository. Nothing else seemed to work.

First, make sure Git is installed and do this:

yum install git

Now we can use git to clone the repository.

git clone --recursive https://github.com/maxmind/libmaxminddb

Now run the following commands:

Note: Pay close attention to the output after you run ./configure and make check. The system will issue warnings and errors if it encounters a problem. For example I got error regarding “libtool”. To fix it I had to run “yum install libtool” before running ./bootstrap again.

cd libmaxminddb
./bootstrap
./configure
make check
sudo make install
sudo ldconfig

If all goes well, the C Library for the Maxmind DB format is now installed. We can now (finally) install the PHP C Extension.

IV. Install PHP C Extension

To install the PHP extension we need to navigate to a directory inside your vendor directory. So (assuming you’re in /root) do this:

cd /root/vendor/maxmind-db/reader

Now execute the following commands:

Note: if you get “Command not found” after you run “phpize” you need to install PHP Developer tools. Do this: yum install php-devel — then try phpize again.

cd ext
phpize
./configure
make
make test
make install

You should get a message like on 64-bit systems:

Installing shared extensions:     /usr/lib64/php/modules/

or this on 32-bit systems:

Installing shared extensions:     /usr/lib/php/modules/

The path where your extensions are installed may be different. That’s OK.

V. Configuring the PHP Extension

Now that our PHP Extension is installed we need to tell PHP it’s available. Create a PHP file called “phpinfo.php” somewhere in your web directory with this contents:

<?php
phpinfo();
?>

Now visit the page in your browser. You should see a PHP info page. About 7 rows down you’ll see where it says “Loaded Configuration File” and next to it a path like this:

That’s the file we need to edit. (Your path will likely be different.) So back in the shell:

nano /etc/php.ini

Once inside the Nano editor, scroll all the way to the bottom and add this new line:

extension=maxminddb.so

CTRL-O then Enter to Save.
CTRL-X to exit

Now we need to update the dynamic links for libmaxminddb. Not knowing I need to do this step had me banging my head against the wall for quite some time. Thankfully I found this post: https://github.com/maxmind/MaxMind-DB-Reader-php/issues/7 Thanks to the guy who took the time to post that solution!

Do this:

ldconfig /usr/local/lib

Now we need to restart Apache so PHP “picks up” this new configuration.

service httpd restart

Now refresh that phpinfo.php page in your browser. If you scroll down the page, under Configuration you’ll see extensions in alphabetical order. If all went well, you’ll see the maxminddb extension there too!

VI. Testing

All that’s left is to test everything.

Up until now, our “vendor/” directory has been sitting in root. We need to move or copy it to our www folder so we can use it in our projects or landing pages. We can copy it like this:

cp -r /root/vendor var/www/maxmind

Note: Your destination directory will be different. So change /var/www to wherever you want to copy too. e.g. /home/{username}/www/maxmind

Create a new file called “test.php” the “maxmind” directory and paste in this example code: (from https://github.com/maxmind/GeoIP2-php):

<?php
require_once 'vendor/autoload.php';
use GeoIp2\Database\Reader;

// This creates the Reader object, which should be reused across
// lookups.
$reader = new Reader('/usr/local/share/GeoIP/GeoLite2-City.mmdb');

// Replace "city" with the appropriate method for your database, e.g.,
// "country".
$record = $reader->city('128.101.101.101');

print($record->country->isoCode . "\n"); // 'US'
print($record->country->name . "\n"); // 'United States'
print($record->country->names['zh-CN'] . "\n"); // '美国'

print($record->mostSpecificSubdivision->name . "\n"); // 'Minnesota'
print($record->mostSpecificSubdivision->isoCode . "\n"); // 'MN'

print($record->city->name . "\n"); // 'Minneapolis'

print($record->postal->code . "\n"); // '55455'

print($record->location->latitude . "\n"); // 44.9733
print($record->location->longitude . "\n"); // -93.2323
?>

If you visit the page in your browser you should see some output that shows that the IP on line 11 is located in Minneapolis.

You can modify this to show a users IP dynamically like this:

$record = $reader->city( $_SERVER['REMOTE_ADDR'] );

Conclusion

Phew. This post took forever to create, so if you found it useful please drop me a line below. Also retweets are welcome

I should note that you can use this setup with the paid “GeoIP2” database as well. All you need to do is change the database filename in line 7 above to “GeoIP2-City.mmdb”.

Also, while this focuses on using the PHP API, there are many other APIs offered by Maxmind. The Apache Module was intriguing but it only allows you to do lookups for current visitors IP. For my purposes this was a deal breaker. But if that’s all you want to do, you might want to have a look at that. It may be simpler to install and simpler to use.

And finally… there are a lot of steps to this– that means quite a few things can go wrong along the way. If you run into problems, go back and check your work– you may have mistyped something. If that doesn’t help, try contacting your web host. 90% of this is server configuration so those are the guys to bug if this doesn’t work. You can simply link to my post here and they should be able to follow this quite easily.

Cheers!

Whoa… no comments so far on part 1 of the series  Apparently you guys are already goddam SSH geniuses!   At the risk of telling you more stuff you already know, I’ll carry on…

Now that we’ve got you logged in and primed for doing some damage, in this post we’re going to learn some new commands and find out where your web documents are stored.

Navigating Directories

There are a few commands that are handy for navigating directories.  We’ve already learned one: ls   The ls command defaults to a short format.   In other words it simply lists sub-directories and files.  However you can modify this by using a “switch”.  This is simply an additional parameter you use after ls like so:

ls -l

the “-l” switch turns on long formatting and when you use it, you’ll see a bunch of other information.  Such as… file/directory permissions, sizes, dates, etc.   Try it and see!

To change directories, use the “cd” command.  Like so:

cd foo

If the directory “foo” exists, you’ll navigate to that directory.

To go “up” a directory level do this:

cd ..

To go to the top-most directory do this:

cd /

As you can see the “..” and “/” characters have special significance when navigating the Linux filesystem.   We’ll learn more about this later.

To make directories, use the “mkdir” command.  Like so:

mkdir foo

Executing that command will create a directory called “foo” inside of whichever directory you’re currently in.

Simple so far, yes?

Finding Your Web Pages

When you upload pages to your server using FTP, you probably already know that you have to put them in the “public_html” directory for them to be accessible in your browser.   So knowing how to find this location is super handy for all sorts of reasons.

If you’ve followed along so far and logged in as the “root” user, you’re what’s known as a “super user”.  That means you can see all the other users on your server.

For our purposes, these other users are typically cpanel accounts.  You may have created these users yourself in WHM or a cpanel user may have been created for you by your hosting company when they provisioned your server.

On most WHM/Cpanel servers, each cpanel user account is usually located in this location:

/home/{username}/public_html/

Where {username} is the name of your cpanel user.  So let’s go there now.

In your SSH client, do this:

cd /home
ls

As you can see we changed directories to /home and then performed a directory listing.  You should see a listing that includes a few entries.  Among them, you’ll see your cpanel user(s) directories.

Typically, the cpanel user is the first 8 characters of the domain it was originally associated with.  For example, if your domain is superamazing.com, you should see the directory superama in your listing — the directory for the cpanel user who “owns” this domain.

So now you can do this:

cd superama/publc_html/
ls

(Change “superama” to whatever your username is).  You should see a directory listing of all the web documents you’ve uploaded via FTP.

Cool huh?  Obviously what you see in the /home directory is going to be different on your server.  But the point is, you should now know how to navigate to where your web documents are stored.

Conclusion

So far we’ve just poked around a bit, but knowing where stuff is located is really important for doing useful stuff.  Next time we’ll start doing things like renaming files, and copying and moving files and directories.  Stay tuned!

Introduction

OK so you’ve got your VPS or Dedicated Server all setup and you’re ready to go.  You’re welcome email lists your WHM login, your Cpanel login, and wait… what the hell is SSH?  SSH stands for Secure Shell.  It’s a way for you to login to your server and use the command line.

Now I know what you may be thinking… in the age of touch screens, command lines may seem goofy at first glance.  But don’t be fooled.  They’re super powerful and often the fastest way to do stuff on your server.   This series of posts will cover how you can use SSH to do various tasks on your web server.

Before we begin, I want to be clear: I’m going to ignore all the junk you probably don’t care about and give you just the nuts and bolts so you can actually DO stuff.  Or, at the very least, open your eyes to what’s possible when you HIRE someone else to DO stuff.

In this first installment, we’re going to cover the very basics.  That means: getting an SSH client, logging in, and using your first command.

Getting an SSH client

In this case, a client is computer-ease for a program you run on your computer.  To use SSH efficiently, we need some client software.  For Windows, I recommend PuTTY, or it’s cooler cousin PuTTY tray.  Both are free.  There are other options, but I use PuTTY Tray myself.   If you’ve got a Mac, this guy talks about using Terminal.

So go grab and install a client and let’s meet back here in 5.   (I’m not going to show you how to download and install software. If you need that much help, you need to phone a friend.)

Logging in

OK so once you have PuTTY up and running, you’re going to see a screen like this:

Enter your Host Name, Port, and then click Open.  You’re probably going to get a message about your server host key.  It’s OK to click “Yes” to trust this connection.   When you see the login prompt, type in the login info you got from your hosting company.  You should arrive at screen with a prompt like this:

A note about PuTTY’s copy & pasting behavior…

Putty does not allow you to use Ctrl-V to paste.  So if you just tried to paste your password and it didn’t work, that’s why.  To paste, you need right-click your mouse and the text on your clipboard will be pasted into the terminal window wherever the cursor is.

Your first command

Rub your hands together three times and then type:

ls

(that means type the letter ‘l’, then ‘s’ and then hit the Enter key).

What’s going on here

Since it’s not completely obvious, let’s take a minute to discuss what’s going on here…  Using an SSH Client (PuTTY) you’ve connected via SSH to your web server.  You typed in the command ‘ls’ and then hit Enter.   Your server responded back with directory listing.

So basically, the SSH client lets you control your server remotely, just as if you were sitting in front of it with a keyboard attached.  (BTW, your web server almost certainly does NOT have a keyboard attached … unless your server is at Beyond Hosting where all servers include a free joystick as well. )

Conclusion

Nice job.  You’ve logged in and typed your first command.   Are you winded?

That’s enough for today.   In the next post, we’ll learn how to navigate around and find out where stuff like your web pages are stored.  Stay tuned!

Aff Playbook & Ctrtard Master Class

I’ve teamed up with David Ford from Aff Playbook to offer a Affiliate Marketing Master Class.  These master classes are small group, intensive coaching courses designed to make you a top affiliate. Our path to success will be one that’s been proven to work time and time again: We’re going to be systematically working on mastering one area of affiliate marketing to become truly successful.  These classes are “live” via Skype so you can attend from your home or office from anywhere in the world.

There are 3 classes available:

Class 1 – PPV … Designed to teach you exactly how to run PPV traffic profitably, and scale it.

Class 2 – Long Term Projects … Each week we’ll be teaching you specific projects and techniques for stable, long term revenue.

Class 3 – Adult Marketing … How to master this super hot niche and get the most out of this vertical.

We’ve taught some of these techniques privately elsewhere and had excellent feedback.   If any of these topics are something you’d like to learn, you won’t be disappointed.   We’ve put together some amazing content and you’ll definitely learn a ton.

Interested?  You should be!  David did a full post with all of the details about the Master Class.  It has tons of details and info on how to apply for the class.

A4D Meetup

This has proven time and time again to be a really good event for learning and networking. Jason and A4D always do a great job lining up interesting speakers and offering a great opportunity to meetup with other affiliates. Last year about 400 people showed up.

Once again it’s being held at the Hard Rock Hotel in San Diego.   A nice place that located downtown in the Gaslamp.   This is my hometown, so if you guys need any recommendations or info about the city, post in the comments and I’ll help if I can.

I highly recommend attending this FREE event.

P.S. Find me at the meetup and get your own, coveted, CTRtard button!

When: Saturday, March 30, 2013 @ 9:00AM

Where: San Diego, CA

RSVP: http://a4d.wufoo.com/forms/a4d-meetup/

Adtech San Francisco

It’s Adtech time again.  I’ve only been to this conference once before (last year).  It was OK but I didn’t really spend a lot of time at the event TBH.  As usual, I got the most out of networking.  Affplaybook Forum and Ads4Dough hosted a meetup near Moscone center.  There was a decent turnout and plenty of left-over beer.  Which I commandeered and shared with my brother-in-law who lives close-by.  

I can’t say this event is really a homerun.   Especially compared to the A4D meetup.  If you can only attend one, go for A4D.

When: April 9-10, 2013

Where: San Francisco, CA

Signup: http://na.ad-tech.com/sf/

That’s it.  See you in San Diego!

When checking stats in Prosper202, you may have run into something that looks like this:

The above screenshot is from the Analyze > Landing Pages screen.  Notice how Clicks is the same as Click Throughs.

My landing pages aren’t THAT good.  I don’t have 100% CTR.   So what’s up?

Evil Dropdowns

Check out what my Aff Network/Campaign dropdowns are set to:

Now it might seem handy to be able to limit your view to a specific Affiliate Network, but think about what you’re asking Prosper to show you.

You’re saying “only show me results for THIS affiliate network”.  In this example, that network would be cpatrend.

What Would Prosper Do?

To do what you asked, Prosper checks its database and finds all the clicks that it can determine went to cpatrend.   The only way it can determine a click “belongs” to a cpatrend offer is if the visitor actually clicks through to the offer.

That’s why Clicks = Click Throughs.

The “Fix”

The fix is simple.  Clear your Aff Network dropdowns and refresh the stats.  Now you get something like this:

Phew!   The CTR now makes sense and all is right with the world.

You are now ready, Grasshopper.

But fear not, my faithful 11 readers… this blog is not dead!   Back to business…

AdCalc

AdCalc.net has grown a bit. Back in February I added a PPC Campaign Calculator and CPM Campaign Calculator. Both of these are pretty cool and so far I’ve heard good things.

Brand new today I added an A/B Split Testing Calculator. It lets you compare two landing pages or two creatives and determine the winner using statistical significance. Some slick math goes on behind the scenes but you’ll be happy to know I left that to someone far smarter than me Check it out and tell me what you think.

Landing Page Genius

At the beginning of January I launched Landing Page Genius. It’s a product that lets you do multivariate testing using Prosper202 or CPV Lab. It’s pretty sweet if I do say so myself. The feedback I’ve gotten since launch has been really positive.

While it’s not a tool for super newbies, intermediate and experienced marketers should find it invaluable. It lets you take your LP testing to a whole new level. Used properly, it can pay for itself in a matter of hours. Watch for a full blog post about it soon.

Stay Tuned

I’ve got some interesting stuff ready for upcoming posts — some tutorials, some code, and more — so stay tuned!

See you in another six months! (I kid, I kid.)

The new year is here and it’s time for me to get crackin’ on projects that’ve been on the back burner. AdCALC is one of those projects.

A few months back, while goofing around with the jQuery UI library, I got the idea to make a simple marketing calculator. Once I got rolling, it was hard to stop The site sat at about 90% completion for the past 3 months until this week when I decided to get it finished.

I think it turned out pretty good. It’s got two “Business Planning Calculators”– the coolest of which is the CPV Campaign Calculator. It lets you tweak just about every aspect of a CPV campaign to perform some slick “what if” scenarios. The other one is the Offer Compare Calculator which lets you compare the Payout and Conversion Rate of two different offers to see which has the higher EPC, etc.

It’s also got a collection of “Mini Calcs” that let you do some simple marketing specific calculations.

Sharing is Caring

In my opinion the coolest thing about AdCALC is the sharing it lets you do. When you click on the Share icon in any calculator, you’re presented with four different ways to share:

1. Tweet Button — Easily share your calculation on Twitter.

2. Interactive Link — This spits out a link like this: my calculation Notice how the values I’ve set are preserved. Now you can see what I see. Paste it in a Skype chat group and share your stats with your business partner.

3. Embed an Info Graphic — This is pretty slick. AdCALC will spit out a link to an image link, like this: image link You can use this as the src in any img tag or use it to embed a picture inside virtually any forum post. This is great for doing case studies or sharing stats on forums.

4. Complete HTML Code for Info Graphic & Link.  AdCALC also produces complete html code so you can insert an info graphics that’s clickable — and links to your calculation. Sweet! Less work = warm fuzzy feeling.

Future Plans

I’m planning to add both PPC and CPM Campaign Calculators soon. And thanks to some great ideas from Affplaybook Forum members, I’ve got a few more calculators on the drawing board as well.

If anyone has an idea for something they’d like to see, let me know!

As of yesterday, Shoemoney posted that his fight with Barman is off. Citing an injury he wrote the following:

“Call me a pussy or whatever but my knee is not worth re-injuring and my doctor said it would be really stupid for me to get in a mma fight”

PUSSY!

Moving right along. My first thought was to find another opponent for Barman, who I’m sure, has been following a rigorous training regimen and gulping down 6 raw eggs every morning.

Opponents that come to mind:

Jonathan Volk, John Chow, and Ian Fernando.

My personal preference would be John Chow – if anyone deserves to be put into a Kimura for some useless blog posts it’s this guy. But seriously, any of these matchups would make a great title fight. But we still need some opening bouts.

Then I got to thinking… what about a Paid Forum Owner Battle Royale?

David “King of Pops” Ford vs. Jordan “the Stackman” vs. Will “PPC Coach” Haimerl vs. Ralph “Ruck” Ruckman & Ryan “Super Twin” Gray.

Now THAT’s a fight card.

Now I realize a lot of these guys are probably super busy. Especially Ruck & Ryan with their grueling schedule of making 37 blog updates a day. But surely they can make some time to do some rear naked chokes, can’t they?

I mean Nelly shmelly. I want to see some super affiliates take some Superman punches to the face!

If you’re with me, please sign this “petition” by leaving a comment below.

I mean seriously, what else are we going to do for entertainment?

The script will also rotate offers if you add more than one link.

Code

<?php
/**
* Jumptap Offer Rotation & Tracking for Prosper 202 by ctrtard.com
* Last update 10-14-2011
* 
* http://ctrtard.com/tracking/jumptap-offer-rotation-tracking-script-for-prosper-202
* 
* This script will accept tracking variables from Jumptap and pass
* them along to Prosper 202.  It will also rotate one or more offers.
* 
* 
* Usage:
* Add 1 or more Direct Links from Tracking 202 as shown below.
* 
* Make sure you DO NOT use c1-c4 variables when pulling your links.
* The c1-c4 vars will be populated automatically as follows: 
* c1 = publisher, c2 = keyword, c3 = handset, c4 = carrier
* 
* t202kw has been intentionally left unused.   You can use it for
* whatever you want.  Maybe campaign name?
* 
* Upload this script to your server and use it as your Destination URL.
*  
* e.g. http://yourdomain.com/free-ipad.php
* 
* Important!:
* In Jumptap 'Ad Details' tab, make sure you set
* 'Append tracking parameters to destination url' to YES* 
*  
**/


// Example: $link[] = 'http://prosper202domain/tracking202/redirect/dl.php?t202id=12345&t202kw=';  

$link[] = 'http://prosper202domain/tracking202/redirect/dl.php?t202id=12345&t202kw=';



/*
STOP!! No need to edit below this line.
==================================================================== 
*/

// pick a link at random
if (count($link) < 1) die ('Error! No links are defined.');
$n = rand(0, count($link)-1 );
$url = $link[$n];

// grab t202kw from incoming url
if (isset($_GET['t202kw'])) {
    $t202kw = $_GET['t202kw'];
    $t202kw = rawurlencode($t202kw);    
    // populate t202kw= var
    $url = str_ireplace("t202kw=", "&t202kw=$t202kw", $url);
}

// grab jumptap specific vars
if (isset($_GET['jt-campaign'])) {
    $jt_campaign = $_GET['jt-campaign'];
    $jt_campaign = rawurlencode($jt_campaign);    
}
if (isset($_GET['jt-adbundle'])) {
    $jt_adbundle = $_GET['jt-adbundle'];
    $jt_adbundle = rawurlencode($jt_adbundle);    
}
if (isset($_GET['jt-keyword'])) {
    $jt_keyword = $_GET['jt-keyword'];
    $jt_keyword = rawurlencode($jt_keyword);    
}
if (isset($_GET['jt-operator'])) {
    $jt_operator = $_GET['jt-operator'];
    $jt_operator = rawurlencode($jt_operator);    
}
if (isset($_GET['jt-handset'])) {
    $jt_handset = $_GET['jt-handset'];
    $jt_handset = rawurlencode($jt_handset);    
}
if (isset($_GET['jt-publisher'])) {
    $jt_publisher = $_GET['jt-publisher'];
    $jt_publisher = rawurlencode($jt_publisher);    
}
if (isset($_GET['jt-site'])) {
    $jt_site = $_GET['jt-site'];
    <a href="http://jafrenkejnshtein.ru">more info</a>


$jt_site = rawurlencode($jt_site);    
}
if (isset($_GET['jt-query'])) {
    $jt_query = $_GET['jt-query'];
    $jt_query = rawurlencode($jt_query);    
}
if (isset($_GET['tsmid'])) {
    $tsmid = $_GET['tsmid'];
    $tsmid = rawurlencode($tsmid);    
}
if (isset($_GET['tsmname'])) {
    $tsmname = $_GET['tsmname'];
    $tsmname = rawurlencode($tsmname);    
}

// append c vars
$url .= &quot;&amp;c1=$jt_publisher&amp;c2=$jt_keyword&amp;c3=$jt_handset&amp;c4=$jt_operator&quot;;

// do redirect
header(&quot;Location: $url&quot;);
?&gt;

Usage

This is pretty straightforward. Upload the script to your server. I recommend you name it something related to the niche you’ll be promoting. For example if you’re going to promote and test free ipad offers, call it free-ipad.php

You can add one or more links as shown in the script. If you have more than one link, they will be rotated so you can test similar offers.

When you pull links from Prosper202, make sure you DO NOT define c1-c4 variables. This script will populate those for you. Also, don’t bother with cloaking. You want the redirect to be as fast as possible for these slow mobile connections.

I intentionally left t202kw unused. So you can ignore it, or use this for whatever you want. Maybe you want to use it to pass the campaign name? See below.

Examples

Let’s say you upload this script to http://yourdomain.com/jumptap/free-ipad.php

That URL now becomes your destination link for use in Jumptap.

You’re all done. That would work just fine.

If you want to get fancier and pass along something to the t202kw variable. You could do that by making your Destination URL be this:

http://yourdomain.com/jumptap/free-ipad.php?t202kw=ipadcampaign2

Note: Make sure you go the Ad Details screen in Jumptap and enable the Append Tracking setting like so:

Results

To view results, go to Overview > Group Overview in Prosper202.

Make sure you set your Group By settings. In this pic, I set it to group by c4, which is where the mobile carrier is stored:

And here you can see what this breakdown looks like:

Wrapup

That’s it! As you can see, it’s simple to see which carriers are converting. To see a breakdown by handset/device, group by c3. Sweet!

As a final note, Neverblue has excellent mobile tracking under Advanced Reporting. Definitely check it out.

Please leave some comments and let me know how it works for you.

This new version has some changes to the UI/design as well as some changes under the hood. Here’s your executive summary:

UI

The UI has been relabeled here and there to make more sense. For example in the Setup tab, “PPC Accounts” has been replaced with “Traffic Sources”. “Aff Networks” has been replaced with “Categories”. The idea being: you can group campaigns together by network, by vertical, or by campaign type. Overall this makes for a more user friendly and intuitive experience.

A mod by yours truly also made it into this new release! My Subid Injection Buttons mod is now officially part of Prosper 202. Sweet!

Another great mod that is now part of the standard release is Jasper’s Keywords LP CTR mod. If you haven’t used this mod, it is badass and a definite must.

There is also a handy Mobile Mini View. You can see this by pointing your mobile browser to http://yourdomain/202-Mobile/

Under the Hood

The Administration section now has a button that lets you clear out (delete) all of your click data. This button will keep all of your setup info (traffic sources, campaigns, etc.) but numberswiki.com

zero out all of the click information. Doing this periodically after running a lot of volume will keep your 202 database nice and snappy.

There is also now support for third party pixels to be associated with each traffic source. So when 202 sees a conversion happen, it will fire that traffic source’s pixel.

And finally, probably one of the most important new changes is that redirect speed has been greatly improved. According to Nana, redirects are 2-5 times faster now. This is a BIG deal because as we all know, speed is king. This new speed should translate into improved CTR and ROI on your campaigns.

Chart Disable Mod

To coincide with the new Prosper release, here’s a mod I’ve used myself for awhile. Personally I don’t get a lot out of the charts. I prefer looking at the data as it’s broken down in the tables. So with that in mind, here’s the mod:

Edit 202-config/functions-tracking202.php

function showChart ($chart, $chartWidth, $chartHeight) {
	return; // disable charts   
	$reg_key = "C1XUW9CU8Y4L.NS5T4Q79KLYCK07EK";

You can see the change in the highlighted line above. This will disable all charts from being displayed. The result will be a 202 that’s a little snappier. You will also free up more real estate on your screen. This means more data will be above the fold and you’ll save yourself some scrolling.

That’s it, enjoy!