Data Feeds (Flows)

Event data for campaigns launched through Flows can be found in the table SD_DATA_ROUTING._DATA_ROUTING_DATA_FEEDS_EVENTS with the following schema:

• FLOW_ID
• FLOW_NAME
• SIMON_ID
• EXPERIMENT_ID
• EXPERIMENT_NAME
• VARIANT
• SEGMENT_NAME
• IDENTITY_TYPE
• IDENTITY_VALUE
• TIMESTAMP
• ACTION
• OPERATION
• SYNC_ID
• ATTRIBUTES

Contact Journey History (Journeys)

Event data for campaigns launched through Journeys can be found in the table SD_DATA_ROUTING.CONTACT_JOURNEY_HISTORY with the following schema.

• EVENT_ID
• EVENT_TYPE
• TIMESTAMP
• SIMON_ID
• ENTRY_ID
• JOURNEY_ID
• FRONTEND_JOURNEY_ID
• JOURNEY_NAME
• JOURNEY_VERSION_NUMBER
• JOURNEY_STATUS
• JOURNEY_VERSION_STATUS
• JOURNEY_TRIGGER
• JOURNEY_CREATED_AT
• JOURNEY_LAUNCHED_AT
• JOURNEY_VERSION_CREATED_AT
• JOURNEY_VERSION_LAUNCHED_AT
• OPERATION_ID
• STEP_ID
• STEP_NAME
• JOURNEY_ENDED_AT
• JOURNEY_VERSION_ENDED_AT
• CAMPAIGN_SYNC_ID
• METADATA
• CAMPAIGN_ACTION_ID
• CHANNEL_NAME
• CHANNEL_ACTION_NAME
• SKIPPED
• SKIPPED_CATEGORY
• SKIPPED_SUB_CATEGORY
• SKIPPED_DESCRIPTION
• BRANCH_NAME
• VARIANT_NAME
• VARIANT_ID
• LOADED_AT
• ADVANCEMENT_TIME