# Asana: Team

## Description

* Enriched team table consisting of basic team info + task/completion metrics (note that teams can only act on tasks in projects)

## Supported Data Sources

* <img src="https://fivetran.com/integrations/asana/resources/asana.svg" alt="" data-size="line"> Asana

## Columns

| Type    | Name                              | Description                                                                             |
| ------- | --------------------------------- | --------------------------------------------------------------------------------------- |
| INTEGER | team\_id                          | System generate unique ID for the team                                                  |
| STRING  | team\_name                        | UI-facing name of the team.                                                             |
| INTEGER | number\_of\_open\_tasks           | Count of the currently open tasks for this team.                                        |
| INTEGER | number\_of\_assigned\_open\_tasks | Count of the open and assigned tasks for the team.                                      |
| INTEGER | number\_of\_tasks\_completed      | Count of tasks that this team has completed.                                            |
| INTEGER | avg\_close\_time\_days            | The avg number of days it has taken projects of this team to close tasks.               |
| INTEGER | avg\_close\_time\_assigned\_days  | The avg number of days it has taken projects of this team to close tasks, once assigned |
| INTEGER | number\_of\_active\_projects      | Count of non-archived projects                                                          |
| STRING  | active\_projects                  | Aggregated list of non archived projects associated with the team                       |
| INTEGER | number\_of\_archived\_projects    | Count of archived projects                                                              |


---

# 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-team.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.