This article helps you:
Understand and create the main types of transformations
Edit and manage transformations
Amplitude Data’s transformations feature allows you to transform event data in order to correct common implementation mistakes. Transformations are retroactive: you can create them whenever you want, and apply them to all historical data. This means you can make changes to your event data without having to touch your underlying code base. No matter when you recognize a mistake or want to make a change, you can use a transformation to correct all affected data, both historically and moving forward.
Currently, transformations on Amplitude's default user properties are not supported.
Transformations can only be performed in a project’s main
branch. Ensure the Show transformations toggle is set to ON
.
Transformations are applied at query time when a chart or cohort generates results. This does not affect the raw data. Raw data on Snowflake or Redshift will not be impacted by transformations.
This feature is available with some Amplitude plans only. See the pricing page for details.
For many Amplitude users, the need to consolidate superfluous or duplicate events, event properties, or user properties will eventually arise. Transformations make this process easy.
This transformation allows you to merge events together. This is helpful if you are tracking two or more events that you would like to track as one single event instead. For example, you can merge the events comment_reply_like
and comment_share
into a single event, comment
.
When merging events, you can also add a property that will help you distinguish between the two original events after you’ve merged them. This transformation can be helpful if you are logging data into two events with similar syntax when you could log this information as one event with different property values instead. For example, you could transform the events comment_reply_like
and comment_share
into one event, comment
. The event comment
will then have a new event property comment type
with values reply like
and share
.
To merge events, follow these steps:
Otherwise, select the event property you’d like to use as a differentiator from the Select Property drop-down. Then click Next.
This transformation allows you to merge properties, either for events or for users. This is helpful if you have two properties that track the same information but were named with different syntax.
For example, imagine an event property is called title
in some cases, and in others, it's called TITLE
—but they represent the same thing on all events. You can clean things up by transforming title
and TITLE
into Title
, combining the data.
Similarly, a user property called name
in some cases and NAME
in others—even though they represent the same thing for all users—could be unclear. Transforming name
and NAME
into Name
is a good way to resolve any potential confusion.
Event properties can only be merged with other event properties, and user properties can only be merged with other user properties.
To merge event properties or user properties, follow these steps:
This transformation allows you to re-assign event and user property values. This transformation is useful if a property has a number of misspellings or nonsensical values in drop-downs and will allow you to hide them from the UI or turn them into another value.
For example, you can reassign the values of true
and TRUE
to True
.
To rename a property value, follow these steps:
Setting a property value's visibility status to hidden is helpful for values you may want to track but do not want to appear on the dashboard in any charts. Hiding a property value does not delete its raw data, and the value will still be visible in the user's individual event stream.
To hide a property value, follow these steps:
Transformations are not permanent and can be reversed. You can edit or delete them at any time.
To edit your transformation, follow these steps:
To delete your transformation, follow these steps:
Deleting a transformation does not delete the original events.
Thanks for your feedback!
June 5th, 2024
Need help? Contact Support
Visit Amplitude.com
Have a look at the Amplitude Blog
Learn more at Amplitude Academy
© 2024 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.