# Asana

Analyze tasks, projects, and team productivity

Connect Asana to Scoop to analyze your project management data, track task completion rates, understand team workload, and monitor project health.

# AI-Assisted Setup

When connecting Asana to Scoop, choose **"Guide me with AI"** for an intelligent, guided setup experience.

## Available Analysis Templates

| Template | Object | Data Mode | Best For | What You'll Analyze |
|----------|--------|-----------|----------|---------------------|
| **Task Completion & Deadlines** (Default) | tasks | Snapshot | Productivity tracking | Completion rates, overdue items, deadline adherence |
| **Project Status & Timeline** | projects | Sync | Portfolio management | Project health, at-risk projects, timeline tracking |
| **Team Assignments** | tasks | Snapshot | Workload balance | Task distribution, overloaded team members |
| **Team Members** | users | Sync | Team directory | Team composition, contact information |
| **All Projects** | projects | Sync | Project inventory | Complete project list for portfolio overview |

## Example Questions You Can Answer

**Task Productivity:**
- "What's our task completion rate this week/month?"
- "How many tasks are overdue by assignee?"
- "Which team members have the most open tasks?"
- "What's the average time from task creation to completion?"
- "How many tasks were completed ahead of deadline?"

**Project Health:**
- "Which projects are on track vs at risk vs off track?"
- "How many projects are past their due date?"
- "What's the distribution of project status across teams?"
- "Which project owners have the most active projects?"
- "How many projects were created this quarter?"

**Workload Analysis:**
- "Who has the heaviest workload by open task count?"
- "How are tasks distributed across team members?"
- "Which assignees have the most overdue tasks?"
- "What's the task completion trend by assignee?"

**Team Insights:**
- "How many projects does each team own?"
- "What's the task volume by project?"
- "Which teams have the most at-risk projects?"

## Need Something Different?

If the templates above don't match your needs, select **"Something else"** and describe what you want to analyze. For example:

- "I want to track milestone completion by project"
- "I need to see subtask counts by parent task"
- "I want to analyze task velocity by team"

Scoop's AI will recommend the right configuration for your specific use case.

## Snapshotting for Task Analysis

Tasks change over time - completion status updates, due dates shift, assignees change. Configure your Tasks extract as a **Snapshot** dataset to:

- Track completion progress over time
- Monitor overdue task trends
- Analyze how tasks move through status changes
- Compare workload snapshots week-over-week

> **Pro Tip:** Enable snapshotting on day one for tasks. Project managers need historical snapshots to track productivity trends and identify workflow bottlenecks.

# Connecting Asana to Scoop

1. Create a new dataset in Scoop
2. Select **Asana** from the application list
3. Authorize Scoop to access your Asana workspace
4. Select which workspace to connect (if you have multiple)
5. Choose your analysis template or customize
6. Save and extract data

# What Data You Get

## Tasks (16 fields)
Work items with completion status, deadlines, and assignments.

| Field | Description |
|-------|-------------|
| Task ID | Unique identifier (prefixed with AS) |
| Name | Task title |
| Notes | Task description |
| Completed | Whether task is marked complete |
| Completed Date | When task was completed |
| Due Date | Task deadline (date only) |
| Due DateTime | Task deadline with time |
| Start Date | When task work should begin |
| Created Date | When task was created |
| Modified Date | When task was last modified |
| Assignee ID | Assigned user's ID |
| Assignee Name | Person assigned to the task |
| Projects | Projects containing this task |
| Tags | Task labels |
| Subtask Count | Number of subtasks |
| Type | default_task, milestone, section, or approval |

## Projects (15 fields)
Containers for organizing tasks.

| Field | Description |
|-------|-------------|
| Project ID | Unique identifier |
| Name | Project name |
| Notes | Project description |
| Owner ID | Project owner's user ID |
| Owner Name | Person who owns the project |
| Team ID | Owning team's ID |
| Team Name | Team that owns the project |
| Created Date | When project was created |
| Modified Date | When project was last modified |
| Due Date | Project deadline |
| Start Date | Project start date |
| Status | on_track, at_risk, off_track |
| Public | Whether project is public |
| Archived | Whether project is archived |
| Color | Project color code |

## Users (4 fields)
Team members who can be assigned tasks.

| Field | Description |
|-------|-------------|
| User ID | Unique identifier |
| Name | Person's name |
| Email | Email address |
| Type | Resource type |

## Teams (5 fields)
Groups of users within an organization.

| Field | Description |
|-------|-------------|
| Team ID | Unique identifier |
| Name | Team name |
| Description | Team description |
| Organization ID | Parent organization |
| Visibility | Team visibility setting |

## Workspaces (3 fields)
Top-level containers (organizations or personal spaces).

| Field | Description |
|-------|-------------|
| Workspace ID | Unique identifier |
| Name | Workspace name |
| Is Organization | Whether it's an organization vs personal workspace |

# Analysis Examples

## Task Completion Trends
Track daily, weekly, or monthly completion rates with breakdowns by:
- Assignee
- Project
- Task type (milestone vs regular task)

## Workload Distribution
Analyze task assignments:
- Open tasks per team member
- Overdue items per assignee
- Task completion rate by person

## Project Portfolio Health
Monitor project status:
- Projects by status (on track, at risk, off track)
- Projects past due date
- Timeline adherence by team

## Deadline Performance
Track how well the team meets deadlines:
- Tasks completed on time vs late
- Average days before/after deadline
- Deadline adherence trends

# Best Practices

- **Start with Tasks**: The tasks object contains the richest data for productivity analysis
- **Enable Snapshotting**: Track how task status changes over time
- **Combine with Projects**: Blend tasks + projects for context on which projects have bottlenecks
- **Use Tags**: Asana tags can segment tasks for deeper analysis (e.g., by priority, category)

# Troubleshooting

## Connection Issues
- Verify you have access to the Asana workspace
- Ensure the workspace is selected during connection
- Check that required permissions are authorized

## Missing Data
- Tasks only include tasks you have access to
- Archived projects are included but marked as archived
- Some fields require specific Asana plan features