Kaia Meetings
This table has 1 row per meeting and per org id.
o_id and instance_id together uniquely identify the meeting.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| ACCESS_SCOPE | Varchar | The meeting access scope. | 'public', 'protected', 'private' | |
| ACCOUNT_ID | Varchar | The account the meeting is associated with. | Maps to the ACCOUNTS table | |
| BOT_IN_MEETING_MSECS | Number | The duration of Bot in the meeting in milliseconds. | ||
| BUYERS | Number | The number of buyers (i.e., non Outreach users). | ||
| CALENDAR_EVENT_ID | Varchar | The ID of the calendar event (deprecated). | ||
| END_TIME | Timestamp_NTZ | The meeting end time. | ||
| EVENT_ID | Varchar | The event ID. | ||
| EVENT_SUB_TYPE | Varchar | The type of event. | 'create', 'update', 'delete' | |
| EVENT_TIME | Timestamp_NTZ | The time the event (see event_sub_type above) was created. | ||
| HAS_PROSPECT | Boolean | Whether there was a prospect present. This counts a non Outreach user as a prospect. | ||
| HOST_GUID | Varchar | The meeting host guid. | ||
| HOST_ID | Varchar | The meeting host outreach ID. | Maps to the USERS table | |
| ID | Varchar | The unique meeting ID. | Maps to the MEETINGS table | |
| INSTANCE_ID | Varchar | The meeting instance ID. | ||
| IS_ON_DEMAND | Boolean | Whether Kaia is added on demand (vs. auto joined). | ||
| JOIN_URL | Varchar | The meeting provider url (for example, Zoom or Teams). | ||
| MEETING_SEQ_ID | Number | The meeting sequence ID (deprecated). | ||
| MEETING_TYPE_ID | Number | The ID associated with the meeting type. | ||
| OPPORTUNITY_ID | Number | The ID associated with the opportunity. | Maps to the OPPORTUNITIES table | |
| OPPORTUNITY_STAGE_ID | Number | The ID associated with the opportunity stage. | ||
| O_ID | Varchar | Organization ID, also called instance ID. This is the ID for your unique Outreach account. | Most commonly used on joins alongside other primary keys. where a.o_id = b.o_id and a.id = b.a_id | |
| PROVIDER | Varchar | The meeting provide. | 'zoom', 'teams', 'voice_twillio', 'gong' | |
| RECORDING_URL | Varchar | The meeting recording URL. | ||
| SOURCE_ID | Varchar | An ID with respect to the source_type. | ||
| SOURCE_TYPE | Varchar | The type of meeting. | 'calendar', 'voice', 'gong' | |
| START_TIME | Timestamp_NTZ | The time the bot joined the meeting. |