Statistics: is it possible to check which subscribers open the newsletter [#1618234]

I would like to check which subscribers are regularly opening the newsletter and whichones never do (so I can delete them after time).

Is it possible to create a custom view (Views) to gather such data? (as far as I can see now in the statistics tab there is only the percentage and no individual subscribers).

Comments

Comment #1

ParisLiakos CreditAttribution: ParisLiakos commented 18 June 2012 at 15:58

Component:	User interface	» Code
Category:	support	» feature

Well the functionality is there, all that needed to be done for this feature to work is actually make database aware of individual subscriber statistics..
it would be pretty easy to add, i intend to add this when i find some time:)
till then any help/patch is appreciated

Comment #2

dreamingX CreditAttribution: dreamingX commented 29 June 2012 at 23:42

Any pointers on where to start would be very appreciated ;)
I guess that for the percentage to work there needs to be some checking of the individual subscriber (ie if the person already opened the newsletter in question - and then setting to true if it is the first time.. )

Anyway, looks like I will have to byte in to this, so again: hints, pointers etc.
(can I use Views to generate a list of subscribers?)

Comment #3

ParisLiakos CreditAttribution: ParisLiakos commented 30 June 2012 at 16:07

http://drupalcode.org/project/newsletter.git/blob/630f33c:/includes/news...

this function triggers when a subscriber opens the newsletter..and subscriber data are already there
So what we need here

A new seperate table i guess that gather opens per subscriber:
Something like this:
Subscriber id (INT)
Newsletter id (INT)
when this function triggers insert to this new table the newsletter id and the subscriber id..both of them are available in this function
register this tables in to views and voila! you can now know whether a subscriber open specific newsletter

thats it.. would take me just a few hours, but i am very busy latest days and use my free time to actually rest