Best Practices on reply-by-email

[RGJ (Richard - Communiteq)]

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.