How to
1 like400 views
This document introduces marketing mix modeling (MMM) as a way to quantify the sales impact of marketing activities and optimize future marketing spend. It discusses how to build an MMM through data collection, model building, forecast optimization, and recommendations. An MMM goes beyond simple attribution by using past marketing spend and sales data to determine how to allocate future budgets across channels. The document provides details on the typical MMM framework and process.
How to
- 1. How to Build a Marketing Mix Model How to Quantify and Optimize Your Future Marketing Spend WHITE PAPER BY WILLIAM CAO, CHIEF ANALYTICS OFFICER
- 2. How to Build a Marketing Mix Model 2Page Introduction CMOs often struggle to quantify their marketing activity, yet increasingly, their CEOs expect it. Although it is relatively easy to quantify activity within individual channels, such as direct mail or television advertising, it is more difficult to attribute the impact of marketing activity across different channels. In this white paper, well introduce the concept of marketing mix modeling (MMM) for future attribution and show you how to structure one for your own marketing organization. Whats a Marketing Mix Model? Amarketing mix model quantifies the sales impact of your marketing activities. Its more than an attribution model; based on your past marketing spend and sales, a marketing mix model can help you optimize your future spend and maximize your return on investment (ROI). Is a Marketing Mix Model a Type of Attribution Model? No, an attribution model looks backwards, analyzing the data you already have. A marketing mix model attempts to tell you how to allocate your future spend and therein lies its power. BAU TV Online Display Online Search Radio Billboard Mobile Direct Mail Email
- 3. How to Build a Marketing Mix Model 3Page How to Create a Marketing Mix Model You would typically begin with data collection, followed by model building, forecast optimization and recommendations for implementation. The following chart shows the typical process. MMM Framework: INPUT DATA We collect input data by media type. Its typically the targeted rating points (TRP) over time vs. actual dollars. Below are the graphic representations of the model for each media type. Different media have different influences. Identify data sources Collect historical data to build a database Explore the collected data Build the MMM using collected data to identify the drivers Calculate optimal marketing spend allocation for markets and channels based on different scenarios Make recommendations based on these models and estimates Data Collection Model Building Forecast Optimization Recommendation Implementation TV RADIO DM DISPLAY
- 4. How to Build a Marketing Mix Model 4Page MODEL We build the actual model by selecting the appropriate model type based on the data and estimating the parameters in that model. Y = a + f(TV , TV , Radio , Radio , DM , Display , Display ) + t t-1 t-1 t t t t-1 t-1 t3 OPTIMIZATION Usually the sales response to media spending is an S-shaped response curve. You dont realize the impact of the media spend until it reaches a minimum threshold. Once it reaches a higher threshold, the response flattens out, indicating a marginal return that would become negative with any incremental spending. TV Display Radio DM This model is known as a Nonlinear Regression Model. This graph shows the gaps and opportunities for optimizing marketing spend.
- 5. How to Build a Marketing Mix Model 5Page Breaking Down the Framework The model attempts to identify the correct functional form of the response curve using historical data to fit the identified functional form for estimating parameters. Once the model is built, the second step is optimization. This is a simulation exercise to identify the global maximum based on your marketing budget. It should answer questions such as the following: How much should I invest in each channel? How should I allocate my marketing dollars across regions? How much should I spend on marketing to achieve the desired revenue and profit? If I have additional marketing dollars to spend, where should I spend them? What would be the estimated impact across all media types and what would be the optimal spend? WHAT KIND OF IMPROVEMENT SHOULD YOU EXPECT? You should expect significant improvement. According to Doug Brooks, senior vice president, analytics and modeling services of Information Resources Inc., and author of Success and Failures in Marketing Mix Modeling, you should expect up to 40% improvement in your marketing ROI within 12 months. CHALLENGES First among the challenges is collecting the appropriate data to build the model. Other challenges include: Explaining or predicting 100% of sales activities Securing the right mix of resources to obtain buy-in Building an actionable model Do you have answers for all of these questions?
- 6. How to Build a Marketing Mix Model 6Page WHAT TYPE OF DATA SHOULD YOU COLLECT? Your marketing mix model can be successful only if you have accurate and specific data available with which to build it. In addition to media spend and sales, other categories of data must be collected to improve the models accuracy and performance. A typical list of data categories youll need: Market-level media measure (GRP/TRP in addition to spend) Your organizations marketing events and sponsorships New accounts/sales by product line Pricing data by product Economic data, to measure macroeconomic forces for each region or Your marketing mix model can be successful only if you have accurate and specific data available with which to build it. market Industry data, including competitors spending Brand equity data, including advertising awareness, brand affinity, etc.
- 7. How to Build a Marketing Mix Model 7Page 息2015 Catalyst. All rights reserved. Conclusion Marketing mix modeling is a powerful weapon to add to your analytics arsenal. Although it can be cumbersome to collect the initial data, the savings you can realize will make it well worth the effort. For more information or to begin a discussion about whether a marketing mix model is appropriate for your organization, contact William Cao at wcao@catalystinc.com or call 585.453.8300. Key Takeaways 1. Marketing mix modeling is based on your historical marketing data and performance. The model wont be accurate if you dont have accurate historical data. 2. The more granular your data, the more accurate your model. 3. The model will not justify your marketing spend today. But it will help you better understand your marketing ROI and help you optimize future marketing spend. Marketing mix modeling is a powerful weapon. ABOUT THE AUTHOR William currently provides data and analytic leadership to Catalyst clients. He has led analytics teams for Associated Bank, BMO Harris Bank and MI Bank as well as Sprint, HR Block and Dell. He holds an MBA from the University of Chicago Booth School of Business, an MS in statistics from Kansas State University and an MS in applied mathematics from Southeast University. He has also taught graduate level courses in business analytics at Marquette University. 800.836.7720 | www.catalystinc.com | Facebook | Twitter | LinkedIn