Kaia Content Cards Activity
This table has 1 row per time a content card was triggered, per call, and per org id.
A single Kaia call may have multiple rows for the same content card ID - one for each content card moment triggered in that call.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| CONTENT_CARD_ID | Varchar | The unique ID of the content card. | ||
| CONTENT_CARD_TYPE | Varchar | The type of content card. | 'KAIA_CONTENT_CARD_TYPE_INVALID', 'KAIA_CONTENT_CARD_TYPE_COMPETE', 'KAIA_CONTENT_CARD_TYPE_PRODUCT_INFO', 'KAIA_CONTENT_CARD_TYPE_PRODUCT_INTEGRATION', 'KAIA_CONTENT_CARD_TYPE_PRICING', 'KAIA_CONTENT_CARD_TYPE_CASE_STUDY', 'KAIA_CONTENT_CARD_TYPE_OTHER' | |
| 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. |
| INSTANCE_ID | Varchar | The Kaia meeting 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 | |
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | ||
| USER_GUID | Varchar | This guide of the user who creates or edits the highlight. This is only populated when the user manually pulls up card during the live meeting. | ||
| USER_ID | Varchar | This indicates the user who creates or edits the highlight. This is only populated when the user manually pulls up card during the live meeting. | ||
| USER_STATE | Varchar | This indicates the state imposed by the user. | 'KAIA_USER_ACTION_STATE_ACTIVE' (normal state), 'KAIA_USER_ACTION_STATE_REJECTED' (user chose to hide/cancel card) |