Page 1 of 1

open-rate statistics

Posted: Mon Nov 10, 2008 2:14 pm
by PFX
Hello everybody,

I got a question regarding the open-rate statistics (OpenEMM 5.5.1 on WinXP).

It only gives me some of the mail-domains. E.g. There have been 98 recipients downloaded the "tracking-pixel" but it only shows me 48 domains. The rest is only listed as figure: "Others: 50"

How do I see every single domain from which the tracking-pixel was downloaded?

Thanks in advance. And thanks for a great product.

Best,
PFX

Posted: Tue Nov 11, 2008 10:36 am
by maschoff
Only the top domains are listed in the frontend. If you want to dig deeper you need to manually access the database with a SQL select statement.

Posted: Wed Jan 21, 2009 7:20 am
by percivalg
Im having the same problem
can you specify which table on the database to select to, to get the other domains?


thanks

Posted: Wed Jan 21, 2009 8:35 am
by maschoff
You can find more information on the OpenEMM database schema here:

http://www.openemm.org/fileadmin/docs/O ... le-Doc.txt

Re:

Posted: Thu Apr 18, 2013 10:07 pm
by Liam
maschoff wrote:You can find more information on the OpenEMM database schema here:

http://www.openemm.org/fileadmin/docs/O ... le-Doc.txt
Link is broken.

Re: open-rate statistics

Posted: Fri Apr 19, 2013 5:59 am
by maschoff
Download extension development guide from SourceForge and have a look at appendix A:
https://sourceforge.net/projects/openem ... velopment/

Re: open-rate statistics

Posted: Thu Jul 18, 2013 10:19 am
by gregor
Hi, As a (relatively) non tech user is there any way to see this information. For us to view the users that have open the email is a key requirement- I am surprised it not part of the interface?
I noticed plugins for the product - has anyone written one to show better reporting?

thanks

Re: open-rate statistics

Posted: Thu Jul 18, 2013 10:34 am
by maschoff
If you want to track openings individually you have to define an "open action" in tab "trackable links" which sets a flag in a profile field of the recipient.

Re: open-rate statistics

Posted: Wed Oct 02, 2013 9:56 am
by blackrose
Im having the same problem
can you specify which table on the database to select to, to get the other domains?

Re: open-rate statistics

Posted: Wed Oct 02, 2013 10:27 am
by maschoff
You can find a documentation of the OpenEMM database schema in the appendix of the Extension Development Guide.