Asana connector

Use your Asana data for reporting, automation and AI.

Data Panda brings your Asana data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your project leads, operations and finance teams use every day.

Data Panda Reporting Automation AI Apps
Asana logo
About Asana

Work management that also gets reported on.

Asana was founded in San Francisco in 2008 by Dustin Moskovitz and Justin Rosenstein, both from Facebook's early engineering team. The company went public on NYSE in September 2020 and, as reported in September 2022, serves around 131,000 paying customers, from product and marketing teams to operations and engineering at the likes of Uber, IBM and AB-InBev. The platform is built around Projects, Tasks, Goals and Portfolios, with AI Teammates added in late 2024 to cover routine coordination work.

For operations and project leaders, Asana is the system of record for how work is planned, assigned and closed. Built-in dashboards and portfolio views cover the day-to-day view well. The harder questions, like how lead time on product launches drifted quarter over quarter, which teams are carrying the roadmap, or whether goal attainment holds up against planned milestones, sit across Asana and the systems around it. Pulling Asana into a warehouse is how those questions stop being a slide someone rebuilds before every steerco.

What your Asana data is for

What you get once Asana is connected.

Project and portfolio reporting

Lead time, throughput, goal attainment and portfolio health in one place, aligned across teams.

  • Project lead time and task cycle time per team
  • Goal attainment versus planned milestones per quarter
  • Portfolio load, blocked tasks and slip rate by owner

Process automation

Turn CRM, support and engineering events into the right Asana work, without someone copying a ticket each morning.

  • Create project kickoffs from closed-won deals in CRM
  • Escalate support tickets into engineering tasks with context
  • Close tasks when the linked pull request merges

AI workflows

Put project, task and comment history behind AI that understands how your team delivers in practice.

  • Slip-risk scoring on open tasks based on comment and assignee history
  • AI summaries of project status for weekly updates
  • Intake triage that routes new requests to the right team and template

Custom apps on your data

Small operations tools that sit on Asana data instead of another rule engine inside the product.

  • Capacity planner showing task load per person across projects
  • Goal-to-deliverable tracker mapping tasks to business goals
  • Client-facing project portal with read-only Asana views
Use cases

Use cases we deliver with Asana data.

A list of concrete reports, automations and AI features we have built on Asana data. Pick the one that matches your situation.

Project lead timeTime from project creation to completion, per team and project type.
Task throughputCompleted tasks per week, per team and assignee.
Goal attainmentGoal progress against planned milestones and due dates.
Portfolio slip ratePercentage of projects finishing after their planned end date.
Capacity and loadOpen task load per person across active projects.
Stuck task alertsTasks with no activity for N days, by project and assignee.
Custom field analyticsReporting across custom fields like priority, effort or stage.
Intake response timeTime from form submission to task assignment and first activity.
Cross-team dependenciesBlocked-by and blocking links between teams, visualised.
Campaign executionMarketing projects tracked against campaign outcomes in GA4.
Release cadenceEngineering releases tied to merged PRs and completed tasks.
Client project viewExternal-safe project status exposed to customers or sponsors.
Real business questions

Answers you will finally get.

How has our project lead time moved this year?

Median and 90th-percentile lead time per project type, per quarter, with the teams and template changes that moved the number. Project leads see drift in time to steer, rather than in a retro six weeks after the quarter closes.

Are our goals tracking against the real work?

Goal progress joined to the tasks and projects tagged against each goal, compared to the planned milestones. Where a goal is green in Asana but the underlying tasks are slipping, the gap shows up as a number instead of a gut feeling at the next OKR review.

Which teams are carrying the portfolio?

Completed-task throughput, project ownership and slip rate per team, ranked across the portfolio. Leadership sees who is over-loaded and who has capacity, without every team manager running their own dashboard the morning of the planning call.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Project-level effort and slip rate next to budget. You see which projects really consumed the quarter, instead of reading about it after the fact in a steerco slide.

For sales leaders

Deal kickoffs and onboarding projects tied back to the deal record. You see where sold-work stalls in delivery before the customer opens a ticket about it.

For operations

Lead time, throughput and cross-team blockers in one view. The weekly ops sync runs on data that was there all week instead of a portfolio snapshot someone rebuilt that morning.

Ideas

What you can automate with Asana.

Pair with HubSpot

Turn closed-won deals into project kickoffs

Deals that close in HubSpot create the onboarding or delivery project in Asana from the right template, with the account, contact and sold-scope attached. Status back to HubSpot keeps sales informed without a weekly handover meeting, and finance sees which sold scopes have started and which are still sitting on someone's queue.

Pair with Salesforce

Link enterprise delivery to the Salesforce opportunity

Opportunities that close in Salesforce produce the delivery project and its milestones in Asana, keyed on the account. As tasks close and goals move, the opportunity record shows delivery health, so CSMs and account execs walk into QBRs with actual project status rather than a call with the project lead the day before.

Pair with Intercom

Escalate support issues into engineering tasks

Intercom conversations tagged as bugs or feature requests create Asana tasks in the engineering project with the conversation, customer tier and repro steps attached. When engineering closes the task, the status flows back into Intercom so support can follow up the customer, instead of a weekly spreadsheet of open escalations.

Pair with GitHub

Keep Asana tasks and GitHub pull requests in step

Branches and pull requests in GitHub map to the Asana task they implement, and task status follows the PR lifecycle: in review, merged, deployed. Engineering managers see cycle time per task next to PR review time, and release notes write themselves from the tasks that shipped in the window.

Data model

Tables we make available.

These are the 14 tables we currently pull from Asana into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Attachments
  • Custom Fields
  • Portfolios
  • Project Memberships
  • Projects
  • Sections
  • Stories
  • Tags
  • Tasks
  • Team Memberships
  • Teams
  • Users
  • Workspace Memberships
  • Workspaces

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Asana data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Asana to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Asana connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Do custom fields on tasks and projects come across?

Yes. Custom fields land in the warehouse next to tasks and projects, so fields like priority, effort estimate, stage or client become reportable alongside the core Asana data. When your admin changes a field definition we track the shift so downstream reports do not silently drift.

What about Goals and Portfolios?

Portfolios and Goals come across as first-class tables, with their link to the underlying projects and tasks preserved. Goal progress can be recomputed in the warehouse from the real task and project status, rather than relying only on the manual progress updates someone made in the Goal itself.

Will the sync run into Asana's API limits?

Asana's API has per-minute rate caps that vary by plan. We schedule reads around them and use incremental extraction where the API supports it, so large portfolios with thousands of tasks keep syncing without burning through the quota your in-product integrations also depend on.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Asana setup and the systems around it. Together we pick the first thing worth building.