Reference no: EM133650271
Assignment
Your manager wants you to explore the company's email data from Mailchimp, the email marketing service that has the largest market share in the United States. Mailchimp allows for the creation of free accounts and offers premium features for a cost. Unfortunately, you do not have direct access to the company's Mailchimp account, but your manager has exported the email performance data for you. The email data for all of 2019 is in the "Mailchimp Emails Outrageous Fun Game" file. Your manager has asked you to answer the following questions using the email data from in the file.
Question A. In total, how many emails were successfully delivered in 2019? (Hint: Total successful deliveries from all emails.)
Question B. The file indicates that some emails "soft bounced" and others "hard bounced." Do some research on the internet on those terms. What is the definition of each term?
Question C. What email from 2019 had the highest open rate? Write the subject of the email as your answer.
Question D. What email from 2019 had the lowest click rate? Write the subject of the email as your answer.
Question E. What email from 2019 got the most unsubscribes? Write the subject of the email as your answer.
Question F. How much total revenue was created by email in 2019? (Hint: Total revenue from all emails.)
Question G. Based on the data, how much do you think one game costs? How did you determine the cost of one game?
Question H. What email from 2019 had the highest revenue? Write the subject of the email as your answer.
Question I. How did the amount of subscribers in the (Updates & Offers) list change over 2019? (Hint: Look at total recipients.)
Question J. You asked your manager about the change in the email list subscribers. Your manager mentions that they made some enhancements to the email list in the summer. Based on the data, were these email list enhancements effective at driving quality email engagement and increased revenues?