Books

Book: Marketing Analytics


Marketing Analytics Book Marketing Analytics: Strategic Models and Metrics gives marketing students and professionals a practical, structured, and comprehensive guide to marketing analytics. The book covers a variety of different strategic models and metrics to aid marketers in quantifying and monitoring their marketing efforts, as well as predicting their results. With the additional insight, marketers can make better decisions and maximize the effectiveness of their marketing budget.

The book includes almost 500 pages of text and nearly 400 figures, diagram, tables, and charts to illustrate the concepts. The book is also packed with current examples showing how marketing can indeed be measurable.

The book is ideal for analytics-related courses in upper-level undergraduate and lower-level graduate school programs. It is also recommended for business executives who are held accountable for results, and who want to show how their efforts relate to organizational outcomes.


The course content table below includes chapter content, case studies (with supporting files), web resources, and relevant videos. The table also includes several sample syllabii to accommodate courses of different length. Each course variation uses the same book, "Marketing Analytics: Strategic Models and Metrics."

Case Study Solutions are available by going to the Contact page and sending a note requesting them. You must be an educator, a professional not taking a marketing analytics course, or a student with permission from your professor to get the case study solutions.

General Disclaimer/ Limit of Liability: Although the author and publisher have made every effort to ensure that information in the book, and in content associated with the book, was correct at press time, the author and publisher do not assume and hereby disclaim any liability to any party for any loss or damages, including but not limited to special, incidental, consequential, or any other damages. The author and publisher make no representations or warranties with respect to the accuracy or completeness of the contents of the book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. This limit of liability and disclaimer of warranty extends to any goods or services associated with the work, or derivatives of the work, such as workbooks, videos, websites, seminars, webinars, and so forth. The advice and strategies contained in the book or related works may not be suitable for particular situations. The content in the book and related works should not be considered legal advice. Readers are advised to seek appropriate legal counsel or other professional assistance for their own situations. By using any content related with the book, you are hereby agreeing to the general disclaimer and limit of liability.

Marketing Analytics Master Content Table

Course Content Case Studies Web Resources Videos
Syllabus Sample syllabus for Marketing Analytics I; 8 week course;
Sample syllabus for Marketing II; 8 week course;
Sample syllabus for 16 week course;
Sample syllabus for short 5 week intro course
Chapter 1.
Introduction
(pdf); (ppt)
Case 1A.
Project Selection I
(pdf); (doc)
Case 1B.
Project Selection II
(pdf); (doc)
Career articles: "Data Analysts: The New Masters of the Universe"
"Hunt for Analytics Talent Hots Up";
Finding a Job in Analytics
Chapter 2.
Market Insight
(pdf);
Case 2.
Market Sizing: Luggage
(pdf)
Google Ninja: Search Tips;
IBISWorld Industry Reports;
Survey: Laundry habits;
Market attracting new entrants: EDM
Business Research Basics (9:59);
Steve Jobs on Market Understanding (18:11); PESTLE Analysis (3:18);
Porter 5 Forces Model: Animation
(3:18);
Porter 5 Forces Model: Discussion (13:12)
Chapter 3A.
Market Segmentation: Segmentation and Targeting
Segmentation (pdf); (ppt);
Targeting (pdf); (ppt);
Case 3A.
Targeting: Hair Care Market
(pdf); (doc);
Case 3R. Segmentation: Pet Market. Requires R.
(pdf); (doc);
Dataset:
(xls)
Article: Segmentation K-Means Equations;
Article: Behavioral Targeting;
Segments for Nokia/ Microsoft Lumia Cellphone
Malcolm Gladwell: Segmentation and Spaghetti Sauce (17:33);
Finding p-values in Excel (5:15);
Cross tabulation in Excel ;
Market Segmentation in Sports (5:00);
Segmentation at McDonald's (4:26);
Segmentation, Targeting, Positioning (6:00); Seth Godin: Tribes (17:26)
Chapter 3B.
Market Segmentation: Positioning
(pdf); (ppt)
Case 3B.
Perceptual Map: Smartphones Market
(pdf); (doc)
Article: Positioning in Social Media Positioning and Perceptual Mapping (9:08);
Chapter 4.
Competitive Analysis (pdf); (ppt)
Case 4.
Competitive Analysis: Casual Fashion Market
(pdf); (doc)
Tools: Alexa; Compete; Google Trends;
Go To Market: Leasing
Online Competitive Analysis (11:38);
Google Alerts (2:47);
Keyword Discovery (4:13);
Chapter 5A.
Business Strategy: Strategic Decision Models (pdf); (ppt)
Case 5A.
QSPM: Hotel Market
(pdf); (doc);
Dataset:
(xls)
Market Share (02:02);
Michael Porter on Strategy (01:47);
Analytical Hierarchy Process for Asset Allocation (8:01)
Chapter 5B.
Business Strategy: Strategic Metrics
(pdf); (ppt)
Case 5B.
Strategic Metrics: Footwear Market
(pdf); (doc);
Dataset:
(xls)
Business Week: Strategic Metrics
Business Week: Emerson Electric's Innovation Metrics
Monopoly: Strategy and Math

