I am looking for guidance in the following -
This is what we would like to create reports on from Asana:
- tasks unassigned
- tasks unscheduled by assignee
- tasks without effort hours by assignee (custom number field which we had before Asana added the “estimated time” field). (Asana reporting can’t create a chart for this, but I have a saved search with custom filters to track this.)
- tasks being continuously rescheduled (not sure how to track)
- overdue tasks by assignee
- upcoming personal due dates
- upcoming timeline due dates
What I know Asana reporting/chart capabilities currently are:
- tasks unassigned - number count turns to list view
- tasks unscheduled by assignee
- overdue tasks by assignee
- upcoming personal due dates
- upcoming timeline due dates (custom date field)
Asana saved search capabilities:
- tasks without effort hours (custom field) by assignee
- Recently created tasks/features
Based on that information, I would like to generate daily or weekly emails to each team member to report on the tasks they are assigned to regarding the following:
- What was accomplished (today) (i.e. what moved to the next status (custom field) or what was closed)
- tasks without due dates
- tasks without effort hours
- tasks being continuously rescheduled
- overdue tasks
- upcoming (tomorrow’s) task count
- upcoming (tomorrow’s) tasks marked high priority
- upcoming (tomorrow’s) effort hour workload
- upcoming (tomorrow’s) tasks due
- upcoming (tomorrow’s/next week’s) timeline due dates
Any advice how to create these reports and emails? Any software that would be useful? So far I haven’t found a good one.
Thank you!