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

• 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.