Course Webpage for Marketing Analytics, University of Bari, Spring 217
Course Syllabus
Course Schedule
Required Software:
decisionpro-software-marketing-engineering-tutorial-edu-getting-started-v160917
Powerpoint Slides
Principles of Marketing Engineering, 2nd Edition
- principles-ch1-the-marketing-engineering-approach
- principles-ch2-customer-value-and-valuing-customers
- principles-ch3-segmentation-and-targeting
- principles-ch4-positioning
- principles-ch5-forecasting
- principles-ch6-new-product-and-service-design
- principles-ch7-the-marketing-mix
- principles-ch8-harvesting-value-from-marketing-engineering
Software Assignments – More Details Pending
- clv-tutorial-v150211-prin-ch-2
- segmentation-and-classification-tutorial-prin-ch-3
- customer-choice-tutorial-logit-ch-3
- positioning-tutorial-prin-ch-4
- bass-tutorial-prin-ch-5
- conjoint-tutorial-prin-ch-6
- resource-allocation-tutorial-prin-ch-7
- pricing-tutorial-prin-ch-7
- ge-tutorial-prin-ch-8
Technical Notes for Software Exercises and Other Data Analysis Techniques
- tn01_-_excel_solver_technical_note-prin-ch-1
- tn02_-_response_models_technical_note-prin-ch-1
- tn03_-_choice_modeling_technical_note-prin-ch-1-2-and-7
- tn04_-_segmentation_technical_note-prin-ch-3
- tn05_-_positioning_technical_note-prin-ch-4
- tn06_-_time_series_technical_note-prin-ch-5
- tn07_-_assessor_technical_note-prin-ch-5
- tn08_-_bass_model_technical_note-prin-ch-5
- tn09_-_conjoint_analysis_technical_note-prin-ch-6
- tn10_-_resource_allocation_technical_note-prin-ch-7
Videos:
- Clumpiness and Customer Lifetime Value
- A Step by Step Guide to Calculating Customer Lifetime Value
- Slightly different approach from the textbook
- https://www.youtube.com/watch?v=3pL98QNBMkE
- Segmenting, Targeting and Positioning
- Good overview of the STP process
- https://youtu.be/nU_oV0N414A
- How to Make a Perceptual Map Using Excel
- Marketing Research-GE Portfolio Matrix using Marketing Engineering (Office Star)
- GE McKinsey Matrix for SBU Strategies (Grand Canyon)
- Good explanation of how to create a GE McKinsey Matrix, including industry attractiveness, brand equity, market share, etc.
- https://www.youtube.com/watch?v=FffD1Ze76JQ
- Advanced Customer Segmentation for Consumer Marketing – MindEcology.com
- A much more detailed look at the STP process
- https://youtu.be/iMP0rhc2Ztg
Test Information:
You will not have access to your notes for the exam, so please prepare accordingly. Think about the topics we covered in class and then think about what information you might need to have in order to show proficiency in marketing analytics to your work colleagues in a strategic marketing meeting or a job interview for a marketing position. These are the types of questions I will focus on. Also, review what you have learned from each of your class assignments. If you are prepared, you will easily finish the exam in less than the 90 minutes allotted.
[Note the assignment information and the session summaries have been moved to separate pages. You can access the under the Marketing Analysis main course menu option under the Student section.]
Project Rubric:
Area: | Proj 1 | Proj 2 | Notes: | |||||||
Purpose of the Study | 5 | 5 | what company problem or issue are you addressing and attempting to solve; remember the time limit of 8 to 12 mintues — choose an appropriate scope / focus for the study; it must be a meaningful and critical company issue | |||||||
Use of Appropriate Data Analysis Methods | 15 | 25 | did you use the most important tools from the class in your analysis given your company situation and objectives; advertising reponse functionss, clv, segmentation, targeting, positioning, conjoint analysis, etc. | |||||||
Conclusions Drawn from Analysis | 15 | 25 | what specifically did you learn from the analysis from a managerial perspective | |||||||
Financial Analysis | 10 | 15 | what are the financial implications for taking no action versus taking the action you recommend, return on investment? Should be at least 15% and up to 400%, be sure you include the costs; consider the operating costs; use 3 scenarios: best / ideal case, worst case, most likely | |||||||
Strategic Action that should be taken | 10 | 10 | what action should the company take, have a timeline or schedule for these actions | |||||||
Presentation Quality – slides, illustrations, charts, graphs, easy to read and understand, easy for the audience to follow, did you convince the audience to take your suggestions | 10 | 10 | did you organize and present the information in a manner that overall convinces the audience to follow your course of action? Does the audience believe your analysis and believe that you have the right solution to the problem? | |||||||
Executive Summary – well written, summaries the most critical information for the top executives | 5 | 5 | if you were a top executive and could not attend the presentation, what would you tell them about the presentation? Include the most important information to persuade them that they need to follow your strategic actions. | |||||||
References Used | 5 | 5 | appropriate references to show credibility to the analysis with benchmarks and industry averages | |||||||
Total | 75 | 100 |