1

Intercom + Segment – conversion rate of customers you talk to

Question

How are customer conversations impacting conversion? 

Sources

Intercom (see full visual schema here)

Results

Query

select
count(distinct segment_users.id) as "All users",
count(distinct conversations.user_id) as "Users that had conversation",
count(distinct
 conversations.user_id is not null
 and signup.user_id is not null
 -- ensure signup happens after conversation
 and datediff('days', conversations.created_at, signup.sent_at) > 0
 ) as "Users that had conversations and converted"
from intercom.users intercom_users
left join intercom.conversations conversations
 on conversations.user_id = intercom_users.id
join segment.users segment_users
 on segment_users.id = intercom_users.user_id
join segment.signup signup
 on signup.user_id = segment_users.id