SequenceTemplates
An object used to track which templates are in use by which sequence steps.
Select
The add-in will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- Id supports the '=,IN,>=,<=,>,<' operators.
SELECT * FROM SequenceTemplates WHERE Id = 1 SELECT * FROM SequenceTemplates WHERE Id IN (1, 2) SELECT * FROM SequenceTemplates WHERE Id >= 1 SELECT * FROM SequenceTemplates WHERE Id <= 1 SELECT * FROM SequenceTemplates WHERE Id > 1 SELECT * FROM SequenceTemplates WHERE Id < 2
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of sequence template. |
| BounceCount | Integer | The total count of bounced mailings during this sequence template. |
| ClickCount | Integer | The total count of clicked mailings from this sequence template. |
| CreatedAt | Datetime | The date and time the sequence template was created. |
| DeliverCount | Integer | The total count of delivered mailings from this sequence template. |
| Enabled | Boolean | Boolean indicating if the sequence template is currently enabled. |
| EnabledAt | Datetime | Datetime for when the sequence template was enabled. |
| FailureCount | Integer | The total count of failed mailings from this sequence template. |
| IsReply | Boolean | Boolean indicating if the sequence template should be a reply email or a new thread. |
| NegativeReplyCount | Integer | The total count of negative reply mailings from this sequence template. |
| NeutralReplyCount | Integer | The total count of neutral reply mailings from this sequence template. |
| OpenCount | Integer | The total count of opened mailings from this sequence template. |
| OptOutCount | Integer | The total count of opted out mailings from this sequence template. |
| PositiveReplyCount | Integer | The total count of positive reply mailings from this sequence template. |
| ReplyCount | Integer | The total count of replied mailings from this sequence template. |
| ScheduleCount | Integer | The total count of scheduled mailings from this sequence template. |
| UpdatedAt | Datetime | The date and time the sequence template was last updated. |
| LinksSelf | String | Link self. |
| SequenceStepId | Integer | Sequence step Id. |
| SequenceStepType | String | Sequence step type. |
| TemplateId | Integer | Template Id. |
| TemplateType | String | Template type. |
| Type | String | Type. |