To view data about activities used in your journeys, use the _JourneyActivity data view in Automation Studio.
Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.
Note JourneyActivityObjectID corresponds to TriggererSendDefinitionObjectID in the
_Sent, _Open, _Click, and _Bounce, data views.
Note When profile attributes are created in Enterprise 2.0 accounts, new columns are
added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0
accounts can return results from profile attribute columns in addition to the
columns listed here.
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| VersionID | The unique identifier for the version of the journey | uniqueidentifier(36) | Text | |
| ActivityID | The unique identifier for the activity. There are one or more ActivityID’s associated to a VersionID. | uniqueidentifier(36) | Text | |
| ActivityName | The name of the activity | nvarchar(200) | Text | X |
| ActivityExternalKey | The external key associated with the activity | nvarchar(200) | Text | |
| JourneyActivityObjectID | Use this unique identifier to join to email tracking system data views to identify a journey email’s Triggered Send Definition. | uniqueidentifier(36) | Text | X |
| ActivityType | The type of activity | nvarchar(512) | Text | X |