We send a triggered email via Discourse to all users when a new topic is posted by an admin in a specific section. I assume some users are unsubscribing from these triggered emails and/or changing their email preferences upon receiving the email.
Is there a way to track the number of unsubscribes?
You could use the data explorer plugin to search which users are not watching the category.
Good question, any thoughts here @sam?
Not at the moment but I think a report (and tracking) of where the atomic unsubscribe comes from is interesting
Hi again.
We were able to use the data explorer plugin to find the users who are no longer watching the category (thanks @pfaffman!). We would also like to find the users who unsubscribe by clicking on “To unsubscribe from these emails, click here” and then selecting “Don’t send me any mail from Squarespace Circle Forum”
Do you have any insight on the best way to query the results for the don’t send me any mail folks?
CC: @Emaddy
我找不到更多关于这个的近期讨论……
我也觉得原子退订的报告和跟踪会很有趣。
我已经有了数据浏览器查询来列出已退订摘要的用户。但是：
这似乎是一个合法的全新功能请求，如果确实无法查看有多少电子邮件地址因为收到 Discourse 站点的电子邮件而退订。我将把它移到 Feature 以便讨论。
我已经将该查询扩展为某种程度上有助于我的第 2 点——我可以推断出谁可能是最近取消订阅的用户：
-- 列出电子邮件偏好设置为负的用户，并包含他们的 TL、联系日期和 Cheers
SELECT u.ID “用户 ID”
,u.USERNAME “用户名”
,u.trust_level “TL”
-- 下一行可选地包含来自 Gamifaction 插件的全部 Cheers 分数。请参阅下面的第二个连接。
,di.gamification_score “Cheers”
,CAST (u.first_seen_at AS DATE) “加入”
,CAST (u.last_seen_at AS DATE) “最后 seen”
,CAST (u.last_emailed_at AS DATE) “最后邮件”
,CASE uo.email_digests
WHEN 't' THEN '是'
WHEN 'f' THEN '否'
ELSE '未设置'
END “摘要？”
,CASE uo.email_level
WHEN 0 THEN '从不'
WHEN 1 THEN '离开'
WHEN 2 THEN '总是'
END “邮件级别”
,CASE uo.email_messages_level
WHEN 0 THEN '从不'
WHEN 1 THEN '离开'
WHEN 2 THEN '总是'
END “邮件消息级别”
FROM USERS u
LEFT OUTER JOIN USER_OPTIONS uo
ON u.ID = uo.USER_ID
-- 第二个连接包括来自 Gamifaction 插件的全部 Cheers 分数
LEFT OUTER JOIN directory_items di
ON u.ID = di.USER_ID AND di.period_type = 1
-- 使用以下 SELECT 语句列出未收到任何主题活动电子邮件的用户
WHERE uo.email_digests = 'f' OR (uo.email_level = 0)
-- 或使用以下 SELECT 语句列出未收到任何主题活动电子邮件和任何消息活动电子邮件的用户
-- WHERE uo.email_digests = 'f' OR (uo.email_level = 0 AND uo.email_messages_level = 0)
AND u.ID <> -1
ORDER BY u.last_emailed_at DESC
…但是，如果没有一些日期和关于取消订阅请求的详细信息，就无法清晰地了解情况。
基本上，我想要的是：是什么样的电子邮件导致了取消订阅；他们是从摘要中取消订阅还是从所有邮件中取消订阅；取消订阅者是长期活跃用户（可能已经失去兴趣），还是一个不活跃的 TL0 用户（一开始并没有真正那么感兴趣）？
