Journeys Fact Table

Journeys is an engagement automation interface that enables brands to create scenario-based flows to nurture your customers throughout their lifecycle. Journeys are created using building blocks. After the entry trigger, the building blocks define the journey of a customer. Each building block has a specific purpose in the journey.

The journey_block_execution_fact table captures information about each execution of a journey block, including timestamps, journey and block identifiers, user identifiers, and status.

Databricks Table Name: journey_block_execution_fact

Journeys Fact - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.

Journey Block Execution Factauto_update_time_journey: bigintauto_update_time_journey_block_execution: bigint