listmonk icon indicating copy to clipboard operation
listmonk copied to clipboard

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

Open dev-cb opened this issue 1 year ago • 3 comments

Version

  • listmonk: [eg: v3.0.0]
  • OS: [e.g. Ubuntu]

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 avatar Mar 25 '24 10:03 dev-cb

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

dev-cb avatar Mar 25 '24 11:03 dev-cb

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.

andreagdipaolo avatar Jun 11 '24 20:06 andreagdipaolo