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
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.