Kaia Coach Cards Activity
This table has 1 row per time a coach card was triggered, per call, and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| ANSWERS | Variant | The list of answers | {"48": {"id": true, "nt": "Good job", "oq": "What is your overall score for this call?", "rs": 3}, "49": {"id": false, "oq": "Did the rep introduce themselves and their company?", "yn": true}} | |
| BENTO | Varchar | A collection of machines that power the Outreach app. Orgs live inside these. | This may distinguish orgs that are in different data centers. | |
| CREATED_AT | Timestamp_NTZ | Time when the coach card was created | 2024-08-13 12:14:01:10 | |
| DEFAULT_SCORE | Number | The overall score for the score card | 3 | |
| 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', 'insert', 'backfill', 'backfill-delete' | Where dml_type <> 'delete' Excludes deleted rows. |
| INSTANCE_ID | Varchar | The associated meeting instance id. | aDPPXNXeQQy9ynbiP123 | |
| 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 | Outreach instance unique identifier | ||
| SCORE_USER_ID | Number | User that scored the coach card (Submitter name) | 2233 | |
| SCORECARD_ID | Number | Org level unique id for the coach card. | 1 | |
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | This can be used to get distinct counts of records if an account has more than 1 org instance. Two orgs will both have a prospect with ID of "1" but each will have a different surrogate ID. | |
| TARGET_USER_ID | Number | User for whom the coach card was scored (Rep name) | 2233 | |
| UPDATED_AT | Timestamp_NTZ | Time when the coach card was last updated | 2024-08-13 12:14:01:10 | |
| UUID | Varchar | Outreach level unique id for the coach card | 32edf14a-0eca-44f3-989d-61e01b2f76f8 |