The “Rocket Fuel: Measuring the Effectiveness of Online Advertising”

Purchase the “Rocket Fuel: Measuring the Effectiveness of Online Advertising” case from Harvard Business Publishing using this link:
Read pages 1-3 of the case study. Answer the following questions, using the data in the attached Excel file Download the attached Excel file.

  1. Was the advertising campaign effective? How many people converted (purchased a handbag) in the test group and in the control group? What was the conversion rate (%) in the two groups? (25 points)
  2. What was the increase in revenue, assuming $40/handbag, resulting from the campaign? (10 points)
  3. What was the cost of the campaign? (10 points)
  4. What was the ROI of the campaign? (10 points)
  5. What is the minimum number of impressions (the nearest 10) required for conversion? (10 points)
  6. At what number of impressions do returns starts to decline? (10 points)
  7. What do questions 5 & 6 imply for buying impressions? (10 points)
  8. What additional kinds of data would you collect/acquire to better segment potential customers for future marketing campaigns? (15 points)

Sample Solution