Tag Archives: forecasting

How is multivariate data analysis used in marketing?

Published / by Simon Foster

‘Multivariate’ means ‘many variables’ and in the context of marketing it usually means analysing multiple variables from customer records to get a deeper understanding of the customer base. This increased understanding of customer behaviour permits the development of customised offers, relevant creative messaging and more accurate media targeting – particularly with techniques like email and behavioural targeting. Very strong offer targeting will significantly increase your response and sales conversion rates.  Any company that has a database of more than around 5,000 records should be using multivariate data analysis to analyse customer data and improve marketing performance.

The most common forms of multivariate analysis in marketing are cluster analysis and hierarchical analysis. Cluster analysis uses statistical techniques to allocate customers into segments based on how similar, or dissimilar, they are to each other. So for example, if you had 10,000 customers and you were clustering by income and home ownership, you would be able to define groups of customers with similar levels of income and home ownership status, or those with high income and low home ownership status, or those with low income and high home ownership status. The number of clusters generated depends on how you set up your cluster analysis and of course, what patterns actually lie within your data. You can set up your analysis to produce either a large or small number of clusters, but most marketers can’t practically service more than about fifteen clusters.

Hierarchical analysis breaks customers down into sub-sets of the whole customer base. Results of hierarchical analysis are often shown as dendograms or tree diagrams. In a tree diagram, all customers belong to the ‘root’ and segments of the customer base are called ‘nodes’, nodes are connnected to the tree by ‘branches’.  So for example, all customers can be divided into males and females. Then the males and the females can be divided by age, and then by income and then by spend. You are then able to see what proportion of the whole base is composed of customers with certain characteristics.  Here are some examples of customer segments defined using hierarchical analysis:

  1. Spend more than £250 per year and are aged 18-34 and female and do not have children
  2. Spend more than £500 per year and are aged 25-44 and male and do not have children and earn between £20,000 and £30,000 and have a mortgage
  3. Spend more than £1000 per year and are aged 35-54 and have children and have a mortgage and live in the South East

Whichever technique you use, it is likely that you will see a small number of segments account for disproportionally large amounts of sales revenue or sales potential. When you have identified these segments you can leverage what you know to develop tailored offers, messages and targeting. Over and above this you can identify customers who have the characteristics of high performance segment membership, but are not spending at the rate they could be. You can use this information to target your marketing messages to the sales prospects with the highest untapped potential.

What is predictive modelling in marketing?

Published / by Simon Foster

Predictive modelling is a term with many applications in statistics but in database marketing it is a technique used to identify customers or prospects who, given their demographic characteristics or past purchase behaviour, are highly likely to purchase a given product. In this context, ‘predictive’ does not simply mean predicting the future; it means identifying the quantitative factors that can be used to predict buyer behaviour. Predictive modelling is a powerful data analysis technique that can be used to target email and direct mail activity, and to some degree behavioural targeting in online media.

Here’s an example: Let say you sell 10 products. It may be the case that all purchasers of product 8 are: 1) in a certain geodemographic group, 2) married with more than one child and 3) own more than one car. All these factors can be analysed and combined to predict the likelihood of any consumer in your database buying product 8. Usually this combined measure is referred to as a ’score’ i.e. a figure which represents the presence or combination of certain variables in the consumer record. Once you have developed your scoring model you can rank all customers by their score. When you’ve stripped out those who have already bought product 8, you are left with a set of high potential prospects.

Predictive modelling can also be undertaken based on transactional information about past purchases. Going back to the 10 products, it may be the case that 80% of people who buy product 7 have previously bought products 2, 5 and 6 and in that order. So we can say that people who have bought products 2, 5 and 6 (in that order) but who have not yet purchased product 7, are much more likely to buy product 7 than everyone in your database. Again a score is attached to these behaviours and that score can be used to rank your prospects in terms of untapped sales potential.

Of course as well as predicting purchase behaviour, these techniques can be used to predict risk. In credit assessment for example, it may be the case that those customers who have certain demographic characteristics combined with a certain type of past purchase behaviour are highly likely to default on a credit agreement. This is sometimes referred to as credit scoring. If you are rejected for credit at a bank or in a shop it will be because your data has been analysed and your credit risk score is deemed too high or low to meet the criteria of the lender.

These predictions can help you target your communications very efficiently and also help you control commercial risk in customer behaviour. What’s interesting about these techniques is that they help both the marketing department and the finance department. Marketing delivers customers who are both highly likely to convert to sales or high lifetime value whilst at the same time, producing customers who are less likely to cause problems for the finance department. Overall, this means that the resources of the business are being better utilised.

Marketing data analysis gets you closer to customers

Published / by Simon Foster

Smart data analysis can be a major source of campaign insight and even competitive advantage for brands and advertisers. The customer data owned by a brand advertiser can reveal

  • Exactly who buys a given product or service
  • Detailed information about the characteristics of those buyers
  • Which other products and services they buy
  • Which product and service offers they find most attractive
  • Which buyers buy more of certain types of products
  • How you can find more buyers with the same characteristics

These data analysis techniques can be applied to all types of customer data – whether it’s for a retail business, an online business or a call centre based business. Insight from data analysis can be applied across a wide spectrum; from adding inspiration to a creative brief through to changing a company’s entire business strategy.

You may think the claim that data analysis can change the destiny of a business is rather grandiose. But I can can think of two examples of breakthrough data insight from the same category that ended up contributing millions in additional brand revenues.

Sainsbury’s  – Sainsbury’s agency AMV were tasked with increasing the then ailing retailer’s sales by £2.5bn over a three year period. A seemingly impossible challenge until viewed as a data question. The AMV team calculated that £2.5bn equated to £833m per year which in turn equated to £16m per week.  It still looked like a big number until the AMV team considered that Sainsbury’s handled 14m customer transactions per week.  Then the target equated to just £1.14 per transaction. The brief to increase sales by £833m per week could be redefined as increasing each existing transaction by just £1.14. Now the target not only looked attainable, but this data insight led to the idea that lots of small changes could make a big difference.  From this insight came the campaign idea that consumers should “Try something new today”. By asking customers to ‘try something new’ they were able to persuade customers to spend at extra £1.14 every time they shopped.

Tesco – The Tesco Clubcard is now legendary as both a customer loyalty card and a source of information about customers.  Up until the introduction of the loyalty card, many retailers didn’t know who their customers were. And if they didn’t know who they were it was difficult for them to gather the data that allowed them to understand individual customers better. With the Club Card this all changed. Tesco were able to develop individual data driven relationships with their customers.  They were able to understand customer needs better and in doing so they gained competitive advantage over their rivals.