# Asana: User

## Description

* Enriched user table consisting of base user info + metrics around 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 | user\_id                                      | System generated unique ID of the user                                                |
| STRING  | email                                         | The user's email                                                                      |
| STRING  | user\_name                                    | Name of the user as it appears in the UI                                              |
| INTEGER | number\_of\_open\_tasks                       | Count of the currently open tasks assigned to this user                               |
| INTEGER | number\_of\_tasks\_completed                  | Count of the tasks that this user has completed                                       |
| INTEGER | avg\_close\_time\_days                        | The avg number of days it has taken the user to complete tasks once assigned to them. |
| INTEGER | number\_of\_projects\_owned                   | Count of the projects that this user is the owner of (excludes archived projects)     |
| INTEGER | number\_of\_projects\_currently\_assigned\_to | Count of the projects that the user is currently assigned open tasks to.              |
| STRING  | projects\_working\_on                         | Aggregated list of the projects that the user is currently assigned to or owns        |


---

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