CRM addicted

Measure templates Recently a new feature has been added to Customer Insights, which allows to create measures based on templates. If you select "Choose a template" various templates are offered, that allow the calculation of popular KPIs, like Average transaction value, Loyalty points earned or Time since last purchase: If you select one of the templates, e.g. "Loyalty points earned" a short description of the measure based on an example, the formula behind the measure and the data, which is required to calculate the measure, is displayed: As we can see, this template is based on activities and the activities need the following information: - How many loyalty points have been earned with a purchase - Activity timestamp of the purchase Which means we have to setup an activity first, before we can define our measure. Activities In this example, we have an entity called "posPurchases", which contains transactional data in the following format: To add a new ac...