Email tracking
With AB Bulk Mailer you can gain a precise understanding of what is happening to your messages and what part of your newsletter is of greater interest to the subscribers. Web tracking makes it possible to view opens, clicks-through, and the recipient's IPs. There is no need to substitute your regular links to tracking ones. When you switch on email tracking, all links are interchanged automatically.
You can use Google Analytics to track your mails. Now, lets us see how tracking is implemented in AB Bulk Mailer. If you have your own website you can track opens. We recommend not using tracking as it affects email delivery.
Still if you want to use it, please follow below steps:-
Step 1:Go to your web panel of your website, go to phpMyAdmin , create a mySQL server database, and then create a table in it using below script:-
CREATE TABLE `opentracking` (
`eid` varchar(64) NOT NULL DEFAULT '',
`ipaddr` varchar(16) NOT NULL DEFAULT '',
`atime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Practically you can have any database like Oracle, sybase etc, but the above fields are required.
Step 2: Go to Message in AB Bulk Mailer and click Edit HTML link in it and type below at the bottom:-
IMG src="http://mysite.com/tracking/getPicture.php?eid=[emailAddress]"
Step 3: Open getPicture.php and view.php, and replace localhost, databaseName, databaseUser, databasePassword by
IP of your server/localhost, name of database, database user attached to the database, database password respectively.
After making the changes upload the getPicture.php, view.php and logo99.jpg to your website in say tracking folder.
Assume you uploaded it to http://www.mysite.com/12/tracking
After doing the above one time activity, to view number of opens any time, Please open below link in your browser:- http://www.mysite.com/12/tracking/view.php Replace mysite.com by your website name. The sample php files can be seen in Tracking tab in Messages.