1

Intercom – conversations by customer

Question

Measure which customers have interacted most with your team

Sources

Intercom (see full visual schema here)

Results

Query

select
users.email,
count(distinct conversations.id) convos
from intercom.conversations conversations
join intercom.users users on conversations.user_id = users.id
group by users.email
order by convos desc