Article
Learn about journey state tables | GrowthLoop Docs
3 min read
Last updated 3 months ago
Learn about journey state tables
Data Cloud Storage
A quick overview of the information written back to your data warehouse for each journey.
Whenever you publish a journey, a journey "state table" is written back to your data warehouse. This state table is maintained as a running record of each individual’s passage through the different steps of the journey.
- Unlike snapshotting, in which multiple tables are written back to the data warehouse for each audience, there is only one state table written back for each journey
- The journey state table is created within the same schema as your snapshotting tables
- The naming convention for a journey state table is “journey_[journey id]”
- The journey ID can be found in the GrowthLoop UI beneath the title of a journey
- The state table is updated based on the journey run frequency configured as part of the journey settings
| Field Name | Data Type | Description |
|---|---|---|
| user_id | String | The unique identifier for an individual in your data |
| created_at | Timestamp | Timestamp for when this record was created |
| run_id | String | The ID for the specific run of the journey during which this record was created |
| step_id | String | The ID of the node being evaluated (also available in the UI once the journey has been published) |
| state | String | The state of this user for this step_id as part of this run_id. The possible values are Completed, Pending, and Exited. Exited indicates that the user was removed from the journey as a result of meeting global exit criteria identified as part of the journey settings. |
| request_id | String | The ID for the request that triggered the node evaluation |
| journey_id | String | The ID of the journey (also available in the UI beneath the journey title) |
| glca_{custom attributes} | String | Any custom attributes that are created are stored with a prefix of "glca_" and the name of the custom attribute |
Updated 5 months ago