(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 track PayPal orders. 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 tracking the PayPal transaction ID from PayPal and properly feeding it into Google Analytics. I’m going to show you how to track PayPal transactions in Google Analytics Ecommerce, 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!


Yulia Solodky
Yulia Solodky

Yulia Solodky is a Java programmer with Capture Commerce and enjoys working at the beach.

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

    • RuudHein

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

    • free paypal

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

    • brooks green silence

      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.

Comments are closed.