Professional advice for entrepreneurs and business managers in the context of Europe's recovery from the financial crises. Marketing notes, stories and videos.

Marketing Analytics

Marketing Analytics

Conjoint Analysis

Conjoint Analysis is an analytic technique used in marketing that helps managers to determine the relative importance consumers attach to salient product attributes or the utilities the consumers attach to the levels of product or service attributes.  Conjoint procedures attempt to assign values to the levels of each attribute so that the resulting utilities attached to the stimuli match as closely as possible. Like MDS, Conjoint Analysis relies on respondents subjective evaluations. [Read more…]

Multidimensional Scaling (MDS) for Marketing

Multidimensional Scaling (MDS) is a class of procedures for representing  perceptions and preferences of respondents spatially by means of visual display. Perceived psychological relationships among stimuli are represented as geometric relationships among points in multidimensional space.  These geometric representations are often called spacial maps.  Multidimensional scaling are use for: [Read more…]

Marketing Analytics – why decisions based on analytic analysis are better?


People overestimate the probabilities of events and often become overconfident. The quality of the information available to them from external sources, such as media, real life experiences as they occur, or heuristic may give a false impression of the events. The problem with overconfidence, especially in the business environment, is that it often leads to the boiled frog syndrome. Bias is a cognitive phenomenon and has its roots in psychology (availability heuristic). Analytical methods for data processing and decision making are used to remove bias from the process of information assessment. [Read more…]

Regression Analysis – predicting the future



Let’s start with the definition of regression: Regression is a prediction equation that relates the dependent (response) variable (Y) to one or more independent (predictor) variables (X1, X2).

In marketing, the regression analysis is used to predict how the relationship between two variables, such as advertising and sales, can develop over time. Business managers can draw the regression line with data (cases) derived from historical sales data available to them.

The purpose of regression analysis is to describe, predict and control the relationship between at least two variables. The basic principle is to minimise the distance between the actual data and the perditions of the regression line. Regression analysis is used for variations in market share, sales and brand preference and this is normally done using variables such as advertising, price, distribution and quality.

  •  Regression analysis is used:
  •  To predict the values of the dependent variable
  • To determine the independent variables
  • To explain significant variation in the dependent variable and whether a relationship between variables exists
  • To measure strength of the relationship
  • To determine structure or form of the relationship

Example:

An online t-shirt sales company invested in Google AdWords advertising:

  • £1000 in January
  • £1000 in February
  • £1000 in March

Their sales grew steadily in this period:

  • £5000 in January
  • £5500 in February
  • £6000 in March

The managers can predict by looking at the regression line that with current level of advertising spent (£1000 per month) the sales in April will be £6500. This obviously would be the case if all other things remain equal but in reality they never do. The sales managers should use the prediction data from the regression analysis as an additional managerial tool but should not exclusively rely on it. The level of sales can be affected by elements other than the level of advertising. This includes, but is not limited to, factors such as weather conditions or the central bank’s increase or decrease of base interest rates. Regression analysis is concerned with the nature and degree of association between variables but does not assume causality (does not explain why there is relationship between variables). Other good examples of how regression analysis can be used to test marketing relevant hypothesis are: Can variation in demand be explained in terms of variation in fuel prices? Are consumers’ perceptions of quality determined by their perceptions in price? For a simple tutorial about the regression analysis for beginners please view the video below:

Regression analysis consists of number of statistics used to determine its accuracy and usefulness for certain purpose. Some of those statistics and methods are clearly explained by the statistics experts in the videos listed below. It is recommended that you read the text first and then watch the corresponding video:

  • Product Moment Correlation (r) is a statistic summarising the strength of association between two metric variables (for example: X and Y). It is used to determine whether a linear (straight line) relationship exists between X and Y. It indicates the degree to which the variation in one variable (X) is related to the variation in another variable (Y) (also known as Pearson or Simple Correlation, Bivariate Correlation or Correlation Coefficient). Covariance is a systematic relationship between two variables in which a change in one implies a corresponding change in the other (COV x Y).  The correlation coefficient between two variables will be the same regardless of their units of measurement. If r = 0.93 (a value close to 1.0) it means that one variable is strongly associated with the other. It does not matter which variable is considered dependent and which independent (X with Y) or (Y with X). The ‘r’ is designed to measure the strength of linear relationship, thus r= 0 does not suggest that there is no relationship between X and Y as there could be a non-linear relationship between the two.

  • Residuals – the difference between the observed value of Y and the value predicted by the regression equation.

  • Partial Correlation Coefficient – measures the association between the variables after adjusting for the effect of one or more additional variables. For example: how strongly related are sales to advertising expenditure when the effect of price is controlled?
  • Part Correlation Coefficient – is a measure of the correlation between Y and X when the linear effects of the other independent variables have been removed from X but not from Y.
  • Non-metric Correlation – a correlation measure for two non-metric variables that rely on rankings to compute the correlations.
  • Scatter Diagram – is a plot of values of two variables for all the cases of observation. The dependent variable on the vertical axis and the independent variable on the horizontal axis. If one variable increases so does the other – there is a linear relationship between X and Y. Scattergram
