Kaia Meeting Participants
This table has 1 row per user, per meeting, and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| DERIVED_GUID | Varchar | The derived unique identifier for the participant. | ||
| Varchar | The participant email. | |||
| EVENT_ID | Varchar | The Kaia meeting ID. | ||
| EVENT_TIME | Timestamp_NTZ | The time of the latest update event (create/update/delete). | ||
| INSTANCE_ID | Varchar | The unique identifier for the meeting. | ||
| IN_MEETING_ID | Varchar | The order in which participants joined. It begins with '2'. | ||
| LONGEST_MONOLOGUE_MSECS | Number | The longest monologue in milliseconds. | ||
| MEETING_SEQ_ID | Number | The meeting sequence ID (deprecated). | ||
| NAME | Varchar | The participant's name. | ||
| OUTREACH_ID | Varchar | The outreach user ID. | Maps to USERS table | |
| O_ID | Varchar | The org guid. | ||
| PROSPECT_ID | Varchar | The prospect ID. | Maps to PROSPECTS table | |
| QUESTIONS_ASKED | Number | The number of questions a participant asked. | 'automated', 'off', 'recorded' | select user_id from users where inbound_voicemail_prompt = 'off'; returns a list of users with no inbound voicemail |
| START_TIME | Timestamp_NTZ | The meeting start time. | ||
| TALK_TIME_MSECS | Number | The total talk time in milliseconds of the participant in the meeting. | ||
| TALK_TIME_RATE | Float | The rate of participant talking over total talk time of all participants. | ||
| USER_GUID | Varchar | The user guid for an Outreach user (empty for non-Outreach users). | ||
| WAIT_DURATION_MSECS | Number | The average time in milliseconds the participant waited before speaking after previous participant. |