Analytics Pipeline: Data structure reference | Rasa Documentation

Build your first agent in just a few minutes with Rasa Copilot.

On this page

The data structure is created by the Analytics pipeline and treated as a public API. The versioning of the API follows the Rasa Product Release and Maintenance Policy. All Internal Tables should be considered private and may change without notice.

Database Table Overview [](/content/docs/reference/api/analytics-data-structure-reference/#database-table-overview "Direct link to Database Table Overview"/index.html)

Common Terms [](/content/docs/reference/api/analytics-data-structure-reference/#common-terms "Direct link to Common Terms"/index.html)

a sender is a user who is talking to the assistant through a channel. A user might have multiple senders if they use multiple channels, e.g. communicating with the assistant through a website and through a channel integrated into a mobile app.
a session is a conversation between a sender and the assistant. A session is started when a sender sends a message to the assistant and ends when the session either has been timed out or explicitly ended. If a session is interrupted by a longer period of inactivity new activity will trigger a new session to be created ( configurable\ through the session timeout).
a turn always starts with a message from a sender and ends right before the next message from the sender. A turn can also end with a session being timed out or explicitly ended. A turn will usually contain at least one bot response.
a dialogue stack frame represents the state of a CALM assistant at a certain point in time. The stack frame contains the active flow and step of the assistant. The stack frame is created as the assistant advances through flow(s) and is updated with every event that is sent to the assistant. The stack frame is stored in the rasa_dialogue_stack_frame table.

Tables [](/content/docs/reference/api/analytics-data-structure-reference/#tables "Direct link to Tables"/index.html)

rasa_sender [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_sender "Direct link to rasa_sender"/index.html)

A sender is a user who interacts with the assistant through a Rasa Channel. If the assistant supports more than one channel, a user might have multiple senders. For example, a user might have a sender for the Facebook channel and a sender for the Slack channel.

`id` sender identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-sender-identifier "Direct link to id-sender-identifier"/index.html)

The unique identifier of the sender is generated by Analytics. Sender gets a different, generated id assigned. The id differs from the sender_id used by the Rasa channels, the sender_id in Rasa is the sender_key in Analytics.

Type: varchar(36)
Example: a78783c4-bef7-4e55-9ec7-5afb4420f19a

`sender_key` Rasa channel sender identifier [](/content/docs/reference/api/analytics-data-structure-reference/#sender_key-rasa-channel-sender-identifier "Direct link to sender_key-rasa-channel-sender-identifier"/index.html)

The unique identifier used by the Rasa channel to identify this sender. The sender_key is specific to the channel implementation in Rasa and the format depends on the channel.

Type: varchar(255)
Example: fb26ba0a9d8b4bd99e2b8716acb19e4b

`channel` Rasa channel name [](/content/docs/reference/api/analytics-data-structure-reference/#channel-rasa-channel-name "Direct link to channel-rasa-channel-name"/index.html)

Name of the channel that is used for this sender. The channel names are defined in the implementation of the respective Rasa channel.

Type: varchar(255)
Example: socket.io

`first_seen` first contact with this sender [](/content/docs/reference/api/analytics-data-structure-reference/#first_seen-first-contact-with-this-sender "Direct link to first_seen-first-contact-with-this-sender"/index.html)

The date and time of the first contact with this sender. Corresponds to the time of the first event of the first session created for this sender.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`last_seen` latest contact with this sender [](/content/docs/reference/api/analytics-data-structure-reference/#last_seen-latest-contact-with-this-sender "Direct link to last_seen-latest-contact-with-this-sender"/index.html)

The date and time of the last contact with this sender. Corresponds to the time of the latest event of the latest session created for this sender.

Type: DateTime
Example: 2022-10-28 02:15:49.326936

rasa_session [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_session "Direct link to rasa_session"/index.html)

The rasa_session table contains information about all conversation sessions that users started with the assistant. New sessions are created for every new user and for users who return to the assistant. The conditions that trigger a new session to start can be configured in the Rasa Domain.

`id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-session-identifier "Direct link to id-session-identifier"/index.html)

The unique identifier of the session. Every session gets a different, generated id assigned.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`sender_id` sender who started the session [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-session "Direct link to sender_id-sender-who-started-the-session"/index.html)

The unique identifier of the sender who started the session. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`timestamp` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time "Direct link to timestamp-creation-date-time"/index.html)

The timestamp when the session was created. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`start_sequence_number` start of the session [](/content/docs/reference/api/analytics-data-structure-reference/#start_sequence_number-start-of-the-session "Direct link to start_sequence_number-start-of-the-session"/index.html)

The sequence number of the first event in this session. All events belong to exactly one session. The start sequence number is always smaller or equal to the end_sequence_number. The difference between start and end sequence numbers does not equal the number of events in this session since sequence numbers are incremented across multiple conversations.

Type: Integer
Example: 78

`end_sequence_number` end of the session [](/content/docs/reference/api/analytics-data-structure-reference/#end_sequence_number-end-of-the-session "Direct link to end_sequence_number-end-of-the-session"/index.html)

The sequence number of the last event in the session.

Type: Integer
Example: 91

rasa_turn [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_turn "Direct link to rasa_turn"/index.html)

The rasa_turn table contains information about all conversation turns. A turn is one interaction between a user and an assistant. A turn always starts with a user message. It ends with the last event before the next user message or with the end of a session. A turn will usually be one user message followed by one or multiple assistant responses. All events between the user message and the end of the turn belong to the same turn.

`id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-session-identifier-1 "Direct link to id-session-identifier-1"/index.html)

The unique identifier of the turn. Every turn gets a different generated id assigned.

Type: varchar(36)
Example: ffa5d0cd-f5a6-45a4-9506-ba7ffd76edf1

`sender_id` sender who started the turn [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-turn "Direct link to sender_id-sender-who-started-the-turn"/index.html)

The unique identifier of the sender who started the turn. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier "Direct link to session_id-session-identifier"/index.html)

The unique identifier of the session this turn is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`start_sequence_number` start of the turn [](/content/docs/reference/api/analytics-data-structure-reference/#start_sequence_number-start-of-the-turn "Direct link to start_sequence_number-start-of-the-turn"/index.html)

The sequence number of the first event in this turn. All events belong to exactly one session. The start sequence number is always smaller or equal to the end_sequence_number. The difference between start and end sequence numbers does not equal the number of events in this session since sequence numbers are incremented across multiple conversations.

Type: Integer
Example: 79

`end_sequence_number` end of the turn [](/content/docs/reference/api/analytics-data-structure-reference/#end_sequence_number-end-of-the-turn "Direct link to end_sequence_number-end-of-the-turn"/index.html)

The sequence number of the last event in this turn.

Type: Integer
Example: 82

rasa_dialogue_stack_frame [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_dialogue_stack_frame "Direct link to rasa_dialogue_stack_frame"/index.html)

The rasa_dialogue_stack_frame table contains information about the active flow identifier and flow step id of the topmost dialogue stack frame. The CALM assistant adds and removes stack frames to the dialogue stack as it advances through the flow and across flows. When a new DialogueStackUpdated event is received, the table is updated with the new stack frame information.

The end sequence number of the stack frame record is updated with the sequence number property of every rasa event that is sent by the assistant after emitting a DialogueStackUpdated event. This indicates that the events taking place after this stack update event are associated with the saved stack frame record. The end sequence number is no longer updated when the next DialogueStackUpdated event is received.

`id` stack frame identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-stack-frame-identifier "Direct link to id-stack-frame-identifier"/index.html)

The unique identifier of the stack frame. Every stack frame record gets a different generated id assigned.

`sender_id` sender who started the stack frame [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-stack-frame "Direct link to sender_id-sender-who-started-the-stack-frame"/index.html)

The unique identifier of the sender who started the stack frame. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-1 "Direct link to session_id-session-identifier-1"/index.html)

The unique identifier of the session this stack frame is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`active_flow_identifier` active flow identifier [](/content/docs/reference/api/analytics-data-structure-reference/#active_flow_identifier-active-flow-identifier "Direct link to active_flow_identifier-active-flow-identifier"/index.html)

The identifier of the active flow in the stack frame. The flow identifier is the flow id in the flows yaml file. When the assistant is not in a flow, the active flow identifier is null.

Type: varchar(255)
Example: book_restaurant

`flow_step_id` step identifier [](/content/docs/reference/api/analytics-data-structure-reference/#flow_step_id-step-identifier "Direct link to flow_step_id-step-identifier"/index.html)

The identifier of the current step in the stack frame. The step identifier is the step id in the flows yaml file. When the assistant is not in a flow, the current step is null.

Type: varchar(255)
Example: 2_ask_amount

`inserted_at` creation timestamp [](/content/docs/reference/api/analytics-data-structure-reference/#inserted_at-creation-timestamp "Direct link to inserted_at-creation-timestamp"/index.html)

The timestamp when the stack frame was created. The timestamp is in UTC. The timestamp corresponds to the first event timestamp in the stack frame.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`start_sequence_number` start of the stack frame [](/content/docs/reference/api/analytics-data-structure-reference/#start_sequence_number-start-of-the-stack-frame "Direct link to start_sequence_number-start-of-the-stack-frame"/index.html)

The sequence number of the first event in this stack frame. All events belong to exactly one session. The start sequence number is always smaller or equal to the end_sequence_number. The difference between start and end sequence numbers does not equal the number of events in this session since sequence numbers are incremented across multiple conversations.

Type: Integer
Example: 79

`end_sequence_number` end of the stack frame [](/content/docs/reference/api/analytics-data-structure-reference/#end_sequence_number-end-of-the-stack-frame "Direct link to end_sequence_number-end-of-the-stack-frame"/index.html)

The sequence number of the last event in this stack frame.

Type: Integer
Example: 82

rasa_flow_status [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_flow_status "Direct link to rasa_flow_status"/index.html)

The rasa_flow_status table contains information about the active flow, status of the flow and flow step id in any given session.

`id` flow status identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-flow-status-identifier "Direct link to id-flow-status-identifier"/index.html)

The unique identifier of the flow status record. Every flow status record gets a different generated id assigned.

`sender_id` sender who started the flow status [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-flow-status "Direct link to sender_id-sender-who-started-the-flow-status"/index.html)

The unique identifier of the sender who started the flow event. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-2 "Direct link to session_id-session-identifier-2"/index.html)

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`flow_identifier` flow identifier [](/content/docs/reference/api/analytics-data-structure-reference/#flow_identifier-flow-identifier "Direct link to flow_identifier-flow-identifier"/index.html)

The identifier of the active flow in the stack frame. The flow identifier is the flow id in the flows yaml file.

Type: varchar(255)
Example: book_restaurant

`flow_status` flow status [](/content/docs/reference/api/analytics-data-structure-reference/#flow_status-flow-status "Direct link to flow_status-flow-status"/index.html)

The status of the flow. The flow status can be one of the following: The flow status can be one of the following:

started: The flow is started and the assistant is in the flow.
completed: The flow is completed and the assistant is not in the flow.
interrupted: The flow is interrupted and the assistant is not in the flow.
resumed: The flow is resumed and the assistant is in the flow.
cancelled: The flow is aborted and the assistant is not in the flow.
Type: varchar(255)
Example: started

`step_id` step identifier [](/content/docs/reference/api/analytics-data-structure-reference/#step_id-step-identifier "Direct link to step_id-step-identifier"/index.html)

The identifier of the current step in the stack frame. The step identifier is the step id in the flows yaml file.

Type: varchar(255)
Example: 0_ask_amount

`inserted_at` creation timestamp [](/content/docs/reference/api/analytics-data-structure-reference/#inserted_at-creation-timestamp-1 "Direct link to inserted_at-creation-timestamp-1"/index.html)

The timestamp when the flow status was created. The timestamp is in UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

rasa_event [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_event "Direct link to rasa_event"/index.html)

The rasa_event table contains all events that an assistant created. Events are created for every user message, bot response, and action that is executed as well as for a lot of internal changes to a conversation session. Overview of all Rasa Events.

`id` event identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-event-identifier "Direct link to id-event-identifier"/index.html)

The unique identifier of the event. Every event gets different, generated id assigned.

Type: varchar(36)
Example: f5adcd16-b18d-4c5c-95f0-1747b20cb0e6

`sender_id` sender whose conversation the event belongs to [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-event-belongs-to "Direct link to sender_id-sender-whose-conversation-the-event-belongs-to"/index.html)

The unique identifier of the sender whose conversation this event is part of. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-3 "Direct link to session_id-session-identifier-3"/index.html)

The unique identifier of the session this event is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`timestamp` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-1 "Direct link to timestamp-creation-date-time-1"/index.html)

The timestamp when the event was created. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`event_type` kind of event [](/content/docs/reference/api/analytics-data-structure-reference/#event_type-kind-of-event "Direct link to event_type-kind-of-event"/index.html)

The type of the event. The event type is a string and can be one of the following:

user: The user sent a message to the assistant.
bot: The assistant sent a message to the user.
action: The assistant executed an action.
session_started: A new session was started.
action_execution_rejected: An action failed to execute.
active_loop: The assistant is currently in a loop.
slot: A slot was set.
followup: A follow-up action was triggered.
loop_interrupted: A loop was interrupted.
pause: A session is paused, e.g. because the session was handed over to a human agent.
restart: A session was restarted. This will trigger a new session to be started. The state of the assistant will be reset.
rewind: The assistant rewinds to a previous state.
user_featurization: The assistant featurized the user input.

The event type defines how the event is interpreted and how the event affects the conversation. For example, the user event type will be interpreted as a user message and the bot event type will be interpreted as a bot response.

Type: varchar(255)
Example: action

`model_id` model identifier [](/content/docs/reference/api/analytics-data-structure-reference/#model_id-model-identifier "Direct link to model_id-model-identifier"/index.html)

The identifier of the Rasa model that was running as part of the assistant when this event was created.

Type: varchar(255)
Example: 75a985b7b86d442ca013d61ea4781b22

`environment` name of the assistant environment [](/content/docs/reference/api/analytics-data-structure-reference/#environment-name-of-the-assistant-environment "Direct link to environment-name-of-the-assistant-environment"/index.html)

The name of the environment of the assistant that created this event. The environment is a string that is set up during the start of the assistant,

Type: varchar(255)
Example: production

`sequence_number` start of the event [](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event "Direct link to sequence_number-start-of-the-event"/index.html)

The sequence number of the event. The events of a session always have increasing sequence numbers. Sequence numbers are not guaranteed to be sequential for events following one another. But sequence numbers can be used to order the events of a session.

Type: Integer
Example: 78

rasa_bot_message [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_bot_message "Direct link to rasa_bot_message"/index.html)

A message sent by the assistant to a user will be tracked in the rasa_bot_message table. The table contains information about the sent message.

`id` bot message identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-bot-message-identifier "Direct link to id-bot-message-identifier"/index.html)

The unique identifier of the bot message is generated by Analytics.

Type: varchar(36)
Example: 2f2e5384-1bfa-4b53-90a7-c75e5f20b117

`event_id` id of the event of this message [](/content/docs/reference/api/analytics-data-structure-reference/#event_id-id-of-the-event-of-this-message "Direct link to event_id-id-of-the-event-of-this-message"/index.html)

The unique identifier of the event that created this bot message. It is a foreign key to the rasa_event.id column.

Type: varchar(36)
Example: f5adcd16-b18d-4c5c-95f0-1747b20cb0e6

`sender_id` sender whose conversation the message belongs to [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-message-belongs-to "Direct link to sender_id-sender-whose-conversation-the-message-belongs-to"/index.html)

The unique identifier of the sender whose conversation this message is part of. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-4 "Direct link to session_id-session-identifier-4"/index.html)

The unique identifier of the session this message is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`timestamp` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-2 "Direct link to timestamp-creation-date-time-2"/index.html)

The timestamp when the message was created. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`template_name` name of the template used to generate the message [](/content/docs/reference/api/analytics-data-structure-reference/#template_name-name-of-the-template-used-to-generate-the-message "Direct link to template_name-name-of-the-template-used-to-generate-the-message"/index.html)

The name of the template that Rasa used to generate the bot message. Might be empty if the message was not generated from a template but a custom action.

Type: varchar(255)
Example: utter_greet

`text` message content [](/content/docs/reference/api/analytics-data-structure-reference/#text-message-content "Direct link to text-message-content"/index.html)

The text of the bot message.

Type: varchar(65535)
Example: Ok, what can I help you with?

`model_id` model identifier [](/content/docs/reference/api/analytics-data-structure-reference/#model_id-model-identifier-1 "Direct link to model_id-model-identifier-1"/index.html)

The identifier of the Rasa model that was running as part of the assistant when this message was created.

Type: varchar(255)
Example: 75a985b7b86d442ca013d61ea4781b22

`sequence_number` start of the event [](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event-1 "Direct link to sequence_number-start-of-the-event-1"/index.html)

The sequence number of the message. The events of a session always have increasing sequence numbers. The sequence number of this message is the same as the one of the underlying event.

Type: Integer
Example: 78

rasa_user_message [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_user_message "Direct link to rasa_user_message"/index.html)

A message sent by a user to the assistant will be tracked in the rasa_user_message table. The table contains information about the sent message.

`id` user message identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-user-message-identifier "Direct link to id-user-message-identifier"/index.html)

The unique identifier of the user message is generated by Analytics.

Type: varchar(36)
Example: 49fdd79e-976b-47c2-ab27-a4c3d743a1c9

`event_id` id of the event of this message [](/content/docs/reference/api/analytics-data-structure-reference/#event_id-id-of-the-event-of-this-message-1 "Direct link to event_id-id-of-the-event-of-this-message-1"/index.html)

The unique identifier of the event that created this user message. It is a foreign key to the rasa_event.id column.

Type: varchar(36)
Example: f5adcd16-b18d-4c5c-95f0-1747b20cb0e6

`sender_id` sender whose conversation the message belongs to [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-message-belongs-to-1 "Direct link to sender_id-sender-whose-conversation-the-message-belongs-to-1"/index.html)

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-5 "Direct link to session_id-session-identifier-5"/index.html)

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`intent` classification of the text [](/content/docs/reference/api/analytics-data-structure-reference/#intent-classification-of-the-text "Direct link to intent-classification-of-the-text"/index.html)

The name of the intent that Rasa classified the text as. One of the intents in the domain used to train the model.

Type: varchar(255)
Example: book_flight

`retrieval_intent` classification of the text [](/content/docs/reference/api/analytics-data-structure-reference/#retrieval_intent-classification-of-the-text "Direct link to retrieval_intent-classification-of-the-text"/index.html)

The name of the retrieval intent that Rasa classified the text as. Only populated if there is a configured retrieval intent.

Type: varchar(255)
Example: book_flight/faq

`confidence` certainty the model predicted for classifications [](/content/docs/reference/api/analytics-data-structure-reference/#confidence-certainty-the-model-predicted-for-classifications "Direct link to confidence-certainty-the-model-predicted-for-classifications"/index.html)

The confidence of the ML model's intent prediction. The confidence is a value between 0 and 1. The higher the value, the more certain the model is that the intent is correct.

Type: Float
Example: 0.8798527419567108

`text` message content [](/content/docs/reference/api/analytics-data-structure-reference/#text-message-content-1 "Direct link to text-message-content-1"/index.html)

The text of the user message.

Type: varchar(65535)
Example: I want to book a flight.

`timestamp` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-3 "Direct link to timestamp-creation-date-time-3"/index.html)

The timestamp when the message was created. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`model_id` model identifier [](/content/docs/reference/api/analytics-data-structure-reference/#model_id-model-identifier-2 "Direct link to model_id-model-identifier-2"/index.html)

The identifier of the Rasa model that was running as part of the assistant when this message was created.

Type: varchar(255)
Example: 75a985b7b86d442ca013d61ea4781b22

`sequence_number` start of the event [](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event-2 "Direct link to sequence_number-start-of-the-event-2"/index.html)

Type: Integer
Example: 78

`message_id` unique id for the message text [](/content/docs/reference/api/analytics-data-structure-reference/#message_id-unique-id-for-the-message-text "Direct link to message_id-unique-id-for-the-message-text"/index.html)

A unique id that identifies the text of the message.

Type: varchar(255)
Example: 7cdb5700ac9c493aa46987b77d91c363

rasa_llm_command [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_llm_command "Direct link to rasa_llm_command"/index.html)

Commands sent by LLMCommandGenerator will be tracked in the rasa_llm_command table. The table contains information about the commands issued in response to each user message.

`id` llm command identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-llm-command-identifier "Direct link to id-llm-command-identifier"/index.html)

The unique identifier of the LLM command is generated by Analytics.

Type: varchar(36)
Example: 49fdd79e-976b-47c2-ab27-a4c3d743a1c9

`sender_id` sender whose conversation the command belongs to [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-command-belongs-to "Direct link to sender_id-sender-whose-conversation-the-command-belongs-to"/index.html)

The unique identifier of the sender whose conversation this command is part of. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-6 "Direct link to session_id-session-identifier-6"/index.html)

The unique identifier of the session this command is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`user_message_id` unique id for the user message text [](/content/docs/reference/api/analytics-data-structure-reference/#user_message_id-unique-id-for-the-user-message-text "Direct link to user_message_id-unique-id-for-the-user-message-text"/index.html)

A unique id that identifies the text of the message. Represents a foreign key to the rasa_user_message.message_id column.

Type: varchar(255)
Example: 7cdb5700ac9c493aa46987b77d91c363

`command` command name [](/content/docs/reference/api/analytics-data-structure-reference/#command-command-name "Direct link to command-command-name"/index.html)

The name of the command issued.

Type: varchar(255)
Example: set slot

`inserted_at` creation timestamp [](/content/docs/reference/api/analytics-data-structure-reference/#inserted_at-creation-timestamp-2 "Direct link to inserted_at-creation-timestamp-2"/index.html)

The timestamp when the user message was received. The timestamp is in UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`flow_identifier` flow identifier [](/content/docs/reference/api/analytics-data-structure-reference/#flow_identifier-flow-identifier-1 "Direct link to flow_identifier-flow-identifier-1"/index.html)

The identifier of the active flow in the stack frame. The flow identifier is the flow id in the flows yaml file. This is only populated for start flow commands.

Type: varchar(255)
Example: book_restaurant

`set_slot_name` slot name [](/content/docs/reference/api/analytics-data-structure-reference/#set_slot_name-slot-name "Direct link to set_slot_name-slot-name"/index.html)

The name of the slot that was set. This is only populated for set slot commands.

Type: varchar(255)
Example: restaurant_name

`clarification_options` list of flow identifiers [](/content/docs/reference/api/analytics-data-structure-reference/#clarification_options-list-of-flow-identifiers "Direct link to clarification_options-list-of-flow-identifiers"/index.html)

The list of flow identifiers that the user can choose from. This is only populated for clarify commands.

Type: varchar(65535)
Example: '["add_contact", "remove_contact"]'

rasa_action [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_action "Direct link to rasa_action"/index.html)

An action executed by the assistant. All actions the bot executes are tracked in the rasa_action table. The table contains information about the executed action and its prediction.

`id` action identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-action-identifier "Direct link to id-action-identifier"/index.html)

The unique identifier of the action execution is generated by Analytics.

Type: varchar(36)
Example: bd074dc7-e745-4db6-86d0-75b0af7bc067

`event_id` id of the event of this action execution [](/content/docs/reference/api/analytics-data-structure-reference/#event_id-id-of-the-event-of-this-action-execution "Direct link to event_id-id-of-the-event-of-this-action-execution"/index.html)

The unique identifier of the event that created this action execution. It is a foreign key to the rasa_event.id column.

Type: varchar(36)
Example: f5adcd16-b18d-4c5c-95f0-1747b20cb0e6

`sender_id` sender whose conversation triggered this action execution [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-triggered-this-action-execution "Direct link to sender_id-sender-whose-conversation-triggered-this-action-execution"/index.html)

The unique identifier of the sender whose conversation triggered this action execution. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-7 "Direct link to session_id-session-identifier-7"/index.html)

The unique identifier of the session this action execution is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`name` name of the executed action [](/content/docs/reference/api/analytics-data-structure-reference/#name-name-of-the-executed-action "Direct link to name-name-of-the-executed-action"/index.html)

The name of the action that Rasa has predicted and executed. One of the actions in the domain used to train the model.

Type: varchar(255)
Example: action_book_flight

`confidence` ML models certainty of the predicted action [](/content/docs/reference/api/analytics-data-structure-reference/#confidence-ml-models-certainty-of-the-predicted-action "Direct link to confidence-ml-models-certainty-of-the-predicted-action"/index.html)

The confidence of ML model's action prediction. The confidence is a value between 0 and 1. The higher the value, the more certain the model is that the action is correct.

Type: Float
Example: 0.9398527419567108

`policy` name of the policy that predicted the action [](/content/docs/reference/api/analytics-data-structure-reference/#policy-name-of-the-policy-that-predicted-the-action "Direct link to policy-name-of-the-policy-that-predicted-the-action"/index.html)

The name of the policy that predicted this action. The policy is a component in the Rasa assistant that makes a prediction. The policy can be a rule policy, a memoization policy, or an ML policy.

Type: varchar(255)
Example: policy_2_TEDPolicy

`timestamp` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-4 "Direct link to timestamp-creation-date-time-4"/index.html)

The timestamp when the action was executed. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`model_id` model identifier [](/content/docs/reference/api/analytics-data-structure-reference/#model_id-model-identifier-3 "Direct link to model_id-model-identifier-3"/index.html)

The identifier of the Rasa model that was running as part of the assistant when this action was executed.

Type: varchar(255)
Example: 75a985b7b86d442ca013d61ea4781b22

`sequence_number` start of the event [](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event-3 "Direct link to sequence_number-start-of-the-event-3"/index.html)

The sequence number of the executed action. The events of a session always have increasing sequence numbers. The sequence number of this executed action is the same as the one of the underlying event.

Type: Integer
Example: 78

rasa_slot [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_slot "Direct link to rasa_slot"/index.html)

A slot that has been set for a session. All changes to slot values are tracked in the rasa_slot table. The table contains information about the change in the value of the slot.

`id` slot change identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-slot-change-identifier "Direct link to id-slot-change-identifier"/index.html)

The unique identifier of this change in slot values is generated by Analytics.

Type: varchar(36)
Example: a793d284-b5b9-4cef-be8a-bc0f58c70c28

`event_id` id of the event that triggered this slot change [](/content/docs/reference/api/analytics-data-structure-reference/#event_id-id-of-the-event-that-triggered-this-slot-change "Direct link to event_id-id-of-the-event-that-triggered-this-slot-change"/index.html)

The unique identifier of the event that triggered this change in the slot value. It is a foreign key to the rasa_event.id column.

Type: varchar(36)
Example: f5adcd16-b18d-4c5c-95f0-1747b20cb0e6

`sender_id` sender whose conversation triggered this slot change [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-triggered-this-slot-change "Direct link to sender_id-sender-whose-conversation-triggered-this-slot-change"/index.html)

The unique identifier of the sender whose conversation triggered this slot change. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-8 "Direct link to session_id-session-identifier-8"/index.html)

The unique identifier of the session this slot change is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`slot_path` path of the slot [](/content/docs/reference/api/analytics-data-structure-reference/#slot_path-path-of-the-slot "Direct link to slot_path-path-of-the-slot"/index.html)

A path to the slot that was changed. The path identifies the slot by its name, the sender and the session. The path is a string that looks like <sender_id>/<session_id>/<slot_name>.

Type: varchar(255)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53/63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1/email

`name` name of the slot [](/content/docs/reference/api/analytics-data-structure-reference/#name-name-of-the-slot "Direct link to name-name-of-the-slot"/index.html)

The name of the changed slot. The name of the slot is the same as the name of the slot in the domain.

Type: varchar(255)
Example: email

`value` new slot value [](/content/docs/reference/api/analytics-data-structure-reference/#value-new-slot-value "Direct link to value-new-slot-value"/index.html)

The new value of the slot for the session. The value is a dumped JSON object.

Type: varchar(65535)
Example: john@example.com

`timestamp` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-5 "Direct link to timestamp-creation-date-time-5"/index.html)

The timestamp when the slot value was changed. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-28 02:15:49.326936

`sequence_number` start of the event [](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event-4 "Direct link to sequence_number-start-of-the-event-4"/index.html)

The sequence number of the slot change. The events of a session always have increasing sequence numbers. The sequence number of the slot change is the same as the one of the underlying event.

Type: Integer
Example: 78

rasa_session_slot_state [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_session_slot_state "Direct link to rasa_session_slot_state"/index.html)

The state of a slot at the end of a session. The state of a slot is the value of the slot at the end of a session. The state of a slot is stored in the rasa_session_slot_state table.

`id` path of the slot [](/content/docs/reference/api/analytics-data-structure-reference/#id-path-of-the-slot "Direct link to id-path-of-the-slot"/index.html)

A path to the slot. The path identifies the slot by its name, the sender and the session. The path is a string that looks like <sender_id>/<session_id>/<slot_name>.

Type: varchar(255)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53/63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1/email

`sender_id` sender whose conversation this slot is part of [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-this-slot-is-part-of "Direct link to sender_id-sender-whose-conversation-this-slot-is-part-of"/index.html)

The unique identifier of the sender whose conversation this slot is part of. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-9 "Direct link to session_id-session-identifier-9"/index.html)

The unique identifier of the session this slot is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`name` name of the slot [](/content/docs/reference/api/analytics-data-structure-reference/#name-name-of-the-slot-1 "Direct link to name-name-of-the-slot-1"/index.html)

The name of the slot. The name of the slot is the same as the name of the slot in the domain.

Type: varchar(255)
Example: email

`value` last value of the slot in the session [](/content/docs/reference/api/analytics-data-structure-reference/#value-last-value-of-the-slot-in-the-session "Direct link to value-last-value-of-the-slot-in-the-session"/index.html)

The value of the slot at the end of the session. The value is a dumped JSON object. If a slot is changed multiple times during a session, the value is set to the last change.

Type: varchar(65535)
Example: john@example.com

`timestamp` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-6 "Direct link to timestamp-creation-date-time-6"/index.html)

Time of the last update of the slot in this session. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-21 02:15:49.326936

rasa_pattern [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_pattern "Direct link to rasa_pattern"/index.html)

Patterns are marker definitions that have been received from Rasa. This table is called rasa_pattern to distinguish them from extracted markers which are stored in rasa_marker table. It stores the configuration of markers (which can be thought of as a pattern of conversational events) along with their metadata.

`id` pattern identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-pattern-identifier "Direct link to id-pattern-identifier"/index.html)

The unique identifier of the rasa pattern is generated by Analytics.

Type: varchar(36)
Example: bd074dc7-e745-4db6-86d0-75b0af7bc067

`name` pattern name [](/content/docs/reference/api/analytics-data-structure-reference/#name-pattern-name "Direct link to name-pattern-name"/index.html)

Name of the pattern

Type: varchar()
Example: registration success

`description` pattern description [](/content/docs/reference/api/analytics-data-structure-reference/#description-pattern-description "Direct link to description-pattern-description"/index.html)

Description of the pattern

Type: varchar()
Example: This marker identifies successful account registration in the chat

`config` pattern configuration [](/content/docs/reference/api/analytics-data-structure-reference/#config-pattern-configuration "Direct link to config-pattern-configuration"/index.html)

Pattern configuration dictionary stored as an escaped string

Type: varchar()
Example: "{'or': [{'intent': 'mood_unhappy'},{'intent': 'mood_great'}]}"

`is_active` soft-delete flag [](/content/docs/reference/api/analytics-data-structure-reference/#is_active-soft-delete-flag "Direct link to is_active-soft-delete-flag"/index.html)

Only patterns with is_active==True are processed during real-time analysis

Type: boolean

`created_at` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#created_at-creation-date-time "Direct link to created_at-creation-date-time"/index.html)

Time of creation of this pattern. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-21 02:15:49.326936

`updated_at` update date time [](/content/docs/reference/api/analytics-data-structure-reference/#updated_at-update-date-time "Direct link to updated_at-update-date-time"/index.html)

Time of the last update of the pattern in this session. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-21 02:15:49.326936

rasa_marker [](/content/docs/reference/api/analytics-data-structure-reference/#rasa_marker "Direct link to rasa_marker"/index.html)

Extracted markers from the conversations. Each row in this table corresponds to a marker along with details of the pattern, sender, session and the last event where it was extracted.

`id` marker identifier [](/content/docs/reference/api/analytics-data-structure-reference/#id-marker-identifier "Direct link to id-marker-identifier"/index.html)

The unique identifier of the extracted rasa marker is generated by Analytics.

Type: varchar(36)
Example: bd074dc7-e745-4db6-86d0-75b0af7bc067

`pattern_id` pattern which was applied in this marker [](/content/docs/reference/api/analytics-data-structure-reference/#pattern_id-pattern-which-was-applied-in-this-marker "Direct link to pattern_id-pattern-which-was-applied-in-this-marker"/index.html)

The unique identifier of the pattern which was applied in this marker. It is a foreign key to the rasa_pattern.id column

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`sender_id` sender identifier [](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-identifier "Direct link to sender_id-sender-identifier"/index.html)

The unique identifier of the sender whose conversation this marker is part of. It is a foreign key to the rasa_sender.id column.

Type: varchar(36)
Example: 9e4ebded-f232-4cc5-af78-d98daa0c1a53

`session_id` session identifier [](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-10 "Direct link to session_id-session-identifier-10"/index.html)

The unique identifier of the session this marker is part of. It is a foreign key to the rasa_session.id column.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`event_id` event identifier [](/content/docs/reference/api/analytics-data-structure-reference/#event_id-event-identifier "Direct link to event_id-event-identifier"/index.html)

The unique identifier of the event from event broker where this marker was applied. Note that a marker can be applied across multiple events, this is the ID of the last event in the sequence.

Type: varchar(36)
Example: 63b150a6-21a3-4e6c-bb24-5ab6ddc30cf1

`num_preceding_user_turns` Number of Proeeding User turns [](/content/docs/reference/api/analytics-data-structure-reference/#num_preceding_user_turns-number-of-proeeding-user-turns "Direct link to num_preceding_user_turns-number-of-proeeding-user-turns"/index.html)

an integer indicating the number of user turns preceding the event at which the marker applied.

Type: integer
Example: 4

`created_at` creation date time [](/content/docs/reference/api/analytics-data-structure-reference/#created_at-creation-date-time-1 "Direct link to created_at-creation-date-time-1"/index.html)

Time of creation of this marker. The timestamp is a UTC.

Type: DateTime
Example: 2022-06-21 02:15:49.326936

Internal Tables [](/content/docs/reference/api/analytics-data-structure-reference/#internal-tables "Direct link to Internal Tables"/index.html)

Internal tables are used to store information about the assistant and the events that are sent to the assistant. They are not meant to be queried directly but are required for the functioning of Analytics. They are a private API that is used by the Analytics service internally and might change without notice.

Internal tables:

Ask AI

🍪 Cookie settings

We use cookies to keep things running smoothly and improve your experience.

Customize settings

Accept allReject all

Database Table Overview [​](/content/docs/reference/api/analytics-data-structure-reference/#database-table-overview "Direct link to Database Table Overview"/index.html)

Common Terms [​](/content/docs/reference/api/analytics-data-structure-reference/#common-terms "Direct link to Common Terms"/index.html)

Tables [​](/content/docs/reference/api/analytics-data-structure-reference/#tables "Direct link to Tables"/index.html)

rasa_sender [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_sender "Direct link to rasa_sender"/index.html)

id sender identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-sender-identifier "Direct link to id-sender-identifier"/index.html)

sender_key Rasa channel sender identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_key-rasa-channel-sender-identifier "Direct link to sender_key-rasa-channel-sender-identifier"/index.html)

channel Rasa channel name [​](/content/docs/reference/api/analytics-data-structure-reference/#channel-rasa-channel-name "Direct link to channel-rasa-channel-name"/index.html)

first_seen first contact with this sender [​](/content/docs/reference/api/analytics-data-structure-reference/#first_seen-first-contact-with-this-sender "Direct link to first_seen-first-contact-with-this-sender"/index.html)

last_seen latest contact with this sender [​](/content/docs/reference/api/analytics-data-structure-reference/#last_seen-latest-contact-with-this-sender "Direct link to last_seen-latest-contact-with-this-sender"/index.html)

rasa_session [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_session "Direct link to rasa_session"/index.html)

id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-session-identifier "Direct link to id-session-identifier"/index.html)

sender_id sender who started the session [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-session "Direct link to sender_id-sender-who-started-the-session"/index.html)

timestamp creation date time [​](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time "Direct link to timestamp-creation-date-time"/index.html)

start_sequence_number start of the session [​](/content/docs/reference/api/analytics-data-structure-reference/#start_sequence_number-start-of-the-session "Direct link to start_sequence_number-start-of-the-session"/index.html)

end_sequence_number end of the session [​](/content/docs/reference/api/analytics-data-structure-reference/#end_sequence_number-end-of-the-session "Direct link to end_sequence_number-end-of-the-session"/index.html)

rasa_turn [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_turn "Direct link to rasa_turn"/index.html)

id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-session-identifier-1 "Direct link to id-session-identifier-1"/index.html)

sender_id sender who started the turn [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-turn "Direct link to sender_id-sender-who-started-the-turn"/index.html)

session_id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier "Direct link to session_id-session-identifier"/index.html)

start_sequence_number start of the turn [​](/content/docs/reference/api/analytics-data-structure-reference/#start_sequence_number-start-of-the-turn "Direct link to start_sequence_number-start-of-the-turn"/index.html)

end_sequence_number end of the turn [​](/content/docs/reference/api/analytics-data-structure-reference/#end_sequence_number-end-of-the-turn "Direct link to end_sequence_number-end-of-the-turn"/index.html)

rasa_dialogue_stack_frame [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_dialogue_stack_frame "Direct link to rasa_dialogue_stack_frame"/index.html)

id stack frame identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-stack-frame-identifier "Direct link to id-stack-frame-identifier"/index.html)

sender_id sender who started the stack frame [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-stack-frame "Direct link to sender_id-sender-who-started-the-stack-frame"/index.html)

session_id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-1 "Direct link to session_id-session-identifier-1"/index.html)

active_flow_identifier active flow identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#active_flow_identifier-active-flow-identifier "Direct link to active_flow_identifier-active-flow-identifier"/index.html)

flow_step_id step identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#flow_step_id-step-identifier "Direct link to flow_step_id-step-identifier"/index.html)

inserted_at creation timestamp [​](/content/docs/reference/api/analytics-data-structure-reference/#inserted_at-creation-timestamp "Direct link to inserted_at-creation-timestamp"/index.html)

start_sequence_number start of the stack frame [​](/content/docs/reference/api/analytics-data-structure-reference/#start_sequence_number-start-of-the-stack-frame "Direct link to start_sequence_number-start-of-the-stack-frame"/index.html)

end_sequence_number end of the stack frame [​](/content/docs/reference/api/analytics-data-structure-reference/#end_sequence_number-end-of-the-stack-frame "Direct link to end_sequence_number-end-of-the-stack-frame"/index.html)

rasa_flow_status [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_flow_status "Direct link to rasa_flow_status"/index.html)

id flow status identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-flow-status-identifier "Direct link to id-flow-status-identifier"/index.html)

sender_id sender who started the flow status [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-who-started-the-flow-status "Direct link to sender_id-sender-who-started-the-flow-status"/index.html)

session_id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-2 "Direct link to session_id-session-identifier-2"/index.html)

flow_identifier flow identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#flow_identifier-flow-identifier "Direct link to flow_identifier-flow-identifier"/index.html)

flow_status flow status [​](/content/docs/reference/api/analytics-data-structure-reference/#flow_status-flow-status "Direct link to flow_status-flow-status"/index.html)

step_id step identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#step_id-step-identifier "Direct link to step_id-step-identifier"/index.html)

inserted_at creation timestamp [​](/content/docs/reference/api/analytics-data-structure-reference/#inserted_at-creation-timestamp-1 "Direct link to inserted_at-creation-timestamp-1"/index.html)

rasa_event [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_event "Direct link to rasa_event"/index.html)

id event identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-event-identifier "Direct link to id-event-identifier"/index.html)

sender_id sender whose conversation the event belongs to [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-event-belongs-to "Direct link to sender_id-sender-whose-conversation-the-event-belongs-to"/index.html)

session_id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-3 "Direct link to session_id-session-identifier-3"/index.html)

timestamp creation date time [​](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-1 "Direct link to timestamp-creation-date-time-1"/index.html)

event_type kind of event [​](/content/docs/reference/api/analytics-data-structure-reference/#event_type-kind-of-event "Direct link to event_type-kind-of-event"/index.html)

model_id model identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#model_id-model-identifier "Direct link to model_id-model-identifier"/index.html)

environment name of the assistant environment [​](/content/docs/reference/api/analytics-data-structure-reference/#environment-name-of-the-assistant-environment "Direct link to environment-name-of-the-assistant-environment"/index.html)

sequence_number start of the event [​](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event "Direct link to sequence_number-start-of-the-event"/index.html)

rasa_bot_message [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_bot_message "Direct link to rasa_bot_message"/index.html)

id bot message identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-bot-message-identifier "Direct link to id-bot-message-identifier"/index.html)

event_id id of the event of this message [​](/content/docs/reference/api/analytics-data-structure-reference/#event_id-id-of-the-event-of-this-message "Direct link to event_id-id-of-the-event-of-this-message"/index.html)

sender_id sender whose conversation the message belongs to [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-message-belongs-to "Direct link to sender_id-sender-whose-conversation-the-message-belongs-to"/index.html)

session_id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-4 "Direct link to session_id-session-identifier-4"/index.html)

timestamp creation date time [​](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-2 "Direct link to timestamp-creation-date-time-2"/index.html)

template_name name of the template used to generate the message [​](/content/docs/reference/api/analytics-data-structure-reference/#template_name-name-of-the-template-used-to-generate-the-message "Direct link to template_name-name-of-the-template-used-to-generate-the-message"/index.html)

text message content [​](/content/docs/reference/api/analytics-data-structure-reference/#text-message-content "Direct link to text-message-content"/index.html)

model_id model identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#model_id-model-identifier-1 "Direct link to model_id-model-identifier-1"/index.html)

sequence_number start of the event [​](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event-1 "Direct link to sequence_number-start-of-the-event-1"/index.html)

rasa_user_message [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_user_message "Direct link to rasa_user_message"/index.html)

id user message identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-user-message-identifier "Direct link to id-user-message-identifier"/index.html)

event_id id of the event of this message [​](/content/docs/reference/api/analytics-data-structure-reference/#event_id-id-of-the-event-of-this-message-1 "Direct link to event_id-id-of-the-event-of-this-message-1"/index.html)

sender_id sender whose conversation the message belongs to [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-message-belongs-to-1 "Direct link to sender_id-sender-whose-conversation-the-message-belongs-to-1"/index.html)

session_id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-5 "Direct link to session_id-session-identifier-5"/index.html)

intent classification of the text [​](/content/docs/reference/api/analytics-data-structure-reference/#intent-classification-of-the-text "Direct link to intent-classification-of-the-text"/index.html)

retrieval_intent classification of the text [​](/content/docs/reference/api/analytics-data-structure-reference/#retrieval_intent-classification-of-the-text "Direct link to retrieval_intent-classification-of-the-text"/index.html)

confidence certainty the model predicted for classifications [​](/content/docs/reference/api/analytics-data-structure-reference/#confidence-certainty-the-model-predicted-for-classifications "Direct link to confidence-certainty-the-model-predicted-for-classifications"/index.html)

text message content [​](/content/docs/reference/api/analytics-data-structure-reference/#text-message-content-1 "Direct link to text-message-content-1"/index.html)

timestamp creation date time [​](/content/docs/reference/api/analytics-data-structure-reference/#timestamp-creation-date-time-3 "Direct link to timestamp-creation-date-time-3"/index.html)

model_id model identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#model_id-model-identifier-2 "Direct link to model_id-model-identifier-2"/index.html)

sequence_number start of the event [​](/content/docs/reference/api/analytics-data-structure-reference/#sequence_number-start-of-the-event-2 "Direct link to sequence_number-start-of-the-event-2"/index.html)

message_id unique id for the message text [​](/content/docs/reference/api/analytics-data-structure-reference/#message_id-unique-id-for-the-message-text "Direct link to message_id-unique-id-for-the-message-text"/index.html)

rasa_llm_command [​](/content/docs/reference/api/analytics-data-structure-reference/#rasa_llm_command "Direct link to rasa_llm_command"/index.html)

id llm command identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#id-llm-command-identifier "Direct link to id-llm-command-identifier"/index.html)

sender_id sender whose conversation the command belongs to [​](/content/docs/reference/api/analytics-data-structure-reference/#sender_id-sender-whose-conversation-the-command-belongs-to "Direct link to sender_id-sender-whose-conversation-the-command-belongs-to"/index.html)

session_id session identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#session_id-session-identifier-6 "Direct link to session_id-session-identifier-6"/index.html)

user_message_id unique id for the user message text [​](/content/docs/reference/api/analytics-data-structure-reference/#user_message_id-unique-id-for-the-user-message-text "Direct link to user_message_id-unique-id-for-the-user-message-text"/index.html)

command command name [​](/content/docs/reference/api/analytics-data-structure-reference/#command-command-name "Direct link to command-command-name"/index.html)

inserted_at creation timestamp [​](/content/docs/reference/api/analytics-data-structure-reference/#inserted_at-creation-timestamp-2 "Direct link to inserted_at-creation-timestamp-2"/index.html)

flow_identifier flow identifier [​](/content/docs/reference/api/analytics-data-structure-reference/#flow_identifier-flow-identifier-1 "Direct link to flow_identifier-flow-identifier-1"/index.html)

set_slot_name slot name [​](/content/docs/reference/api/analytics-data-structure-reference/#set_slot_name-slot-name "Direct link to set_slot_name-slot-name"/index.html)

clarification_options list of flow identifiers [​](/content/docs/reference/api/analytics-data-structure-reference/#clarification_options-list-of-flow-identifiers "Direct link to clarification_options-list-of-flow-identifiers"/index.html)