Intercom: Admin Metrics

Description

• Each record represents an individual admin (employee) and a unique team they are assigned on, enriched with admin specific conversation aggregates. For example, the admin's total conversations, average rating, and median response times by specific team.

Supported Data Sources

• Intercom

Columns

Type	Name	Description
STRING	admin_id	The unique identifier representing the admin.
STRING	admin_name	The name of the admin.
INTEGER	team_id	The team ID the admin is associated with.
STRING	team_name	The team the admin is associated with.
INTEGER	job_title	The admin job title.
INTEGER	total_conversations_closed	The admins sum of total closed conversations.
INTEGER	average_conversation_parts	The admins average number of parts associated with a single conversation.
INTEGER	average_conversation_rating	The admins total average rating given to conversations they closed.
INTEGER	median_conversations_reopened	The admins median value of times they reopened conversations.
INTEGER	median_conversation_assignments	The admins median value of times they closed a conversation and had other assignees on the conversation.
INTEGER	median_time_to_first_response_time_minutes	The admins median value of time it took for their first response on a conversation.
INTEGER	median_time_to_last_close_minutes	The admins median value of time it took to the last closure of a conversation.