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). | ||
| 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. |
| 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. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| 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 | |
| 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' | |
| 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. | ||
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. |