# Run report of digest Unsubscribes

**URL:** https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678
**Category:** Data & reporting
**Tags:** sql-query, activity-summary
**Created:** [6월 17, 2017, 5:59오후 UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678 "2017-06-17T17:59:24Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![SouperC](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/souperc/32/62875_2.png) [@SouperC](https://meta.discourse.org/u/SouperC)
#### Post date: [6월 17, 2017, 5:59오후 UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678/1 "2017-06-17T17:59:24Z")

</div>

Is there a way I can run a report on which users have unsubscribed from the Discourse digest for my site?

I’d like to flag them elsewhere (ActiveCampaign) too so that they don’t have to unsubscribe in to places. Or get pi$$ed at us because they thought they were opting out of everything.

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [6월 19, 2017, 12:49오후 UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678/2 "2017-06-19T12:49:58Z")

</div>

```plaintext
./launcher enter app
rails c
[7] pry(main)> UserOption.where(email_digests: false).references(:user).includes(:user).pluck(:email)

```

---

<div class="post-metadata">

### Author: ![hutchinsfairy](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hutchinsfairy/32/103475_2.png) [@hutchinsfairy](https://meta.discourse.org/u/hutchinsfairy)
#### Post date: [6월 19, 2017, 1:46오후 UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678/3 "2017-06-19T13:46:16Z")

</div>

If you’re doing this often then you could install the [Data Explorer plugin](https://meta.discourse.org/t/data-explorer-plugin/32566) and use query:

```
SELECT u.ID "User ID" 
       ,u.USERNAME "Username" 
       ,u.NAME "Name" 
       ,CASE uo.EXTERNAL_LINKS_IN_NEW_TAB 
          WHEN 't' THEN 'True' 
          WHEN 'f' THEN 'False' 
          ELSE 'Not set' 
        END "External links?"
        ,CASE uo.mailing_list_mode 
          WHEN 't' THEN 'True' 
          WHEN 'f' THEN 'False' 
          ELSE 'Not set' 
        END "Mailing List Mode?"
        ,CASE uo.email_digests 
          WHEN 't' THEN 'True' 
          WHEN 'f' THEN 'False' 
          ELSE 'Not set' 
        END "Email Digests?"
        ,digest_after_minutes/60 || ' Hours' "Digest Every"
FROM USERS u 
       LEFT OUTER JOIN USER_OPTIONS uo 
                    ON u.ID = uo.USER_ID 
WHERE uo.email_digests = 'f' 
   AND u.ID <> -1

```

---

<div class="post-metadata">

### Author: ![SouperC](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/souperc/32/62875_2.png) [@SouperC](https://meta.discourse.org/u/SouperC)
#### Post date: [7월 4, 2017, 9:20오후 UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678/4 "2017-07-04T21:20:33Z")

</div>

Thanks guys! I thought I had the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin installed… looks like I don’t so I’ll have to get that done..

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [1월 8, 2023, 5:08오후 UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678/7 "2023-01-08T17:08:29Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.