Ghost 3.39.0 Ubuntu 18.04 I have sent many newsletters, the value of the opened / read emails is always 0%, I have entered several of my emails as members receiving the newsletter, to test this functionality. With all my accounts I have opened and read the newsletter, the value is always 0%. Wha…

Yep, that error is the problem. Bugfix has just been released in 3.39.2, please let me know how things go after the upgrade! :slight_smile:

@n1n10 can you share some details about your environment? Which database are you using, and if it’s mysql which version?

@Kevin I am using mysql database with the following output of mysql -V: mysql Ver 14.14 Distrib 5.7.32, for Linux (x86_64) using EditLine wrapper

@n1n10 can you check your email_recipients table for one of your recent emails to see if it has opened_at timestamps present? If it does then it’s indicating that the aggregation is failing somehow :thinking:

@Kevin The “opened-at” timestamps for all emails are NULL.

@n1n10 are there timestamps in any of the email_recipients rows for delivered_at / failed_at?

@Kevin Sorry it went at bit fast. There are nine opened_at timestamps (which equals the 2 percent I mentioned earlier - see attachment with mouse over) 12 failed_at and maybe a couple of hundred delivered_at But the last three days is just NULL [Skærmbillede 2020-12-11 kl. 16.28.56]

[image] n1n10: But the last three days is just NULL Which is just null? All of the fields or just the opened_at fields?

All three are null: opened_at failed_at and delivered_at

Hi @Kevin Just a small update. Saturday afternoon —out of the blue — some of the opening rates began appearing. But it has stopped again. Any idea what causes this? [Skærmbillede 2020-12-14 kl. 20.49.51]

As an aside, and briefly glancing over this thread I don’t think it was mentioned here, but I have had Mailgun open analytics off for some time. The problem for me was not that it wasn’t tracking opens, but that, when members were getting emails sent to them for logging in, the link was prepended wi…

Enable newsletter open-rate analytics doesn't work

Developer help

tomotvos April 25, 2021, 1:15am 31

Apparently the “private key” and the sending key are different. It is important to use an API key, as noted in this newer thread:

Topic		Replies	Views
How to troubleshoot email open rate being 0%? Developer help	27	3651	June 1, 2022
Open rate does not show in Ghost (but does in Mailgun) Self-hosting	3	953	January 12, 2022
Open rate stuck at a low number Memberships & subscriptions	3	1019	January 2, 2023
Anyone else having problems with newsletter analytics? Using Ghost	9	779	July 18, 2023
I don't see the number of opens of the posts I mailed to subscribers Memberships & subscriptions	3	549	March 22, 2021

Enable newsletter open-rate analytics doesn't work

Related topics