Asana + Orcabase
Which projects are running late?
Sync Asana through Fivetran and ask which projects are behind, who’s overloaded and how fast work gets done, in plain words.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which projects are behind schedule?
Two projects are behind: the holiday gift box and the new website.
- The gift box has 12 overdue tasks, most of them in packaging.
- The website has 7 overdue tasks, all waiting on copy.
- Everything else is on track.
Overdue tasks by project
How I got this· 4 steps
- Looked at your Asana projects and tasks
- Found tasks past their due date
- Counted overdue tasks by project
- Grouped them by section
Example answer. Numbers are illustrative.
In plain words
How do I report across Asana projects?
Asana shows one project at a time. Questions across all of them, like who’s overloaded or which launches are slipping, need everything in one place. Fivetran copies your tasks, projects and comments into a database Orcabase hosts for you.
Ask in plain words, and get the answer with a chart and the steps behind it.
Ask in plain words
What you can ask about your Asana data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
Which projects are behind schedule?
Who has the most open tasks?
How many tasks did we finish each week?
How long do tasks take from created to done?
Which tasks have no owner or due date?
What share of tasks finish on time?
Which sections do tasks get stuck in?
Show me tasks completed by project and month.
What comes in
Your Asana data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Tasks
Projects and sections
Comments and changes
Users and teams
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Asana data.
Overdue tasks
Open tasks past their due date.
On-time completion
Share of tasks completed by their due date.
Open tasks per person
Open tasks assigned to each person.
Time to complete
Days from task created to completed.
Dashboards to start with
Your Asana numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Projects
3 charts- Overdue tasks by project
- On-time completion
- Tasks completed by week
Team
3 charts- Open tasks per person
- Tasks without an owner
- Time to complete
Better together
Ask across Asana and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect Asana, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Asana. Pick the database to sync into.
- 2
Connect Asana on Fivetran’s page
Sign in to Asana on Fivetran’s page and allow access.
- 3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
- 4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Asana data.
What you’ll need
- An Asana login with access to the projects you want.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- How it connects
- Synced by Fivetran
- How fresh
- Every 6 hours, as standard.
- Where your data lives
- A copy in a database Orcabase hosts for you, with its own folder for each app.
- Who can set it up
- An admin in your organization.
- Your login
- You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
- Cost
- Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Does it include comments and task changes?
Can Orcabase change tasks?
Do I need a Fivetran account?
How fresh is my Asana data in Orcabase?
What does syncing cost?
Your Asana data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.