Auto email for professor to flag low registration % in their community

1 votes

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!

Under consideration Suggested by: Anh Upvoted: 27 Jul, '20 Comments: 0

Add a comment

0 / 1,000

* Your name will be publicly visible

* Your email will be visible only to moderators