# Intercom: Company Metrics

## Description

* Each record represents a single row from intercom\_\_company\_enhanced, enriched with aggregates which determine the total conversation count, average satisfaction rating, median time to first response, and median time to last close with contacts associated to a single company.

## Supported Data Sources

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

## Columns

| Type     | Name                                             | Description                                                                                                                                                  |
| -------- | ------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING   | company\_id                                      | The unique identifier representing the historical Intercom defined company.                                                                                  |
| STRING   | company\_name                                    | The name of the company.                                                                                                                                     |
| INTEGER  | website                                          | The website associated with the company.                                                                                                                     |
| INTEGER  | industry                                         | The defined industry the company operates in.                                                                                                                |
| DATETIME | created\_at                                      | The time the company was created.                                                                                                                            |
| DATETIME | updated\_at                                      | The time the company was last updated at.                                                                                                                    |
| INTEGER  | user\_count                                      | The total count of users associated with the company.                                                                                                        |
| INTEGER  | session\_count                                   | The count of sessions the company has recorded.                                                                                                              |
| INTEGER  | monthly\_spend                                   | How much revenue the company generates for your business.                                                                                                    |
| INTEGER  | plan\_id                                         | Unique identifier representing the company plan.                                                                                                             |
| INTEGER  | plan\_name                                       | The name of the plan you have associated with the company.                                                                                                   |
| 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\_company\_tags                               | String aggregation of all tags associated with the company.                                                                                                  |
| INTEGER  | total\_conversations\_closed                     | The total closed conversations with contacts from that company.                                                                                              |
| INTEGER  | average\_conversation\_parts                     | The average number of parts associated to a single conversation with contacts from that company.                                                             |
| INTEGER  | average\_conversation\_rating                    | The average rating given to conversations from contacts associated with a single company.                                                                    |
| INTEGER  | median\_conversations\_reopened                  | The median value of times a conversation was reopened with contacts from a single company.                                                                   |
| INTEGER  | median\_time\_to\_first\_response\_time\_minutes | The median value of time it took for contacts of a single company to receive their first response on a conversation.                                         |
| INTEGER  | median\_time\_to\_last\_close\_minutes           | The median value of time it took for contacts of a single company to receive their last closure of a 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-company-metrics.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.