Ranking records in FastStats by a Numeric Variable
Posted: Mon Dec 23, 2024 5:11 am
Given the importance of identifying your top spending customers, it is no great surprise that the Apteco support team often get asked if it is possible to rank customers based on their total order value. Gaining these types of customer insights, for example, producing a ranking value of 1 for the customer with the highest total spend, 2 for the second highest, and so on, is possible within FastStats and in the following blog we show you just how it can be done.
It is possible to rank your cyprus mobile phone numbers customer records in FastStats Discoverer by making use of the Numeric Banding wizard. To illustrate this, let's use our fictitious holiday company. For the purposes of this illustration I have created a “Total Spend per Person” variable which is derived from an RFV (Recency, Frequency, Value) aggregation, totalling the booking “Cost” variable for each customer.
Create a selection of all the people in your database
The first thing you need to do is create a Selector variable which has all of the Person records flagged under a single category. This can be done with the Create and Update wizard, creating a Selector variable with one category and using a Person universe selection to populate this category.
In the example below, this variable is named 'Everyone', has a Code of '1' with a description of 'Everyone'
Customer Insights: How to Maximise Profit With Your Top Spending Customers
Produce the ranking using the Numeric Banding wizard
Click the Numeric Banding wizard in the list of Wizards and drop on the numeric value variable you wish to rank i.e. Total Spend per Person. On Step 2 choose the option labelled Ranked.
It is possible to rank your cyprus mobile phone numbers customer records in FastStats Discoverer by making use of the Numeric Banding wizard. To illustrate this, let's use our fictitious holiday company. For the purposes of this illustration I have created a “Total Spend per Person” variable which is derived from an RFV (Recency, Frequency, Value) aggregation, totalling the booking “Cost” variable for each customer.
Create a selection of all the people in your database
The first thing you need to do is create a Selector variable which has all of the Person records flagged under a single category. This can be done with the Create and Update wizard, creating a Selector variable with one category and using a Person universe selection to populate this category.
In the example below, this variable is named 'Everyone', has a Code of '1' with a description of 'Everyone'
Customer Insights: How to Maximise Profit With Your Top Spending Customers
Produce the ranking using the Numeric Banding wizard
Click the Numeric Banding wizard in the list of Wizards and drop on the numeric value variable you wish to rank i.e. Total Spend per Person. On Step 2 choose the option labelled Ranked.