Data cleansing

Transform/fix your events before to send them to destinations

Cleaning, fixing and preparing your data is crucial for success when using the Platform activation capabilities. The no-code approach allows you to create transformations using simple formula based on basic functions and operators.

You can choose between different kind of transformations:

• Rename event: simply change the name of an incoming event

• Derive event: create a new event from an existing one (coming soon)

• Modify properties: apply transformations and functions on properties

• Filter event: define rules to filter incoming events (coming soon)

• Custom code: create your own transformations (coming soon)

Rename event

First, give a name to the transformation and add a description if needed.

Select on which sources the rename transformation will be applied.

Select which event should be renamed. It is also possible to add more conditions, like rename the page view event to product view, if 'page_type' contains 'product'.

Last step, enter the new event name.

Modify properties

First, give a name to the transformation and add a description if needed.

Select on which sources the transformation will be applied.

Define conditions on events and/or properties, the transformation will be applied only regarding these conditions.

You can add multiple values (like event name is purchase ; add to cart). In that case, it is an OR condition (event name is purchase OR add to cart)

Select properties to transform. You can:

• rename the property ('rename to' option)

  • Example: rename 'date_of_birth' to 'birthdate'

• map/link to an existing property ('copy value from' option)

  • Example: map property 'price' to 'revenue'

• delete a property ('delete' option)

  • Example: always remove property 'tax_amount' from event 'purchase'

• change the value ('set value to' option)

With the 'set value to' option, you can simply change the value (ex: 'currency' = EUR by default) but you also have access to formulas based on basic functions and operators. For example, you can hash incoming data with SHA-256 or MD5 functions. You can also REPLACE or SUBSTITUTE a text to replace by another one, or EXTRACT a specific text in a chain.

You can also use operators like AND / OR / NOT and create operations with * / + -, full list here.

For example, to calculate the revenue with taxes, you can do: revenue = value*1,2.