Hello,

I could see statistics data via direct api call to intercom however Fivetran is not including many of these fields in convesation table. Please add fields mentioned below.

Intercom is saying some of these fields can be calculated but it's not possible with only underlying raw data.
in email response below, for example to calculate time_to_admin_reply, we’d need 
first_admin_reply_at and first_contact_reply_at and they both are missing from fivetran conversation_history table. Please take a look at this conversation history api and advise. these missing values cannot be calculated by raw data.(“https://api.intercom.io/conversations”)

 time_to_admin_reply = first_admin_reply_at - first_contact_reply_at

--Intercom reply to this issue >>>>>>

Hey again! You can take a look at the statistics object on the Conversation Model in our API docs for most of the definitions of the attributes returned, but just to be thorough here, I have included the definitions for the some of those metrics below 

• first_contact_reply_at = Earliest timestamp of when an attribute was collected by a bot or where the user sent in a message (whether that's to start the conversation or responding to an outbound message).
• time_to_admin_reply = first_admin_reply_at - first_contact_reply_at
• time_to_first_close = first_close_at - first_contact_reply_at
• time_to_last_close = last_close_at -first_contact_reply_at
• first_admin_reply_at = Timestamp of the first visible human admin conversation part after first_contact_reply_at
• first_close_at = Timestamp of the first close conversation part after first_contact_reply_at
• last_close_at = Timestamp of the last close conversation part after first_contact_reply_at
• last_closed_by_human_at = Timestamp of the last close conversation part by a human after started_at
• count_reopens = Number of reopens after first_contact_reply_at
• count_assignments = Number of assignments after first_contact_reply_at