Customer Transactions: Money vs. Loyalty enhanced

In this workflow we convert raw customer transactions, i.e. contract registrations, into money measures on the one hand and loyalty features on the other. The idea is to move from a list of transactions to one or a few numbers describing an aspect of the customer activity. Here we have chosen money and loyalty. Money as total amount of money paid by customer or as amount paid per year. Loyalty as # of days under contract or as loyalty ratio (= # effective days / total number of days till now).

This workflow is based on the workflow created by Rosaria Silipo: https://kni.me/w/c00Kq3qCHdUHFi_L

External resources

• kni.me/w/c00Kq3qCHdUHFi_L