# User Digest options

**URL:** https://meta.discourse.org/t/user-digest-options/275028
**Category:** Data & reporting
**Tags:** sql-query, activity-summary
**Created:** [April 3, 2018, 1:41pm UTC](https://meta.discourse.org/t/user-digest-options/275028 "2018-04-03T13:41:49Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![robmc](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/robmc/32/125900_2.png) [@robmc](https://meta.discourse.org/u/robmc)
#### Post date: [April 3, 2018, 1:41pm UTC](https://meta.discourse.org/t/user-digest-options/275028/1 "2018-04-03T13:41:49Z")

</div>

### User Digest options

It may not be the best way to do it (I still need to find a way to tell it to convert minutes to “Daily”, “Weekly” etc) but I find this information useful in order to know what digests my members are receiving - plus I analyse the results in excel to monitor the % who turn off digests.

```
SELECT users.id AS "ID",
users.username AS "Username",
user_options.email_digests AS "Digests",
user_options.digest_after_minutes AS "Timing"
FROM users
JOIN user_options ON users.id = user_options.user_id
ORDER BY ID

```