Asana: Task

Description

• An enriched task table consisting of base task info + aggregated metrics and lists

Supported Data Sources

• Asana

Columns

Type	Name	Description
INTEGER	task_id	System generated unique ID of the task.
INTEGER	assignee_user_id	Foreign key referencing the ASANA_USER that is currently assigned the task.
BOOLEAN	is_completed	Boolean that is true if the task is currently marked complete.
DATETIME	completed_at	Timestamp of when the task was marked complete.
INTEGER	completed_by_user_id	Foreign key referencing the USER who completed the task. Note that this may be different than the assignee
DATETIME	created_at	Timestamp of when the task was created
DATETIME	due_date	Date the task is due, if provided.
DATETIME	modified_at	Timestamp of when the task was last modified
STRING	task_name	User-facing name of the task
INTEGER	parent_task_id	Self-referential id of the parent TASK that this is a subtask of.
DATETIME	start_date	The start date of the task, if a date range is given.
STRING	task_description	Free-form text describing the task, as seen in the UI.
BOOLEAN	is_liked	Boolean that is true if the task is liked by the authorized user.
INTEGER	number_of_likes	Number of users who have liked this task.
INTEGER	workspace_id	Foreign key reference to the workspace
STRING	task_link	URL formatted to bring you directly to the task in asana.
STRING	assignee_name	Name of the user that the task is currently assigned to.
STRING	assignee_email	Email of the user that the task is currently assigned to.
INTEGER	days_open	The number of days the task has been/was open (creation -> completion)
BOOLEAN	is_currently_assigned	Boolean, true if the task is currently assigned
BOOLEAN	has_been_assigned	Boolean, true if the task has at one point been assigned, even if currently not.
INTEGER	days_since_last_assignment	The number of days the task has been/was open and assigned to to the most recent user (last assignment -> completion)
INTEGER	days_since_first_assignment	The number of days the task has been/was open and assigned at all (first time assigned -> completion)
DATETIME	last_assigned_at	Timestamp of when the task was last assigned (to the current user if still assigned)
DATETIME	first_assigned_at	Timestamp of when the task was first assigned to someone
INTEGER	first_modifier_user_id	Foreign key referencing the ASANA_USER who made the first modification to the task (ie added a description). A proxy for task creator.
STRING	first_modifier_name	Name of the user who made the first modification to the task
STRING	conversation	The task's comments and authors aggregated into an ordered conversation, with authors + time sent
INTEGER	number_of_comments	Count of comments made on the task
STRING	followers	A list of the names of the users who follow the task.
INTEGER	number_of_followers	Count of the users following the task
STRING	tags	A list of the tags associated with the task.
INTEGER	number_of_tags	Count of the tags associated with the task.
STRING	project_ids	List of all project_ids associated with the task. You can parse or explode the items in the list using a comma + space (", ") as a delimiter. To keep the table grain at the task_id level, this list is not parsed by default.
STRING	project_names	List of all project_names associated with the task. You can parse or explode the items in the list using a comma + space (", ") as a delimiter. To keep the table grain at the task_id level, this list is not parsed by default.
STRING	projects_sections	A list of the projects + sections that this task is listed under. You can parse or explode the items in the list using a comma + space (", ") as a delimiter. To keep the table grain at the task_id level, this list is not parsed by default.
INTEGER	number_of_projects	The number of projects associated with the task.
BOOLEAN	is_subtask	Boolean that's true if the task is a subtask of another.
STRING	parent_task_name	User-facing name of the task's parent task.
INTEGER	parent_assignee_user_id	Foreign key referencing the ASANA_USER who is assigned the parent task
STRING	parent_assignee_name	Name of the user assigned this task's parent task
DATETIME	parent_due_date	Date on which the parent task is due, if given
DATETIME	parent_created_at	Timestamp of when the parent task was created