Clickstream Analytics: The Catalyst for Revenue Maximization in Retail
“The customer is the king” is a famous adage among businesses, as they need
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.
An accurate marketing mix model can be the difference between the success or failure of a product!
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).
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:
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.
Through MMM, markets can suggest optimal spend levels in highly effective marketing channels to avoid saturation.
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.
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.
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:
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:
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.
Read our blog and infographic on Holiday Shopping Analytics to understand the impact of seasonality on sales.
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.
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:
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
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).
The long-term impact of several marketing initiatives can be grouped under:
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.
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.
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.
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
Read our blog on Social Media Analytics and Monitoring to understand how new channels are impacting marketing for businesses.
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
|BASELINE||BASE PRICE||Undiscounted price of the product at which it is sold in the market|
|AVERAGE SALES PRICE||Discounted 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|
|VELOCITY||Rate at which product is moving when it is available in store (Units/Store)|
|DISTRIBUTION||Distribution of the product – No. of stores or No. of locations the product is available|
|PROMOTIONS||SALES PROMOTION||No 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.|
|DISCOUNTS||AVERAGE PRICE DISCOUNT||Average Price Discounts on the product at a particular time period|
|WEIGHTED DISCOUNT||Average Price Discounts on the products weighted based on their share to product sales|
|SEASONALITY & HOLIDAY||SEASONALITY & HOLIDAY||Dummy 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 ACTIVITY||TV SPENDS||Marketing Spends for TV advertising|
|REACH||Total No of consumers exposed to the ad|
|FREQUENCY||Total No of times the customers are exposed to the ad|
|TV GRP||Product of reach and frequency|
|DIGITAL SPENDS||Marketing spends for digital advertising|
|DIGITAL IMPRESSIONS||No of times the ads are exposed to customers|
|DIGITAL CLICKS||No of clicks on online ads|
|DIGITAL – OTHERS||Many 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 SPENDS||Spends for Search marketing|
|SEARCH IMPRESSIONS||Impression counted when Search page for product loads|
|PRINT SPENDS||Marketing spends for product in a medium like magazines, newspapers etc.|
|RADIO SPENDS||Marketing spends for radio advertising|
|COMPETITION||BASE||Base metrics for competition like pricing, distribution, seasonality, events, launches etc.|
|MEDIA ACTIVITES||Competition media activities like spends, GRPs, impressions etc.|
|OFFERS||Count of competition offers on different platforms|
|DISCOUNTS||Discounts offered by competition on their products|
|OTHERS||SOCIAL MEDIA||Metrics to capture the activities of the brand or product on social media like page views, followers, sentiment score, reviews, likes, comment, retweets etc.|
|EXTERNAL FACTORS||External variable affecting KPIs like macroeconomic factors|
|TREND||The trend of product category or product over time period|
|CYCLICITY||Metrics to capture product cycles like Sine or Cosine functions|
|EVENTS & LAUNCHES||Indicative variables for capturing significant product launches, special events, conferences etc.|
To learn more about the importance of data in marketing mix modeling, read our blog on Data-Driven Approach in Account-Based Marketing Campaigns.
In some cases, two specific instances can hamper marketers from developing a complete marketing mix model based on the above metrics:
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.
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:
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.
Read our blog on Marketing Mix Modeling: Challenges and Best Practices to learn more about how other common issues faced by marketers when developing a model can be resolved.
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 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:
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
Bivariate analysis is the analysis to understand the relationship between two different variables among marketing mix elements.
In MMM, Bivariate analysis helps us to
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:
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.
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.
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.
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 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:
However, this method does not perform well on large amounts of data as it is sensitive to outliers, multicollinearity and cross-correlation.
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:
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:
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.
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.
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.
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.
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.
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:
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.
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 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.
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:
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:
You can also read our blog on Using Analytics to Cater to the Multi-Touchpoint Customer to help you build the most effective marketing mix model.
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.
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
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.
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.
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.
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’
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’
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:
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:
Assuming data is at weekly granularity,
Assuming data is at weekly granularity,
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.
Read our blog on How to Measure Campaign Effectiveness Without a Control Group to understand how you can successfully attribute and measure campaign success.
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.
This step involves specifying the model objective, model variables and model constraints for the problem.
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:
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.
Read our blog on Data Analytics for CMOs : Using Digital Data for Consumer Insights
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:
You can also read our blog on How Conversion Rate Optimization Can Make or Break Your Sales to learn more about the importance of optimization in marketing mix modeling techniques.
These use cases answer the key areas for strategic planning like
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.
|Week||Sales||Pricing||Distribution||Competition Discounts||Competition Online Impressions||TV GRP||Online Impressions||Promotions||Discounts|
|07/01/2017||30,503||$1,067||48||1.12%||105.68 M||0||22.82 M||27||6.93%|
|07/08/2017||27,037||$1,068||47||4.33%||0.00 M||0||0.00 M||5||8.55%|
|07/15/2017||30,646||$1,038||42||1.89%||0.00 M||0||0.00 M||6||9.64%|
|07/22/2017||40,887||$954||35||1.10%||0.00 M||0||0.00 M||6||13.75%|
|07/29/2017||48,947||$912||31||4.56%||0.00 M||0||0.00 M||10||16.57%|
|08/05/2017||37,910||$1,010||38||3.64%||66.62 M||100||127.65 M||12||11.15%|
|08/12/2017||40,436||$1,007||37||1.66%||124.18 M||93||125.34 M||8||11.42%|
|08/19/2017||49,343||$994||33||2.50%||96.87 M||95||150.62 M||10||12.90%|
|08/26/2017||32,371||$1,078||39||5.08%||109.01 M||90||206.28 M||11||7.24%|
|09/02/2017||28,665||$1,060||40||1.10%||115.16 M||12||595.09 M||2||7.20%|
|09/09/2017||29,079||$1,061||42||0.00%||157.02 M||17||284.73 M||13||6.35%|
|09/16/2017||22,794||$1,098||41||0.15%||145.53 M||11||46.09 M||7||5.74%|
|09/23/2017||26,607||$1,048||36||0.02%||105.84 M||0||13.62 M||10||8.91%|
|09/30/2017||21,153||$1,100||39||0.00%||118.05 M||0||36.95 M||11||5.99%|
|10/07/2017||20,704||$1,092||42||0.00%||62.06 M||0||16.33 M||10||6.49%|
|10/14/2017||19,364||$1,082||44||2.10%||73.75 M||0||13.50 M||11||4.94%|
|10/21/2017||25,881||$1,050||53||3.13%||115.28 M||0||4.19 M||17||6.51%|
|10/28/2017||25,903||$1,018||46||2.30%||78.39 M||0||5.77 M||11||8.96%|
|11/04/2017||42,168||$996||54||1.08%||78.04 M||0||8.84 M||37||10.43%|
|11/11/2017||36,524||$1,002||57||7.11%||90.22 M||0||11.58 M||18||10.29%|
|11/18/2017||35,647||$1,014||55||7.44%||145.45 M||0||20.57 M||21||9.39%|
|11/25/2017||98,776||$948||41||16.57%||180.83 M||128||167.81 M||10||13.89%|
|12/02/2017||110,717||$935||52||5.62%||165.39 M||115||215.72 M||29||13.26%|
|12/09/2017||43,575||$1,039||56||0.00%||155.02 M||106||255.36 M||17||8.71%|
|12/16/2017||55,115||$1,000||52||5.19%||176.43 M||94||373.02 M||30||9.61%|
|12/23/2017||82,843||$961||40||4.87%||164.09 M||16||424.45 M||40||11.40%|
|12/30/2017||38,610||$1,072||53||2.07%||143.84 M||0||173.51 M||30||6.75%|
Using weekly marketing data and market mix model equation, marketing optimization can be performed for various business cases.
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%?
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.
The following table lists the current levels and constraints levels for IDVs
|Optimization Inputs||Actual Values||Target Values|
|Variable||Start Date||End Date||Minimum||Maximum||Value||Minimum||Maximum||Value|
These constraints are fed to the solvers and are optimized. Solvers provide optimized results for effective marketing plan
The business recommendations, based on optimization results are as follows :
The data summary for target variable and optimized variables are as follows
The weekly distribution of target variable and optimized variables are shown in the below charts
You can read our blog on How Forecasting Is Changing Businesses Across Industries to learn more about the importance of developing a strong marketing mix model.
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.
A marketing mix model is the analysis of all the marketing activities considering the various metrics of product growth. It basically measures the success or failure of a product. The four important elements of marketing mix models are Product which can be a product or a service, Price that the customer pays, Promotion which are the marketing strategies that the firm undertakes and the Place where the product distribution takes place. Moreover, marketing models assess various marketing activities to check if these strategies have helped in increasing ROI.
Marketing mix is the process of analysing marketing initiatives and their corresponding outcomes. For example, consider a Product A which could be a product or a service that satisfies the customers’ needs. Next, look into the Price which is the amount that the customers would be paying for the particular product. Collect the marketing details for the product over a period of time, like the advertisements and forums which come under the category of Promotions. Also consider the Place where the product would be sold and how it is delivered to a particular place is important for building a model. Now, using the direct sales and few other factors, a marketing mix model is built.
Marketing mix optimization is the process of selecting a feasible solution after considering many possible solutions. The problems are categorized into different sections like nature of variables, equations involved, number of functions and many more. Analysing various factors classified into categories helps in finalising the solution after proper consideration.
Marketing mix modeling analyses the product performance of a company. For this, there are a set of metrics allocated to evaluate the performance by drafting a model. The metrics could be the base price of the product, sales price, discount, average sales and many more. These set factors are together analysed and the model differentiates between marketing activities and other base factors to check the efficient functioning of the product in the product.
Marketing mix model is the process of checking the performance of a product. There are a few metrics like sales price, discount, average sales, etc. These values are assigned for coming up with an equation for the model. With the model data, marketing plans are reviewed and necessary changes are made if needed.
Marketing mix models require the consideration of many factors like direct sales, Average sales, product promotion and discount to optimize the data. The data is collected for a particular period of time say, weekly or monthly. With the optimized marketing data, companies analyze their marketing strategies and refine their plans accordingly.
To build a marketing model, firstly, decide the objective of the model. The objective can be anything like increasing the sales. Next, fix the model variables like product spends, sales price, etc. These variables should be optimised. Later, finalise the model constraints that define the relationship of these variables. Then, identify the algorithms for optimization depending on the type of problem.
There are a few limitations for the marketing mix model like obtaining accurate data is difficult and there is no particular standard to create the model. Moreover, this method is highly time consuming and also costly.
Marketing mix modeling is the statistical analysis of the performance of a product depending on the product’s marketing strategies whereas, attribution is a subset of the marketing mix model that analyzes the digital marketing channels.