Tracking accurate.

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

hugueshabert
Posts: 2
Joined: Wed Sep 26, 2012 10:42 am

Tracking accurate.

Post by hugueshabert »

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
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Tracking accurate.

Post by maschoff »

if you drill down into the mailing statistics they show you mail openings and clicks by day and by the hour.
OpenEMM Maintainer
hugueshabert
Posts: 2
Joined: Wed Sep 26, 2012 10:42 am

Re: Tracking accurate.

Post by hugueshabert »

Hello,

Thank you for your answer. However, this does not indicate that, but how!
I want the identity of each person!
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Tracking accurate.

Post by maschoff »

In this case you have to query the database directly.
OpenEMM Maintainer
Liam
Posts: 9
Joined: Mon Oct 22, 2007 8:08 pm

Re: Tracking accurate.

Post by Liam »

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.
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Tracking accurate.

Post by maschoff »

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