Business Strategy Metrics Dashboard (0:56)
Chapter 6.
Business Operations
(pdf); (ppt)
Case 6.
Forecasting: Real Estate Market
(pdf); (doc)
Datasets: Excel: Time & Causal (xls);
R: Time (xls);
R: Causal (xls)
Foursquare Social GPS Adoption Curve;

Bass equations (pdf);
Sample Table of Bass p and q Coefficients;
Bass Paper with many p and q Coefficients;
IBM battling Parkinson's with Big Data;
Big Data and Hedge Funds;
Predictive Analytics: High FICO score means high love commitment;
Predictive Analytics: Crushing the Zika Virus;
McKinsey: Analytics for HR;
Sample Data: Bay Area Bike Share
Backlash (4:31);
Forecasting Inflections (14:21);
Chapter 7.
Product and Service Analytics: Conjoint Analysis:
Conjoint Analysis (pdf); (ppt);
Decision Trees (pdf); (ppt);
Case 7A.
Conjoint Analysis: Espesso Machine Market
(pdf); (doc); (xls);
Conjoint in R: Datasets:
preferences (xls);
profile (xls);
levelnames (xls)
Case 7B. BCG Resource Allocation: Automotive Market
(pdf); (doc)
Article: Conjoint Analysis with Excel (pdf);
Article: Understanding Conjoint in 15 Minutes;
Article: Courtyard by Marriott;
Taguchi: Fractional Factorial Designs;
Taguchi Presentation; Taguchi Orthogonal Matrices;
Conjoint: Simulation Algorithms 1;
Conjoint: Simulation Algorithms 2;
Conjoint in 10 minutes (9:33);
Conjoint in Excel (7:54);
Decision Tree Tutorial (7:00);
BCG Matrix (07:26)
Chapter 8.
Price Analytics
(pdf); (ppt)
Case 8.
Pricing: Light Bulb Market
(pdf); (doc)
Online Optimal Pricing Tool;
Article: Kindle Price Elasticity
Pricing and Measurement; Pay Per Laugh (3:10);
Risks of Freemium Strategies (9:31);
Yield Management (5:08);
Price Segmentation (7:26);
Decoy Pricing (1:58)
Chapter 9.
Distribution Analytics (pdf); (ppt)
Case 9.
Distribution: Cosmetics Market
(pdf); (doc);
Dataset:
(xls)
Go to Market Joint Venture: Uber and China;
Subaru: Auto dealership analytics
Partnerships and Positioning (4:42);
Multi-channel distribution: M&Ms
Chapter 10.
Promotion Analytics Full Chapter (pdf); Full Chapter (ppt);
Allocation only(pdf); (ppt)
Case 10.
Promotion Allocation: Restaurant Market
(pdf); (doc);
Dataset:
(xls)
Guide to Google Analytics 4;
Become a Search Ninja!;
Facebook Ad ninja;
Google Analytics Interface (8:15);
Google AdWords (3:36);
How Search Works (3:15);
Allocating Marketing Budget: Auto Dealers (4:30);
Evan Williams, founder of Twitter (7:55);
Social Media Analytics (6:21)
Chapter 11.
Sales Analytics (pdf); (ppt)
Case 11.
Sales Analytics: Ecommerce Sales
(pdf); (doc);
Dataset:
(xls)
Forbes article: NoMoreRack.com Ecommerce Sales;
Sales Funnel;
Sears loyalty plan and Uber
Sales Operations Metrics Dashboard(0:44);
Use Cases for Sales Analytics (17:15)
Chapter 12.
Analytics in Action Full Chapter) (pdf); (ppt);
Pivot Tables Only (pdf); (ppt)
Case 12.
Pivot Table: Multi-Channel Sales
(pdf); (doc);
Dataset:
(xls)
Tornado chart example;
Overlay Chart: Lending vs. Spending; ;
Article: Calculating ROMI;
Data Blending;
Analytics Projects: Top Mistakes to Avoid";
Courses to learn more about analytics
Pimp My PowerPoint (2:58);
Presenting Data in Charts (2:12);
Pivot Tables (7:38);
MIT Sloan: Analytics Strategy in Organizations (58:51)
Analytics Project:
Model Development (pdf); (ppt)
Sample Project: Promotion Allocation:
(pdf);
Sample Project: Forecasting: (pdf);
Sample Project: Pricing: (pdf)
Group Project Teamwork Skills;
Tuckman's Team Model
Working in Groups (4:35)

