Nov 11 2010

How to Track PayPal Transaction Data in Google Analytics Ecommerce – Sample Code

Category: generalYulia Solodky

 

(Warning: highly technical post, but highly useful for ecommerce sites!)

Problem
Although Google Analytics is free, it can be tricky getting the Ecommerce section to provide you with the kind of data you need to track specific transactions. As you may know, when Ecommerce analytics work you can see things like:

  • Products purchased
  • Price
  • Quantity
  • Tax
  • Shipping
  • Location
  • Order ID
  • SKU

When you have data like this, it helps in making decisions about pricing, product lines, shipping, locations to target and much more. The problem is getting this transaction data from PayPal and properly feeding it into Google Analytics. That’s what this report is going to help you do, if you are using a PHP platform.

Solution
Step 1: Activate Payment Data Transfer (PDT) within your PayPal Account Properly

To use PDT, you must activate PDT and Auto Return in your PayPal account profile. You must also acquire a PDT identity token, which is used in all PDT communication you send to PayPal.

Follow these steps to configure your account for PDT:

1. Log in to your PayPal account.
2. Click the Profile subtab.
3. Click Website Payment Preferences in the Seller Preferences column.
4. Under Auto Return for Website Payments, click the On radio button.
5. For the Return URL, enter the URL on your site that will receive the transaction ID posted by PayPal after a customer payment (must be a php page).
6. Under Payment Data Transfer, click the On radio button.
7. Click Save.
8. Click Website Payment Preferences in the Seller Preferences column.
9. Scroll down to the Payment Data Transfer section of the page to view your PDT identity token.

Step 2: Create Your Payment Buttons and include specific PayPal variables in the Payment Button on your product pages. These variables, and a lot more, can be passed through to Google Analytics if you set them up properly. Log in to your PayPal account so you can get this list of HTML Variables for Website Payments Standard.

<form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="amount" value="139.95">
<input type="hidden" name="business" value="XXXXXXXXXXXXX">
<input type="hidden" name="item_name" value="Rocking Horse">
<input type="hidden" name="item_number" value="sc1">
<input type="hidden" name="undefined_quantity" value="1">
<input type="hidden" name="no_shipping" value="2">
<input type="hidden" name="discount_rate">
<input type="hidden" name="discount_rate2">
<input type="hidden" name="on1">
<input type="hidden" name="os1">
<input type="hidden" name="return" value="http://www.mysite.com/thanks.php">
<input type="hidden" name="cancel_return" value="http://www.mysite.com/">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="lc" value="US">
<input type="hidden" name="bn" value="PPBuyNowBF:btn_buynowCC_LG.gif:NonHosted">
<input type="image" src="https://www.paypal.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" onclick=CalculateOrder(this.form) name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>

You’ll need to change the values of the variables in this code to fit your business and products.

Step 3: Create your order confirmation page using php (thanks.php).

<?php
// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-synch';

$tx_token = $_GET['tx'];
$auth_token = "";
$req .= "&tx=$tx_token&at=$auth_token";

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);
// If possible, securely post back to paypal using HTTPS
// Your PHP server will need to be SSL enabled
// $fp = fsockopen ('ssl://www.paypal.com', 443, $errno, $errstr, 30);

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
// read the body data
$res = '';
$headerdone = false;
while (!feof($fp)) {
$line = fgets ($fp, 1024);
if (strcmp($line, "\r\n") == 0) {
// read the header
$headerdone = true;
}
else if ($headerdone)
{
// header has been read. now read the contents
$res .= $line;
}
}

// parse the data
$lines = explode("\n", $res);
$keyarray = array();
if (strcmp ($lines[0], "SUCCESS") == 0) {
for ($i=1; $i<count($lines);$i++){
list($key,$val) = explode("=", $lines[$i]);
$keyarray[urldecode($key)] = urldecode($val);
}
// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// check that payment_amount/payment_currency are correct
// process payment
$firstname = $keyarray['first_name'];
$lastname = $keyarray['last_name'];
$itemname = $keyarray['item_name'];
$amount = $keyarray['payment_gross'];

//* Add the following additional (3) lines of variables to the Paypal php section that displays your process payment (under this line of the original PayPal code):
$order_id = $keyarray['txn_id'];
$sku = $keyarray['item_number'];
$quantity = $keyarray['quantity'];

}
else if (strcmp ($lines[0], "FAIL") == 0) {
// log for manual investigation
}

}

fclose ($fp);
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Thanks for your order!</title>

<!-- the asynchronous google-analytics code Start -->
<script type="text/javascript">
<?php
$product_name = $itemname;
$phpPrice = $amount;
$phpOrder_id = $order_id;
$phpSku = $sku;
$phpQuantity = $quantity;
?>
// The argument list for _addTrans() and _addItem() is matched by position.
// While not all arguments are required, you should supply an empty placeholder for unspecified arguments to avoid errors.
var name = "<?= $product_name ?>";
var price = "<?= $phpPrice ?>";
var orderId = "<?= $phpOrder_id ?>";
var sku = "<?= $phpSku ?>";
var quantity = "<?= $phpQuantity ?>";

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-XXXXXXX-1']);
  _gaq.push(['_trackPageview']);
	_gaq.push(['_addTrans',
  	orderId,           // order ID - required
 	 	' ',  // affiliation or store name
  	'Total',          // total - required  replace with your variable or value of your Total
 	 	' ',           // tax
  	' ',              // shipping
  	' ',       // city
 	 	' ',     // state or province
  	' '             // country
	]);
	_gaq.push(['_addItem',
 	 orderId,           // order ID - required
 	 sku,           // SKU/code
 name,        // product name
 ' ', ,   // product category or variation
 	 price,          // unit price - required
 	quantity               // quantity - required
	]);
	_gaq.push(['_trackTrans']);

(function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
  </script>
<!-- the asynchronous google-analytics code End -->
</head>
<body>

Modify your identity token and your Google Analytics UA number and you should be good to go with the above code.

Within the content area of your page, add this code so the details of the transaction display properly:

<?php
echo ("<p><h3>Thank you for your purchase!</h3></p>");
echo ("<b>Payment Details</b><br>\n");
echo ("<li>Name: $firstname $lastname</li>\n");
echo ("<li>Item: $itemname</li>\n");
echo ("<li>Amount: $amount</li>\n");
echo ("");
?>

And just like that you’ll be up and tracking all transactions from PayPal within Google Analytics Ecommerce. Whew… done!

Curiously, we are working on a PayPal to Google Analytics Tracker Wizard that does the bulk of this coding for you. If you want to try it out on your site when it’s ready, subscribe and we’ll keep you posted.



If you enjoyed this post, make sure you subscribe to my RSS feed!

3 Responses to “How to Track PayPal Transaction Data in Google Analytics Ecommerce – Sample Code”

  1. RuudHein says:

    RT @tomshark How to Track PayPal Transaction Data in Google Analytics Ecommerce – Sample Code – via #twitoaster http://www.capturecommerce.com/blog/gene

  2. free paypal says:

    Wow I’ll be using this for sure! I didn’t know you could track data like this with Google Analytics

  3. brooks green silence says:

    Hey there, You have performed an incredible job. I will certainly digg it and in my view recommend to my friends. I am confident they’ll be benefited from this site.
    brooks green silence recently posted..1My Profile