Tracking accurate.

[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]

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

[hugueshabert]

Hello,

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

[maschoff]

In this case you have to query the database directly.

[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]

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