Sequence Steps
This table has 1 row per sequence step and per org id.
Note, sequence steps can be deleted and replaced with new sequence steps.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| AUTO_SEND | Boolean | A Boolean field for if emails for this step will automatically send upon entering the sequence step. Otherwise they require manual review by the user. | ||
| 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. | |
| BOUNCE_COUNT | Number | The total number of mailings associated with this sequence step that have bounced. | ||
| CALL_COMPLETED_COUNT | Number | The total number of calls associated with this sequence step that have connected. | ||
| CALL_NO_ANSWER_COUNT | Number | The total number of calls associated with this sequence step that have not been answered. | ||
| CALL_PURPOSE_ID | Varchar | Calls initiated from this step have their purpose set to this ID. | Maps to CALL_PURPOSES table | |
| CLICK_COUNT | Number | The cumulative # of times anyone (not just the desired prospect) clicked a link in a mailing associated with this sequence step. Requires that the mailing have click tracking enabled. | ||
| 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. | ||
| DATE | Timestamp_NTZ | This is the date associated with when a step should activate. | ||
| DELIVER_COUNT | Number | The total number of mailings associated with this sequence step that have been delivered. | ||
| 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. |
| FAILURE_COUNT | Number | The total number of mailings associated with this sequence step that have failed to be delivered. | ||
| 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. | |
| INTERVAL | Number | The # of seconds a sequence step should wait before moving on to the next step if there is no response. | 259200 (i.e. 3 days) | |
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| NAME | Varchar | Typically Null as sequence steps are not named unless created via API. | ||
| OPEN_COUNT | Number | The cumulative # of times anyone (not just the desired prospect) opened a mailings associated with this sequence step. Requires that open tracking be enabled. | ||
| OPT_OUT_COUNT | Number | The total number of times a recipient has opted out of a mailing associated with this sequence step. | ||
| ORDER | Number | Beginning at the first step (order = 1) , this represents the order sequence steps occur for a sequence. | order = 5 is the fifth step in a sequence | |
| 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 | |
| REPLY_COUNT | Number | The total number of emails that are associated with this sequence that have received a reply. | ||
| SEQUENCE_ID | Varchar | The ID of the sequence this step is for. | Maps to SEQUENCES table | |
| STEP_TYPE | Varchar | The type of action this step expects the rep to take or will be automated. | auto_email', 'call', 'manual_email' | |
| 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. | |
| TASK_NOTE | Varchar | The default note given to tasks when prospects enter this step. | ||
| TASK_PRIORITY_ID | Varchar | The associated task_priority ID for any tasks created from this sequence step. | Maps to TASK_PRIORITIES table | |
| 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. |
| UPDATER_ID | Varchar | Same as creator_id above, but refers to who last did the update of the record. |