ASGN Goal Seek and Social Media.docx - (updates in Red...

This preview shows page 1 - 2 out of 5 pages.

(updates in Red ) Updated 2/25/20 ASGN:Goal Seek and Social Media Analytics Scenario Walt Disney Resorts & Parks (WDRP) has a new advertisement for broadcast TV and social media. As a new marketing intern at WDRP, it is your job to identify the most popular TV shows and social media sites on which to place the ad. You’ve also been asked to understand the historical performance of various shows and genres, as well as perform some basic calculations to determine the cost implications of different placement strategies. Using the data on the "Prime Broadcast TV" and "Social Content Ratings" tabs of the provided data spreadsheet, answer the following questions: Questions Data Orientation For the first two questions, use the “Prime Broadcast TV” tab of the spreadsheet (1) For the weeks of 1/29/18, 7/30/18, and 2/4/19, and 2/3/20 what single TV show should WDRP have advertised on to reach the most viewers? a. 1/29/18: Grammy Awards b. 7/30/18: America’s Got Talent c. 2/4/19: Grammy Awards d. 2/3/20: The Oscars (2) WDRP may be able to negotiate a discount to advertise on ABC stations (which are also owned by Disney). Filter the Prime Broadcast TV list for just ABC shows (this should result in just 11 rows) and list the three ABC shows with the most viewers.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture