search

putyourlightson / craft-campaign

Send and manage email campaigns, contacts and mailing lists in Craft CMS.
https://putyourlightson.com/plugins/campaign
Other
64 stars 24 forks source link

Reporting Calculations Off? #410

Closed adrianjean closed 1 year ago

adrianjean commented 1 year ago

I just sent a campaign out and was watching the numbers roll into the report. After the send was complete I looked at the report in Craft Campaign, and compared it to the report I get from SendGrid and noticed that Campaign was only recording half the traffic.

In the attached screenshot, you can see the graph is showing higher numbers (these numbers jive with SendGrid) but if you look at the calculated numbers below, they are far lower, almost half as much as the chart.

For example, in the graph I see there were 902 opens within the first hour alone... yet in the calculated value below (which I assume is the aggregate) I see only 861 opens. Same thing with clicked, etc.

Is it possible there is a bug in the calculated values?

Screenshot 2023-08-23 at 3 50 13 PM
bencroker commented 1 year ago

Can you please provide the plugin and Craft version numbers that your site is running?

The reason I ask is that 2.1.11 fixed a bug in which inconsistencies could occur in campaign reports and 2.4.0 added the campaign/reports/sync console command that syncs campaign reports.

adrianjean commented 1 year ago

Ack! — forgot to add that. Here you go:

CraftCMS Pro: 4.4.17 Campaign: 2.8.4

AHA! — I ran php craft campaign/reports/sync and that solved it!!

bencroker commented 1 year ago

Great! The stats can get out of sync, although I’ve taken measures to avoid that as much as possible. If it happens again then please do let me know and I’ll revisit it.

adrianjean commented 1 year ago

Will do! — Thank you!!