SequenceStates

Get details of sequence states.

Select

The component 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 component.

Id supports the '=,IN,>=,<=,>,<' operators.
ClickCount supports the '=,IN,>=,<=,>,<' operators.
CallCompletedAt supports the '=,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
DeliverCount supports the '=,IN,>=,<=,>,<' operators.
OpenCount supports the '=,IN,>=,<=,>,<' operators.
PauseReason supports the '=,IN' operators.
RepliedAt supports the '=,>=,<=,>,<' operators.
ReplyCount supports the '=,IN,>=,<=,>,<' operators.
State supports the '=' operator.
StateChangedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM SequenceStates WHERE Id = 1

SELECT * FROM SequenceStates WHERE Id IN (1, 2)

SELECT * FROM SequenceStates WHERE Id >= 1

SELECT * FROM SequenceStates WHERE Id <= 1

SELECT * FROM SequenceStates WHERE Id > 1

SELECT * FROM SequenceStates WHERE Id < 2

SELECT * FROM SequenceStates WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE DeliverCount = 0

SELECT * FROM SequenceStates WHERE Name = 'test'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of sequence state.
ActiveAt	Datetime	The date and time the sequence state was last active.
BounceCount	Integer	The total count of bounced mailings during this sequence state.
CallCompletedAt	Datetime	The date and time the sequence state last had a call completed.
ClickCount	Integer	The total count of clicked mailings from this sequence state.
CreatedAt	Datetime	The date and time the sequence state was created.
DeliverCount	Integer	The total count of delivered mailings from this sequence state.
ErrorReason	String	The reason for the most recent error.
FailureCount	Integer	The total count of failed mailings from this sequence state.
NegativeReplyCount	Integer	The total count of negative reply mailings from this sequence state.
NeutralReplyCount	Integer	The total count of neutral reply mailings from this sequence state.
OpenCount	Integer	The total count of opened mailings from this sequence state.
OptOutCount	Integer	The total count of opted out mailings from this sequence state.
PauseReason	String	The reason for the most recent pause.
PositiveReplyCount	Integer	The total count of positive reply mailings from this sequence state.
RepliedAt	Datetime	The date and time the sequence state last had a mailing reply.
ReplyCount	Integer	The total count of replied mailings from this sequence state.
ScheduleCount	Integer	The total count of scheduled mailings from this sequence state.
State	String	The current state of the sequence state.
StateChangedAt	Datetime	The date and time the sequence state's state last changed.
UpdatedAt	Datetime	The date and time the sequence state was last updated.
LinksSelf	String	Link self.
AccountId	Integer	Account Id.
AccountType	String	Account type.
CreatorId	Integer	Creator Id.
CreatorType	String	Creator type.
MailboxId	Integer	Mailbox Id.
MailboxType	String	MailBox type.
ProspectId	Integer	Prospect Id.
ProspectType	String	Prospect type.
SequenceId	Integer	Sequence Id.
SequenceType	String	Sequence type.
SequenceStepId	Integer	Sequence step's Id.
SequenceStepType	String	Sequence step's type.
Type	String	Type.

SSIS Components for Outreach

SequenceStates

Select

Columns