Do you want to do your own analysis of the data? On the dashboard, you can easily download the data which makes up our analytics page. You can download the data either as an Excel (XLSX) file or a JSON file.
You can download up to 10,000 chat data per file
These downloads are only available to those managers with Download data permission.
When downloading the data you need to set a password and write a purpose for the download.
Only alphabets and numbers are allowed for creating a password.
If you lose the password, the file cannot be recovered, you have to re-download the file
Download via Analytics
Go to [Operations] - [Analytics]
After filtering and selecting the desired conditions, select the download button.
Select file type, and message data.
Click download.
If there is a lot of data, it may take a few minutes.
Download via Inbox search results
Under the user chat tab, click the magnifying glass and et the search conditions accordingly.
After selecting your desired conditions, go to [Actions ]- [Download data].
You can only download up to 200 chats at one time.
Data worksheet tab
Tab value | Description |
|---|---|
UserChat data | Data from the chat including information and time data |
User data | Customer data involved in a user chat |
SupportBot data | Data received from the support bot |
Marketing data | Data from chats opened through Marketing campaigns |
Manager data | Operator Data |
Bot data | Data from the Channel bot |
UserChatTag data | Tags related to chat |
Message data | Contents of the uerchat |
All active chat profile data is displayed.
Data Value | Description | Remark |
|---|---|---|
id | User chat id | Use it to differentiate between userchats in the Message data sheet. |
userId | Customer ID | |
name | Customer Name | |
description | Chat Description | |
state | User chat Status | Opened / Snoozed/ Closed |
contactMediumType | Type of messenger (external) | - appLine : Line messenger - appInstagramMessenger : Instagram messenger |
marketingId | Marketing Message ID | You can check the specific marketing message on the Marketing datasheet |
marketingType | Marketing message type | - Onetime message: oneTimeMsg - Campaign : campaign |
supportBotId | Supportbot ID | You can check the SupportBot data on the supportbot data sheet |
source.workflow.id | Start Workflow | The ID of the first workflow executed when starting a new chat from the Channel Talk button. |
managerIds | Follower ID | You can check the followers on the Manager data Sheet |
assigneeId | Assignee ID | You can check the assignee data on the Manager data sheet |
teamId | Assigned team ID | You can check the team in the Team data sheet |
tags | Chat Tags | |
firstAskedAt | First Inquiry Time (Auxiliary value for calculating response time) |
|
firstQueuedAt | First Queue Entry Time |
|
firstOpenedAt | User chat first opened time | This variable shows the time at which the customer first opened their UserChat |
firstRepliedAt |
|
|
openedAt | User chat opened time | - Time for New user chat created - Time for reopened user chat after closed and snoozed status |
firstRepliedAtAfterOpen | Time when manager replied after Userchat was opened | If the chat was opened again it changes |
createdAt | Time from first opening the Channel lounge to starting a chat | Button press time |
waitingTime | First response time: the time from when the customer first sends a message until a manager responds | If a new chat is opened it remains the same |
avgReplyTime | Average response time | -This is the average total reply time to the total number of replies in said chats (totalReplyTime/replyCount) - It will be renewed when the chat is reopened |
totalReplyTime | Total Reply Time | - This is the total amount of time it took for the manager to reply - If a new chat is opened it does not change |
replyCount | Total number of manager’s responses | If a new chat is opened it does not change |
resolutionTime | How long did was the UserChat from opened to closed status | -(closedAt - openedAt) - If a new chat is opened it does not change |
operationWaitingTime | Waiting time during Operation hours | If a new chat is opened it does not change |
operationAvgReplyTime | Average reply time during Operation hours | If a new chat is opened it does not change |
operationTotalReplyTime | Total reply time for during Operation | If a new chat is opened it does not change |
operationReplyCount | Total reply count during Operation hours | If a new chat is opened it does not change |
operationResolutionTime | Resolution time of chats only during opersting hours | If a new chat is opened it does not change |
closedAt | User chat closing time | If a new chat is opened it does not change |
goalState | Chat goal achievement status | When a chat is reopened, the following cases will trigger an update:
|
goalEventName | Chat goal details | |
goalCheckedAt | Chat goal achievement time | |
source.page | Source page | |
priority | Chat priority | |
profile.csat | CSAT | |
profile.csatComment | CSAT feedback |
User data sheet includes all profile information on all users that have left a user chat.
Data Value | Description | Remark |
|---|---|---|
id | Manager ID | |
channelId | Manager assigned channel ID | |
accountId | Channel Talk account ID | |
username | Other mentioned manager ID | @ mentions |
name | Name presented to the customer | |
mobileNumber | Phone number | |
role | Manager permissions | - Owner - Member |
removed | Manager removed status | |
createdAt | Date manager joined Channel | |
defaultGroupWatch | Group message notification settings | - All activity: all - Important only: info - Nothing: none - Based on the time data was downloaded |
defaultDirectChatWatch | DM alert settings | - All activity: all - Important only: info - Nothing: none - Based on time the data was downlowded |
defaultUserChatWatch | User Chat notification settings | - All activity: all - Important only: info - Nothing: none - Based on time the data was downlowded |
operator | Operator mode settings | Based on time the data was downlowded |
operatorEmailReminder | Operator response email settings when operator mode is on | Based on time the data was downloaded |
Data Value | Description | Remark |
|---|---|---|
id | Team ID | |
channelId | Channel ID | |
name | Team Name | |
managerIds | IDs of managers belonging to the team | Manager information can be checked in the Manager data sheet |
Data Value | Description | Remark |
|---|---|---|
id | Bot profile ID | |
channelId | Channel ID | |
name | Bot profile ID | |
createdAt | Bot profile creation date |
Data value | Description | Remark |
|---|---|---|
id | Chat tag ID | |
channelId | Channel ID | |
name | Chat tag name | |
description | Chat tag description | |
followerIds | Manager assigned chat tag ID | |
createdAt | Assigned chat tag date |
Data value | Description | Remark |
|---|---|---|
ChatId | Userchat ID | |
PersonType | Message sender information | -Bot: All automated responses - Manager: manager - User: user |
PersonId | Message sender ID | - Supportbot : bot ID - Manager: manager ID - Customer: customer ID |
CreatedAt | Message creation time | |
PlainText | Message content |
Data value | Description | Remark |
|---|---|---|
id | meet id | ID assigned to phone/video/audio meets. |
userChatId | UserChat’s unique ID | |
startedAt | Time the call was initiated | |
endedAt | Time the call ended | |
engagedAt | Time the call was connected | |
from | Caller number | |
to | Receiver number | |
direction | Inbound/outbound call type | • inbound: received • outbound: sent • missed: missed call |
missedReason | Reason for missed call | • notInOperation: Outside of business hours • noOperator: No available operator • abandonedInQueue: Caller hung up after 1 hour in queue • ringTimeOver: Assigned ring time exceeded before answer • userLeft: Customer hung up first • preservedNumber: Call to a previously registered but now inactive number • unregisteredNumber: Call from an unregistered number • exceededQueue: Exceeded the maximum number of queued calls (200) • workflow: Ended via workflow action |
duration | Total call duration | |
type | Type | • call: Phone call • frontMeet: Audio or video meet between customer and manager |
primaryNumber | Actual caller number | |
representativeNumber | Altered caller number |
Data value | Description | Remark |
|---|---|---|
id | Supportbot ID | |
revisionId | Support bot moderation ID | |
sectionPath | Record of the support bot path section that the customer chose on the edited version | It shows the most frequent paths taken by customers. For more detailed data, use the Support bot data download function. |
Can you search only the chats which have all searched tags?
Unfortunately, that feature is unavailable. If you search for more than one tag, every chat with at least one of those tags will be included. If you want to check the data only with multiple tags (unions) you must download the data and search via excel.
Can I see data for the time a chat was put on hold?
It is a very difficult process to check current pending chats. It is easier to check via customer inbox to see current pending. You can also create formulas via excel to infer such a metric.
I can't see my Chat Statistics Data.
If chat data is not shown on the analytics dashboard, it is either a temporary phenomenon (there is no available chat data). If you create a test user chat and the data is still not present please contact customer service as soon as possible.