Asana: Project

Description

• Table of projects' basic info enriched with metrics regarding tasks and completions

Supported Data Sources

• Asana

Columns

Type	Name	Description
INTEGER	project_id	System-generated unique ID of the project.
STRING	project_name	UI-facing name of the project
INTEGER	number_of_open_tasks	Count of the currently open tasks in this project
INTEGER	number_of_assigned_open_tasks	Count of the open and assigned tasks in this project.
INTEGER	number_of_tasks_completed	Count of tasks that have been completed in this project
INTEGER	avg_close_time_days	The avg number of days it has taken to close tasks in this project
INTEGER	avg_close_time_assigned_days	The avg number of days it has taken to close tasks, since their last assignment, in this project
STRING	project_link	URL formatted to bring you directly to the project in asana.
INTEGER	team_id	Foreign key referencing the ASANA_TEAM that the project is associated with
STRING	team_name	User-facing name of the project's team
BOOLEAN	is_archived	Boolean representing if the project has been archived in the UI
DATETIME	created_at	Timestamp of when the project was created
STRING	current_status	The most recent progress status update for the project (free-form string)
DATETIME	due_date	The date the project is due on, if given
DATETIME	last_modified_at	Timestamp of when the project was last modified (doesn't include comments or tasks)
INTEGER	owner_user_id	Foreign key referencing the USER who owns the project.
STRING	users_involved	Aggregated list of the names + roles of the users involved (working on or owning) a project
INTEGER	number_of_users_involved	Count of the unique users associated with the project
STRING	sections	Aggregated list of the sections that exist in the project.
STRING	notes	Free-form textual description associated with project
INTEGER	is_public	Boolean that's true if public to the whole workspace, false if private.