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.

Last updated

Was this helpful?