Is there a way to track which recipients opened the e-mail

Jeffrey Zimmerman · Post by **Jeffrey Zimmerman** » Sun Dec 09, 2007 3:09 am

OpenEMM tracks the number of times an e-mail was opened and I have implemented that feature, but I would like a list of recipients who opened the e-mail. I know this can be done with a trackable link, but that is not the same as opening the e-mail.

Any ideas?

kevin_s · Post by **kevin_s** » Mon Dec 10, 2007 3:43 pm

According to The documentation for OpenEMM's database tables, onepixel_log_tbl contains a row for every recipient that opened a mailing, so it should have all the data you require.

abmm · Post by **abmm** » Wed Mar 19, 2008 1:12 pm

Hi,

I'm newbie to openemm, facing an issue in tracking links in HTML code...I have implemented all the steps that are given in the user manual...

i have followed these steps to count the clicks on the link.

1.Defined a new numeric data field "clickcount" with default value 0 and length 3.
2. Set up an action "link feedback" which sets the content of the field "clickcount" to 1 to actually count link clicks.
3. When creating a mailing, i have used the "trackable links" tab to connect action "link feedback" with the link to monitor clicks.

This is of no help....The statistics does not show any click records

I searched my database tables too. I realised that "rdir_log_tbl" is not showing any records...is that the reason for not displaying any click statistics....

please help me in this regard....
my HTML code is
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>
<title>Info@Impetus January 2008!</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">

</style></head>

<body >
<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>
<td align="center"><table width="700" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#ebf3f9">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" height="808" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="288" height="117" bgcolor="#FFFFFF"><img src="http://www.impetus.com/newsletter/img-jan08/dot.gif" width="288" height="1"><a href='http://www.impetus.com' target="_blank" onClick='http://192.168.150.116:8080/form.do'><img src="http://www.impetus.com/newsletter/img-jan08/pic1.gif" alt="Impetus Technologies" width="288" height="117" border="0"></a></td>
</tr>

<tr>
<td height="567" valign="top" background="http://www.impetus.com/newsletter/img-j ... if"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><br> <br></td>
<td width="12"> </td>
</tr>
<tr>
<td width="12" height="288"> </td>
<td width="264"> <div align="justify" style="font-family: Verdana;font-size: 11px; line-height:14px;color: #FFFFFF;
margin-left: 5px; margin-right: 5px;" > 2007 was an action packed year for Impetus...<br>
<br>
We started off the year at a high-note with Impetus declaring a 75% revenue growth. In May, our organization won the "Best Software Exporter" Award instituted by the Madhya Pradesh government. We were listed among the Top-100 IT companies by the Silicon India magazine and were recognized by Nasscom in the Nasscom’s Top 100 IT Innovators of 2007. The year ended with IMA felicitating our CEO, Mr. Praveen Kankariya with the GenNext Leadership Award. <br>
<br>
We hope to carry on with our winning spree in 2008 as well!<br>
<br>
</div></td><td > </td>
</tr>
<tr>
<td colspan="2"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> <div align="justify" style="font-family: Verdana;font-size: 11px; line-height:14px;color: #FFFFFF;
margin-left: 5px; margin-right: 5px;" > <br>
It is our constant endeavor to serve the under-privileged , in whichever way we can. As one of our recent initiatives, Impetus donated books and study material to an underprivileged neighborhood for the benefit of a few students who were preparing for Pre-Engineering and Pre-Medical exams. These students were working as domestic-help or earned their living by washing cars, while also attending school in the evenings. We are happy to share with you that two of these children cleared their Pre-engineering exam and one has got through the Pre-Medical exam.
<br>
<br>
We also conducted an year-end charity drive within our office. Our employees donated books, stationery, clothes, toys, medicines, utensils, furniture, winter wear, blankets, bed-spreads, food items etc. to the under-privileged. We tied up with local NGOs to ensure that the donations reach those who would actually benefit from them. <br>
<br>
We hope to continue sharing our happiness and success through a variety of such big and small initiatives. <br>
<br>
<br>
<div> </div>
</div></td>
<td class="textWhite-1"> </td>
</tr>
</table></td>
</tr>

