Bot analytics data in the Amazon Connect analytics data lake
This topic details the content in the Amazon Connect analytics data lake bot tables. The tables list the column, type, and description of the content.
There are two ways to access the analytics data lake and configure data to be shared:
If you are unable to access the scheduling tables by using Option 1, try using Option 2.
Bot conversations
Table name: bot_conversations
Composite primary key: {instance_id, event_id}
| Column | Type | Description |
|---|---|---|
| event_id | String | This is the primary key of the table. This will be a hash of originating request identifier and session identifier. |
| bot_originating_request_id | String | A unique identifier for a specific bot request. |
| bot_session_id | String | The identifier of the user session that is having the conversation. |
| aws_account_id | String | The identifier of the AWS account that owns the contact. |
| instance_arn | String | The ARN of the Amazon Connect instance. |
| instance_id | String | The identifier of the Amazon Connect instance. |
| invoking_resource_type | String | Can be flow or module. |
| flow_resource_id | String | Flow identifier. |
| module_resource_id | String | Module identifier. |
| invoking_resource_start_timestamp | Timestamp | Time at which flow started. |
| parent_flow_resource_id | String | Flow Id from which the module was invoked from. This field will only be populated for modules. |
| contact_id | String | The identifier of the contact. |
| flow_action_id | String | Identifier for action that was executed. An Action is a single step of a flow's run. |
| invoking_resource_published_timestamp | Timestamp | "Creation" or "revision" date of the flow itself. |
| flow_type | String | Amazon Connect includes a set of nine flow types. For more information, see Choose a flow type. |
| channel | String | The method used to contact your contact center: VOICE, CHAT, TASK. |
| sub_type | String | This subtype for the contact. For example, connect:Guide or connect:SMS. |
| initiation_method | String | Indicates how the contact was initiated. |
| flow_language_version | String | Flow language version. |
| invoking_resource_version | String | Version of the contact flow used. |
| bot_id | String | The identifier of the bot. |
| bot_alias_id | String | The alias identifier of the bot that the session was held with. |
| bot_version | String | The version of the bot that the session was held with. |
| bot_locale | String | Language configuration of the bot. |
| bot_conversation_start_timestamp | Timestamp | The Timestamp marking the start of the conversation with the bot. |
| bot_conversation_end_timestamp | Timestamp | The Timestamp marking the end of the conversation with the bot. |
| bot_conversation_outcome | String | The final state of the conversation. Values: Success | Failure | Dropped |
| bot_number_of_conversation_turns | Number | The number of turns that the session took. |
| data_lake_last_processed_timestamp | Timestamp | Timestamp, which shows the last time the data lake processed the record. This can include transformation and backfill. This field cannot be used to determine reliably data freshness. |
Bot intents
Table name: bot_intents
Composite primary key: {instance_id, event_id}
| Column | Type | Description |
|---|---|---|
| event_id | String | This is the primary key of the table. This will be a hash of originating request identifier, session identifier, intent name, and intent level. |
| bot_originating_request_id | String | A unique identifier for a specific bot request. |
| bot_session_id | String | The identifier of the user session that is having the conversation. |
| account_id | String | The identifier of the AWS account that owns the contact. |
| instance_arn | String | The ARN of the Amazon Connect instance. |
| instance_id | String | The identifier of the Amazon Connect instance. |
| invoking_resource_type | String | Can be flow or module. |
| flow_resource_id | String | The flow identifier. |
| module_resource_id | String | The module identifier. |
| invoking_resource_start_timestamp | Timestamp | The time when the flow started. |
| parent_flow_resource_id | String | The flow identifier where the module was invoked. This field is only be populated for modules. |
| contact_id | String | The identifier of the contact. |
| action_id | String | The identifier for action that was executed. An Action is a single step of a flow's run. |
| invoking_resource_published_timestamp | Timestamp | The "creation" or "revision" date of the flow itself. |
| flow_type | String | The type of flow. Amazon Connect includes a set of nine flow types. For more information, see Choose a flow type. |
| channel | String | The method used to contact your contact center: VOICE, CHAT, TASK. |
| sub_type | String | The subtype for the contact. For example, connect:Guide or connect:SMS. |
| initiation_method | String | How the contact was initiated. |
| flow_language_version | String | The flow language version. |
| invoking_resource_version | String | Version of the contact flow used. |
| bot_id | String | The identifier of the bot. |
| bot_alias_id | String | The alias identifier of the bot that the session was held. with |
| bot_version | String | The version of the bot that the session was held with. |
| bot_locale | String | The language configuration of the bot. |
| bot_conversation_start_timestamp | Timestamp | The Timestamp marking the start of the conversation with the bot. |
| bot_conversation_end_timestamp | Timestamp | The Timestamp marking the end of the conversation with the bot. |
| bot_intent_name | String | The name of the intent. |
| bot_intent_level | Number | The number of intents up to and including the requested path. |
| bot_intent_outcome | String | The end state of the intent. Value of Success, Failed, Switched, or Dropped. |
| data_lake_last_processed_timestamp | Timestamp | The Timestamp, which shows the last time the data lake processed the record. This can include transformation and backfill. This field cannot be used to determine reliably data freshness. |
| chat_contact_metrics_total_messages | bigint | The number of chat messages on the contact |
| chat_contact_metrics_conversation_close_time_ms | bigint | The time it took for a contact to end after the last customer message |
| chat_contact_metrics_conversation_turn_count | bigint | The number of conversation turns in a chat contact |
| chat_contact_metrics_agent_first_response_timestamp | Timestamp | The agent first response timestamp for a chat contact. |
| chat_contact_metrics_agent_first_response_time_ms | bigint | The time for an agent to respond after obtaining a chat contact. |
| chat_contact_metrics_total_bot_messages | bigint | The total number of bot and automated messages on a chat contact. |
| chat_contact_metrics_total_bot_message_length_in_chars | bigint | The total number of characters from bot and automated messages on a chat contact. |
| chat_contact_metrics_multi_party | Boolean | A flag indicating whether multiparty chat or supervisor barge were enabled on this contact |
| chat_agent_metrics_participant_id | string | The Agent's participant id. |
| chat_agent_metrics_participant_type | string | The Agent's participant type. |
| chat_agent_metrics_conversation_abandon | Boolean | A flag indicating whether the chat conversation was abandoned by an Agent. |
| chat_agent_metrics_messages_sent | bigint | The number of chat messages sent by Agent. |
| chat_agent_metrics_num_responses | bigint | The number of responses sent by Agent to Customer. |
| chat_agent_metrics_message_length_in_chars | bigint | The number of chat characters sent by Agent. |
| chat_agent_metrics_total_response_time_ms | bigint | The total chat response time by Agent. |
| chat_agent_metrics_max_response_time_ms | bigint | The maximum chat response time by Agent. |
| chat_agent_metrics_last_message_timestamp | Timestamp | The Timestamp of last chat message by Agent. |
| chat_customer_metrics_participant_id | string | The Customer's participant id. |
| chat_customer_metrics_participant_type | string | The Customer's participant type. |
| chat_customer_metrics_conversation_abandon | Boolean | A flag indicating whether the chat conversation was abandoned by an Customer |
| chat_customer_metrics_messages_sent | bigint | The Number of chat messages sent by Customer. |
| chat_customer_metrics_num_responses | bigint | The number of responses sent by Customer. |
| chat_customer_metrics_message_length_in_chars | bigint | The number of chat characters sent by Customer. |
| chat_customer_metrics_total_response_time_ms | bigint | The total chat response time by Customer. |
| chat_customer_metrics_max_response_time_ms | bigint | The maximum chat response time by Customer. |
| chat_customer_metrics_last_message_timestamp | Timestamp | The Timestamp of last chat message by Customer. |
Bot slots
Table name: bot_slots
Composite primary key: {instance_id, event_id}
| Column | Type | Description |
|---|---|---|
| event_id | String | This is the primary key of the table. This will be a hash of originating request identifier, session identifier, intent name, intent level, slot name, and slot level. |
| bot_originating_request_id | String | A unique identifier for a specific bot request |
| bot_session_id | String | The identifier of the user session that is having the conversation. |
| account_id | String | The identifier of the AWS account that owns the contact. |
| instance_arn | String | The ARN of the Amazon Connect instance. |
| instance_id | String | The identifier of the Amazon Connect instance. |
| invoking_resource_type | String | Can be flow or module. |
| flow_resource_id | String | Flow identifier. |
| module_resource_id | String | Module identifier. |
| invoking_resource_start_timestamp | Timestamp | Time at which flow started. |
| parent_flow_resource_id | String | Flow identifier from which the module was invoked from. This field will only be populated for modules. |
| contact_id | String | The identifier of the contact. |
| action_id | String | Identifier for action that was executed. An Action is a single step of a flow's run. |
| invoking_resource_published_timestamp | Timestamp | "Creation" or "revision" date of the flow itself. |
| flow_type | String | Amazon Connect includes a set of nine flow types. For more information, see Choose a flow type. |
| channel | String | The method used to contact your contact center: VOICE, CHAT, TASK. |
| sub_type | String | This subtype for the contact. For example, connect:Guide or connect:SMS. |
| initiation_method | String | Indicates how the contact was initiated. |
| flow_language_version | String | Flow language version. |
| invoking_resource_version | String | Version of the contact flow used. |
| bot_id | String | The identifier of the bot. |
| bot_alias_id | String | The alias identifier of the bot that the session was held with. |
| bot_version | String | The version of the bot that the session was held with. |
| bot_locale | String | Language configuration of the bot. |
| bot_conversation_start_timestamp | Timestamp | The Timestamp marking the start of the conversation with the bot. |
| bot_conversation_end_timestamp | Timestamp | The Timestamp marking the end of the conversation with the bot. |
| bot_intent_name | String | The name of the intent. |
| bot_intent_level | Number | The number of intents up to and including the requested path. |
| bot_slot_name | String | The name of the slot. |
| bot_slot_level | Number | The number of slots up to and including the requested path. |
| bot_slot_outcome | String | The end state of the slot. Values of Success, Failed, Dropped, or Retry. |
| bot_slot_retry_count | Number | The number of times the bot tried to elicit a response from the user for the slot. |
| data_lake_last_processed_timestamp | Timestamp | Timestamp, which shows the last time the data lake processed the record. This can include transformation and backfill. This field cannot be used to determine reliably data freshness. |
