個案總覽

Spreadsheet supplement for case 902A22.

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.

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 702A22, is also available.