Kaia Meeting Participants
This table has 1 row per user, per meeting, and per org id.
Column | Type | Definition | Sample Value(s) | Sample Use |
---|---|---|---|---|
DML_AT | Timestamp_NTZ | A datetime (local to server) in which the row was last modified. dml_at can be used to identify updated and new records, but as tables may not see changed records every day, it is not authoritative on when the table was last synced. | 2019-01-01 12:14:01:10 | Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days. |
DML_TYPE | Varchar | The type of manipulation that last occurred to a row. | 'update', 'delete', 'create' | Where dml_type <> 'delete' Excludes deleted rows. |
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'. | ||
IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
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. | ||
SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | ||
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. |