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
- Create a new dataset in Scoop
- Select Asana from the application list
- Authorize Scoop to access your Asana workspace
- Select which workspace to connect (if you have multiple)
- Choose your analysis template or customize
- 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 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
Updated 2 days ago