need help for tracking the URL clicks....

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

need help for tracking the URL clicks....

Post by abmm »

Hi everyone,

I'm a bit of an newbee with openemm and I am testing the system for my needs. At this moment I have a need that I cannot find. Please help.

I have followed these steps to track the clicks on the URL.

1.Define 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

Please help, as the requirement is very criticle.... :cry: :cry:
christian.lang
Posts: 30
Joined: Thu Apr 19, 2007 3:24 pm

...

Post by christian.lang »

Tracking how often a link in a Mailing has been clicked should be possible without defining a new numeric field or setting up a special action on the link.

Linktracking is done by OpenEMM as soon as the Link appears in the "Trackable Links" Section of the mailing-setup and tracking is enabled for the link.
In the Statistics Tab of the Mailing you should have a list that shows you how often somebody clicked on each tracked link.
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

Dear christian.lang,

Thanks for your prompt reply.

You have written "Tracking how often a link in a Mailing has been clicked should be possible without defining a new numeric field or setting up a special action on the link."

How is this possible....I have inserted the link as www.company.com in my HTML code.

I read in installation guide that for getting the statistics, we need to redirect the port from 8080 to 80 during installation. We haven't done this during installation. Can we get the automatic statistcs information without doing this step. Please help.
Thanks for your patience...
christian.lang
Posts: 30
Joined: Thu Apr 19, 2007 3:24 pm

...

Post by christian.lang »

Links always must be definied as http://www.mylink.com in Text and <a href="http://www.mylink.com">mylink</a> in HTML.
You must not forget the "http://" in the link!

If your links are correctly defined in the Text / HTML Area of the mailing they should show up in the "Trackable Links" Tab.

Redirection must be configured in the company_tbl where you have to define your Mailserver's Domainname instead of http://rdir.de/
For example this could be http://newsletter.youcompany.com:8080/
It doesn't matter whether you use Port 8080 or Port 80 for this.
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

Dear Christian.lang,

Thanks for your prompt reply.....

The links are written in HTML code....with "http://".....(also as suggested by you)....Also the company_tbl has been configured with our company mailserver's domainname....but still the statistics are not displayed....:(



We want to track the links in as given in the code...I'm pasting here my entire code for your reference....please help me out in solving this issue...as the requirement is very critical.....

-------------------------------------------------------------------
<!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">
<!--
body {
background-color: #CCCCCC;
}
-->
</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"><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">&nbsp;</td>
</tr>
<tr>
<td width="12" height="288">&nbsp;</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&rsquo;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 >&nbsp;</td>
</tr>
<tr>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</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">&nbsp;</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">&nbsp;</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 &ndash; 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,11,400,43" href='http://www.impetus.com' target="_blank" alt="">
</map></body>
</html>
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

Dear Christian.lang,

Can you please provide any views on this....any help/inputs from you would be appreciated...thanks for your time and patience...
christian.lang
Posts: 30
Joined: Thu Apr 19, 2007 3:24 pm

...

Post by christian.lang »

Hello,

When you are sending your mailings - how do the links look like in the mail?

The links should look like
http://youropenemmserver.yourdomain.com ... 2z.m1ti33v instead of http://www.impetus.com
(you can see this in the text version of a mailing more easily than in the HTML version)

best regards,

Christian
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

Dear Christian,

Thanks a lot for all your help to solve my issues.

Now the click statistics is automatically displaying in the statistics tab. The only change i made is I gave all the HTML in double quotes i.e "".

Earlier I had given in single quotes.

But this is not what i'm expecting. I want to track who has clicked on which link, the number of clicks on a particular link, name of the user who has opened the mail...these featues will help me in analysis and marketing perspective.

Can you please let me know is there any process we need to follow for tracking these user behaviour...I believe (not sure) we can do it using Actions. Please let me know if I'm on the right track...If it is done using Actions...can you please suggest me with an example....It would be a great help to me...

Thanks again for all your efforts and patience...
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

I meant, I changed all HTML links into double quotes....
christian.lang
Posts: 30
Joined: Thu Apr 19, 2007 3:24 pm

Post by christian.lang »

abmm wrote:Can you please let me know is there any process we need to follow for tracking these user behaviour...I believe (not sure) we can do it using Actions. Please let me know if I'm on the right track...If it is done using Actions...can you please suggest me with an example....It would be a great help to me...
You are right - it can be done using actions.
Just create additional fields in the User-Table for each of the Links you want to track. Create an Action which for example adds +1 to the field and add this action to the link you want to track.
Quite difficult option but - as far as i know - thats what the OpenEMM backend offers ...

Other option (requires MySQL Knowledge): rdir_log_tbl logs which customer clicked a link (and tells you the mailing, date/time and the Ip-address in addition!)
Warning: You should carefully check whether this is in conflict with any of your countries laws on data protection / privacy
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

Dear Christian,

Thanks again for all your help.
I have implemented the first option as you suggested...its working perfectly.....

What I was worried was every time we send a email with 'n' links in HTML code, we need to create n number of fields in the user table....

This way...it will increase the number of fields in the user table with every mail we send.......i have not solution for this except deleting the existing fields before send the new email...

I was planning to keep all the results of the previous emails...

Is there any other way...to solve this issue...I appreciate your time and efforts in answering my doubts...I want to confirm with some experienced person like you for implementing the correct solution...
christian.lang
Posts: 30
Joined: Thu Apr 19, 2007 3:24 pm

...

Post by christian.lang »

I would basically suggest using the rdir_log_tbl ... even tough OpenEMM doesn't offer backend statistics for this, the effort of writing an external script (php [...]) for analyzing this seems to be less work for me than creating fields and actions for every mailing.

If you have experience with Java/JSP/[...] you could also do this within OpenEMM (see OpenEMM directory /webapps/core/stats).

By the way: By using additional fields and actions you can also use that tracking-information as a selection criteria when sending a mailing.
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

Dear Christian,

As you said, If you have experience with Java/JSP/[...] you could also do this within OpenEMM (see OpenEMM directory /webapps/core/stats).

I have created a JSP page and copied into the respective path in Openemm (OpenEMM directory /webapps/core/stats). But it is not recognizing the JSP page...and giveing an error "Page not found".....is there any permissions we need to set to execute the page .....is there any other trick...which I might be missing...please suggest...

Thanks in advance for all your help...
christian.lang
Posts: 30
Joined: Thu Apr 19, 2007 3:24 pm

...

Post by christian.lang »

I am sorry, I don't have that much knowledge in this area :(
Last edited by christian.lang on Wed Apr 02, 2008 6:15 am, edited 1 time in total.
abmm
Posts: 12
Joined: Fri Mar 14, 2008 10:30 am

Post by abmm »

Dear Christian,

Thanks a lot for all your help and patience in solving my queries...

Regards,
abmm
Post Reply