# Intercom: Conversation Metrics
## Description
* Each record represents a single row from intercom\_\_conversation\_enhanced, enriched with aggregates which determine time to first response, time to first close, and time to last close.
## Supported Data Sources
* 
Intercom
## Columns
| Type | Name | Description |
| -------- | -------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| INTEGER | conversation\_id | The id representing the conversation. |
| DATETIME | conversation\_created\_at | The time the conversation was created. |
| DATETIME | conversation\_last\_updated\_at | The date the conversation was last updated at. |
| STRING | conversation\_type | The type of conversation. This includes conversation push facebook twitter and email. |
| STRING | conversation\_initiated\_type | How the conversation was initially delivered to the responder. |
| STRING | conversation\_subject | The subject of the conversation created by the initiator. |
| STRING | conversation\_assignee\_type | The type of user the conversation is assigned to. If it is not assigned to a user it will return null. |
| STRING | conversation\_author\_type | The type of individual who authored the first message. Will be either contact or admin. |
| STRING | conversation\_state | The current state of the conversation (open or close). |
| BOOLEAN | is\_read | Boolean indicating whether the conversation message has been read. |
| DATETIME | waiting\_since | The last time a contact responded to an admin. The time a customer started waiting for a response. Set to null if last reply is from an admin. |
| DATETIME | snoozed\_until | If set this is the time in the future when this conversation will be marked as open. |
| INTEGER | sla\_name | The name of the SLA as given by the teammate when it was created. |
| INTEGER | sla\_status | One of “hit”, ”missed”, or “cancelled”. |
| INTEGER | conversation\_rating | An optional field for the customer to rate the conversation which will be between 1 and 5. |
| INTEGER | conversation\_remark | An optional field to add a remark to correspond to the number rating. |
| DATETIME | first\_close\_at | The time of the first conversation part where part\_type was 'close' by any author type indicating the conversation was closed. |
| DATETIME | last\_close\_at | The time of the last conversation part where part\_type was 'close' by any author type indicating the conversation was closed. |
| DATETIME | first\_admin\_close\_at | The time of the first conversation part where part\_type was 'close' by an admin indicating the conversation was closed. |
| DATETIME | last\_admin\_close\_at | The time of the last conversation part where part\_type was 'close' by an admin indicating the conversation was closed. |
| STRING | all\_conversation\_tags | String aggregation of all tags associated with the conversation. |
| STRING | first\_close\_by\_admin\_id | The admin\_id of the admin who was first assigned to the conversation. |
| STRING | last\_close\_by\_admin\_id | The admin\_id of the admin who last closed the conversation. |
| STRING | first\_close\_by\_author\_id | The author\_id of the author (of author\_type admin, bot, user, etc.) who was first closed to the conversation. |
| STRING | last\_close\_by\_author\_id | The author\_id of the author (of author\_type admin, bot, user, etc.) who was last closed to the conversation. |
| STRING | first\_contact\_author\_id | The contact\_id of the contact who was first associated with the conversation. |
| STRING | last\_contact\_author\_id | The contact\_id of the contact who was last associated with the conversation before closing. |
| STRING | first\_team\_id | |
| STRING | last\_team\_id | |
| STRING | first\_team\_name | |
| STRING | last\_team\_name | |
| STRING | all\_contact\_company\_names | String aggregation of all companies the first\_author\_contact is associated with. |
| STRING | all\_conversation\_admins | String aggregate of all admins that contributed to the conversation. |
| STRING | all\_conversation\_contacts | String aggregate of all contacts that contributed to the conversation. |
| INTEGER | count\_reopens | The count of conversation parts where the part\_type value was 'open'. Note, a conversation part\_type must be manually opened by an admin. |
| INTEGER | count\_total\_parts | The count of total conversation parts for a single given conversation. Max parts are 500. |
| INTEGER | count\_assignments | The count of conversation parts where the part\_type value contained 'assignment'. |
| DATETIME | first\_contact\_reply\_at | The time when the conversation author of type user or lead commented in a conversation. |
| DATETIME | first\_assignment\_at | The time when the first conversation assignment was made. |
| INTEGER | time\_to\_first\_assignment\_minutes | The time difference (not factoring in business hours) between the conversation creation and the first\_assignment\_at. |
| DATETIME | first\_admin\_response\_at | The time when the conversation part author of type admin first commented in a conversation. |
| INTEGER | time\_to\_first\_response\_minutes | The time difference (not factoring in business hours) between the conversation creation and the first\_admin\_response\_at. |
| INTEGER | time\_to\_admin\_first\_close\_minutes | The time difference (not factoring in business hours) between the first\_contact\_reply\_at and the first\_admin\_close\_at. |
| INTEGER | time\_to\_first\_close\_minutes | The time difference (not factoring in business hours) between the first\_contact\_reply\_at and the first\_close\_at. |
| DATETIME | first\_reopen\_at | The time of the first conversation part where part\_type was 'open' indicating the conversation was reopened. |
| DATETIME | last\_assignment\_at | The time of the last conversation assignment. |
| INTEGER | time\_to\_last\_assignment\_minutes | The time difference (not factoring in business hours) between the conversation creation and the last\_assignment\_at. |
| DATETIME | last\_contact\_reply\_at | The time of the last contact response within the conversation. |
| DATETIME | last\_admin\_response\_at | The time of the last admin response within the conversation. |
| DATETIME | last\_reopen\_at | The time of the last conversation part where part\_type was 'open' indicating the conversation was reopened. |
| INTEGER | time\_to\_admin\_last\_close\_minutes | The time difference (not factoring in business hours) between the last\_admin\_close\_at and the first\_contact\_reply. |
| INTEGER | time\_to\_last\_close\_minutes | The time difference (not factoring in business hours) between the last\_close\_at and the first\_contact\_reply. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/intercom-conversation-metrics.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.