Prepared by a marketing lecturer, designed for university-level students
Often students want to graph multiple products onto the product life cycle using an Excel spreadsheet or some other charting approach. Perhaps surprisingly, this is sometimes awkward to … Read more...
Market share can be decomposed into three components, namely:
The following video explains how these three components work together to calculate overall market share.
There are five CLV videos available here:
In these two videos, learn how to make a BCG matrix on Excel from start to finish. Alternatively there is a free Excel template available for download on another of my sites that automates the process for you.
Customer lifetime value is often called marketing’s golden metric. Certainly in most service industries, customer lifetime value would be a very important marketing metric.
Customer lifetime value can be calculated quite simply at times, with a ballpark estimate. This may … Read more...
Perceptual maps are often quite difficult to format, so take advantage of the free perceptual map template that I have built for Microsoft Excel.
It is quick and easy to use – … Read more...
Perceptual mapping is a key analytical tool in understanding market positioning. While the best piece of software to use to construct a perceptual map is Microsoft Excel, the structuring of the graph is sometimes a little bit tricky.
Either a … Read more...
This video highlights a major campaign undertaken by the National Australia Bank (NAB). As you will see, this is probably one of the best executed campaigns that you will see, given that … Read more...
Making a bubble chart in Excel is ideal for making perceptual maps to demonstrate positioning.
There are three ways to make a bubble chart in Excel, as shown the below video “How to make a bubble chart in Excel”.… Read more...
This website has a free Excel spreadsheet template that can enable to quickly calculate customer lifetime value for your university assignment or for your firm. Go here to download the customer lifetime value template.
There are also step … Read more...
When I was a marketing student, a long time ago, I did not study integrated marketing communications. Instead, I studied advertising and sales management as separate subjects. That was the way it was taught in university and that was … Read more...
In a number of marketing textbooks, one of the topics that they address in chapter 1 is the discussion of different marketing philosophies or concepts – which some marketing … Read more...
In advertising and communication programs, one of the challenges is to execute a good creative idea.
Marketing students sometimes have difficultly understanding how an idea may or may not be … Read more...
Positioning is how the firm or brand wants to be perceived by consumers relative to its competitors. It is a very important topic in the study of marketing and usually forms the basis … Read more...
