Sequence Templates

This table has 1 row per sequence step, per template, and per org id.

Used to track which templates are in use by which sequence steps.

ColumnTypeDefinitionSample Value(s)Sample Use
BENTOVarcharA collection of machines that power the Outreach app. Orgs live inside these.This may distinguish orgs that are in different data centers.
BOUNCE_COUNTNumberThe total count of bounced mailings during this sequence template.
CLICK_COUNTNumberThe total count of clicked mailings from this sequence template.
CREATED_ATTimestamp_NTZThe date and time the sequence template was created.
CREATOR_IDVarcharThe 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.
DELIVER_COUNTNumberThe total count of delivered mailings from this sequence template.
DML_ATTimestamp_NTZA 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:10Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days.
DML_TYPEVarcharThe type of manipulation that last occurred to a row.'update', 'delete', 'insert', 'backfill', 'backfill-delete'Where dml_type <> 'delete' Excludes deleted rows.
ENABLED_ATTimestamp_NTZThe UTC datetime for when this sequence template was enabled.
FAILURE_COUNTNumberThe total count of failed mailings from this sequence template.
IDVarcharRepresents 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_APPBooleanIs the latest dml_type 'delete' or 'backfill-delete'.Where is_deleted_in_app = false Only keeps undeleted rows.
IS_REPLYBooleanBoolean indicating if the sequence template should be a reply email or a new thread.
O_IDVarcharOrganization 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
OPEN_COUNTNumberThe total count of opened mailings from this sequence template.
OPT_OUT_COUNTNumberThe total count of opted out mailings from this sequence template.
REPLY_COUNTNumberThe total count of replied mailings from this sequence template.
SCHEDULE_COUNTNumberThe total count of scheduled mailings from this sequence template.
SEQUENCE_STEP_IDVarcharThe sequence step of a prospect at the time of mailing.
SURROGATE_IDVarcharAn 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.
TEMPLATE_IDVarcharThe template used for this sequence template
UPDATED_ATTimestamp_NTZThe UTC datetime for the last time this record was updated.2019-01-01 20:14:01:10Almost equivalent to dml_at (but adjusted for time zones), but doesn't include record creation or deletion.
UPDATER_IDVarcharSame as creator_id above, but refers to who last did the update of the record.