# Make data-driven decisions with the Asana API and Asana2sql

> Asana’s API opens up exciting possibilities for integrating the information collected in Asana with the other tools you already use.

Source: https://asana.com/inside-asana/make-data-driven-decisions-with-the-asana-api-and-asana2sql

## Make data-driven decisions with the Asana API and Asana2sql

As part of our initiative to enable teams to track anything (and everything), we recently launched [custom fields](https://blog.asana.com/2016/09/track-anything-with-custom-fields/). Teams have already used custom fields to collect data on a variety of workflows, from tracking job applicants and software bugs to managing VC deal flow and DNA synthesis.

For an organization to truly thrive, it requires more than seamless collaboration. Managers also need an overview of what’s happening across multiple teams quickly and accurately. Asana’s API opens up exciting possibilities for integrating the information collected in Asana with the other tools you already use. And with [Asana2sql](https://github.com/Asana/asana2sql), an open source integration that lets you export Asana projects into a common format, you can run more complex and powerful queries on your data.

## What is Asana2sql?

Asana2sql is a Python script that generically transforms Asana projects into a database. The integration can handle creating tables, exporting data, synchronizing data, mapping to various database types and more. For instance, you can turn a custom field into a column in your tasks table. (For more details, check out [Asana2sql on GitHub](https://github.com/Asana/asana2sql).)

## How the Asana recruiting team uses Asana2sql

We use custom fields and templates to do all of our applicant tracking in Asana. We built Asana2sql to empower our recruiting team to increase the quality, quantity, and diversity of candidates accepting offers.

To improve our hiring process, we started by asking a lot of complex questions. For example, which interviewers are more likely to have a candidate accept an offer? Does it make a difference if a founder pitches to a candidate versus another senior engineer? What’s the median time spent by candidates at each stage of the funnel? Which interviewers are the most accurate in their hiring decisions?

To help teams stay on the same page, we keep all of our workflows in Asana. But to answer these questions we need to query the data collected in Asana using tools designed for that purpose (like Redshift and Looker). Asana2sql is just one example of how you can leverage the Asana API to make data-driven decisions about your business.

## Access (only) the data you need

Asana has different reporting options so that you get the insight you want without the noise (and endless status meetings and emails) you don’t want. The [Asana dashboard](https://asana.com/guide/help/fundamentals/dashboards) provides high-level overviews of projects as well as status reports. You can get deeper insight using a [reporting app.](https://asana.com/apps/?category=reporting) For example, our [Google Sheets integration](https://asana.com/apps/google-sheets) lets you pull data from Asana projects to create custom reports and visualizations. With our open API, you can export your data to business intelligence tools to answer questions about specific workflows.

We’ve made Asana2sql open source and welcome pull requests. As more users explore the power of custom fields, we’re excited to see how you use our API to do more with the data created in Asana.

- [擴展 LunaDb，我們內部的宣告式資料載入系統](/zh-tw/resources/scaling-lunadb)

工程

#### 平台工程師

在 Asana，我們建立了一個名為 LunaDb 的資料載入系統，作為我們 Web 應用程式的骨幹。 儘管名字如此，但它並非資料庫。 相反地，它是一個類似 GraphQL 的系統，用於以宣告式方式擷取資料，基本上是一種載入最新版本資料和所有未來更新的方法。我們最初在 2015 年推出 LunaDb，作為對後端基礎架構的徹底重寫¹。 此新系統的核心元件是同步 ...

- [Asana 如何讓我成為更有效的工程經理](/zh-tw/inside-asana/asana-makes-me-effective-engineering-manager)

工程

#### 資料基礎結構工程經理

As an engineering manager, I need to keep track of so many things. I have my own personal to-dos that I need to prioritize, making time for focused work while also handling incomi ...

- [擴展我們的無效管線：第 1 部分](/zh-tw/inside-asana/scaling-invalidation-pipeline-part-1)

工程

#### 平台工程師

At Asana, our invalidation pipeline is a key part of implementing near-realtime reactivity in the webapp. Reactivity is how each-and-every Asana tab keeps up-to-date with the lat ...

- [Make data-driven decisions with the Asana API and Asana2sql](/zh-tw/inside-asana/make-data-driven-decisions-with-the-asana-api-and-asana2sql)

工程

As part of our initiative to enable teams to track anything (and everything), we recently launched custom fields. Teams have already used custom fields to collect data on a variet ...

- [工程](/inside-asana/engineering-spotlight)