Auto email for professor to flag low registration % in their community
Create an auto email for professors if their registration is low and cc the EMs. Here's the proposed logic:
- It's been 2 weeks after community start date but enrollment % registration is less than 60%
- It's been 3 weeks after community start date but enrollment % registration is less than 75%
- It's been 4 weeks after community start date but enrollment % registration is less than 90%
Note:
- Registration % = Registered students / (registered students + pending students)
- If a professor has more than 1 community, combine their stats in 1 email
- cc the EM of the community in the email. Appropriate EM can be found in a big query table (ask Anh for access)
Find the email template in the attached image!