You can use Data Export to track a wide variety of statistics, Session activities, and more. You can learn how to run a Data Export job here. Choose a Data Export View below to see the information included in the export; click each heading to expand.
- User_Info
- User_Login_Activity
- Session_Assignment_Activity
- Session_Daily_Activity
- Session_Device_Activity
- Session_Path_Activity
- Session_Path_Step_Activity
- Session_Queue_Activity
- Session_Path_Feedback
- Session_Survey
- SelfService_Session_Daily_Activity
- SelfService_Session_Path_Activity
- SelfService_Session_Path_Step_Activity
- SelfService_Session_Device_Activity
- SelfService_Session_Queue_Activity
- SelfService_Session_Queue_Statistics
- SelfService_Aggregate_Statistics
- SeeSupport_Aggregate_Statistics
- Path_Category
- Path_Timeline
- Session_Agent_Comments
- Session_Consumer_Device_Data
User_Info
This table contains information pertaining to all your Users, including Admins, Designers, Agents, etc. (click to expand)
user_id | Unique User ID in Support.com (Primary Key). |
email | User email. |
given_name | User first name. |
family_name | User last name. |
phone | User phone number. |
time_created | Date and time the User was created. |
time_deleted | Date and time the User was deleted. When you delete a User, that User no longer appears in the UI, but the User's information can still be retrieved via Data Export. |
time_accessed | Date and time User last logged in. |
is_global | Internal use |
global_user_id | Internal use |
external_id | User ID in an external system. |
teams | Teams the User is on. Information is returned as a JSON array with the following format: [ { "id": 0, "name": "string", "description": "string" } ] |
roles | Roles the User is assigned. Information is returned as a JSON array with the following format: [ { "id": 0, "name": "string", "description": "string" } ] |
skills | Skill the User is assigned. Information is returned as a JSON array with the following format: [ { "id": 0, "name": "string", "description": "string" } ] |
User_Login_Activity
This activity view lists Agents that were active between a start time and an end time you specify. (click to expand)
id | One specific record of User login/logout activity. (Primary Key) |
agent_id | Agent ID. (Foreign Key) |
agent_given_name | User first name. |
agent_family_name | User last name. |
login_time_stamp | Login time. |
latest_activity_time | Time of most recent User activity (not necessarily login/logout.) |
logout_time_stamp | Logout time (this may be blank if the User did not explicitly log out.) |
ip_address | User IP Address. |
os | User operating system information. |
browser | User browser information. |
Session_Assignment_Activity
This activity view lists Session assignments and other actions between a start time and an end time you specify.
Id | Unique ID for each specific Agent action (e.g. Assignment, Reskill, Transfer.) (Primary Key) |
session_id | Session ID. (Foreign Key) |
start_time | Assignment start time. |
end_time | Assignment end time (due to removal or end of active work.) |
reason_code | Reason for a Session being assigned to a queue. Reason codes include:
|
triggered_by | ID of the Agent who assigned the Session to the queue. |
time_created | Date and time of the assignment. |
pending_assignment | This field contains True if the Session is in queue and there is no Agent assigned. |
session_external_id | Session ID in an external system. |
session_device_type | Consumer device type (e.g. computer, mobile, other.) |
agent_id | Assigned Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
Session_Daily_Activity
This activity view tracks events that occurred in a Session on a given day.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
date | Date the first Session event occurred. |
start_time | Time Session started. |
latest_activity_time | Time of the last activity on this Session on this day. |
latest_activity_event | Last event on this Session on this day. |
latest_session_start_time | |
latest_session_view_time | |
is_status_set_closed | This field contains True if the Session was closed on this day, unless the Session was reopened. |
is_created | This field contains True if the Session was created on this day. |
reopen_count | Number of times the Session status changed from “closed” to “open” on this day. |
attended_duration | Average handle time for the day for this Agent on this session. (in seconds) |
view_duration | Sum of session_view and session_view_pause. (in seconds) |
note_count | Number of times a note was created. |
attachment_count | Number of attachments. |
survey_sent_time | Time when a survey was sent to the Consumer. |
survey_presented_time | Time when the Consumer viewed the survey. |
survey_responded_time | Time when the Consumer submitted the survey. |
created_device_count | Number of devices attached to this session on this day. |
session_open_count | Number of times the Session status changed to "open" during this day. (including session creation) |
session_close_count | Number of times the Session status changed to "closed" during this day. |
used_seesupport | This field contains True if the Agent used SeeSupport. |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
disposition | Session disposition. (Resolved/Unresolved) |
Session_Device_Activity
A Session can be used to service multiple devices. This activity view has a row for each device that was worked on in a Session.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. (Foreign Key) |
session_device_id | Device ID. |
start_time | Date and time of first Session activity. |
is_created | This field contains True if the Agent created the Session. This field contains false otherwise. (e.g. the Session was created as part of Self-Service) |
is_cancelled | This field contains True if the Agent cancelled out of the “Add Path” UI. |
addpath_end_time | Date and time Agent either chose a Path or cancelled out of the “Add Path” UI. |
addpath_duration | Time spent by Agent in the “Add Path” UI, regardless of whether Agent chose a Path. (in seconds) |
first_device_start_time | Date and time the first activity was received from the device. |
latest_device_activity_time | Date and time the latest activity was received from the device. |
latest_activity_time | Date and time of the latest Session activity. |
latest_activity_event | Latest Session activity event. |
working_as_assigned_user_since | |
latest_session_pause_time | Date and time of the latest Session pause. |
latest_device_start_time | Date and time the most recent event was received from the device. |
attempt_connect_duration | Time the Agent spent on the connection screen. (in seconds) |
attended_duration | Time the Agent spent on this device. (in seconds) |
is_email_link_sent | This field contains True if an email with app installation instructions was sent to the Consumer. |
is_sms_link_sent | This field contains True if an SMS with app installation instructions was sent to the Consumer. |
is_connection_guide_opened | This field contains True if the Agent viewed the Connection Guide to assist the Consumer with installation of the app. |
remote_pushed_url_count | Number of times Agent invoked push URL to send a URL to the Consumer. |
remote_pushed_url | Array of URLs pushed to the Consumer. |
remote_view_zoomin_count | Not currently used. |
remote_view_zoomout_count | Not currently used. |
remote_win_start_count | Number of times the Agent sent Windows start shortcut to the Consumer’s machine. |
remote_ctrl_alt_delete_count | Number of times The Agent sent Ctrl+Alt+Del to the Consumer’s machine. |
latest_remote_connect_time | Date and time of the most recent device connection. |
first_remote_connect_time | Date and time of the first device connection. |
remote_connection_duration | Time spent remotely connected. (in seconds) |
current_remote_connection_duration | In the case of multiple remote connections across one or more days, this field tells the time spent remotely connected in the currently running Session. |
remote_disconnect_reason_code | Reason for disconnection. Reason codes include:
|
** first_path_start_time | Date and time the first Path started. |
path_create_count | Number of Guided Paths the Agent chose while servicing this device in this Session. |
path_start_count | Number of times the Agent started Guided Paths while servicing this device in this Session. |
path_complete_count | Number of Guided Paths the Agent completed while servicing this device in this Session. |
path_abort_count | Number of Guided Paths the Agent aborted while servicing this device in this Session. |
is_session_status_closed | This field contains True if the Session was closed (unless subsequently reopened) or archived. |
is_customer_remote_ready | This field contains True if the Consumer device is ready to be connected. |
used_seesupport | This field contains True if the Agent sent a SeeSupport request to Consumer. |
seesupport_duration | Time SeeSupport was used by the Agent. (in seconds) |
seesupport_annotation_count | Number of times Agent used annotation in SeeSupport. |
remote_annotation_count | Number of times Agent used annotation in Remote Control. |
session_external_id | Session ID in an external system. |
session_device_type | Device type (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
remote_seesupport_accept_count | Number of times the Consumer accepted SeeSupport request. |
remote_seesupport_decline_count | Number of times the Consumer declined SeeSupport request. |
remote_camerafeed_pause_count | Number of times Agent paused the SeeSupport feed. |
seesupport_pause_duration | Time SeeSupport feed was paused. (in seconds) |
flashilight_used_count | Number of times Agent activated device flashlight. |
remote_seesupport_zoom_in_count | Number of times Agent zoomed in. |
remote_seesupport_zoom_out_count | Number of times Agent zoomed out. |
os | Consumer device operating system information. |
seesupport_mms_recv_count | Number of MMS received. |
seesupport_mms_sent_count | Number of MMS sent. |
seesupport_mms_history_panel_count | Number of times Agent expanded the history view. |
Session_Path_Activity
This activity view displays information regarding a specific Session + Path combination.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
session_device_id | Device ID. |
session_path_id | Instance ID of a device interaction. |
path_version_id | Instance ID of the Path being executed. |
is_created | This field contains True if the Agent is the Path creator. |
start_time | Date and time workflow execution started. |
end_time | Date and time workflow execution ended. (e.g. completed, aborted, paused) |
is_aborted | This field contains True if the Path was aborted. |
latest_path_activity_time | Date and time of the latest activity on the Path. |
latest_activity_time | Date and time of the latest activity on this Session or for the Agent. |
latest_activity_event | Latest activity event received on the Session or for the Agent. |
working_as_assigned_user_since | |
latest_session_pause_time | Date and time of the latest Session pause. |
latest_device_pause_time | Date and time of the latest device pause. |
latest_path_start_time | Date and time the most recent Path was started. |
attended_duration | Time spent on the Session Path. (in seconds) |
view_duration | Time spent viewing the Session. (in seconds) |
expand_count | |
collapse_count | |
step_complete_count | Number of Steps the Agent completed. |
step_na_count | Number of Steps the Agent marked "N/A." |
step_blank_count | Number of Steps the Agent did not mark resolved. (e.g. completed, N/A) |
attended_step_duration | Time spent working on all Steps on the Path. (in seconds) |
unattended_step_duration | |
is_session_status_closed | This field contains True if Session status is marked as "closed." |
agent_id | Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
session_external_id | Session ID in an external system. |
path_id | Guided Path ID. |
category_id | Category ID. |
Session_Path_Step_Activity
This activity view displays information regarding a specific Step in a Path.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
session_device_id | Device ID. |
session_path_id | ID for each Session+Path combination. |
session_path_step_id | ID for each Session+Path+Step combination. |
path_version_step_id | ID of the Path and Step version. |
start_time | Date and time Step execution started. |
end_time | Date and time Step execution ended. |
latest_path_step_activity_time | Date and time the latest activity occurred on the Path+Step. |
latest_activity_time | Date and time the latest activity occurred on the Session while the Agent is working on the Step. |
latest_activity_event | Latest event that occurred on the Session while the Agent is working on the Step. |
working_as_assigned_user_since | |
latest_session_pause_time | Date and time of the latest Session pause. |
latest_device_pause_time | Date and time of the latest Device pause. |
latest_path_pause_time | Date and time of the latest Path pause. |
latest_path_step_start_time | |
attended_duration | Time spent working on the Path+Step by the Agent. (in seconds) |
view_duration | Time spent viewing the Path+Step. (in seconds) |
status | The status the Agent marked on the Step. Statuses include:
|
step_name | Step name. |
language_code | Step language code. |
visit_sequence | An array of integers which represent the visit sequence of the Step. The number starts at “1”. Each time a Step is visited, the number is incremented by 1. |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
Session_Queue_Activity
This activity view tracks events that occurred on a Session while it was in a queue.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
skill_id | Skill to which the Session was queued. |
start_time | Date and time the Session entered queue. |
offer_time | Date and time the Session was offered to an available Agent. |
offer_to | Agent to which the Session was offered. |
end_time | Time at which the offer was removed. (end_time - start_time will tell the amount of time this session spent in the queue) |
end_reason_code | Reason the offer was removed. Reason codes include:
|
end_by | Agent that took the action listed in end_reason_code. |
triggered_by | Agent involved in queuing this session, if any. |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
Session_Path_Feedback
This view displays Agent feedback of a Path, as well as information regarding the feedback creation.
session_path_id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
time_start | Date and time when feedback activity started. |
feedback_comments | Comments/Feedback provided by the Agent. |
feedback_comments_archived | Array of feedback comments archived by Designers. |
path_version_id | Guided Path ID. |
path_name | Guided Path name. |
path_audience | Intended Guided Path audience. (e.g. Agents, Consumers, both) |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
category_name | Category name. |
category_id | Category ID. |
Session_Survey
This view displays Survey responses generated by Agents.
agent_id | Agent ID. (Primary Key) |
agent_email | Agent email. |
session_id | Session ID. (Foreign Key) |
question_name | Question text. |
answer | Answer text. |
time_created | Date and time the answer was received. |
SelfService_Session_Daily_Activity
This activity view tracks events that occurred on a Self-Service Session on a given day.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
date | Session date. (tenant time zone) |
start_time | Session start time. |
latest_activity_time | Time of the latest activity associated with the Session. |
latest_activity_event | Latest activity event received on the Session. |
latest_session_start_time | Latest time a Session started |
attended_duration | Time spent on the Session. (in seconds) |
is_assisted | This field contains True if the Session is escalated to an Agent. |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
SelfService_Session_Path_Activity
This activity view displays information regarding a specific Self-Service Session+Path combination.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
session_device_id | Instance ID of a device interaction. |
session_path_id | Instance ID of the Path being executed. |
path_version_id | Guided path version ID. |
start_time | Date and time Path execution started. |
end_time | Date and time Path execution ended. |
latest_path_activity_time | Date and time of latest activity associated with the Path. |
latest_activity_time | Date and time of the latest activity either on this Session or for the Agent. |
latest_activity_event | Latest activity event associated with the Session. |
latest_session_pause_time | Date and time Agent paused work on the Session. |
latest_path_start_time | Date and time Path was started/restarted. |
attended_duration | Time spent working on the Session. (in seconds) |
step_helpful_count | Number of Steps marked "helpful." |
step_not_helpful_count | Number of Steps marked "not helpful." |
step_blank_count | Number of Steps not marked as "helpful" or "not helpful." |
attended_step_duration | Time spent working on the Step (in seconds) |
rating | Rating given by the Consumer to the workflow. |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
agent_given_name | Agent first name. |
agent_family_name | Agent last name. |
agent_external_id | Agent ID in an external system. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
path_id | Guided Path ID. |
category_id | Category ID |
SelfService_Session_Path_Step_Activity
This activity view displays information regarding a specific Self-Service Step in a Path.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
session_device_id | Device ID. |
session_path_id | Unique ID for each Session+Path combination |
session_path_step_id | Unique ID for each Path+Step combination. |
path_version_step_id | ID representing the Step version. |
start_time | Date and time Step execution started. |
end_time | Date and time Step execution ended. |
attended_duration | Time Agent worked on the Step. (in seconds) |
status | Session status. |
was_assisted | This field contains True if the Session was escalated. |
session_external_id | Session ID in an external system. |
session_device_type | Device type (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
agent_given_name | Agent first name. |
agent_family_name | Agent last name. |
agent_external_id | Agent ID in an external system. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
SelfService_Session_Device_Activity
A Session can be used to service multiple devices. This activity view has a row for each device that was worked on in a Self-Service Session.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
addpath_id | Guided Path ID. |
session_device_id | Device ID. |
start_time | Date and time of first Session activity. |
first_device_start_time | Date and time the first event was received from the device. |
latest_device_activity_time | Date and time the latest event was received from the device. |
latest_activity_time | Date and time of the latest Session activity. |
latest_activity_event | Latest activity event. |
latest_session_pause_time | Latest session pause time. |
latest_device_start_time | Latest device start time. |
path_create_count | Number of times a Path is created under the device. |
path_start_count | Number of times a Path is started under the device. |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
agent_given_name | Agent first name. |
agent_family_name | Agent last name. |
agent_external_id | Agent ID in an external system. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
SelfService_Session_Queue_Activity
This activity view tracks events on that occurred on a Session while it was in a queue.
id | Unique ID for each row in this view. (Primary Key) |
session_id | Session ID. |
escalation_time | Date and time Session was escalated to enter a queue. |
start_time | Date and time Session entered queue. |
start_reason_code | How the Session was escalated. Reason codes include:
|
offer_time | Date and time Session was offered to an Agent. |
offer_to | Agent to which the Session was offered. |
end_time | Date and time offer was removed. |
end_reason_code | Reason the offer was removed. Reason codes include:
|
end_by | Agent that took the action listed in end_reason_code. |
consumer_abandoned_time | Date and time Consumer abandoned the session before it was picked by an Agent. |
session_external_id | Session ID in an external system. |
session_device_type | Device type. (e.g. computer, mobile, other) |
agent_id | Agent ID. |
agent_email | Agent email. |
agent_given_name | Agent first name. |
agent_family_name | Agent last name. |
agent_external_id | Agent ID in an external system. |
consumer_id | Consumer ID. |
consumer_external_id | Consumer ID in an external system. |
session_skill | Skill associated with the Session. |
SelfService_Session_Queue_Statistics
This view displays statistical information regarding a Session that entered a queue.
session_id | Session ID. (Primary Key) |
skill_id | Skill to which the Session was queued. |
session_status | Session status. |
queue_enter_time | Date and time the Session was escalated and entered the queue. |
total_time_spent_in_queue | Time the Session statyed in queue. (in seconds) |
end_time | Time Agent accepted the Session if end_reason_code is other than "SESSION_REQUEUED". Time the Session re-queued if end_reason_code= "SESSION_REQUEUED" . |
end_reason_code | Reason for assigning the Session. |
accepted_agent_id | Agent ID. (Foreign Key) |
accepted_agent_email | Agent email. |
session_external_id | Session ID in an external system. |
consumer_id | Consumer ID. |
consumer_abandoned_time | Date and time Consumer abandoned the Session before it was picked up by an Agent. |
chat_picked_time | Time Agent first enters Chat. |
chat_end_time | Time Agent closed the Session or the Consumer closed Chat. |
total_chat_time | Chat duration. (in seconds) |
SelfService_Aggregate_Statistics
This view displays counts of outcomes of Self-Service Sessions.
total_selfservice_sessions | Number of sessions that used Self-Service. |
distinct_call_escalation_count | Number of distinct sessions escalated using call. |
total_call_escalation_count | Number of escalations using call. |
distinct_chat_escalation_count | Number of distinct Sessions escalated using Chat. |
total_chat_escalation_count | Number of escalations using Chat. |
sessions_with_agent_presence | Self-Service Sessions where Agent assignment occurred. |
distinct_selfservice_escalations | Number of distinct Sessions escalated using either Chat or call. |
total_selfservice_escalations | Number of escalations using either Chat or call. |
SeeSupport_Aggregate_Statistics
This view displays counts of outcomes of SeeSupport Sessions.
seesupport_session_count | Number of Sessions that used SeeSupport. |
ios_seesupport_session_count | Number of SeeSupport Sessions with iOS devices. |
android_seesupport_session_count | Number of SeeSupport Sessions with android devices. |
annotation_session_count | Number of SeeSupport Sessions that used annotation. |
screenshare_in_seesupport_count | Number of Sessions that used both screenshare & SeeSupport. |
app_background_session_count | Number of Sessions where app was taken to the background. |
framerate_changed_session_count | Number of SeeSupport sessions where framerate was modified. |
flashlight_session_count | Number of SeeSupport Sessions where flashlight was used. |
seesupport_zoom_session_count | Number of SeeSupport Sessions where zoom was used. |
email_link_sent_count | Number of Sessions email containing a link to the app was sent to the Consumer. |
sms_link_sent_count | Number of times where SMS containing a link to the app was sent to the Consumer. |
total_seesupport_time | Time SeeSupport streaming was used (in seconds). |
seesupport_mms_session_count | Number of Sessions where MMS feature was used. |
seesupport_mms_images_received_session_count | Number of Sessions where image/s were received. |
seesupport_mms_images_sent_session_count | Number of Sessions where Agent sent image/s. |
seesupport_chathistory_used_session_count | Number of Sessions where the Chat history pane was expanded. |
Path_Category
This view displays Guided Path metadata.
path_id | Guided Path ID. |
path_published_version | Published Path version. |
path_name | Guided Path Name. |
path_description | Guided Path description. |
path_uid | GUID used to uniquely identify a Guided Path. |
path_tags | Self-Service tags configured for the Guided Path. |
path_audience | Guided Path intended audience. - 1. Agent-Facing (string AGENT) 2. Consumer-Facing (string CONSUMER) 3. Both (string ALL) |
path_help_id | Self-Service help ID configured for referring to this Guided Path in Self-Service app. |
path_time_modified | Date and time the Path was last modified. |
category_id | Category ID. |
category_name | Category name. |
category_enabled | This field contains True if the Category is enabled. |
category_display_order | Category image display order. |
category_time_created | Date and time of Category creation. |
category_time_modified | Date and time of Category modification. |
category_uid | GUID used to uniquely identify a Category. |
category_ancestors | Ancestors or parent category. |
Path_Timeline
This view displays information regarding how a Guided Path was chosen for delivery and statistics about the Path's usage in a Session.
session_id | Id of the session on which the delivery occurred |
session_path_id | If a session used multiple workflows, there's one session_workflow_id for each GP selection |
category_name | Category chosen to select the Guided Path |
path_id | Guided path id |
path_name | Guided Path Name |
session_path_aborted | Whether the GP delivery was aborted or not |
attended_duration | Amount of time spent on the path in the session |
session_path_start_time | Time at which workflow was chosen |
session_path_end_time | Time at which workflow was closed |
total_steps | Total number of steps in the Workflow |
completed_percent | Percentage of steps completed during delivery |
Session_Agent_Comments
This view displays information regarding Agent comments.
session_id | Session ID. (Primary Key) |
agent_id | Agent ID. |
agent_email | Agent email. |
time_created | Date and time of comment creation. |
agent_comment | Agent comment. |
Session_Consumer_Device_Data
This view displays information regarding a Consumer's device.
session_id | Session ID. (Primary Key) |
start_time | Date and time Session started. |
device_id | Device ID. (Foreign Key) |
device_type | Type of device. ('computer' or 'mobile' or 'other') |
device_name | Device name. |
device_os | Device operating system information. |
device_time_created | Date and time of device record creation. |
device_arch | Device architecture. |
device_memory | Device RAM. |
device_serial | Device serial. |
device_serial2 | Device serial 2. |
device_vendor | Device manufacturer. |
device_model | Device model. |
device_ip_address | Device IP address. |
device_os_lang | Device operating system language. |