OpenEMM Technical Support Forum

Posted: **Wed Sep 26, 2012 10:55 am**

Hello,

I'm French and I use google translate to write to you!

Currently, in order to know the people who clicked on links in my mail (Tracking), I use actions. However, this does not allow me to know what time people have clicked. Do you have a solution for this?

Then I would like to know if it is possible to know the time spent on the site by users who clicked on the link! With a plug-in or otherwise.

Thank you in advance

Hugues

Posted: **Thu Sep 27, 2012 8:59 pm**

if you drill down into the mailing statistics they show you mail openings and clicks by day and by the hour.

Posted: **Thu Oct 04, 2012 8:59 am**

Hello,

Thank you for your answer. However, this does not indicate that, but how!
I want the identity of each person!

Posted: **Fri Oct 05, 2012 11:57 am**

In this case you have to query the database directly.

Posted: **Thu Apr 18, 2013 9:45 pm**

Which database table? This would sometimes be useful.
Okay, I figured it out. Here it is.

Code: Select all

select cust.email from onepixel_log_tbl onepix, customer_1_tbl cust where onepix.mailing_id=34 and cust.customer_id=onepix.customer_id order by cust.email;

Note that the mailing id needs to be set to your mailing. In this case it is 34.

Posted: **Fri Apr 19, 2013 5:58 am**

The extension development guide provides a documentation of the OpenEMM DB schema in its appendix.

OpenEMM Technical Support Forum

Tracking accurate.

Tracking accurate.

Re: Tracking accurate.

Re: Tracking accurate.

Re: Tracking accurate.

Re: Tracking accurate.

Re: Tracking accurate.