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	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)

Asana