Skip to main content
Interania

Building an event property

Event properties help "clean up" your data by transforming names and values post-ingest. In queries, event properties are reusable expressions on which you can sum, split by, or filter. Event properties can be direct references to data columns (for example the sum of two similar fields from different data sources), references to values derived from lookups, or logical expressions evaluating multiple data columns.

This article demonstrates how to build the following types of event properties:

  • Defined value—an event property with at least one specified value
  • Function—an event property that performs a mathematical function

Creating an event property

The initial steps for creating an event property are the same for both types of event property: function or defined value.

To create an event property, do the following:
  1. Select the desired dataset from the drop-down list in the upper left of the top menu bar. We chose the IA_MOVIES dataset for our example.

CB_Event-Prop_dataset.png

  1. In the left navigation bar, click the Events icon.
  2. In the top right corner of the window, click New Event Property.

CB_Event-Prop_New-Event-Property.png

  1. In the center window, enter a descriptive Name for the event property. Use a name that conveys the purpose of the event property, so that it will be easy to find in a list of event properties. 
  2. Optionally, click the About tab and enter a description of the purpose and function of the property.
  3. In the Definition tab, specify a Defined Value and/or Function, and then click Save.

You can assign an event property both a defined value and a function, as appropriate.

For a defined value event property:

You must specify at least one value for a defined value event property, and optionally a value to assign if the event property definition does not return any results.

  1. Click the Defined Value tab.
  2. Click inside the value ... field and enter a descriptive name.
  3. Select all events (default value) and then choose the desired value from the drop-down list. The query builder automatically provides valid options from which you can select, and inserts words to create a meaningful sentence. 

In the following example, we selected events with user_type that matches consumer. Choose the values appropriate for your dataset.

CB_Event-Prop_DefinedValue.png

  1. Optionally: You can specify multiple values and multiple AND / OR conditions for each value.

Click AND to toggle between AND and OR.

For a function event property:

You can apply a function to a specific action, a flow, a flow that is compared to another action, an event property, or all events (the default).

  1. Click the Function tab.
  2. Click inside the For each event value is ... field, and select the actor or event from the drop-down list with which to evaluate the value, the mathematical operator to perform (add, subtract, multiply, or divide).
  3. Select all events (default value) and then choose the desired value from the drop-down list. The query builder automatically provides valid options from which you can select, and inserts words to create a meaningful sentence. This specifies whether the function is for the default all events, a specific action, a flow, a flow that is compared to another action, or an event property. 

In the following example, we chose Purchase Movie as the first value, then filtered to events with Action Type that matches Comments.

CB_Event-Property_Function.png

  1. Optionally: You can specify multiple values and multiple AND / OR conditions for each value.

Click AND to toggle between AND and OR.