A complete guide to Marketing Mix Modeling
A complete guide to Marketing Mix Modeling
The singular aim driving all marketing initiatives is to maximise the ROI on the production, sales and distribution of a certain product or service. Effective marketing can therefore be defined as having the right product at the right time at the right place and available at the right price. The concept of a marketing mix strategy, was first proposed in 1960 by marketing expert Edmund Jerome McCarthy. The marketing mix elements can be broken down into:
The importance of developing a marketing mix lies in the fact that the success or failure of a product or service in the market can also be traced back to how accurate and efficient its marketing mix was. Here is a complete guide to everything your company needs to know about the importance of creating a marketing mix and how to develop a winning marketing mix strategy for your product in 2020.
What is Marketing Mix Modeling?
An accurate marketing mix model can be the difference between the success or failure of a product!
Marketing Mix Modeling definition
The key purpose of a Marketing Mix Model is to understand how various marketing activities are driving the business metrics of a product. It is used as a decision-making tool by brands to estimate the effectiveness of various marketing initiatives in increasing Return on Investment (RoI).
How does a Marketing Mix Model work?
Marketing Mix modeling breaks down business metrics to differentiate between contributions from marketing and promotional activities (incremental drivers) vs. other (base) drivers. These factors affecting marketing mix can be defined as:
Incremental drivers: Business outcomes generated by marketing activities like TV and print ads, digital spends, price discounts, promotions, social outreach, etc.
Base drivers: Base outcome is achieved without any advertisements. It is due to brand equity built over the years. Base outcomes are usually fixed unless there are any economic or environmental changes.
Other drivers: They are a sub-component of baseline factors and are measured as the brand value accumulated over a certain time period due to long-term impact of marketing activities.
Importance of Marketing Mix Modeling
Marketing Mix modeling offers several important benefits for marketers:
1. Better allocation of marketing budgets
This tool can be used to identify the most suitable marketing channel (Eg. TV, online, print, radio, etc.) to achieve the marketing objectives and get maximum returns.
2. Better execution of ad campaigns
Through MMM, markets can suggest optimal spend levels in highly effective marketing channels to avoid saturation.
3. Business scenario testing
MMM can be used to forecast business metrics based on planned marketing activities and then simulate various business scenarios like increase in spends by 10%, level of spends required to achieve 10% lift in business metric etc.
Impact of variables on marketing mix models
Developing an accurate forecast for sales is only possible by taking into account these main variables.
Marketing mix elements are broken down into three variables: incremental, base and other. These three categories are further subdivided into a range of factors that can influence the market performance of a product or service. Understanding each of these variables is crucial for marketers to make an accurate forecast of the effects of promotional activities and product distribution.
Base variables
The baseline is any impact achieved independent of marketing mix variables. They are influenced by various factors like brand value, seasonality and other non-marketing factors like GDP, growth rate, consumer sentiment, etc. Determining the baseline outcomes is critical to understand the impact marketing activities are having on a product’s performance and a product’s distribution.
Some of the base variables include:
1. Price: The price is a very significant factor in determining the other elements of the marketing mix strategy. Price determines the target consumer group as well as the strategy for advertising, promotion and distribution.
The pricing model is one of the key factors affecting marketing mix because:
- Pricing communicates the value of the product to the customers and can have direct impact on business performance
- Impact on pricing depends on the elasticity of the product
2. Distribution: In Marketing Mix Modeling, distribution refers to the number of stores or locations where the product is available, number of stock keeping units (assortment) and shelf life (velocity). The distribution strategy is influenced by the market structure, the firm’s’ objectives, its resources and of course, its overall marketing strategy.
Distribution of a product is key because:
- Strong product distribution chain coupled with targeted marketing activities directly results in effective business outcome.
- Strong assortment for a product enables consumers to have multiple options to actively research and purchase.
3. Seasonality: Seasonality refers to variations that occur in a periodic manner. Seasonal opportunities are enormous, and often they are the most commercially critical times of the year. For example, major share of electronics sales are around the holiday season.
4. Macro-economic variables: Macro-economic factors greatly influence businesses and hence, their marketing strategies. Understanding of macro factors like GDP, unemployment rate, purchase power, growth rate, inflation and consumer sentiment is very critical as these factors are not under the control of businesses but substantially impact them.
Incremental variables
All marketing mix elements can be broadly classified under three categories:
1. ATL (Above-the-Line) marketing: Above-the-line advertising consists of advertising activities that are largely non-targeted and have a wide reach. The primary objective of ATL activities is to help in brand building and to create consumer awareness and familiarity.
Examples of ATL marketing include television advertising, radio advertising, print advertisements (magazine and newspaper), and product placements (cinema and theatres).
Advantages of above-the-line marketing:
- Tailored to reach a massive audience
- Great for creating awareness
- Long-term brand building
2. BTL (Below-the-Line) marketing: Below-the-line advertising consists of very specific, memorable and direct advertising activities focused on targeted groups of consumers. Often known as direct marketing strategies, below-the-line strategies focus more on conversions than on building the brand.
Examples of BTL activities include sales promotions, discounts, social media marketing, direct mail marketing campaigns, in-store marketing, events and conferences.
Advantages of below-the-line marketing
- Specifically targeted towards individual customers
- Drives immediate impact
- Helps measure campaign effectiveness and conversions
3. TTL (Through-the-Line) marketing: Through-the-Line advertising involves the use of both ATL & BTL marketing strategies. The recent consumer trend in the market requires integration of both ATL & BTL strategies for better results.
Examples of TTL activities include 360° Marketing – campaigns developed with the vision of brand building as well as conversions and digital marketing (digital ads & videos).
Other variables
The long-term impact of several marketing initiatives can be grouped under:
1. Competition
Keeping a close eye on the competition is key to maintaining your brand’s edge.
Competition in the market can be either direct or indirect.
- Direct competitors: Direct competitors are businesses that have the same product offerings. E.g. Apple iPhone acting as Competition to Samsung Galaxy
- Indirect Competitors: Indirect competitors are those who don’t offer a similar product but meets the same need in an alternative way. E.g. Amazon Kindle and paperback books are indirect competition as they are substitutes
2. Halo and Cannibalization Impact
What is the halo effect?
Halo effect is a term for a consumer’s favouritism towards a product from a brand because of positive experiences they have had with other products from the same brand. Halo effect can be seen as a measure of a brand’s strength and brand loyalty. For example, consumers favour Apple iPad tablets based on the positive experience they had with Apple iPhones.
What is the cannibalization effect?
Cannibalization effect refers to the negative impact on a product from a brand because of the performance of other products from the same brand. This mostly occurs in cases when brands have multiple products in similar categories. For example, a consumer’s favouritism towards iPads can cannibalize MacBook sales.
In Marketing Mix Models, base variables or incremental variables of other products of the same brand are tested to understand the halo or cannibalizing impact on the business outcome of the product under consideration.
New variables emerging
With changing marketing environments, there are a number of new platforms emerging where brands are engaging actively with customers, especially millennial customers. This also leads to new marketing mix variables to be accounted for.
Some of these variables are
- Product/Market Trend: Market trend/product trend is key in driving the baseline outcome of the product and understanding the consumer demand for the product.
- Product Launches: Marketers invest carefully to position the new product into the market and plan marketing strategies to support the new launch.
- Events & Conferences: Brands need to look for opportunities to build relationships with prospective customers and promote their product through periodic events and conferences.
- Behavioural Metrics: Variables like touch points, online behaviour metrics and repurchase rate provide deeper insights into customers for businesses.
- Social Metrics: Brand reach or recognition on social platforms like Twitter, Facebook, YouTube, blogs and forums can be measured through indicative metrics like followers, page views, comments, views, subscriptions and other social media data. Other social media data like the types of conversations and trends happening in your industry can be gathered through social listening.
Marketing Mix Methodology
Data preparation can help you identify key measurable metrics to that can impact your marketing mix model.
Each of the variable categories included when developing a strong marketing mix strategy involves a set of metrics that are used to measure the performance of different marketing activities
CATEGORYVARIABLESMETRICSBASELINEBASE PRICEUndiscounted price of the product at which it is sold in the market
AVERAGE SALES PRICEDiscounted price at which the product is sold in the market
ASSORTMENT (SKU)Number of Stock Keeping Units of the product in a store/market to track the inventory of the product
VELOCITYRate at which product is moving when it is available in store (Units/Store)
DISTRIBUTIONDistribution of the product – No. of stores or No. of locations the product is availablePROMOTIONSSALES PROMOTIONNo of offers or No of days for which offers are running or the type of promotions like coupons, free shipping, price match guarantees, dollar-off etc.DISCOUNTSAVERAGE PRICE DISCOUNTAverage Price Discounts on the product at a particular time period
WEIGHTED DISCOUNTAverage Price Discounts on the products weighted based on their share to product salesSEASONALITY & HOLIDAYSEASONALITY & HOLIDAYDummy variables to capture the spike/dip in KPIs during holidays like Thanksgiving, Christmas, New Year, Back to School, Labour Day, President Day, Retailer Promotions days like Prime Day etc.MEDIA ACTIVITYTV SPENDSMarketing Spends for TV advertising
REACHTotal No of consumers exposed to the ad
FREQUENCYTotal No of times the customers are exposed to the ad
TV GRPProduct of reach and frequency
DIGITAL SPENDSMarketing spends for digital advertising
DIGITAL IMPRESSIONSNo of times the ads are exposed to customers
DIGITAL CLICKSNo of clicks on online ads
DIGITAL – OTHERSMany other variables act as a measure for digital ads like click-through-rate, rich media, video view rate, cost-per-clicks, video likes, video comments etc.
SEARCH SPENDSSpends for Search marketing
SEARCH IMPRESSIONSImpression counted when Search page for product loads
PRINT SPENDSMarketing spends for product in a medium like magazines, newspapers etc.
RADIO SPENDSMarketing spends for radio advertisingCOMPETITIONBASEBase metrics for competition like pricing, distribution, seasonality, events, launches etc.
MEDIA ACTIVITESCompetition media activities like spends, GRPs, impressions etc.
OFFERSCount of competition offers on different platforms
DISCOUNTSDiscounts offered by competition on their productsOTHERSSOCIAL MEDIAMetrics to capture the activities of the brand or product on social media like page views, followers, sentiment score, reviews, likes, comment, retweets etc.
EXTERNAL FACTORSExternal variable affecting KPIs like macroeconomic factors
TRENDThe trend of product category or product over time period
CYCLICITYMetrics to capture product cycles like Sine or Cosine functions
EVENTS & LAUNCHESIndicative variables for capturing significant product launches, special events, conferences etc.
In some cases, two specific instances can hamper marketers from developing a complete marketing mix model based on the above metrics:
- Missing values
- Outliers
Missing Value Treatment
What is a missing value?
One of the challenges in data analytics is missing values. A missing value is the non-availability of data for a particular observation or calculation in a variable. Usually, this happens because of errors during recording data or because of non-availability of data. Missing values may lead to biased variables, which in turn, may affect business outcomes.
Reasons for missing value
To resolve a missing value, we first need to understand why it occurred in the first place. Some of the most common reasons for a missing value are:
- Data might not be available for the complete time period of analysis.
- Non-occurrence of events.
- People skipped response for some questions in surveys.
- Non-applicability of questions in a survey.
- Missing out in randomness.
Methods to treat missing values
- Imputation: Imputation is a method where missing data is filled in with estimated values. Mean, median and mode are frequent imputation methods used.
- Forecasting: Time series forecasting can be used to forecast/reverse-forecast the range of records that are not available. Apart from forecasting, we can use 4 weeks Moving Average to estimate missing values.
- Replace with Zero: When data is available only if the transactions or a promotional event happened in a day, we should simply replace missing data with zeros to denote that there was no transaction or promotion for that day.
- Deletion: A survey is the best example of an instance where deletion can fix missing values. In a survey, we cannot guess people’s choice and so it would be wise to delete rows with missing data.
- Other: There are other sophisticated techniques for missing value treatment like prediction and KNN Imputation that can also be used if required.
Outliers
One of the key objectives of MMM is to try and explain the spikes, otherwise known as outliers. Outliers may or may not occur at random.
The reason for an outlier could be seasonality, a new product launch, campaign, promotion, discounts, competitor actions, etc. It could also be due to randomness. By differentiating outliers due to randomness from those caused by specific factors, you can include the right variables in the model and test them out to check if they explain outliers.
Example: Sales of electronics are much higher during product launches and holiday season like Christmas & Thanksgiving.
Types of Analysis in Marketing Mix Modeling
Through exploratory analysis, marketers can develop an understanding of the results of their marketing initiatives.
The statistical analysis involved in understanding the outcomes of various marketing activities can be broadly grouped into two different types:
- Univariate analysis
- Bivariate analysis
Univariate analysis
Univariate analysis is a form of quantitative evaluation where the data being analysed contains only one variable. Univariate analysis is primarily used to describe the data gained from marketing mix variables and find patterns that exist within them.
Patterns found in univariate analysis of a variable can be explained using:
- Central tendency (mean, median & mode)
- Dispersion (range & variance)
- Maximum & minimum
- Quartiles
- Standard deviation
Univariate analysis is used to
Analyse the patterns in the data: E.g., Higher discounts are provided only during holiday periods
Identify the possibility of creating new variables: E.g., If there is a clear difference in discounts offered during the holiday periods and non-holiday periods, two separate discount variables could be created – holiday discounts and non-holiday discounts to test their impact
Identification of any outliers in the data – Univariate data can be visualized using
- Frequency distribution tables
- Bar charts
- Histograms
- Pie charts
- Line charts
Bivariate analysis
Bivariate analysis is the analysis to understand the relationship between two different variables among marketing mix elements.
In MMM, Bivariate analysis helps us to
- Identify the key variables that exhibit a good relationship with the dependent variable
- Identify the type of relationship that the variable exhibits with the dependent variable
Types of bivariate analysis:
- Numerical and numerical variables: Relationship between two numerical variables could be visualized using scatter plots and line charts.
- Numerical and categorical variables: Relationship between numerical and categorical variables could be visualized using line charts or combination charts.
- Categorical and categorical variables: Relationship between categorical and categorical variables can be visualized using stacked column chart and combination chart.
Data Transformation
Make the most accurate forecasts and efficient marketing mix models through data transformation.
Data transformation is the replacement of a variable by a function of that variable. For example, you can replace a variable X by the square root or logarithm of X.
The transformation, in essence, represents the response curve. Certain variables don’t have a linear relationship with sales. For example, TV GRPs usually have a nonlinear relationship with sales. Increase in TV GRP would increase the sales only to a certain extent, post which the growth would be saturated.
Bivariate analysis is the analysis to understand the relationship between two different variables among marketing mix elements.
There are generally two practical applications of data transformation:
- Adstock effect
- Lag effect
What is adstock effect?
Advertising adstock is a term used for measuring the memory effect carried over from the time of first starting advertisements. Marketers can use the advertising adstock as a variable in sales response modeling, such as regression analysis. It represents the half-life of advertisements.
What is lag effect?
A lag effect is used to represent the effect of a previous value of a lagged variable when there is some inherent ordering of the observations of this variable. This effect is useful in a study in which different subjects are given sequences of treatments and you want to investigate whether the treatment in the previous period is important to understand the outcome in the current period.
Understanding the adstock effect and lag effect are helpful in developing a marketing mix model to measure the impact of spending on advertisements. For instance, ads aired on TV might be remembered for longer than those on digital modes.
Significance of S-Curve transformations:
In reality, most of the advertising activities will have non-linear impact on the KPI’s and they exhibit a pattern of diminishing returns. Research has shown that initial advertising spends will have little impact until a certain threshold after which there will be a noticeable impact on the KPI’s can be observed. This impact tends to diminish as the spends reach a point of saturation post which there will be minimal impact. This entire impact can be captured in form of s-curve transformations. Gompertz, Chapman Richards and Weibull and Morgan-Mercer-Flodin transformations are typically better from a marketing mix perspective.
Marketing Mix Modeling Techniques
Wondering how you can build the most effective marketing mix model? These techniques can help you get started!
While the importance of a marketing mix is clear, most marketers are still unsure of how to build a marketing mix model. A technique known as ‘regression’ can predict the most efficient mix of all marketing variables. In regression, data is broken down into two categories: dependent variables (DV) and independent variables (IDV). The analysis of how independent variables can impact the outcome of dependent variables is the crux of regression. By doing this, marketers will be able to provide an accurate estimate of the marketing mix on the company’s net profits.
The most common marketing mix modeling regression techniques used are:
- Linear regression
- Multiplicative regression
1. Linear regression model
Linear regression can be applied when the DV is continuous and the relationship between the DV and IDVs is assumed to be linear.
The relationship can be defined using the equation:
Here ‘y’ is the dependent variable to be estimated, X are the independent variables and ε is the error term. βi’s are the regression coefficients. The difference between the observed outcome Y and the predicted outcome y is known as a prediction error. Regression analysis is mainly used for:
- Causal analysis
- Forecasting the impact of a change
- Forecasting trends
However, this method does not perform well on large amounts of data as it is sensitive to outliers, multicollinearity and cross-correlation.
2. Multiplicative regression models
Additive models imply a constant absolute effect of each additional unit of explanatory variables. They are suitable only if businesses occur in more stable environments and are not affected by interaction among explanatory variables. But in scenarios such as when pricing is zero, the sales (DV) will become infinite.
To overcome the limitations inherent in linear models, multiplicative models are often preferred. These models offer a more realistic representation of reality than additive linear models do. In these models, IDVs are multiplied together instead of added.
There are two kinds of multiplicative models:
- Semi-logarithmic models
- Logarithmic models
Semi-logarithmic models
In Log-Linear models, the exponents of independent variables are multiplied.
Salest = exp(Intercept) * exp(β1*Pricingt) * exp(β2*Distributiont) * exp(β3*Mediat) * exp(β4*Discountst) * exp(β5*Seasonalityt) * exp(β6*Promotionst) *…
This can also be rewritten as
Salest = exp (Intercept + β1*Pricingt+ β2*Distributiont+ β3*Mediat+ β4*Discountst+ β5*Seasonalityt+ β6*Promotionst+ …)
Logarithmic transformation of the target variable linearizes the model form, which in turn can be estimated as an additive model. The dependent variable is logarithmic transformed; the only difference between additive model and semi-logarithmic model.
Ln (Salest) = Intercept + β1*Pricingt+ β2*Distributiont+ β3*Mediat+ β4*Discountst+ β5*Seasonalityt+ β6*Promotionst+ …
Some of the benefits of Log-Linear models are:
- The coefficients β can be interpreted as % change in business outcome (sales) to unit change in the independent variables.
- Each independent variable in the model works on top of what has been already achieved by other drivers. Hence, they are closer to real-time scenarios. A
Logarithmic Models
In Log-Log models, independent variables are also subjected to logarithmic transformation in addition to the target variable.
Salest = exp(Intercept) * β1*Pricingt * β2*Distributiont * exp(β3*Mediat) * exp(β4*Discountst) * exp(β5*Seasonalityt) * exp(β6*Promotionst) *…
Rewriting the model in linear form,
Ln (Salest) = Intercept + β1*Ln (Pricingt)+ β2*Ln (Distributiont)+ β3*Mediat+ β4*Discountst+ β5*Seasonalityt+ β6*Promotionst+ …
The main difference between Log-Linear and Log-Log models lies in the interpretation of response coefficients. In Log-Log models, the coefficients are interpreted as % change in business outcome (sales) in response to 1% change in independent variable
β = %ΔDependent_Variable / %ΔExplanatory_Variable
This implies constant elasticity of the target variable to explanatory variables. In Log-Linear models, elasticity cannot be directly estimated but can be calculated from the coefficient as β · X for every time period. It increases in absolute value with the explanatory variable.
Model Improvement techniques
Errors can impact the accuracy of your marketing mix model. Find out how these techniques can help you minimize errors in your model.
Invariably, errors often arise in marketing mix model predictions and actual outcomes. In many cases, a model might perform well on training data, but poorly on validation (test) data. To resolve this, marketers need to ensure there is a bias-variance trade-off.
What is a bias?
Bias is the difference between the average predictions of our model and the actual value we are trying to predict. Models with a high bias can lead to errors in training and test data.
What is variance?
Variance is an error which arises from sensitivity to small changes in the training set. Models with this error perform very well or training data, but have high error on test data.
Bias-variance trade-off
In a model, there are two common pitfalls that can occur. The model can have either underfitting (where the model is unable to capture underlying parameters) or have overfitting (where the model captures the noise along with the parameters). An underfitted model can have a high bias and low variance. On the other hand, an overfitted model can have low bias and high variance. Therefore, marketers need to strike a balance between the two with a bias-variance trade-off to develop an accurate model.
Regularization of data
To achieve this balance, regularization is an important tool. Through regularization, you can add a penalty term to the objective function and control the model complexity completely using that penalty term.
There are two main marketing mix modeling regression techniques for regularization are:
- Lasso regression
- Ridge regression
- Elastic-net regression
Lasso regression
In lasso regression, we can minimise the objective function by adding a penalty term (sum of the absolute values of coefficients). This is also known as the least absolute deviations method. By penalizing the absolute values, the estimated coefficients shrink to zero such that overfitting is avoided and the learning is faster.
Ridge regression
In ridge regression, we try to minimize the objective function by adding a penalty term (sum of the squares of coefficients). When there is a multicollinearity problem among the predictor variables, the coefficient of one variable depends on other predictor variables included in the mode. By adding the penalty term, coefficients of collinear variables will shrink, except for the significant predictor among them.
Elastic-net regression
Elastic-net regression is a hybrid of ridge and lasso, combining the penalties of the two. This is usually the preferred method as it combines the best of both models.
Model Selection
Find out what goes into choosing the most appropriate model for your business.
Selection of the most appropriate marketing mix model is crucial for marketers to be able to make accurate predictions and estimations.
There are two main considerations to take into account when selecting a model:
Business logic
Market Mix Models have to be reflective of the actual market scenario. The model should be adaptive to changes in market over time.
For example, price of a smartphone could be elastic and so sales of this smartphone could be heavily dependent on pricing. If there is a significant increase in price, it might impact the sales of smartphone negatively. In such cases, product price can be used as a variable in the model to capture this trend.
From our extensive experience in developing marketing mix models, these are the key features that need to be implemented:
- Media advertisements for the product should have positive coefficients in the model.
- Halo or cannibalization can occur due to promotions for other products from the brand.
- Halo impact from other products should be lower than the impact of marketing activities on the product.
- Ad stock value for TVCs should be greater than for digital ads since TVCs have higher brand recall.
- Discounts and promotions will have an immediate impact on sales
- A product can be promoted by the brand who created the product as well as partners who sell that product.
Statistical significance
Once the model has been generated, it should be checked for validity and prediction quality. Based on the nature of the problem, various model stats are used for evaluation purposes.
The following are the most common statistical measures in marketing mix modeling.
1. R-squared
R-squared is a statistical measure of how close the data are to the fitted regression line. It is also known as the coefficient of determination.
R-squared is always between 0 and 100%:
0% indicates that the model explains none of the variability of the response data around its mean.
100% indicates that the model explains all the variability of the response data around its mean.
General formula for R-squared is
Where SSE = Sum of squared errors and
SST = Total sum of squares
2. Adjusted R Squared:
The adjusted R-squared is a refined version of R-squared that has been penalised for the number of predictors in the model. It increases only if the new predictor improves the model. The adjusted R-squared can be used to compare the explanatory power of regression models that contain different numbers of predictors.
3. Coefficient:
Regression coefficients are estimates of the unknown population parameters and describe the relationship between a predictor variable and the response. In linear regression, coefficients are the values that multiply the predictor values.
The sign of each coefficient indicates the direction of the relationship between a predictor variable and the response variable.
A positive sign indicates that as the predictor variable increases, the response variable also increases.
A negative sign indicates that as the predictor variable increases, the response variable decreases.
4. Variable Inflation Factor
A variance inflation factor (VIF) detects multicollinearity in regression analysis. Multicollinearity is when there’s a correlation between predictors (i.e. independent variables) in a model. The VIF estimates how much the variance of a regression coefficient is inflated due to multicollinearity in the model. Every variable in the model would be regressed against all the other available variables to calculate the VIF. VIF is usually calculated as
Where Ri2 is R-squared value obtained by regressing “i”, the predictor variable against all other variables.
5. Mean Absolute Error (MAE)
MAE measures the average magnitude of the errors in a set of predictions. It’s the average over the absolute differences between prediction and actual observation where all individual differences have equal weight
Where yt is the actual value at time ‘t’ and
ŷt is the predicted value at time ‘t’
6. Mean Absolute Percentage Error (MAPE)
MAPE is the average absolute percent error for each observation or predicted values minus actuals divided by actuals:
Where yt is the actual value at time ‘t’ and
ŷt is the predicted value at time ‘t’
Quantification of Driver impact
Is your marketing mix model performing the way you intended it to? These techniques can help you calculate the success of your marketing mix model.
Once the model has been applied, marketers need to analyse the available data to judge the performance of the model.
There are two broad methods of analysis:
1. Contribution calculation
Business metrics are decomposed into base contributions and contributions due to seasonality and other factors. The marketing mix model helps identify key drivers of sales. Calculating contributions will depend on the type of model used:
Linear model
Assuming data is at weekly granularity,
- From the MMM, we would get the regression equation (Business metric = Base + ®1* Driver1 + ®2*Driver2…)
where ® is corresponding coefficient for each driver - Predicted values are calculated at a weekly level (Predicted value = Base + ®1* Driver1 + ®2*Driver2…)
- Multiply coefficient (®) with corresponding driver values at a weekly level to calculate driver contributions = ®1* Driver1, ®2*Driver2…
Log-linear model
Assuming data is at weekly granularity,
- From the MMM, we would get the regression equation Ln (Business metric) = Base + ®1* Driver1 + ®2*Driver2…where ® is the corresponding coefficient for each driver
- Predicted values are calculated at a weekly level (Predicted value = Base + ®1* Driver1 + ®2*Driver2…)
- Multiply coefficient (®) with corresponding driver values at a weekly level to calculate driver contributions = ®1* Driver1, ®2*Driver2…
2. Due-to analysis
Due-to analysis explains the change in the contribution of each driver towards the business metric for different periods. With the help of due-to analysis, you can explain Year-On-Year (YOY) or Quarter on Quarter (QOQ) change in growth as a contribution to business metric from the drivers.
Budget optimization
These factors are important in optimizing the budget for a marketing mix model.
Optimization is the process of arriving at most desirable solution from the list of all feasible solutions.
Optimization problems can be classified into different categories based on the type of constraints, nature of variables, nature of equations involved, permissible value of variables, number of objective functions etc.
There are multiple steps involved in designing a marketing mix optimization problem.
1. Constructing a model
This step involves specifying the model objective, model variables and model constraints for the problem.
- Objective: This is a measure of the performance of the model that is to be minimized or maximized. For example, in the case of MMM, the objective function is generally to maximize KPI (Sales).
- Variables: Variables are the components of the model that are to be optimized. For example, marketing drivers like TV Spends, Online Spends etc. are variables of the model.
- Constraints: These are the functions that describe the relationships among the variables and that define the allowable values for the variables. For example, Total Spends for FY17 to be less than $100M.
2. Identifying algorithms for optimization
Once the model is constructed, suitable algorithms are chosen for optimization based on the nature of the optimization problem. There are numerous solvers available for optimization problems. Some of them (based on problem type) are:
- Non-Linear Constrained Optimization: IPOPT, GRG Non-Linear, ANTIGONE, CONOPT, KNITRO, SNOPT etc.
- Linear Optimization: BDMLP, Clp, Gurobi, OOQP, CPLEX etc.
- Global Optimization: ASA, BARON, icos, PGAPack, scip etc.
3. Optimization solution
Results from optimization can be either global or local. This depends on the type of solving algorithms used. Hence for the same objective, different solvers return different types of solutions. The best possible solution is chosen based on the business context.
- Global Optimal: This is the solution in which the optimization engine tries with all possible values of variables and ends up with one best solution for the objective.
- Local Optimal: This is the solution in which the optimization engine has huge options for variables and upon solving, ends up with sub-optimal solution within a neighbouring set of solutions.
Read our blog on Data Analytics for CMOs : Using Digital Data for Consumer Insights
Scope for optimization
Marketing optimization is the process of improving marketing efforts to maximize desired business outcomes. Since the nature of MMM are mostly non-linear, non-linear constrained algorithms are used for optimization. Some of the use cases for marketing mix optimization are:
- To improve current sales level by x%, what is the level of spends required in different marketing channels? E.g. To increase sales by 10%, how much to invest in TV ads or discounts or sales promotions?
- What happens to the outcome metric (sales, revenue, etc.), if the current level of spends is increased by x%? E.g. On spending additional $20M on TV, how much more sales can be obtained? Where are these additional spends to be distributed?
These use cases answer the key areas for strategic planning like
- Impact of Marketing levers
- Optimization across different marketing channels
- Optimization across time period
MMM – Optimization Case Study
We can understand the concept of marketing mix more effectively with a marketing mix modeling example. Consider a Product ABC from a leading retailer company. Marketing data for the product ABC is available for July to December 2017 (table below). With the available data, market mix models have been built with Sales as outcome (DV) variable and final marketing mix model equation is obtained.
Using weekly marketing data and market mix model equation, marketing optimization can be performed for various business cases.
Objective
What is the incremental lift in Sales (DV) when TV GRPs are increased by 20% from current level of 880 GRPs and discounts are increased by 10% from current level of 9.37%?
Procedure
The objective is to maximize the target variable (sales). Since TV GRPs and discounts are the variables to be optimized, constraints are applied to these variables.
- Weekly maximum for TV GRPs will be decided by the sigmoid curve (based on saturation point). Total TV GRPs is set at 10% from current levels
- Weekly maximum for discounts is set at value based on historic values. Average discounts is set at 20% from current levels
The following table lists the current levels and constraints levels for IDVs
Optimization InputsActual ValuesTarget ValuesVariableStart DateEnd DateMinimumMaximumValueMinimumMaximumValueTV GRP7/1/201612/30/2016012888002561052Discounts7/1/201612/30/20164.94%16.57%9.37%020%10.31%
These constraints are fed to the solvers and are optimized. Solvers provide optimized results for effective marketing plan
Result
The business recommendations, based on optimization results are as follows :
- On increasing TV GRPs by 20% and Discounts by 10%, Sales increase of 21.90% is achieved upon effective distribution.
- More TV GRPs are spent during holiday period (Nov-Dec) for effective sales
- High levels of discounts are maintained during holiday period with no discounts in other period
The data summary for target variable and optimized variables are as follows
Conclusion
Marketing mix modeling techniques can minimize much of the risk associated with new product launches or expansions. Developing a comprehensive marketing mix model can be the key to sustainable long-term growth for a company. It will become a key driver for business strategy and can improve the profitability of a company’s marketing initiatives. While some companies develop models through their in-house marketing and analytics departments, many choose to collaborate with an external company to develop the most efficient model for their business.
Developers of marketing mix models need to have a complete understanding of the marketing environment they operate within and of the latest advanced market research techniques. Only through this will they be able to fully comprehend the complexities of the numerous marketing variables that need to be accounted for and calculated in a marketing mix model. While numerical and statistical expertise is undoubtedly crucial, an insightful understanding of market research and market environments is just as important to develop a holistic and accurate marketing mix model. With these techniques, you can get started on developing a watertight marketing mix model that can maximise performance and sales of a new product.
