Advanced Analytics for Asana
Integrate Asana data with Zoho Analytics, Monitor and manage project execution, identify any bottlenecks in project execution. Gain visibility into potential roadblocks in project execution and devise data-driven strategies to mitigate them. Optimize your workflow for increased productivity with AI driven analytics.
In this Page
- Setup
- Data Sync Frequency
- Modules and Fields
- Data Synchronization Failure between Asana and Zoho Analytics
- Manage Data Source - Asana
- Data Modelling and Preparation
- Visualize your Asana Data
- Sharing and Collaboration
Setup
Users with Administrator Privileges can configure the connection between Asana and Zoho Analytics.
- Click Import your Data > Project Management > Asana.
- Asana Advanced Analytics setup will open, Click Next to proceed.
- Click Authenticate Asana.
- Provide your Asana username and password to verify your identity. Upon successful authentication, you will be redirected back to Zoho Analytics.
- Choose the Asana Workspace Name from which you wish to import the data.
- All projects under the selected workspace will be displayed. Select the projects you want to import, or enable the Projects checkbox to import all the data.
- Enable Import new projects automatically to sync any new projects added in Asana.
- Selecting Import new Projects automatically syncs data each time a new project is added.
- Choose the Modules and Fields to be imported.
- Select the Data sync interval in which the data should be imported.
Note:
- The initial fetch might take a few minutes depending on the volume of the data to be imported. An email and an in-app notification will be sent once the initial fetch is complete.
- The setup process can sometimes fail for a variety of reasons. In this case, we request you to access the Data Sources tab and click the Retry link to import again. If the issue persists, write to support@zohoanalytics.com
Data Sync Frequency
Zoho Analytics offers flexible sync schedules to ensure that your data is always up-to-date for effective analysis. These schedules allow you to automate the process of updating your data, ensuring that your analyses are based on the latest information.
- 1 Hour (Enterprise plan only)
- 3 Hours(Standard plan and above)
- 6 Hours (Standard plan and above)
- 12 Hours (Standard plan and above)
- Every day
Modules and Fields
| Modules | Fields |
| Projects | ID, Project Name, Created At, Completed At, Due On, Start On, Modified At, Color, Notes, Owner ID, Permalink URL, Archived, Completed, Team ID, Workspace ID, Workspace Name, Status Title |
| Tasks | ID, Task Name, Actual Time Minutes, Approval Status, Assignee ID, Assignee Section, Completed, Completed By, Completed At, Created At, Modified At, Due On, Due At, Notes, Number Of Likes, Number Of Sub Tasks, Parent Task, Permalink URL, Start On, Start At, Tag ID, Resource Subtype, Workspace ID, Workspace Name |
| Users | ID, Name, Email |
| Project Memberships | Project ID, User ID |
| Tasks Vs Projects | Task ID, Project ID |
| Teams | ID, Name, Description |
| Team Memberships | ID, User ID, Team ID |
| Tags | ID, Name |
Data Synchronization Failure between Asana and Zoho Analytics
Data Synchronization can fail due to any of the following reasons:
- Authentication Failure
- Connection Error
- Insufficient Permissions
- Modules and fields selected for analysis are deleted in the Asana Application.
In any of the above mentioned cases, the data sync will be paused. You will be notified via email and in-app notification with the exact reason for failure along with the solution.
Refer to Data Sync failure and solutions article for more details.To resolve the sync failure, delete or restructure the views, or restore the specific modules and fields from the source application.
Once you have made the changes, click the Sync now option to resume the data sync. If the issue persists, contact support@zohoanalytics.com.
Manage Data Source - Asana
The Data Sources tab provides essential information to monitor and manage the integration setup. It also allows you to edit the settings as needed. Users with administrator privileges will be able to view and modify the connection settings.
Edit Setup
The Edit Setup tab allows you to add or delete modules or fields, change the schedule interval, and modify other settings specific to the business application.
To modify the settings,
- Click Data Sources > Edit Setup.
- The Edit Setup - Asana dialog will open. Modify the settings as needed and click Save.
Re-Authenticate
Re-authentication will be helpful when the API key or password is changed. In this case, the data sync will be paused, and the administrators must re-authenticate to resume the data sync.
Sync History
The Sync History tab provides details about the data sync for the last 45 days. A successful data sync is marked in green, and a sync failure is marked in red.
To view the sync history,
- Click Data Sources > Sync History.
- A calendar with the Sync History of the last 45 days will open. The date when the data sync has happened will be highlighted. Hover to view the number of times the data had been synced on a specific date.
- Click the date to view more details. Time - Displays the time when the data is synced.Status - Shows whether the sync was a success or a failure.In case of failure, the reason will be displayed. Refer to resolving sync failures article to learn how to resolve the issue and avoid further failure.
Audit History
Zoho Analytics logs all the user activities and system events within the workspace. The following actions are logged in Zoho Analytics.
User Action: Create, Modules Added, Modules Removed, Fields Added, Fields Removed, Schedule Change and Entities Modified, Delete, Take Ownership, Re-authenticate, Sync Now, Retry.
System Action: Plan upgrade or downgrade.
Remove Data Source
Zoho Analytics allows you to remove the integration if needed. Removing the integration will suspend further data synchronization. The data tables and the reports will be available.
Click the Settings icon in the Data Sources tab, and select Remove Data Source from the drop-down menu.
Data Modeling & Preparation
Zoho Analytics allows you to combine data from various sources such as Files, Feeds, Databases, and Business applications for in-depth analysis. Query Tables allow you to combine data from different tables to create reports. The SQL Query Suggester helps to build complex queries.
Zoho Analytics auto identifies similar columns and provides suggestions for lookup while importing. Click here to learn more about joining tables.
Visualize your Asana Data
- Zoho Analytics offers a wide range of visualization types to conduct your analysis. Refer to the Creating Reports section to learn more. The chart type primer lists all the viz types available in Zoho Analytics.
- With Predictive analytics, forecast future trends, detect anomalies, and segment data using Cluster analysis.
- Find the What, Why and How behind any outcome with Zia Insights.
Sharing and Collaboration
- Use collaborative reporting and analytics with fine-grained permission control over your shared data and reports with your colleagues & friends.
- Efficiently collaborate with your users by setting up real-time commenting on a shared view.Publish reports for wider consumption.
- Embed reports/dashboards within your websites, web applications, and blogs.
- Export, Email, and Print reports in a variety of formats.Get the mobile apps (optimized for both iOS and Android platforms) and access the reports and dashboards on the go.
Technical Support
We offer 24x5 technical support (Monday to Friday). In case if you need our assistance, kindly do mail us your questions to support@zohoanalytics.com.
You can also reach out to us on our toll-free numbers.
United States: +1 (888) 900 9646
United Kingdom: +44 (20) 35647890
Australia: +61-2-80662898
India: +91-44-6965 6060