Sequences
This table has 1 row per sequence id and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| ARCHIVED_AT | Timestamp_NTZ | The UTC datetime for when a sequence was archived and removed from general use. | ||
| 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. | |
| BOUNCED_STAGE_ID | Varchar | If a sequence state experienced a bounce, the corresponding stage is assigned to the prospect. | Maps to STAGES table | |
| BOUNCE_COUNT | Number | The cumulative sum of email bounces for a given sequence. | ||
| CALL_COMPLETED_COUNT | Number | The cumulative sum of answered and logged calls for a given sequence. | ||
| CALL_NO_ANSWER_COUNT | Number | The cumulative sum of call, no answers for a given sequence. | ||
| CALL_TASK_MIN_OPENS | Number | Minimum # of Email opens for an email sequence that will trigger a call task. | ||
| CAPACITY | Number | The maximum # of prospects that can be in a sequence at once. | ||
| CLICK_COUNT | Number | The cumulative # of email link clicks for a given sequence. | ||
| CLONED_FROM_ID | Varchar | The sequence ID that this sequence was cloned from. | Maps to SEQUENCES table | |
| COMPLETED_STAGE_ID | Varchar | If a sequence state reaches the last step in this sequence, the corresponding stage is assigned to the prospect. | Maps to STAGES table | |
| 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. | ||
| DELIVERED_STAGE_ID | Varchar | If a sequence state has an email delivered in this sequence, the corresponding stage is assigned to the prospect. | Maps to STAGES table | |
| DELIVER_COUNT | Number | The cumulative # of emails delivered for a given sequence. | ||
| DESCRIPTION | Varchar | A custom description for the sequence. | ||
| 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. |
| DUPLICATE_PROSPECTS | Varchar | A string flag for if this sequence allows prospects to be in the sequence more than once at the same time. | 'allow', 'disallow' | |
| ENABLED_AT | Timestamp_NTZ | The UTC datetime for when this sequence was enabled for the creation of sequence states. First usable date. | ||
| FAILURE_COUNT | Number | The cumulative # of failures to act against a sequence state (internal errors, ownership or rule limits, etc) for a given sequence. | ||
| FINISHED_STAGE_ID | Varchar | If a sequence state has finished a sequence manually or via response, the corresponding stage is assigned to the prospect. | Maps to STAGES table | |
| FINISH_ON_REPLY | Boolean | A boolean flag for if replying to an email will auto complete a sequence state. | ||
| 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. | |
| INCLUDE_OPT_OUT | Boolean | A boolean flag for if prospects that opted out are allowed in this sequence. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type 'delete' or 'backfill-delete'. | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| LAST_USED_AT | Timestamp_NTZ | The date and time the sequence was last used. | ||
| LOCKED_AT | Timestamp_NTZ | The UTC datetime that this sequence was locked, stopping the further addition of prospects. | ||
| MAX_ACTIVATIONS | Number | The maximum # of prospects that can transition into an active sequence state. | ||
| MAX_ADDS_PER_DAY | Number | The maximum # of sequence states that can be created in a day. | ||
| NAME | Varchar | The name of the sequence that appears in the app. | ||
| OPEN_COUNT | Number | The cumulative # of opens for a given sequence | ||
| OPTED_OUT_STAGE_ID | Varchar | If a sequence state has opts out of contact while in a sequence, the corresponding stage is assigned to the prospect. | Maps to STAGES table | |
| OPT_OUT_COUNT | Number | The cumulative # of opt outs for prospects that occured within a sequence. | ||
| OWNER_ID | Varchar | The owner of a sequence. | Maps to the USERS 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 | |
| PRIMARY_REPLY_ACTION | Varchar | The action to take when the primary prospect replies. Must be one of 'finish', 'continue', or 'pause' | 'finish', 'continue', 'pause' | |
| REPLIED_STAGE_ID | Varchar | If a sequence state has an email reply while in a sequence, the corresponding stage is assigned to the prospect. | Maps to STAGES table | |
| REPLY_COUNT | Number | The cumulative # of replies for a given sequence. | ||
| SCHEDULE_INTERVAL_TYPE | Varchar | The schedule interval type must be either 'calendar' or 'schedule' | 'calendar', 'schedule' | |
| SECONDARY_REPLY_ACTION | Varchar | The action to take when someone other than the primary prospect replies. Must be one of 'finish', 'continue', or 'pause'. | 'finish', 'continue', 'pause' | |
| SEQUENCE_TYPE | Varchar | Dictates how sequence steps are advanced; either intervals of time or specific dates/weekdays. | 'interval', 'date' | |
| SHARE_TYPE | Varchar | Flag for if the sequence is a private or shared sequence. | 'private', 'shared' | |
| STARTED_STAGE_ID | Varchar | When a sequence state advances to the first step, this stage ID is assigned to the prospect. | Maps to STAGES table | |
| 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. | |
| TRANSACTIONAL | Boolean | A boolean flag for if this set of motions qualifies as a transactional engagement with a prospect. | ||
| 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. |