</table></td>
<td width="100%" valign="top" bgcolor="#FFFFFF"><table width="28%" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="412"><img src="http://www.impetus.com/newsletter/img-jan08/pic2.gif" alt="www.impetus.com" width="412" height="55" border="0" usemap="#MapMap"></td>
</tr>
<tr>
<td><img src="http://www.impetus.com/newsletter/img-jan08/header.jpg" width="412" height="174" border="0"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="textWhite-1"><img src="http://www.impetus.com/newsletter/img-jan08/dot.gif" width="1" height="10"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img src="http://www.impetus.com/newsletter/img-jan08/title1.gif" alt="Introducing Performance Engineering labs" width="321" height="23" hspace="15"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="left" style= "line-height:15px; font-family: Verdana; font-size: 11px;color: #676863; text-align: justify; margin-right: 20px; margin-left: 20px; margin-top: 5px;" > Performance Engineering encompasses the set of roles, skills, activities, practices, tools, and deliverables applied at every phase of the System Development Lifecycle. This ensures that a solution will be designed, implemented, and operationally supported to meet the non-functional requirements defined for the solution.<br>
<br>
This focus group has been formed with a vision to reduce risk and improve cost effectiveness in the lifecycle of products as well as engineering services. The team works on creating utilities/tools to offer services in the following areas like : Performance sizing and testing, System diagnostics, Capacity planning, Server health monitoring, Performance centric development, Client side performance and Load Patterns identification. <br>
<br>
Performance Engineering Group offers deep expertise in Performance testing; Architecture, Code and Design optimization; Health Monitoring for various Applications, Web, and Database servers.<br>
<br>
</div></td>
</tr>
<tr>
<td background="http://www.impetus.com/newsletter/img-h ... 8/dots.gif" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img src="http://www.impetus.com/newsletter/img-jan08/title2.gif" alt="The Family's Growing" width="321" height="23" hspace="15"></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><div align="justify" style= "line-height:15px; font-family: Verdana; font-size: 11px;color: #676863; text-align: justify; margin-right: 20px; margin-left: 20px; margin-top: 5px;">
We are all set to welcome new members in the rapidly burgeoning Impetus Family. <br>
<br>
More than 80 campus graduates are joining the company this January in our Noida and Indore facility. We wish these youngsters all the best in their career path and hope they will have a rewarding stint at Impetus.<br>
<br>
We also welcome Rajeeva Gupta, our new V.P. Engineering and Dr. Nitin Agarawal, Associate Vice President – Product Strategy to the Impetus family. They both have individual experience of close to 20 years, and are well respected names in the IT industry. To view their profiles, visit<br>
<a href='http://www.impetus.com/leadership.html' target="_blank" style="text-decoration: underline; color: #990000;">http://www.impetus.com/leadership.html</a>. <br>
</div></td>
</tr>

</table>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="45" background="http://www.impetus.com/newsletter/img-j ... if"><table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>
<td width="65%" ><div align="center" style="font-family: Verdana;font-size: 11px;color: #FFFFFF;
margin-top:8px;" > For suggestions and feedback,
write to <a href="mailto:marcom@impetus.co.in" style="text-decoration: underline; color: #FFFFFF;">marcom@impetus.co.in</a><br>
</div></td><td width="35%" height="40" align="center" valign="middle" class="textWhite-1"><div align="left" style="font-family: Verdana;font-size: 11px; line-height:14px;color: #FFFFFF;
margin-left: 5px; margin-right: 5px; margin-top: 5px;" ><img src="http://www.impetus.com/newsletter/img-j ... -bulet.gif" width="6" height="6" hspace="3"> <a href='http://192.168.150.116:8080/form.do?agn ... ID=[agnUID]' style='text-decoration: underline; color: #FFFFFF;'>Click here to Unsubscribe</a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>

<map name="Map"><area shape="rect" coords="232,10,396,43" href='http://www.impetus.com' target="_blank">
</map>
<map name="MapMap">
<area shape="rect" coords="239,1,400,33" href='http://www.impetus.com' target="_blank" alt="">
</map></body>
</html>

Post by **maschoff** » Wed Mar 19, 2008 3:40 pm

abmm, have you set up the redirect service properly so that link clicks are visible in the statistic view? If not, see install guide for explanation.

abmm · Post by **abmm** » Fri Mar 28, 2008 6:33 am

Dear ma,

Thanks for your prompt response....now I'm able to view the click statistics...

The only change I did is....i gave all the HTMl links in double quotes i.e. ""...earlier i had given in single quotes....may be that was the trick....

However...I'm looking for statistics like which user has opened the mail....who has clicked on a particular link in a mail and how many times...

Can you please let me know ...is there a way of doing this....Please help...

Thanks in advance for your help and patience...

OpenEMM Technical Support Forum

Is there a way to track which recipients opened the e-mail

Is there a way to track which recipients opened the e-mail

counting link clicks