Conversation Logs Tool Export — Field Definitions

This document explains the meaning of each column in the conversation-logs tool export. It follows the same style as the original data dictionary for Digital Human conversation logs.

Columns

Conversation ID

• What it is: Unique identifier for a single conversation/session in the app.
• Notes: One Conversation ID spans multiple rows (events). Do not count rows as conversations.

Organization ID

• What it is: Identifier of the organization (tenant) the conversation belongs to.

Digital Human ID

• What it is: Internal identifier of the Digital Human involved in the conversation (e.g., jimmy).

Digital Human Name

• What it is: Display name (human‑readable) of the Digital Human.
• Notes: May be empty if no display name is set.

Conversation Start Time

• What it is: Timestamp when the conversation started (first event for this Conversation ID).
• Notes: Represents the start boundary used to compute Duration. Timezone is system‑defined; when in doubt, assume UTC unless configured otherwise in the export.

Conversation End Time

• What it is: Timestamp when the conversation ended (last event for this Conversation ID).
• Notes: Represents the end boundary used to compute Duration.

Total Messages

• What it is: Total number of events/messages recorded for this Conversation ID across all rows.
• Includes: user_input, response (including chunked parts), and userfeedback events.
• Notes: If responses are chunked into parts, each part is counted toward this total.

Duration (seconds)

• What it is: Conversation length in seconds.
• How it’s derived: Conversation End Time – Conversation Start Time.

Message Timestamp

• What it is: Event receive time for this row.
• Notes: Stored in UTC.

Message Type

• What it is: Type of event captured on this row. One of:
  • user_input — generated when the user interacts by typing in the chat input, clicking a suggestion, or using voice input.
  • response — a message produced by the Digital Human; may be chunked (see Total Messages).
  • userfeedback — a feedback action (thumbs up/down) recorded by the user.

Sender

• What it is: Who produced the content on this row.
• Typical values:
  • User for user_input and userfeedback rows.
  • Digital Human for response rows.

Message Text

• What it is: Text payload associated with this row.
• Depends on Message Type:
  • For user_input: the user’s typed/voice text or selected suggestion.
  • For response: the Digital Human’s response text (may be a chunk if part of a multi‑part response).
  • For userfeedback: the rated text (the content the feedback refers to).

Additional Behavioral Notes

• One Conversation ID = many rows: A conversation/session consists of multiple events (rows). Use distinct Conversation ID to count sessions, not rows.
• Conversations vs. sessions (common counting):
  • Sessions: unique Conversation IDs (regardless of Message Type).
  • Conversations: unique Conversation IDs with at least one user_input row (excludes welcome‑only sessions).
• Chunked responses: Long responses may be split into multiple parts; each part appears as a separate response row and contributes to Total Messages.
• Timestamps: Per‑row Message Timestamp is UTC; start/end times are system timestamps for the conversation window (treat as UTC unless otherwise configured in the export).