Analytics Technologies

Course Content Case Studies Web Resources Videos
Technology:
Category Overview
(pdf); (ppt)
Technology:
Competitive Analysis Tools
(pdf); (ppt)
Technology:
Data Analysis Software:
SAS, SPSS, R
Part 1: R Essentials (pdf); (ppt)
Part 2: Segmentation Using R (pdf); (ppt)
Part 3: Conjoint Using R (pdf); (ppt)
R Download (Free):
R for Microsoft;
R for Apple
R to Surpass SAS and SPSS by 2015?;
R Reference Card with basic commands;
Free edX Class in R
Getting Started with R (16:30);
Regression in R (16:40)
Technology:
Data Visualization
(pdf); (ppt)
Sample Datasets: Tableau;
Sample dataset: FAA Aircraft Bird Strikes;
Sample dataset: GitHub;
Sample dataset: Ford GoBike bike share;
Sample Tableau Visualization
Tableau for AirBnB Visualization Tableau Training Videos;
Intro to Tableau Public (9:50)
Technology:
Marketing Automation
(pdf)
Forbes: Zeroing In On Leads with Pardot;
Must-have emails for marketing automation
Technology: Market Research Survey Monkey Tutorials:
Creating Surveys; Collecting Responses; Analyzing Results
Online Survey Best Practices Design Best Practices (16:05);
Technology: Microsoft Excel Excel Tutorials:
Up to Speed;
Entering Formulas;
Creating Charts;
Pivot Tables I
Mac Add-In for Analysis ToolPak: AnalystSoft StatPlus;
Mac Add-In for Solver: Frontline Solver;
Windows Add-In: Analysis ToolPak: Tutorial;
Windows Add-In: Solver: Loading instructions; Tutorial;
5 Excel Add-Ins for Data Scientists
Installing StatPlus for Apple Mac;
Using StatPlus for Apple Mac
Technology:
Social Media Measurement
(pdf); (ppt)
AdAge: Social Media Impact on Sales Social Media Analytics (6:21)
Technology: Structured Query Language (SQL)
SQL Coding(ppt);
SQL Session: (pdf); (ppt)
Dataset: MySQL Sample Databases (link) Download MySQL Community Server(Windows and Mac);
SQL School, by Mode
What is Database & SQL?(6:19);
Introduction to MySQL(3:07);
MySQL for Excel(4:41)

"However beautiful the strategy, you should occasionally look at the results."
- Sir Winston Churchill