Image sourced from Flat World Knowledge
  • Least Squares Procedure – is a technique for fitting straight line to a scattergram by minimising the vertical distances of all the points from the line. The best fitting line is a regression line. The vertical distance from the point to the line is the error (e). read more
  • Significance Testing – significance of the linear relationship between X and Y may be tested by examining two hypothesis:
    • There is no linear relationship between X and Y
    • There is a relationship (positive or negative) between X and Y

The strength and significance of association is measured by the coefficient of determination r-square (r2). Significance Testing involves testing the significance of the overall regression equation as well as specific partial regression coefficients.

Multiple Regression

Multiple Regression is extremely relevant to business analysis. Itinvolves single dependent variable such as sales and two or more independent variables such as employee remuneration, number of staff, level of advertising, online marketing spend. For example: can variation in sales be explained in terms of variation in advertising expenditures, prices and level of distribution? It is possible to consider additional independent variables to answer the question raised. Statistics relevant to multiple regression are: adjusted r-square (r2) – coefficient of multiple determination is adjusted for the number of independent variables and the sample size to account for diminishing returns. To get more insight into multiple regression and understand how other statistics such as significance testing influence the usefulness of the analysis please watch the video below:

Multicollinearity – a state of high inter-correlation among independent variables. When multi-collinearity is present, special care is required in assessing the importance of independent variables. Here, once again, it is recommended that you watch the video below.

References:

  • Tuk, M., 2012. Regression Analysis, Marketing Analytics. Imperial College London, unpublished.
  • Malhotra, K. N. and Birks, F.D., 2000. Marketing Research. An applied approach. European Edition. London: Pearson

Written by

Cluster Analysis – a market segmentation procedure



Cluster Analysis in marketing is a process of grouping consumers of similar psychometric, demographic, geographic or socio-economic attributes into groups called clusters. The primary objective of cluster analysis is to classify objects into homogenous groups based on the set of variables considered. Marketers can use cluster analysis to segment the market and more effectively target the selected segments with relevant to them marketing campaigns. Cluster analysis examines an entire set of interdependent relationships and makes no distinction between dependent and independent variables. Independent relationships between the whole set of variables are examined. Cluster analysis is mainly used for:

  • Market segmentation
  • Examination of buying behaviour on a collective rather than individual basis.
  • Brands in the same cluster usually compete more fiercely with each other. A brand can use cluster analysis for strategic positioning and to identify threats and opportunities on the market.
  • With a set of homogeneous geographic clusters marketers can test their strategy on one cluster and if the strategy proves successful it can be expanded to all other clusters of similar characteristics.
  • Cluster analysis can be used as a general data reduction tool to manage individual observations.

Simple example:

When optimising Google AdWords for our international shipping business we used cluster analysis as a campaign targeting tool. We wanted to reduce the cost of our Google advertising by putting all the large cities in the UK into two homogeneous clusters; the more and the less profitable one. The variables we used for the clustering procedure are:

  • Number of paid clicks
  • Number of conversions per click (CPC)

We identified from the cluster analysis that there are profitable and non-profitable groups of UK cities for our Google AdWords advertising. Birmingham, Glasgow and Manchester receive high number of clicks but relatively low number of conversions. On the other hand; Liverpool, Edinburgh, Sheffield and London receive higher number of conversions relative to the number of clicks. With this simple clustering procedure we know which geographic areas in the UK should be excluded from our AdWords campaign. The budget consumed by the unprofitable cities can now be allocated to the more profitable ones.

Cluster Analysis

 

Nowadays cluster analysis is done using SPSS or MS Excel software but in order to understand this procedure properly one should know the mathematical logic behind it. For a simple demonstration of how cluster analysis can be done manually please watch this video:

Statistics associated with cluster analysis:

  • Agglomeration schedule gives information on cases being combined at each stage of clustering.
  • Cluster centroid is the mean value of all the variables or all the cases in particular cluster.
  • Cluster membership indicates the cluster to which each case belongs.
  • Dendrogram is a tree graph for displaying clustering results.
  • Distances between cluster centres indicate how separate individual pairs of clusters are.
  •  The process of conducting Cluster Analysis

