Journey

_JourneyActivity

Activities on the Journey canvas. Join JourneyActivityObjectID to TriggererSendDefinitionObjectID on email tracking views.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _JourneyActivity in the interactive canvas with SQL Sandbox.

Fields (6)

Field Type Flags Relations Description
VersionID Text(36) PK, FK _Journey.VersionID Journey version GUID.
ActivityID Text(36) PK, FK _JourneyActivity.ActivityID Activity GUID on the canvas.
ActivityName Text(200) NULL — Activity display name.
ActivityExternalKey Text(200) — — External key for API and integrations.
JourneyActivityObjectID Text(36) FK, NULL _Sent.TriggererSendDefinitionObjectID
_Open.TriggererSendDefinitionObjectID
_Click.TriggererSendDefinitionObjectID
_Bounce.TriggererSendDefinitionObjectID
_Unsubscribe.TriggererSendDefinitionObjectID
_Complaint.TriggererSendDefinitionObjectID
_FTAF.TriggererSendDefinitionObjectID
_SurveyResponse.TriggererSendDefinitionObjectID		 Triggered Send Definition ID for email activities.
ActivityType Text(512) NULL — Activity type (EMAIL, WAIT, SMS, etc.).

Example query

SELECT TOP 100
  VersionID, ActivityID, ActivityName, ActivityExternalKey, JourneyActivityObjectID, ActivityType
FROM _JourneyActivity

Valid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.