Achieving aggregation with Apteco FastStats®
Some typical areas that require the aggregation of customer data include (but are of course not limited to):
Number of transactions in the last year
Date of last purchase for an individual customer
All of these are common types of aggregation that have been achievable using Apteco FastStats® for many years, through either one of two methods:
Using RFV selections to select customers whose average transactional value was over £1000 through the ‘Apply RFV’ option in the Selection Tree, before entering the desired cyprus mobile numbers parameters for the variable and the amount in the Value section.
Creating Virtual Variables (or VVs) using the Wizards, consolidating these aggregations into new variables that can be used flexibly throughout the application. For example, to output the average transaction amount in a Data Grid, or to use as a statistic in a Cube.
In many cases the creation of these Virtual Variables is sensible, often representing customer attributes that are going to be used regularly. It is useful to have these aggregated results readily available in the System Explorer, so that, should they have to be brought into your analytical workflow, it can be done as efficiently as possible.
In other instances there may have been necessary intermediate results for a particular piece of analysis that you may never use again. In these cases, the variables in question often go on to be forgotten about, languishing in the System Explorer with a name that doesn’t adequately describe its purpose, making it difficult to find if you ever do end up needing it further down the line.