We have mentioned customer analytics before briefly. Still the theory is all well and good but what about actually mining the data and doing something with it. This tool has been under development for about a year and is being fine tuned. It works with any Sage product from Instant right up to Line 500. The basis being it scores and segments your customers to allow you to create targetted offers. The way you do this is to take a set of metrics and measure each customer against these metrics and then split the customers into groups of 10 or 25% (called deciles or quartiles).

This shows the ‘revenue decile’ (customers who have spent the most)

Then if we want to target customers in the top decile we can drill down from the chart and get those customers.

These customers could be either mail-merged or bulk emailed with a specific offer. You will also notice in the data we have the total spend the customer has made with us, the average order value and the number of days since they last ordered (from when this extract was run).