Subject category:
Marketing
Published by:
Ivey Publishing
Version: 2002-09-25
Length: 12 pages
Data source: Generalised experience
Abstract
The marketing manager for a hockey team has been told by senior management that revenues for the next season must increase or the franchise will be sold. The previous year's high-budget advertising campaign did not bring in the single-ticket sales results he expected. A database of past ticket holders is available and the question arises how to use this database. Using pivot tables, and recency, frequency and monetary value analyses, he must determine how to increase the return on the marketing investment. An Excel spreadsheet, product '7B02A022', is also available.
About
Abstract
The marketing manager for a hockey team has been told by senior management that revenues for the next season must increase or the franchise will be sold. The previous year's high-budget advertising campaign did not bring in the single-ticket sales results he expected. A database of past ticket holders is available and the question arises how to use this database. Using pivot tables, and recency, frequency and monetary value analyses, he must determine how to increase the return on the marketing investment. An Excel spreadsheet, product '7B02A022', is also available.