Drip Email System
Goal
The project team is asked to build a Drip Email System, using various existing technologies and developing some custom solutions.
Drip Emails
A drip email system sends pre-written emails out automatically based on a schedule or rhythm. For instance, one email will go out as soon as someone signs up, another will go out 3 days later, with one more going out two weeks later. Or, the emails can be varied based on triggers (e.g., var = true). As such, a drip email system is different to email newsletters (e.g., Mailchimp), which are a great way to send out the latest announcements, but they have a major problem: new subscribers only see new emails, and never get the first emails youd sent out to a drip list.
What you are asked to do
In brief, your engineering contribution is to build a system that works like this:
-
A Google Sheet Contacts contains contact details (name, email); new contacts are regularly appended to this list, including a timestamp when a contact joined this list
-
Another Google Sheet Drip Config allows to define what emails are to be sent when and under what conditions
-
Your custom function monitors schedules and other triggers, to then automatically send emails to all applicable contacts
-
Your function will use the batch email service SendGrid (which contains the email templates)
The Client
Ramon Wenzel, PhD, operates at the nexus of people science, analytics, and tech. He has worked with and mentored many student project teams relating to data and computational science, and is keen to meet you: [email protected] | 0421.165801 | https://www.linkedin.com/in/ramonwenzel/
He leads a research team that maintains existing software solutions realised using containers hosted on Google Firebase. It is highly desirable to implement this new solution in a similar manner (e.g., python, container).
Context
Australian Not-for-Profit organisations employ 1.3 million people and 3 million volunteers to help the homeless, educate the children, feed the hungry, support the arts, enable sports and community, among others. To help them become better at what they do, an applied research initiative called Learning for Purpose developed and deploys a suite of People Analytics solutions to which people sign up. Using a scalable web-based survey and reporting system, we provide for free Not-for-Profit organisations the opportunity to measure, diagnose and change the states of their worker well-being, learning, and happiness. Your contribution will dramatically improve communication between the research team and users of the services described.
See learningforpurpose.org/analytics.
Client
Contact: Ramon Wenzel
Phone: 0421165801
Email: [email protected]
Preferred contact: Email
Location: Perth
IP Exploitation Model
The IP exploitation model requested by the Client is: Right of proposer(s) and students to use and modify project outputs, but not to distribute
Department of Computer Science & Software Engineering
The University of Western Australia
Last modified: 23 July 2021
Modified By: Michael Wise
|
 |