- To create a custom property, you will first navigate to the event achema section under the configure tab and select the event you wish to add the property to.
- Next, you will click on the Add Property button. Here you can name your property and set a unique key for the property.
- Enter the formula for your new property. For a list of available formulas, please see our Formula page for more info.
Say I want to create a new property in a tracked event (e.g. Played Song) using a formula that will group similar music genres together.
For example, in my event called 'Played Song' with a property 'genres', I want to change the data from the original column to the converted column.
The converted column will change the names which makes it much easier to run reports on the data.
First, I'll click the "Add Property" button under the 'Played Song' event while viewing that event in the Event Schema.
Next, I'll select the formula box and start selecting and entering the formula. For this example, I can use IF_THEN_ELSE and select the condition, true result, and false result.
- Lastly, hit the save button in the upper right and you can now use this new property in your reports.
Formulas will only work on properties within each event. You cannot create a formula that has parameters from another event or event property. In other words, if I have a 'Played Song' event, I could not make a new formula property under 'Played Song' that uses another property from another event (e.g. 'Played Video').
You can see when we add the two columns in the Compare by, all the names have been changed for the genres that we edited.
Updated 8 days ago