Sequence States
This table has 1 row per instance of a prospect being put into sequence (one prospect may be in multiple sequences) and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| ACTIVATED_AT | Timestamp_NTZ | The UTC datetime for when the prospect's sequence state started its first step. | ||
| ACTIVE_AT | Timestamp_NTZ | The most recent UTC datetime that a prospect was in a non-failed, non-paused state. | ||
| AUTO_FINISH_AT | Timestamp_NTZ | The UTC datetime for when the prospect completed the sequence through automatic means, such as finishing the sequence or replying. | ||
| BATCH_ITEM_CREATOR_ID | Varchar | The user ID associated with this sequence state if created via a batch item (like an import or multi select). | Maps to the USERS table | |
| 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. | |
| CALL_COMPLETED_AT | Timestamp_NTZ | The UTC datetime for when an associated call was completed and has answered disposition for this sequence state. | ||
| CREATOR_ID | Varchar | The ID for whomever created a record in Outreach, or who updated it if records are overwritten when changed. Maps to different tables based on the "creator_type" field. | ||
| CREATOR_TYPE | Varchar | The object type that created this row. | 'plugin', 'app', 'user', 'trigger', 'import' | This will dictate what table the creator_id maps to. |
| 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. |
| ERROR_REASON | Varchar | If sequence state experienced an error it would be described here. | ||
| ID | Varchar | Represents an individual row of data in a table. Fields in other tables that match to this ID will be called thisTable_id. e.g. ID in the calls table will appear as the call_id in another table. | Count(1), count(id), and count(distinct id) are equivalent in a table without joins or groupings for a given bento & o_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. | |
| MAILBOX_ID | Varchar | The mailbox that all emails will be sent from for this sequence state. | Maps to the MAILBOXES table | |
| MEETING_BOOKED_AT | Timestamp_NTZ | If a meeting is associated with this sequence state, the UTC datetime will be logged here. | ||
| OPPORTUNITY_ID | Varchar | If there is an opportunity associated with this sequence state, it will appear here. | Maps to the OPPORTUNITIES table | |
| 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 | |
| PAUSE_REASON | Varchar | This field provides a brief description of why a prospect was paused. | ||
| PROSPECT_ID | Varchar | The associated primary prospect ID for this sequence state. | Maps to the PROSPECTS table | |
| REPLIED_AT | Timestamp_NTZ | If sequence is marked as replied, there will be a UTC timestamp here. | ||
| RETURN_DATE | Timestamp_NTZ | If a prospect was OOO, this is the date they will "return to office". | ||
| SEQUENCE_ID | Varchar | The associated sequence ID for this sequence state. | Maps to the SEQUENCES table | |
| SEQUENCE_STEP_ID | Varchar | This is the current sequence step that the sequence state is on. | maps to the SEQUENCE STEP table | |
| STATE | Varchar | The current state of a sequence state. Failed and paused are considered 'inactive'. 'finished' implies they have finished the sequence they were in. | 'active', 'paused', 'bounced', 'failed', 'finished' | |
| STATE_CHANGED_AT | Timestamp_NTZ | The latest UTC datetime of when a sequence state had its state field changed. | ||
| STEP_ENTERED_AT | Timestamp_NTZ | The UTC datetime of when a prospect entered their current sequence step. | ||
| 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. | |
| UPDATED_AT | Timestamp_NTZ | The UTC datetime for the last time this record was updated. | 2019-01-01 20:14:01:10 | Almost equivalent to dml_at (but adjusted for time zones), but doesn't include record creation or deletion. |
| USER_ID | Varchar | The user that is responsible/associated with the sequence state actions . | Maps to the USERS table |