search

knadh / listmonk

High performance, self-hosted, newsletter and mailing list manager with a modern dashboard. Single binary app.
https://listmonk.app
GNU Affero General Public License v3.0
13.93k stars 1.25k forks source link

Campaign analytics data is cutoff, but no possible explanation why. #1795

Open dev-cb opened 3 months ago

dev-cb commented 3 months ago

Version

Description of the bug and steps to reproduce Noticed that the analytics data seems incorrect: A campaign was started and finished on the same day (March 11). Correctly stated in the campaign overview, as well as in the campaigns table in the database. But looking at the analytics (/admin/campaigns/analytics?id=15) the data starts from March 18. Changing the date range also doesn’t make a difference.

Several scheduled campaigns where running in parallel. All the same template though, but different contact lists.

Screenshots

Bildschirmfoto 2024-03-25 um 11 39 43 Bildschirmfoto 2024-03-25 um 11 35 48 Bildschirmfoto 2024-03-25 um 11 36 50
dev-cb commented 3 months ago

Also in the database I checked in the data tables link_clicks and campaign_views for this specifics campaign_id, and there is data (using SELECT * FROM campaign_views WHERE campaign_id = 15;):

Bildschirmfoto 2024-03-25 um 12 02 13 Bildschirmfoto 2024-03-25 um 12 03 31
andreagdipaolo commented 3 weeks ago

I noticed a cutoff in my data too, but in my case it seems to be nine days. If I set a different date from the default one in the calendar it simply won't update the grahp. I don't know if it can be a related problem.