SequenceTemplates
An object used to track which templates are in use by which sequence steps.
Select
The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- Id supports the '=,IN,>=,<=,>,<' operators.
- SequenceStepId supports the '=' operator.
- TemplateId supports the '=' operator.
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 SELECT * FROM SequenceTemplates WHERE SequenceStepId = 1 SELECT * FROM SequenceTemplates WHERE TemplateId = 1
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. |