Your university is trying to answer questions on email engagement. The school is worried about the perception of email spam, and want to reduce the number of emails sent to students. To focus on email engagement means that you are looking at how students interact with emails from a school.For this project and data analysis, your team needs to answer the following questions:

What is the average number of emails that are being sent per student?

What is the average open rate per student?

How many students (count and %) are not opening emails?

How many emails does it take (number of delivered) to get students to open an email?

Among students who unsubscribed (emailUnsubscribed), how many emails on average were they sent?

How does email engagement change over the course of enrollment milestones (Prospects Applicants Admitted)

What other actions students complete as they advanced their milestones (Prospects Applicants Admitted) JBonilla | 2018

Are there "windows" where applicants/deposited students complete more actions? For example, an admitted student opens 10 emails in 12 weeks, but 50% of them during the 1st week.

Compute an "engagement score" that combines the actions that lead to higher conversion. The "engagement score" is a weighted average from 0-100% that accounts for different actions completed by an student.