Recency Wizard: Recency Settings

Once the transaction and grouping tables have been specified, you need to define which of the transaction records associated with each grouping record should be chosen.

You can choose the first nth or last nth transaction record to use.  If you use an order of first or last then you need to specify a position.  An order of first and a position of 2 would give the second record and an order of last and a position of 3 would give the third to last record.  Note that in the first example, if a person only has one booking associated with them, picking the second record will result in an unclassified booking.  For first and last orders a variable needs to be specified to decide on the order (i.e. should the second booking be the second earliest or the second cheapest).  Any numeric variable or ordered selector variable can be specified.

Note that the when ordering by numeric variables, the first value will be the lowest value as numerics are always sorted in ascending order.  Therefore if you were sorting by a currency variable, the first value would be the cheapest value.

 

Click Next to go to Target

Click to return to Grouping Table