1

Mandrill – emails over customer lifecycle

Question

View how many emails a customer is receiving over time

Sources

Mandrill (see full visual schema here)

Results

Query

select
date_trunc('week', mandrill.received_at) date,
count(distinct id) count
from
mandrill.send mandrill
where email ilike 'john@example.com'
group by date_trunc('week', mandrill.received_at)
order by count desc