View and click details by subscribers

[mrhydejc]

Is your feature request related to a problem? Please describe. I need to know which subscribers open/click a campaign. (linked to https://github.com/knadh/listmonk/issues/473)

Describe the solution you'd like A CSV export could do the job. When Individual subscriber tracking is enable, add an export button in analytic view, just below the view's graph and the click's graph. View export : Click export :

[charlesmudy]

+1 for this, the overall views and clicks is great but no context to it, knowing the individual subscribers that clicked, viewed a campaign will be great

[charlesmudy]

@knadh @mrhydejc this is what I managed to do and looks quite ok.

` WITH camps AS ( SELECT subscriber_id, COUNT(CASE WHEN subscriber_id = null THEN 0 ELSE 1 END) AS views FROM campaign_views WHERE campaign_id = 586 GROUP BY subscriber_id ),

links AS ( SELECT subscriber_id, COUNT(CASE WHEN subscriber_id = null THEN 0 ELSE 1 END) AS clicks FROM link_clicks WHERE campaign_id = 586 GROUP BY subscriber_id )

SELECT subscribers.id, subscribers.email, camps.views, links.clicks FROM camps, links, subscribers WHERE camps.subscriber_id = links.subscriber_id AND camps.subscriber_id = subscribers.id AND links.subscriber_id = subscribers.id `

[mrhydejc]

@charlesmudy take a look at this PR : https://github.com/knadh/listmonk/pull/689

[niraj-ranjan-comprinno]

@mrhydejc Hi, Above query is failing in scenario like Suppose no one clicked the link but view the compaign

[c-seeger]

Upvote. In Settings there is an option for individual subscriber tracking but I can't find a visualisation for this