This page contains information about your External event and Automation program-related data views. For more information on Open Data - Data views, see Data views overview.
External events
View name: external_events_[customer_ID]
(where customer_ID
is your Emarsys account ID)
This data view contains all basic information on the events triggered through the External Event API. By running a query, you can see statistics about the event types that were triggered over time.
Data field | Description | Type |
---|---|---|
contact_id | Emarsys internal unique contact ID. Same as the user_id values in the contact export files. |
integer |
event_id | A unique identifier of the event generated by our platform. | string |
event_time | The exact time when the event happened. | timestamp |
event_type_id | The ID of the external event (See Management > External Events). | integer |
customer_id | The unique ID (account ID) of the customer. |
integer |
loaded_at | Date of loading into the Data Platform (UTC). | timestamp |
External custom events
View name: custom_events_[customer_ID]
(where customer_ID
is your Emarsys account ID)
This data view contains custom events that you sent.
Data field | Description | Type |
---|---|---|
contact_id |
Emarsys internal unique contact ID. It cannot be used for personally indentifying individuals. | integer |
event_id | The unique ID of the event. | string |
event_time | Timestamp when the event occurred (in UTC). | timestamp |
event_type | The type of the event. | boolean |
customer_id | The unique ID (account ID) of the customer. | integer |
loaded_at | The date when the data is loaded to Data Platform (in UTC). | timestamp |
partitiontime | The field name by which the data is partitioned (in UTC). | timestamp |
Automation
View name: automation_node_executions_[Customerid]
(where customer_ID
is your Emarsys account ID)
This data view contains information about participant journeys in Automation programs on node level.
This view contains data from November 1st, 2022 onwards.
Data field | Description | Type |
---|---|---|
customer_id | The unique ID (account ID) of the customer. |
integer |
ac_program_id | The ID of the Automation program. If the program is an Interaction, this column will be NULL . |
integer |
rti_program_id | The ID of the Interactions program. If the program is an Automation program, this column will be NULL . |
string |
node_id | The ID of the node. | string |
execution_phase | The value can be START or END . |
string |
Start if the item is about a node execution start (optional), END for execution finish. | ||
execution_id | The ID of the node execution. | string |
testing_mode |
TRUE , if the item entered the program in testing
mode. |
boolean |
event_time | The time of the execution. | timestamp |
participants.execution_result | Result code for execution, 'PASSED ' for successful execution, or an error code for unsuccessful execution. |
string |
participants.route_index | The index of the route where the contact continued on after a filter node, NULL for other node types. On a filter node the include path is route 0 , the exclude path is route 1 . |
integer |
participants.child_node_id | The ID of the child node where the participant continued on for A/B splitter nodes, NULL for other node types. |
string |
participants.continued_in_program |
True , if the contact continued to the next node, FALSE if exited the Automation program (ie. removed by a filter). |
boolean |
participants.count | The number of contacts in the contact list or 1 for single contact transaction. |
integer |
participants.contact_list_id | The ID of the contact list for batch executions or NULL for single contact transaction. |
integer |
participants.contact_id | The ID of the contact or null for contact list transaction. |
integer |
participants.trigger_id | Unique ID of an Interactions trigger of a participant. If the program is an Automation program, this column will be NULL . |
string |
participants.deduplication_id | Unique ID for each participant. | string |
partitiontime | The date of the partitioning. | timestamp |