# Intercom: Contact Enhanced

## Description

* Each record represents a single contact, enriched with data identifying the contacts role, if they have unsubscribed from the email list, last contacted information, and which company they belong to.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/intercom/resources/intercom.svg" alt="" data-size="line"> Intercom

## Columns

| Type     | Name                           | Description                                                                                                                                                  |
| -------- | ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING   | contact\_id                    | The unique identifier for the contact which is given by Intercom.                                                                                            |
| INTEGER  | admin\_id                      | The unique identifier representing the admin which has been assigned ownership of the contact.                                                               |
| DATETIME | created\_at                    | The time when the contact was created within Intercom.                                                                                                       |
| DATETIME | updated\_at                    | The time when the contact was last updated.                                                                                                                  |
| DATETIME | signed\_up\_at                 | The time the contact signed up.                                                                                                                              |
| STRING   | contact\_name                  | The name of the contact.                                                                                                                                     |
| STRING   | contact\_role                  | The role of the contact (user or lead).                                                                                                                      |
| STRING   | contact\_email                 | The contacts email.                                                                                                                                          |
| DATETIME | last\_replied\_at              | The time when the contact last messaged in.                                                                                                                  |
| DATETIME | last\_email\_clicked\_at       | The time when the contact last clicked a link in an email.                                                                                                   |
| DATETIME | last\_email\_opened\_at        | The time when a contact last opened an email.                                                                                                                |
| DATETIME | last\_contacted\_at            | The time when the contact was last messaged.                                                                                                                 |
| BOOLEAN  | is\_unsubscribed\_from\_emails | Boolean indicating whether the contact has unsubscribed from emails.                                                                                         |
| BOOLEAN  | \_fivetran\_active             | Boolean to identify an active record.                                                                                                                        |
| DATETIME | \_fivetran\_start              | Timestamp to record the time that a record is ingested by Fivetran. This value may not be identical to the time the record was created in the source system. |
| DATETIME | \_fivetran\_end                | Timestamp to record the time when a record became inactive in the source system.                                                                             |
| STRING   | all\_contact\_tags             | String aggregation of all tags associated with the contact.                                                                                                  |
| STRING   | all\_contact\_company\_names   | String aggregation of all companies the contact is associated with.                                                                                          |


---

# 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-contact-enhanced.md?ask=<question>
```

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.