JourneyHistory
Retrieves the historical execution records of customer journeys in Salesforce Marketing Cloud. Each record reflects the runtime status, performance, and event details of a specific journey instance. Record retrieval is subject to a maximum file size of 1 GB to ensure performance and stability during data access.
Table Specific Information
Select
Retrieves information about a specific contact, journey, or journey version:
SELECT * FROM JourneyHistory
Retrieves information about a specific contact, journey, or journey version within the specified date range.:
SELECT * FROM JourneyHistory where StartDate='2022-09-01T10:29:22.438Z' and EndDate = '2022-09-30T11:29:22.438Z'
NOTE: A maximum of 10k records can be retrieved using JourneyHistory. If only StartDate is mentioned, it will retrieve a maximum of 10k records from the StartDate. If both StartDate and EndDate are mentioned, it will fetch the first 10k records.
Columns
| Name | Type | References | Description |
| Id | String | Specifies the unique identifier (Id) of the journey history record. This Id is generated by the Journey Builder API when the journey begins processing contacts and is used to track execution details for the associated run. | |
| ActivityId | String | Specifies the unique Id of the activity that the history record pertains to. This Id links the execution data to a specific activity within the journey version. | |
| ActivityName | String | Specifies the name of the activity that is associated with the history record. This name helps identify the action or function performed during contact processing. | |
| ActivityType | String | Specifies the type of activity that generated the history entry (for example, a message activity, event activity, wait activity, or decision activity). | |
| ClientStatus | String | Specifies the client-facing status of the activity execution, indicating how the system interpreted the activity outcome during processing. | |
| ContactKey | String | Specifies the customer key that identifies the contact being processed in the journey. This key ensures that the history record is associated with the correct individual within the business unit. | |
| CreatedDate | Datetime | Specifies the date and time when the journey entered its running state for the associated contact or activity. This timestamp provides the starting point for evaluating the execution timeline. | |
| DefinitionId | String | Specifies the Id of the journey definition that governs the activity being executed. This Id identifies the parent definition that underlies the version and structure of the journey. | |
| DefinitionInstanceId | String | Specifies the Id of the journey definition instance that executed the activity. This instance Id represents the specific published version of the journey used during processing. | |
| DefinitionName | String | Specifies the name of the journey definition that is associated with the execution record. This value helps identify the overarching journey that produced the history entry. | |
| EndDate | Datetime | Specifies the date and time when the activity execution completed. This timestamp marks the end of the processing window for the activity. | |
| EntrySource | String | Specifies the entry source that admitted the contact into the journey (for example, an event, data extension entry, or API entry call). | |
| EpochTimeInMilliseconds | Long | Specifies the timestamp of the activity execution that is expressed as epoch time in milliseconds. This value provides a standardized format for time-based calculations and comparisons. | |
| EventId | String | Specifies the Id of the event that triggered the activity or contributed to the execution context for the history record. | |
| EventName | String | Specifies the name of the event that influenced the execution of the activity. This value is used to identify the event source within the journey. | |
| LongId | String | Specifies the extended Id that represents the execution instance in long-format identifier form. This value allows for precise correlation across systems that require long Id formats. | |
| Mid | String | Specifies the Marketing Cloud member Id (MID) of the business unit in which the journey executed. This value provides organizational context for the history record. | |
| Message | String | Specifies the message or descriptive text that is associated with the activity execution. This message can include diagnostic information, event details, or system-generated notes. | |
| OutcomeActivityId | String | Specifies the Id of the activity that represents the outcome of the executed step. This Id identifies the next activity selected by the journey based on evaluation results. | |
| ResultMessages | String | Specifies the messages that describe the execution results of the activity. These messages can provide operational details or context for success, failure, or branching behavior. | |
| ResultOutcomes | String | Specifies the outcome values that are returned during activity execution. These values determine how contacts proceed to the next activity or exit the journey. | |
| ResultStatus | String | Specifies the status of the activity execution (for example, success, failure, or a system-defined result state). This status helps assess processing performance or identify issues. | |
| ResultTags | String | Specifies the tags that are associated with the activity execution. Tags can provide metadata or classification details used for reporting or debugging. | |
| SourceType | String | Specifies the source type that generated the history entry (for example, an API-driven event, an automation-triggered event, or a system-based action). | |
| StartDate | Datetime | Specifies the date and time when the activity execution started. This timestamp marks the beginning of the execution interval for the associated activity. | |
| Status | String | Specifies the overall status of the journey history record, indicating whether the activity or contact path is pending, running, paused, completed, or terminated. | |
| TransactionTime | Datetime | Specifies the timestamp of the transaction that recorded the history entry. This value provides a precise reference point for chronological sorting and auditing. |