Skip to main content
Interania

Building an event property

 

You can use event properties to "clean up" your data by transforming an attribute’s names and existing values post-ingest. You can also use event properties in queries to summarize, split by, and filter on re-usable expressions that can be direct references to physical data columns, references to values derived from lookups, or logical expressions evaluating multiple physical columns.

This article demonstrates how to build the following two 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: defined value or function.

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 upper 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 detailed 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.