Transformations
Modify your data before it's sent to destinations
Last updated
Was this helpful?
Modify your data before it's sent to destinations
Last updated
Was this helpful?
Freshpaint supports three 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_cart
event that you're sending to Freshpaint into Facebook or Pinterest's AddToCart
event.
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.
Identify transformations allow you to re-format OR modify the user data you send to Freshpaint. This can be particularly useful if a certain destination requires a user property in one format, and another destination requires that same user property in a different format.
For example, if one destination enforces a naming convention that the user's operating system must be sent as user_os
while another destination requires the operating system to be sent as os
, you can rename the user property accordingly before the identify event is sent to the destination.
SQL transformations do not apply to identify events at this time.
Use this operation to rename the event. For example, if you have an event named order_complete
, but you want this to be named OrderCompleted
in 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.
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.
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.
2. Click the + button and choose the operation you want to apply. See above for operation descriptions.
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.
Click on the operation you want to delete or modify. It will highlight and show a pencil icon as you hover over it.
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.
when the event was captured