Behavioural modelling - count dimensions (behavioural features)

Working with count dimensions allows you to answer questions such as:

  • How many policies has a person previously taken out?

  • How many times has a person volunteered at one of our charity events?

  • How many communications did a person receive prior to transacting?

Let's consider the following example:

Is a person who books a sports activity more or less likely to buy insurance cover?

Here the behavioural feature needs to:

  1. Group activities up to the person level.

  2. Identify sports activities.

  3. Count sports activities.

To get started:

  1. Right click within the Dimensions panel, hover over Behavioural Modelling and select Create Count aggregation.

The resulting window comprises of 3 sections:

  1. The type of transaction is identified in the top panel.

  2. The middle panel is where you set the timeframe within which the transactions should have occurred.

  3. The bottom panel allows you to be more specific and, rather than counting all transactions, you can also choose to count specific transactions.

  1. Complete the settings as per the screenshot below:

  2. Click OK - a confirmation is displayed:

  3. Click OK.

In the above example, transactions on the Activities table are being aggregated up to the person level - i.e. each person's activities are being counted. The middle panel defines the time window within which the activities should have taken place. At the moment, with no additional criteria defined, all activities are included. To focus on specific transactions - here sporting activities:

  1. Click Add Criteria

In the Add criteria window that opens:

  1. Set the resolve table to Activities.

  1. Select the variable that contains the category of transactions you are interested in - here Activity Type.

  2. Click Define Variable Criteria.

  3. Select the Sport category and OK.

When selecting multiple categories, you have the option to create a more concise, customised description , if you wish.

  1. Click OK - a confirmation is displayed:

  2. Click OK to add the feature to the Dimensions list.

 

For related topics see Behavioural modelling - creating dimensions (behavioural features)