Marketing Campaign Analysis

0 comments

Read the case study, and answer the following questions using the attached excel file. If there are calculations needed, please give the formula.

  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?
  2. What was the increase in revenue, assuming $40/handbag, resulting from the campaign?
  3. What was the cost of the campaign?
  4. What was the ROI of the campaign?
  5. What is the minimum threshold-level of impressions (the nearest 10) for the campaign to be effective?
  6. At what level of impressions (the nearest 10) do the campaign’s returns/impact start to decline?
  7. What is your recommendation for the volume of impressions to purchase?
  8. How would you know if your calculated ROI is repeatable and can be applied to future campaigns?
  9. Based on your learnings from this trial, what improvements would you recommend to Taskabella for future campaigns of the handbag?
  10. What additional kinds of data would you collect/acquire to better segment potential customers for future marketing campaigns?

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}