This post shows how I analyzed a MailChimp email list, including all the data from weekly newsletters for 2014, using MySQL. It was inspired by this excellent tutorial: Performing cohort analysis by Micheal Herman. The email list I’m working with consists of about 18,000 subscribers.
I wanted to answer questions such as:
- How many emails do active subscribers open on average?
- How active are the subset of users who bought a product during the digital flash sale in March of this year?
- Who hasn’t opened an email at all in 2014?