Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Something Wrong With my Analytics? #571

Closed
Pythorus opened this issue Nov 5, 2021 · 7 comments
Closed

Something Wrong With my Analytics? #571

Pythorus opened this issue Nov 5, 2021 · 7 comments
Labels
question Further information is requested

Comments

@Pythorus
Copy link

Pythorus commented Nov 5, 2021

I sent out a campaign today and the moment the campaign status changed from 'Sending' to 'Finished' I saw 79 views already.
Something feels wrong to me.
Analyanomaly
Please let me know if I have done something incorrectly.
@knadh
Copy link
Owner

knadh commented Nov 5, 2021

Nothing in listmonk will generate view counts. They can only come from client side e-mail views. Maybe there are bots hitting the view pixel somehow? You can check the campaign_views table to see if all hits have come from a single subscriber.

@knadh knadh added the question Further information is requested label Nov 5, 2021
@Pythorus
Copy link
Author

Pythorus commented Nov 5, 2021

@knadh Where is the campaign views table?

@knadh
Copy link
Owner

knadh commented Nov 5, 2021

Postgres database table. SELECT * FROM campaign_views;

@Pythorus
Copy link
Author

Pythorus commented Nov 5, 2021

@knadh Really sorry but where can I find that? I'm using LM on Heroku. Is it on LM itself or do I go back to Heroku?

@knadh
Copy link
Owner

knadh commented Nov 5, 2021

Ah, sorry. I assumed you would have hands on access to the database. There is no easy way to find out without that.

PS: A granular view/click report on the admin UI will be available in a future release.

@Pythorus
Copy link
Author

Pythorus commented Nov 5, 2021

@knadh Okay, man. Thanks

@NicoHood
Copy link
Contributor

NicoHood commented Nov 5, 2021

This might be the reason for your issue:
#561

@knadh knadh closed this as completed Nov 5, 2021
@marcinkunert marcinkunert mentioned this issue Jan 25, 2022
Closed
knadh added a commit that referenced this issue Feb 1, 2022
@knadh
Refactor campaign analytics to show unique / non-unique data.
2614b07 
The analytics page showed non-unique counts for views and clicks which
was misleading and source of confusion: #522, #561, #571, #676, #680
This commit changes this behaviour to pull unique views and clicks when
individual subscriber tracking is turned on in settings, and non-unique
counts when it is turned off (as `subscriber_id` in `campaign_views`
and `link_clicks` will be NULL, rendering unique queries dysfunctional).

This commit changes the stats SQL queries to use string interpolation
to either to SELECT `*` or `DISTINCT subscriber_id` on app boot based
on the setting in the DB. This involves significant changes to how
queries are read and prepared on init.

- Refactor `initQueries()` to `readQueries()` and `prepareQueries()`.
- Read queries first before preparing.
- Load settings from the DB using the read settings query.
- Prepare queries next. Use the privacy setting from the DB to apply
  string interpolation to the analytics queries to pull
  unique/non-unique before preparing the queries.

On the UI:
- Show a note on the analytics page about unique/non-unique counts.
- Hide the % donut charts on the analytics page in non-unique mode.

Closes #676, closes #680
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@knadh @NicoHood @Pythorus