Events setup

Endpoint

Select the endpoint from ME using the dropdowndropdown.

Event time extraction

SQLThe expression,reception whichtime willin loadUTC can be used as the event timetimestamp to receive an event in near real-time. For example: 

"reception_time".

However, when receiving data from third-party endpoints, there may be a delay between the payload.actual event occurrence. Therefore, it is necessary to utilize SQL expressions or transformations to handle such cases appropriately. For example:

"payload ->> 'timestamp'".

Remember: you need to be ensured that the event_time is always in UTC.

User identifier extraction

SQL definition that can work on the payload. For example:

"payload ->> 'user_id'"

Event filter

SQL expression that can work on the payload. For example:

"payload ->> 'type' = 'page_view'"

Move

Allows to extract a value from a specified old path, create a new path, place the extracted value in the new path, and delete the old path. This helps organize and restructure the data within the payload, improving data quality and consistency.

Map value

Allows extracting the value from the target_old_value path. It then searches for a matching value in the value_maps array, comparing the extracted value with the old value from each value_map. If a match is found, the component takes the corresponding new value from the value_map, creates a new path named target_new_value, and places the new value from the value_map there. This process is similar to a join operation in a database.

Name pop-up banner

Allows extracting the banner_id value from  id_path. It then searches for a matching banner_name from the refreshed web banner data downloaded from the CDP instance. If a match is found, the component creates a new path called name_path in the payload and places the banner_name value there.

Name native banner

The same logic as in the Name pop-up banner is applied to payloads where native web banners data must be enriched.

Czech vocative

This transformation is designed for projects based in the Czech Republic, where vocative forms of names are commonly used. It extracts the first name from the specified path using the first_name_path. Then tries to use a vocative library to transform first_name. The transformed name is then placed in a new path specified by result_path.

Czech gender

This transformation is mainly for projects in the Czech Republic because it uses a vocative library that works mostly with first names in the Czech calendar. Transformation extracts first_name from first_name_path path. Then try to use a vocative library to estimate gender from first_name. It creates a new path in result_path and places the estimated gender there.

Replace in string

Transformation extracts string object from the string_path path. Then apply Python replace method on an extracted object with old and new as an argument. It creates a new path  result_path and places the transformed string there.

Strip string

Allows extracting string object from string_path path. Then apply the Python replace method on an extracted object with old and new as an argument. It creates a new path  result_path and places the transformed string there.

Lowercase string

Transformation allows to extract string object from the string_path path. Then applies the Python lower method on an extracted object without any arguments. It creates a new path in result_path and places the transformed string there.

Validate email

With the transformation, the string object from the string_path path is extracted. Then applies the Python lower method on an extracted object without any arguments. It creates a new path in result_path and places the transformed string there.

Delete

Checks if delete_path exists and removes it.