# Best Practices on reply-by-email

**URL:** <https://meta.discourse.org/t/best-practices-on-reply-by-email/96107>\
**Category:** Community Building\
**Tags:** data-explorer\
**Created:** [August 31, 2018, 4:27pm UTC](https://meta.discourse.org/t/best-practices-on-reply-by-email/96107 "2018-08-31T16:27:50Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ)\
**Post date:** [August 31, 2018, 7:16pm UTC](https://meta.discourse.org/t/best-practices-on-reply-by-email/96107/4 "2018-08-31T19:16:33Z")

</div>

```
select username, sum(case when (posts.via_email='t') then 100 else 0 end)/count(posts.id) as perc_by_mail
from posts
left join users on users.id = posts.user_id
where posts.created_at >= now() - interval '4 weeks'
group by username

```

> [@pfaffman](#):
>
> if users can reply by email and can interact with the site without visiting it, then we’re losing ad revenue, although small.

That sounds very short sighted. Having more content will bring you a multitude of visitors.

---

_[View the full topic](https://meta.discourse.org/t/best-practices-on-reply-by-email/96107)._