Kaia Meeting Reactions
This table has 1 row per reaction type, per topic (if a topic is detected), per meeting, and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| COUNT | Number | A count of occurrences of this topic/reaction combination in this meeting. | ||
| 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. |
| DURATION_MSECS | Number | The aggregated time that this topic/reaction pair was discussed, in milliseconds. | ||
| INSTANCE_ID | Varchar | The meeting instance ID. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| 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 | |
| REACTION_TYPE | Varchar | A buyer reaction detected in the meeting. | 'KAIA_REACTION_TYPE_BUYER_POSITIVE', 'KAIA_REACTION_TYPE_BUYER_NEGATIVE' | |
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | ||
| TOPIC_TYPE | Varchar | The topic detected for that reaction (if a topic was detected). | 'KAIA_TOPIC_TYPE_STAKEHOLDER', 'KAIA_TOPIC_TYPE_PURCHASE', 'KAIA_TOPIC_TYPE_DEMOANDTRIAL', 'KAIA_TOPIC_TYPE_SALESPITCH', 'KAIA_TOPIC_TYPE_NEXTSTEP', 'KAIA_TOPIC_TYPE_SUPPORT', 'KAIA_TOPIC_TYPE_EVENTANDMARKETING', 'KAIA_TOPIC_TYPE_DISCOVERY', 'KAIA_TOPIC_TYPE_BUDGETANDPRICING', 'KAIA_TOPIC_TYPE_LEGAL', 'KAIA_TOPIC_TYPE_PRODUCT', 'KAIA_TOPIC_TYPE_ORGANIZATION', 'KAIA_TOPIC_TYPE_LOGISTICS', 'KAIA_TOPIC_TYPE_COMPETITOR' |