Foundations of Marketing Analytics専門講座

With marketers are poised to be the largest users of data within the organization, there is a need to make sense of the variety of consumer data that the organization collects. Surveys, transaction histories and billing records can all provide insight into consumers’ future behavior, provided that they are interpreted correctly. In Introduction to Marketing Analytics, we introduce the tools that learners will need to convert raw data into marketing insights. The included exercises are conducted using Microsoft Excel, ensuring that learners will have the tools they need to extract information from the data available to them. The course provides learners with exposure to essential tools including exploratory data analysis, as well as regression methods that can be used to investigate the impact of marketing activity on aggregate data (e.g., sales) and on individual-level choice data (e.g., brand choices).

To successfully complete the assignments in this course, you will require Microsoft Excel. If you do not have Excel, you can download a free 30-day trial here: https://products.office.com/en-us/try

Marketers must make the best decisions based on the information presented to them. Rarely will they have all the information necessary to predict what consumers will do with complete certainty. By incorporating uncertainty into the decisions that they make, they can anticipate a wide range of possible outcomes and recognize the extent of uncertainty on the decisions that they make. In Incorporating Uncertainty into Marketing Decisions, learners will become familiar with different methods to recognize sources of uncertainty that may affect the marketing decisions they ultimately make. We eschew specialized software and provide learners with the foundational knowledge they need to develop sophisticated marketing models in a basic spreadsheet environment. Topics include the development and application of Monte Carlo simulations, and the use of probability distributions to characterize uncertainty.

How will customers act in the future? What will demand for our products and services be? How much inventory should we order for the next season? Beyond simply forecasting what customers will do, marketers need to understand how their actions can shape future behavior. In Developing Forecasting Tools with Excel, learners will develop an understanding of the basic components of a forecasting model, how to build their own forecasting models, and how to evaluate the performance of forecasting models. All of this is done using Microsoft Excel, ensuring that learners can take their skills and apply them to their own business problems.

How do consumers see your brand relative to your competitors? How should a new product be positioned when it’s launched? Which customer segments are most interested in our current offerings? For these questions and many others, surveys remain the tried and true method for gaining marketing insights. From one-off customer satisfaction surveys to brand tracking surveys that are administered on a continuous basis, they provide the information that marketers need to understand how their products, services and brands are seen by consumers. In Analytic Methods for Survey Data, learners will become familiar with established statistical methods for converting survey responses to insights that can support marketing decisions. Techniques discussed include factor analytics, cluster analysis, discriminant analysis and multi-dimensional scaling. These techniques are presented within the STP (Segmentation, Positioning, Targeting) Framework, enabling learners to apply the analytic techniques to develop a marketing strategy. It is recommended that you complete the Meaningful Marketing Insights course offered by Coursera before taking this course.

Note: This course would require using XL Stat, an Excel Add-on that students would need to purchase. XL Stat offers a 30-day free trial, so students could complete this course without incurring additional expense.