Strange behavior with tracking views/clicks

[Krikooo]

Hello Dev Team.

First, thank you for your awesome software! It's very efficient and lightweight, KISS, love it!

We use it as our main mailing tools and newsletter!

I just have an interrogation about the count of the view and the click. I understand that it's "simply" a pixel inside the mail (with the "id" of the subscriber in the url of the pixel), and if the user load it, he count as one view.

So a if a same user load it several time, it counts as several views.

But following if the Individual subscriber tracking parameters is on or off, the count of views is very different:

(We're using redash for dataviz, and redash is connected to the listmonk database).

So between the newsletter 178 and 180 we change the parameter Individual subscriber tracking to yes (or checked) and we observed a huge peak of the views (column Mails ouverts).

We know that the views are counted everytime a user load the pixel. So we have also the column Reach Users to have the tracking by users (even if a user load several times the pixel, is still count as one).

Today we decide to uncheck the Individual subscriber tracking and we retrieve our precedent view rate.

So we are not really sure about the analytics part of listmonk and we don't know if the tracking is working or not?

Our version of listmonk is 3.0.0.

You can find our request SQL here to:

SELECT
    campaigns.id,
    TO_CHAR(campaigns.updated_at, 'YYYY-MM-DD') AS "Date d'envoi",
    TO_CHAR(campaigns.updated_at, 'Day') AS "Jour d'envoi",
    TO_CHAR(campaigns.updated_at AT TIME ZONE 'UTC-1', 'HH24:MI') AS "Heure d'envoi",
    CONCAT(
            ROUND(
                    COUNT(DISTINCT views.id) * 100.0 / campaigns.sent,
                    2
            ),
            '%'
    ) AS "Taux d'ouverture",
    COUNT(DISTINCT clicks.id) AS "Nombre de clics",
    CONCAT(
            ROUND(
                    COUNT(DISTINCT clicks.id) * 100.0 / campaigns.sent,
                    2
            ),
            '%'
    ) AS "Taux de Clic",
   COUNT(DISTINCT bounces.id) as "Bounces",
    campaigns.subject,
    campaigns.sent,
    COUNT(DISTINCT views.id) AS opened_count,
    COUNT(DISTINCT views.subscriber_id) AS reached_users_count
FROM campaigns
LEFT JOIN campaign_views views ON views.campaign_id = campaigns.id
LEFT JOIN bounces ON bounces.campaign_id = campaigns.id
INNER JOIN campaign_lists lists ON lists.campaign_id = campaigns.id
LEFT JOIN link_clicks clicks ON campaigns.id = clicks.campaign_id
WHERE lists.list_id = {{ newsletter_id }}
  AND campaigns.updated_at BETWEEN '{{date_range.start}}' AND '{{date_range.end}}'
GROUP BY campaigns.id, campaigns.updated_at
ORDER BY campaigns.updated_at DESC;

[Krikooo]

Hello any update on this request 🙏?

[Krikooo]

Hello guys. Happy new year :) Any news ?

[prakashoriga]

View tracing is no working for me. Kindly update on the same. Some of the campaign the click and sent count also giving wrong figures. also provide to enable this do i need to do any changes on settings.

[candidexmedia]

Potentially related: https://github.com/knadh/listmonk/issues/1025

See also: https://discuss.whatever.social/r/selfhosted/comments/zp089g/comparison_of_ui_options_for_bulk_email_sending/

[github-actions[bot]]

This issue has been marked 'stale' after 90 days of inactivity. If there is no further activity, it will be closed in 7 days.

[Krikooo]

up

[etranger7]

@prakashoriga if you're getting zero views, I'd suggest making sure you included {{ TrackView }} in the template that you're using. Without it, it won't track views at all.

[github-actions[bot]]

This issue has been marked 'stale' after 90 days of inactivity. If there is no further activity, it will be closed in 7 days.