Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have been hired as a digital marketing analyst for the fictitious company Outrageous Fun Game. The company sells a question-based game sure to bring

You have been hired as a digital marketing analyst for the fictitious company Outrageous Fun Game. The company sells a question-based game sure to bring on the laughs. The game has over 500 outrageous questions. Each game comes with question cards, instructions, and a box. 

Make sure you have Excel installed on your computer or you have access to Google Sheets. Open the "Mailchimp Emails Outrageous Fun Game" file below.

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.

 

1. In total, how many emails were successfully delivered in 2019? (Hint: Total successful deliveries from all emails.)
            

2. 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?

            

3. What email from 2019 had the highest open rate? Write the subject of the email as your answer.

 

4. What email from 2019 had the lowest click rate? Write the subject of the email as your answer.

 

5. What email from 2019 got the most unsubscribes? Write the subject of the email as your answer.

 

6. How much total revenue was created by email in 2019? (Hint: Total revenue from all emails.)

 

7. Based on the data, how much do you think one game costs? How did you determine the cost of one game?

 

8. What email from 2019 had the highest revenue? Write the subject of the email as your answer.

 

9. How did the amount of subscribers in the (Updates & Offers) list change over 2019? (Hint: Look at total recipients.) 

 

10. 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?

 

SubjectListSend DateSend WeekdayTotal RecipientsSuccessful DeliveriesSoft BouncesHard BouncesTotal BouncesTimes ForwardedForwarded OpensUnique OpensOpen RateTotal OpensUnique ClicksClick RateTotal ClicksUnsubscribesAbuse ComplaintsRevenue CreatedTransactionsAverage Order Value
Order Outrageous Fun Game Today - Available Now On Kickstarter(Updates & Offers)1/16/2019 16:00Wednesday3230022002376.67%481240.00%2000$180.00 6$30.00 
Outrageous Fun Game @ Your Next Party(Updates & Offers)1/19/2019 21:15Saturday5250022003672.00%72510.00%810$60.00 2$30.00 
Kickstarter Returns All The Money If We Don't Hit Goal(Updates & Offers)1/30/2019 8:00Wednesday4949000003571.43%561020.41%1400$90.00 3$30.00 
We Secured A Super Bowl Ad Spot(Updates & Offers)2/6/2019 11:32Wednesday5050000002958.00%4124.00%300$0.00 0$0.00 
YouTube Love & 20% OFF Outrageous Fun Game(Updates & Offers)9/24/2019 7:00Tuesday215214011006831.78%12183.74%900$0.00 0$0.00 
50% Off Outrageous Fun Game: 2 Weeks Only On Amazon(Updates & Offers)10/18/2019 10:30Friday234229235005925.76%7573.06%700$120.00 4$30.00 
Outrageously Easy Holiday Shopping(Updates & Offers)11/23/2019 17:58Saturday217217000008237.79%11952.30%540$90.00 3$30.00 
Who Has A Great Gift Idea? ME(Updates & Offers)12/10/2019 10:15Tuesday253248325005522.18%6620.81%230$90.00 3$30.00 
Who Has The Merriest Gift Idea? ME(Updates & Offers)12/11/2019 18:18Wednesday216216000008840.74%11762.78%820$0.00 0$0.00 

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Answer 1 In total the number of emails successfully delivered in 2019 is 1279 This can be calculated ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
663d535e89391_967975.pdf

180 KBs PDF File

Word file Icon
663d535e89391_967975.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Kemp, Jeffrey Waybright

2nd edition

978-0132771801, 9780132771580, 132771802, 132771586, 978-0133052152

More Books

Students also viewed these Accounting questions