Journeys
Represents customer journeys in Salesforce Marketing Cloud. A journey defines an automated, multi-step process that guides contacts through personalized interactions across channels. This table allows you to create, update, delete, and query journey definitions to manage audience engagement strategies.
Table Specific Information
Select
Retrieve journeys with the most recent version:
SELECT * FROM Journeys
Retrieve a journey version:
SELECT * FROM Journeys WHERE ID = '1cb643b5-3144-4d17-80fa-a1f0035e78e2' AND Version = 1
Retrieve all journey versions:
SELECT * FROM Journeys WHERE MostRecentVersionOnly = false
Retrieve journeys with a specific tag:
SELECT * FROM Journeys WHERE Tag = 'First_Tag'
Retrieve journeys which have the specified search string inside the name or description:
SELECT * FROM Journeys WHERE NameOrDescription = 'Journey'
Retrieve journeys with specific work flow API version:
SELECT * FROM Journeys WHERE workFlowApiVersion = 1
Retrieve journeys with specific version:
SELECT * FROM Journeys WHERE Version = 1
Retrieve journeys with specific status:
SELECT * FROM Journeys WHERE Status = 'Draft'
Sort Journeys according to modifiedDate or name column:
SELECT * FROM Journeys ORDER BY ModifiedDate DESC SELECT * FROM Journeys ORDER BY Name DESC
Insert
To create a new journey, you will need to specify at least the Name column.
INSERT INTO Journeys (Name) VALUES ('API-Created journey')
To create a new journey version, you will need to specify an existing journey key.
INSERT INTO Journeys (Name, Key) VALUES ('API-Created journey Version 3', '53bf5ea2-ff59-4c00-a23a-b1e9e333b80c')
Update
Journeys may be modified by providing the Id, Version of the journey and issuing an UPDATE statement.
UPDATE Journeys SET Name = 'API-Updated journey' WHERE Id = '257c51df-d6ed-4fb6-8fbc-70e63ed52b12' AND Version = 5
Delete
Journeys may be deleted by providing the Id of the journey and issuing a DELETE statement.
DELETE FROM Journeys WHERE Id = '53bf5ea2-ff59-4c00-a23a-b1e9e333b80c'
Journey versions may be deleted by providing the Id, Version of the journey and issuing a DELETE statement.
DELETE FROM Journeys WHERE Id = '257c51df-d6ed-4fb6-8fbc-70e63ed52b12' AND Version = 5
Columns
| Name | Type | ReadOnly | References | Filters | Description |
| Id [KEY] | String | True | = |
Specifies the unique identifier (Id) that Marketing Cloud generates for the journey when it is created. This Id is used to reference, query, and manage the journey across Journey Builder and API operations. | |
| Version | Integer | True | = |
Specifies the version number of the journey. Each time the journey is republished, Marketing Cloud increments this value to represent the updated iteration. | |
| Key | String | False |
Specifies the customer key that uniquely identifies the journey within the business unit. This key is user-defined and remains stable across journey versions. | ||
| Name | String | False |
Specifies the display name of the journey as shown in Journey Builder. Users see this name when configuring, publishing, or monitoring journeys across the Salesforce Marketing Cloud account. | ||
| Status | String | False | = |
Specifies the current publishing or execution status of the journey. This field helps filter journeys by their operational state. The allowed values are Draft, Published, ScheduledToPublish, Stopped, Unpublished, Deleted. | |
| CreatedDate | Datetime | True |
Specifies the date and time when the journey was originally created in Journey Builder. This timestamp reflects the initial creation event. | ||
| ModifiedDate | Datetime | True |
Specifies the date and time when the journey was last modified. This timestamp reflects any change to content, structure, configuration, or settings. | ||
| LastPublishedDate | Datetime | True |
Specifies the date and time when the journey was most recently published. This value is used to track deployment events and determine when updates were released. | ||
| Description | String | False |
Specifies a descriptive summary of the journey that explains its business purpose, target audience, or automation objective. This description helps teams understand how and why the journey operates. | ||
| WorkFlowApiVersion | Double | False | = |
Specifies the version of the Journey Builder workflow API that governs the execution logic for the journey. This version determines the available features and processing behaviors. The default value is 1. | |
| Tags | String | False |
Specifies the collection of tags that are assigned to the journey to support organization, filtering, and categorization within Journey Builder and API queries. | ||
| Goals | String | False |
Specifies the goals that are associated with the journey. Goals define the success criteria that Salesforce Marketing Cloud evaluates during execution to determine when a contact has completed the journey. | ||
| Triggers | String | False |
Specifies the trigger configuration for the journey, including the entry source that determines how contacts enter the workflow. Trigger details vary by entry type (for example, event, data extension, or API entry). | ||
| Defaults | String | False |
Specifies the ordered list of email address expressions that Journey Builder evaluates to determine which address should be used as the default sender or recipient context for applicable activities. | ||
| DefinitionId | String | True |
Specifies the Id of the journey definition that governs the structure, configuration, and publishable form of the journey. This Id links execution logic to the underlying definition. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| MostRecentVersionOnly | Boolean |
Specifies whether the query should return only the most recent version of each matching journey. The value is 'true' when limiting results to the latest version and 'false' when including all versions. The default value is true. |
| Tag | String |
Specifies a single tag to apply as a filter when retrieving journeys. The query returns only journeys that are associated with the specified tag. |
| NameOrDescription | String |
Specifies a search string used to filter journeys by matching the provided text against the Name or Description fields. |