Intercom + Segment – conversion rate of customers you talk to
How are customer conversations impacting conversion?
Intercom (see full visual schema here)
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
Upvote Follow 1