Multiple People are sharing one gmail account. Ex: [email protected] type. Tracking their performance on day to day basis.
We assign label to every person. Mails are assigned to this label periodically. These mails are read,replied,moved to archive or other labels. Mails which were read today by each person are considered to be atteneded to. We track these numbers[i.e. Mails Read Today] in this APP.
We assign labels to each person in following fashion.
Team A <---- Label
Team A/John <---- Nested Label under Team A
Team A/Kerry <--------|
Team A/Katy
Team B <--- Label
Team B/Priscilla <---- Nested Label under Team B
Team B/Johny
Team C
Team C/Hugh
Team C/Jake
1) Assign Labels as described above.
2) Add Sheets in current SpreadSheet by name of Team.
3) Edit code to change Team names [Default: Team A, Team B, Team C (three teams)]
4) Setup trigger for timedDBUpdate() just after midnight.
Usage:
Including People in Report:
Every Label With Given Team-Name will be considered for this Report.
Removing People from Report:
Remove the Label from "Team X" and move it somewhere else.
Output:
Report will contain Number of Unread Mails, Number of Replied Mail, Total Mail since a Base-TimeStamp, Currently 1 AM IST.
- Optional Trigger for team status every hour.
Design:
We take a snapshot of each label every day. The snapshot will contain Thread_ids and read/unread status for them.
We use yesterday's snapshot and comapre it with today's snapshot. Our aim is to get mails replied today.
- Mails which were unread yesterday and are not longer present today: CountEm!
- Mails which are read today and were unread yesterday. CountEm!
- Mails which are read today and were not present yesterday. CountEm!
Ignore the rest.