# Intercom: Conversation Enhanced
## Description
* Each record represents a single conversation, enriched with data from the multiple conversation parts. The conversation parts provide relevant information such as who was assigned to the conversation, which contact the conversation was with, the current conversation state, who closed the conversation, and the final conversation ratings from the contact.
## 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 the 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 | ID of the team that was first assigned to the conversation. |
| STRING | last\_team\_id | ID of the team that was last assigned to the conversation. |
| STRING | first\_team\_name | Name of the team that was first assigned to the conversation. |
| STRING | last\_team\_name | Name of the team that was last assigned to the conversation. |
| 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. |
---
# 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-enhanced.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.