E-mail open rate or E-mail tracking is a method for monitoring the e-mail delivery to intended recipient that to be one of the main data for email campaigns manager want to know. The E-mail tracking method is reference to a small 1×1 pixel image is inserted into the email sent. So, the E-mail open rate data cannot be considered an absolutely accurate indicator that a message was opened or read by the recipient because some email clients turn off images by default, so unless images are enabled, the tracking pixel won’t register, and thus the email won’t count as being opened.
Most e-mail marketing software provides tracking features, sometimes in aggregate (e.g. click-through rate), and sometimes on an individual basis. But if you have the ability to create a simple PHP page with a MySQL database, you can create a tracking system that can be as simple or as complex as you would like. You also need to know how to create the email subject and body content, and be able to send it using the “mail” function of your server. The body content will contain your email message, along with a line of tracking code like the code below:
<img border="0" src="http://yoursite.com/track.php?MailID=1111&SID=12345" width="1" height="1">
After that you need to create a simple script like below code and save as “track.php:
<?php header("Location: image.jpg"); $hostname = "localhost"; $username = "username"; $password = "password"; $database = "databse"; $now = time(); $date_added = date(“n/j/y”,time()); $MailID = $_GET['MID']; $SubscriberID = $_GET['SID']; $IP = $HTTP_SERVER_VARS['REMOTE_ADDR']; mysql_connect($hostname,$username,$db_password); @mysql_select_db($database) or die( “Unable to select database”); $query = “INSERT INTO email_table VALUES (”,’$date_added’,'$MailID’,'$SID','$IP’)”; mysql_query($query) or die( mysql_error() ); mysql_close(); exit; ?>
The main point of this post was simply how to track the email open rates. I hope this post will give you some ideas on how to do it and what you can actually track.