History chat details CSV glossary

This article contains a glossary of the metrics included when exporting chat details from the History tab. 

The CSV export file will show 45 columns, containing all the information of each chat session during the time session selected on the dashboard.

For more information on the History feature, see Browsing past chats in History.

Glossary

Metric	Description
chat_id	Unique chat session identifier
visitor_id	Unique visitor identifier; unique for every visit even when the visitor email address has already been used previously
timestamp (GMT+0)	Date and time the visitor sent their first message.
type	The classification of a session on whether the message was received when the account was online (chat) or offline (offline message).
duration (seconds)	The time between the first and last message sent, regardless of the sender.
started_by	The party who initiated the chat Parties include:    • Agent    • Visitor    • Trigger    • None (applies to offline messages only)
visitor_name	The name provided by the visitor in the pre-chat form; the last/final name indicated/updated by the visitor before the chat ends
visitor_email	The email address provided by the visitor in the pre-chat form; the last/final email indicated/updated by the visitor before the chat ends
visitor_phone	The phone number provided by the visitor in the pre-chat form or during chat
visitor_notes	Additional information about the customer; may only be added by agents in the account
session_city	City of the visitor in the chat session
session_start_date (GMT+0)	Date when the chat session started. The chat session starts when a visitor first lands on a website that activates the chat, not when the visitor sends their first message.
session_end_date (GMT+0)	Date when the chat session ended. A session ends when the visitor clicks "end chat" within an ongoing chat or when the visitor leaves the website.
session_ip	IP address of the visitor
session_region	Region of the visitor where the chat session happened
session_id	Unique ID for the specific chat session
session_platform	The operating system used by the visitor
session_user_agent	Information of the web browser and operating system used by the customer
session_country_code	Code of the country where the chat was initiated
session_country_name	Name of the country where the chat was initiated
session_browser	Browser used by the visitor during chat
visitor_message_count	The total number of messages sent by the visitor
agent_message_count	The total number of messages sent by the agent(s) who handled the chat.
total_message_count	The total number of messages sent by all the parties who joined the chat.
is_triggered	Shows "true" when the chat was triggered (a trigger ran in the session) and "false" when no trigger ran in the session. This is in conjunction with the "Visitor Triggered?" condition.
is_missed	Shows "true" when the chat was missed and "false" when the chat was accepted
is_unread	Applies offline messages and missed chats that haven't been read/clicked yet
landing_page	This is the section accessed by the visitor when they clicked a hyperlink on a certain web page, typically the website's home page
referral	Any domain that originates and redirects traffic to your domain where the visitor sees the widget
tags	All the tags added to the chat. Tags are separated by commas
department_name	The department to where the chat was routed
agent_names	The names of the agents who served in the chat session
agent_ids	The agent IDs of all the agents who served the chat
rating_score	The satisfaction rating of the entire chat session Ratings include the following:    • good    • bad    • none (chats without ratings)
rating_comment	The comment when the chat was rated, either good or bad
max_response_time (seconds)	The longest time it took the agent to respond to a message in the chat
avg_response_time (seconds)	The average time it takes for an agent to respond to messages in the chat
first_response_time (seconds)	The time in seconds, taken by the agent to pick the chat and send the initial message
zendesk_ticket_id	Zendesk Support ticket ID associated with the chat session. Appears blank when there's no ID (usually when ticket creation is set to manual)
skills	All the agent skills that matched the visitor's information
skill_match	The agent skill that matched the information set by the visitor and to where the chat was routed
last_conversion_goal_name	Name of the goal conversion
last_conversion_goal_id	A unique conversion identifier
last_conversion_date	The date when the goal was considered a conversion
last_conversion_attribution	The name of the agent to which the goal converted was attributed