Asana: User

Description

• Enriched user table consisting of base user info + metrics around tasks and completions

Supported Data Sources

• Asana

Columns

Type	Name	Description
INTEGER	user_id	System generated unique ID of the user
STRING	email	The user's email
STRING	user_name	Name of the user as it appears in the UI
INTEGER	number_of_open_tasks	Count of the currently open tasks assigned to this user
INTEGER	number_of_tasks_completed	Count of the tasks that this user has completed
INTEGER	avg_close_time_days	The avg number of days it has taken the user to complete tasks once assigned to them.
INTEGER	number_of_projects_owned	Count of the projects that this user is the owner of (excludes archived projects)
INTEGER	number_of_projects_currently_assigned_to	Count of the projects that the user is currently assigned open tasks to.
STRING	projects_working_on	Aggregated list of the projects that the user is currently assigned to or owns