Formulating the problem is the most important part of the clustering procedure. Selecting one irrelevant variable may distort the clustering solution. Once you define the problem and select the right set of variables you now must select a distance between clusters or similarity measure. The most commonly used measure of similarity is the Euclidean Distance or its square. There are other methods also available and these are used for comparing the results and checking their validity.

Clustering procedure can be hierarchical where clustering is characterised by the development of a hierarchy or treelike structure. Agglomerative clustering starts with each object in a separate cluster and clusters are formed by grouping objects into bigger and bigger clusters. Divisive clustering on the other hand starts with all the objects grouped into a single cluster and clusters are then divided or split until each object is in a separate cluster. K-means clustering is a non-hierarchical clustering and is a procedure which first assigns or determines a cluster centre and then groups all the objects within a pre-specified threshold value together working out from the centre. Deciding on the number of clusters is usually based on theoretical or practical considerations. In hierarchical clustering the distances at which clusters are combined can be used as criteria. In non-hierarchical clustering the ratio of the total within group variance to between group variance can be plotted against the number of clusters.

Interpreting and profiling the clusters involves examining the cluster centroids. The centroids represent the mean values of the objects contained in the cluster on each of the variables. The centroids can be assigned with a name or label. To assess reliability and validity one has to perform cluster analysis on the same data using different distance measures and compare the results to determine stability of solutions. Splitting the data randomly into halves and performing clustering separately on each half and comparing cluster centroids across two sub-samples is one of my favourite ways. In hierarchical clustering the solution may depend on the order of cases in the dataset. To achieve the best results make multiple runs using different order of cases until the solution stabilises.

References:

  • Tuk, M., 2012. Cluster Analysis, Marketing Analytics. Imperial College London, unpublished.
  • Malhotra, K. N. and Birks, F.D., 2000. Marketing Research. An applied approach. European Edition. London: Pearson

Written by

About this website



This website is intended to be a platform for the exchange of practical business information as well as a place for discussion about issues in strategic business management. The articles and other materials on the site are aimed at entrepreneurs and managers and those who would like to improve their own understanding of business. What you will find here are the notes, essays, graphic materials and videos based on Michael Pawlicki’s and other business managers’ experience and knowledge acquired through developing businesses, their own research and academic expertise.

How to use this website?

All new posts are published on the home page. You can use the menu on the top right hand side to select the kind of material you would like to view by category (Pricing, Analytics etc.) or format (Notes, Essays etc). Alternatively, you can search the archive using the search bar on the right hand side. The materials published on this website can be shared as long as the original source author and site is acknowledged. Each page and post is opened for discussion in comments. You can also sign up to receive Tweets or RSS Feeds for regular updates.

Written by

About Michael Pawlicki

Michael PawlickiMichael Pawlicki is an experienced online marketing manager and alumnus of Imperial College London with proven success in starting up business ventures to his name. Michael has a special interest in seeing how the latest analytic methods (advances in multiple regression and cluster analysis) can be effectively deployed within an overall framework of strategic decision making. He has a strong secondary interest in staying abreast of developments in how social media platforms are used for the co-creation of customer value. Michael and his team are responsible for many successful commercial ventures, including:

 

VanOne – an online based, no thrills European
removals operating a fleet of 31 vans. VanOne provides low priced international removal services to the people of the UK and Continental Europe. The company is set to offer to their international clients an easy way of moving to and from Europe even if customers are booking at short notice. VanOne is probably the cheapest European Relocation services provider in the UK.

Imperial College London

 

Open Platform – self-sustaining environment for the buying and selling of standards compliant data, applications and models to enable organisations to easily access reliable data. Open Platform also helps these organisations to compute this data through algorithms and enable them to make better decisions based on dependable information. Michael and his university team were instrumental in setting up and managing the digital campaign for Open Platform.

OcaPoranga is a guest house located in Rio de Janeiro, Brazil. Their services are marketed in Britain using innovative, mobile optimised website where users can check prices and book inexpensive rooms with their credit or debit card online. The commercial success of OcaPoranga website lies in the field of smart use of digital media, effective online segmentation and its ability to tangibly illustrate the benefits of using the service offered.

UniText for Professionals

 

UniText – a London based proofreading and copyediting service. Their main focus is on working with individuals, and teams, in business to perfect written documents such as reports, marketing material, business letters, speeches and more. They employ experienced copyeditors and readers who keep up to date with the norms and standards of business communications and commercial language to ensure our clients receive the best service available.

 

Kosciuszki 107Kosciuszki 107 – flexible office hire solution for those needing to work and live in Poland. The terms of use of this office space are specifically designed to ensure ease of conducting business. Highlights of these terms include systems for entering and exiting the lease of the office without unnecessary costs or bureaucracy which helps growing businesses stay agile with their location.

Written by Michael Pawlicki Google+