Modify your data before it's sent to destinations
Freshpaint supports two uses for transformations
Standard mappings are used to re-format the data you send to Freshpaint into the structure that a destination accepts and assigns special meaning to. For example, you can use transformations to rename your
add_to_cartevent that you're sending to Freshpaint into Facebook or Pinterest's
You can use transformations to modify the data Freshpaint sends to destinations in order to match historical data or remove sensitive information before they are sent to a destination.
Change Property Type
Send Built-in Property
Send Constant Property
Use this operation to rename the event. For example, if you have an event named
order_complete, but you want this to be named
OrderCompletedin a destination, you can use this operation.
You can only rename an event once. If you try to add two "Rename Event" operations to a given event + destination combination, you will receive an error.
Use this operation to convert between text, number, and true/false values of a property.
If a value cannot be converted to the desired type, it is left untouched.
When converting a property into a number, we leave everything that is not text untouched. For text, we attempt to parse it as a decimal value, if it has characters that are non-numeric, it fails.
When converting a property's value to text, we leave null and text values as-is, but convert objects, arrays, numbers and true/false values. For objects and arrays, we json-encode them without modifying the sub-element's types. For numbers and true/false values, we simply convert them to text as you'd expect.
When converting a property's value to True/False, all values besides the text values
false(case insensitive) are let as-is.
Note: the numerical values of
1are not converted to
Use these operations to convert the value of a property to upper or lower case. Useful for normalizing email addresses, or converting a
USDto match historical data.
Use this operation to delete an event property. This is often useful if you want to remove sensitive data from flowing into a third party destination.
Use this operation to send the built-in properties to destinations that Freshpaint automatically captures for each event.
The following built-in properties are currently supported:
Builtin Property Name
Identifier for the user. Can be a UUID if the user is anonymous, or the user email if logged in.
Mac OS X
Full url of the page on which the event was captured.
Domain of the page on which the event was captured.
Initial Referring Domain
The user's IP Address
Screen height in pixels
Screen width in pixels
Text of the element which was clicked on
The href of a link which was clicked on
View Built-in properties for each event in Live View
Use this operation to send some constant value as a property. You can use one of the following values:
- Number, which support numeric values (42, 42.1, 0.123)
- True/False, which supports only
Falseas literal booleans
- Text, which can be any text
From the transformation dashboard, you can view and edit your existing transformations, as well as launch the wizard to guide you through creating a new transformation.
Transformations are grouped into sets based on their Transformation Type, Freshpaint Event and Destination.
You can launch the wizard to create a new transformation by clicking the button in the top right.
- 1.Expand the transformation set you want to modify by clicking on it. If you just created a new transformation via the wizard, it will already be opened.
Expanding a transformation set
2. Click the + button and choose the operation you want to apply. See above for operation descriptions.
- 1.Expand the transformation set that contains the operation you want to modify by clicking on it. If you just created a new transformation via the wizard, it will already be opened.
- 2.Click on the operation you want to delete or modify. It will highlight and show a pencil icon as you hover over it.
- 3.From here you can either change the attributes and click "Save" or delete the operation by clicking "delete."
You can delete an entire set of transformations by clicking on the trash icon on the right side of any transformation set.