Custom Action Schema Properties
With custom schema properties, you can use formulas to create your own filtered properties that you can use in reports. This can be useful if you have similar entries that you wish you group together in your reports. For example, if you had campaign sources like face book, FACEBOOK, FaceBook, etc. and you wanted them all to be 'Facebook' -- you could use this feature to achieve this.
How to Create a Custom Property
- To create a custom property, you will first navigate to the action achema section under the configure tab and select the action 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.
Grouping Similar Entries Example
Say I want to create a new property in a tracked action (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.
|Genres Original||Genres Converted|
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 action in the Action 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 action. You cannot create a formula that has parameters from another action or action 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 over 3 years ago