# Asana: Project

## Description

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

## Supported Data Sources

* <img src="https://fivetran.com/integrations/asana/resources/asana.svg" alt="" data-size="line"> 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.                            |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/asana-project.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.