Zoho Analytics integration | Online help | Zoho Projects

Zoho Analytics for Projects

The Zoho Projects Advanced Analytics powered by Zoho Analytics, our online reporting & business intelligence service, allows you to slice and dice your projects data. Packed with 50+ ready made reports and dashboards that assist you in tracking and enhancing your project deliverables. You can also create your own ad hoc reports to analyze your projects data the way you want. You can view and share reports with your team members to enable collaborative analysis of your project information.

Click to learn more on access privileges for Zoho Apps integration.        

Benefits

  1. Create and share reports for your Projects.
  2. Group reports based on different project modules.
  3. Find out the revenue generated per project member for each project.
  • The Reports tab in Admin section is enabled only in the Premium and Enterprise paid plans.
  • The connector is available in all paid plans of Zoho Analytics.
  • The custom fields and custom statuses for tasks can also be viewed in Zoho Analytics from now on.

Get to know more about Sharing and Collaboration in Zoho Analytics at https://www.zoho.com/analytics/help/sharing/ 

List of Fields that are Synced

The following fields under each module are synced with Zoho Analytics.

Projects

  1. Project ID
  2. Project Name
  3. Description
  4. Owner ID
  5. Status
  6. Bug Prefix
  7. Group ID
  8. Start Date
  9. End Date
  10. Billing Method
  11. Currency
  12. Rate Per Hour
  13. Project Budget
  14. Budget Amount
  15. Budget Hours
  16. Primary Client ID
  17. Created Time
  18. Last Modified Time
  19. Is Archived
  20. Completed On
  21. Fixed Cost
  22. Budget Threshold
  23. Layout ID
  24. Track Budget
  25. Is Completed
  26. Created By
  27. Modified By
  28. Task Prefix
  29. Key
  30. Tags and custom fields
  31. Cost per hour
  32. Revenue Budget

Milestones

  1. Milestone ID
  2. Milestone Name
  3. Start Date
  4. End Date
  5. Status
  6. Flag
  7. Owner ID
  8. Completed Date
  9. Project ID
  10. Created Time
  11. Last Modified Time
  12. Budget
  13. Threshold
  14. Tags and custom fields
  15. Revenue Budget

 Tasks

  1. Task ID
  2. Task Name
  3. Tasklist ID
  4. Tasklist Name
  5. Milestone ID
  6. Parent Task ID
  7. Parent Task Name
  8. Root Task ID
  9. Created By ID
  10. Owner IDs
  11. Start Date
  12. Due Date
  13. Completion Date
  14. Completion Percentage
  15. Priority
  16. Status
  17. Project ID
  18. Owner Map
  19. Created Time
  20. Last Modified Time
  21. Duration
  22. Duration Unit
  23. Description
  24. New Status
  25. Key
  26. Rate Per Hour
  27. Billing Type
  28. Budget
  29. Threshold
  30. Tags
  31. Dependency Status and custom fields
  32. Cost per hour
  33. Revenue Budget

 Task Work Hours Planned 

  1. Task ID
  2. Owner ID
  3. Date, Day
  4. Work Hours Planned

Task Bug Mapping

  1. ID
  2. Task ID
  3. Bug ID
  4. Is Associated From Task
  5. Associated By
  6. Associated Time

 Issues

  1. Project ID
  2. Bug ID
  3. Bug Title
  4. Reporter ID
  5. Created Date
  6. Last Modified Date
  7. Assignee ID
  8. Flag
  9. Due Date
  10. Classification ID
  11. Classification
  12. Severity ID
  13. Severity
  14. Status ID
  15. Status
  16. Reproducible ID
  17. Reproducible
  18. Module ID
  19. Module
  20. Description
  21. Milestone ID
  22. Completed On
  23. Is Closed
  24. Escalation Level
  25. Bug Key
  26. Affected Milestone ID
  27. Rate Per Hour
  28. Tags and custom fields
  29. Cost Per Hour

Timesheet 

  1. Project ID
  2. Log ID
  3. Task ID
  4. Title
  5. Notes
  6. Date
  7. Hours
  8. User ID
  9. Status
  10. Type
  11. Bug ID
  12. Approval Status
  13. Approved By User ID
  14. Approved By
  15. Last Modified Time
  16. Invoice Line Item ID
  17. Invoice ID
  18. Is Timer
  19. Start Time
  20. End Time
  21. Created By and custom fields
  22. Cost Per Hour

Users

  1. User ID
  2. User Name
  3. User Email
  4. Role
  5. Profile
  6. Status
  7. Zpeople Employee ID
  8. ZUID

Project Users

  1. Project ID
  2. User ID
  3. Role
  4. User Email
  5. Rate Per Hour
  6. Status
  7. Budget
  8. Threshold
  9. Cost per hour
  10. Revenue Budget

 Teams 

  1. Team ID
  2. Team Name
  3. Description
  4. Team Email Alias
  5. Team Lead
  6. Created Time
  7. Last Updated Time
  8. Created By
  9. Updated By
  10. Associated Project
  11. Team Users

Tags

  1. Tag ID
  2. Tag Name
  3. Tag Colour
  4. Created Time
  5. Last Updated Time
  6. Created By
  7. Updated By

 Invoices

This table contains invoice id and milestone id mapping

 

  1. Entity ID
  2. Milestone ID
  3. Line Item ID
  4. Invoice ID
  5. Invoice Amount

Project Groups 

  1. Group ID
  2. Group Name

Client Company

  1. Client ID
  2. Client Name
  3. Web Address
  4. Address
  5. City
  6. State
  7. Country
  8. Zip Code
  9. Second Address

Client Projects

  1. Client ID
  2. Project ID

Activate Zoho Analytics Add-on

You can configure any numbers of projects as desired to view and track the project progress with multiple report views.

  1. Navigate to   >  Marketplace Zoho Apps Zoho Analytics
  2. Click Configure.
  3. Select the desired projects.
  4. Select the required data options to sync with  Zoho Analytics
  5. Select the sync frequency. You can schedule the frequency to synchronise data every 3, 6, 12, and 24 hrs.
  6. Click  Save.
  7. Select the required data options to sync with Zoho Analytics
  8. Select the sync frequency. You can schedule the frequency to synchronise data every 3, 6, 12, and 24 hrs.
  9. Click Update Sync to sync the chosen project's data.


A notification mail is sent to you after the project(s) data is synced successfully with Zoho Analytics. Once the sync is completed, you can start accessing the default reports created and create your own reports & dashboards on your projects data.

Global Reports

Once the Project's data is synchronized, you can directly access Zoho Analytics dashboard from Global Reports widget.

  1. Click the Home tab in the top band of your portal.
  2. Navigate to Zoho Analytics under Global Reports widget.
  3. Click View Reports.
  4. Select Reports or Dashboard in the top panel to view the Project's data.

You can access the Zoho Analytics Workspace by clicking the Go to Zoho Analytics button in the upper-right corner. 

View Project Reports

You can view the project reports only after the project data is synchronized into Zoho Analytics and see different types of reports for each module.You will be directed to Zoho Analytics reporting workspace setup for this portal. There can be only one reporting workspace setup for a portal. 

A message about the synchronization status, is displayed if the synchronization is in progress. You can also try to reload the Zoho Analytics page after sometime.

  1. In Zoho Analytics, expand any desired module to display its various report views.
    • You can access the data from different projects module by expanding the "Zoho Projects Modules (data)" folder. And you can access the default reports & dashboards created, by expanding other folders listed.
  2. Select any desired report to view its data.

Default Reports Created

Project and Milestone Reports

By default 50+ insightful reports & dashboards are created. The reports are grouped based on module & functionality under different folders. You can view a range of project and milestone based reports capturing useful metrics such as current status of each project in the portal, tasks that are pending in each milestone, Planned vs Actual Time Spent, Target Milestones vs Actual Completed, Top 5 Delayed Open Milestones and so on. You can click on any of the report to view them. You can also edit the default report, if required.

  • Active Milestones by Project User : Active milestones of each users.
  • Delayed Open Milestones : All delayed milestones along with open tasks and percentage.
  • Milestones Completed Trend by Users : Number of milestones completed by each owner every month.
  • Milestones Duration - Planned Vs Actual : The number of planned days vs the actual time taken for each milestone.

  • Milestones On-time Vs Delayed- Last 3 months: Milestones that are on-time and milestones that have been delayed.
  • Overdue Milestones Age: Age of overdue milestone.
  • Pending Tasks across Open Milestones : Tasks that are pending in each milestone.
  • Project Status Overview : Current status of each project in the portal.
  • Project- Planned vs Actual Time Spent : Actual duration planned vs actual time spent in the project. This reports is based on tasks.
  • Slowest Milestones: The scheduled variance of the top 10 slowest milestones.
  • Target Milestones vs Actual Completed each month : Total milestones to be completed each month vs actually completed milestones. 
  • Tasks Status across all Milestones : Status of tasks across all defined milestones.
  • Top 5 Delayed Open Milestones : Top 5 most delayed open milestones.
  • User-wise Milestone Completion - On-time vs Late : Milestones completion status based on its users.

Task Reports

You can view task reports based on various criteria such as task status in each project, total number of tasks completed by its owners month-wise. You can click on any of the views to display its data based on your requirement.

  • Bottom 5 Members with Least Tasks Closed - Last 3 Months : Bottom 5 members, based on the lowest number of tasks closed in the last 3 months.
  • Members with No New Tasks Assigned - Last 30 days : Project members with no new task assigned in the last 30 days.
  • Project-wise Tasks Status : Task status in each project.
  • Tasks Addition Trend : Number of tasks assigned each month.
  • Tasks Completed so far by Owners : Total number of tasks completed by its owners month-wise.
  • Tasks Completed vs Target by Month : Number of tasks completed every month.
  • Tasks Overdue by Owners : Number of overdue tasks along with its overdue days and percentage of overdue and its owners.
  • Tasks Progress by Owners : Tasks in progress and its owners.
  • This Month - Tasks to be Closed : Tasks to be closed in the current month along with its closed percentage and count of closed tasks.
  • Top 10 Delayed Tasks : Top 10 most delayed overdue tasks.
  • Top 5 Members with Most Tasks Closed- Last 3 Months : Numbers of tasks completed by the top 5 members in the last 3 months.

Timesheet Reports

You can view the timesheet report based on the billing hours such as billable and non-billable hours logged for the projects, timesheet report based on projects and so on. You can click on any of the views to display its data based on your requirement.

  • Average Billable Hours by Project - Last 12 Months : Average billable hours logged in a day for the corresponding projects in the last 12 months.
  • Billable Hours Logged Trend by Projects - Last 12 Months : Trend of billable hours logged for the corresponding projects in the last 12 months.

  • Billable vs Non-Billable hours by Project : Billable vs Non-Billable hours logged for the corresponding project.
  • Bottom 5 Project Members by Billable Hours : Bottom 5 members across projects vs the billable hours.
  • Effective ROI of Projects by Billable Hours : Effective ROI of each project vs the average billable hours logged.
  • Timesheet by Projects and Members : Timesheet report based on projects, users and billable hours.
  • Timesheet Hours Logged by Users - Last 6 Months : Total hours logged by each user in the last 6 months.
  • Timesheet Hours Logged Trend -  Last 12 Months : Trend of logged hours vs months in the last 12 months.
  • Timesheet Hours Logged Trend - Last 30 days : Trend of logged hours vs months in the last 30 days.
  • Top 5 Project Members by Billable Hours : Top 5 project members and their billable hours across projects.
  • Top Projects by Billable Hours : Top projects and their total billable hours logged.

Members / User Reports

You can view users report based on various criteria such as milestone completion status for each user, task status for each user and so on. You can click on any of the views to display its data based on your requirement.

  • Member-wise Milestones Trend : Milestone completion status for each user.

  • Member-wise Tasks Completion Status : Task completion status for each user.
  • Member-wise Tasks Status : Task status for each user.

Billing Reports

You can view billing reports based on various criteria. You can use billing reports to find out details such as revenue generated per project member for each project, top 10 members based on their billed hours and so on. You can click on any of the views to display its data based on your requirement.

  • Billing charges : Billing report for members, projects, billable amount and so on.
  • Bottom 10 Billed Members : Bottom 10 billed members and their billable hours.
  • Effective ROI per Project : Revenue generated per project member for each projects.

  • Projected Revenue : Projected revenue for the coming months based on the number of hours to be billed.
  • Projected Revenue Calculation Table : Calculation table for projected revenue.
  • Projects Revenue This Quarter : Revenue of each project based on their billed hours.
  • Top 10 Billed Members : Top 10 members based on the billed hours.
  • User Hourly Rates-Templates : Template for members and their hourly rates.

Burndown Reports

You can view burndown reports based on various criteria. Burndown reports are used to find the difference between the projected figures and its variance in project management. You can click on any of the views to display its data based on your requirement.

  • Burn Down Milestone Entry Table - Template : Template table for milestone burn down report.
  • Burn Down Projects Entry Table - Template : Template table for projects burn down report.
  • Burn Down Report by Milestone : Burn down report for the selected milestone.

  • Burn Down Report by Project : Burn down report for the selected project.
  • Milestone - Burn Down Calculation Query : Internal query to calculate the burn down metrics for milestones.
  • Milestone Day Wise Progress Calculation Query : Internal query for day-wise progress calculation of milestones.
  • Project - Burn Down Calculation Query : Internal query to calculate the burn down metrics for projects.
  • Project - Day Wise Progress Calculation Query : Internal query for day-wise progress calculation of projects.
  • Timekey : Internal query for calculating the burn down reports.

Bug Reports

You can view bug reports based on various criteria. You can use bug reports to find bugs grouped by owners and status, view pie charts providing the distribution of bugs, categorize bugs by severity and so on. You can click on any of the views to display its data based on your requirement.

  • Bugs by Owners : Pie chart based on bugs distributed across users. By default it filters the bugs raised in the last 3 months.

  • Bugs by Projects : Project-wise bug counts categorized by severity.
  • Bugs by Projects & Owners : Bugs grouped by Project, Owners and Status.
  • Bugs by Who Raised It : Pie chart with bugs based on who raised the bugs.
  • Bugs Created by Severity - Last 30 days : Bugs categorized by severity in the last 30 days.
  • Bugs Fixed by Members - Last 30 days : Bugs fixed by members in the last 30 days.
  • Bugs Overdue by Owners : Count of overdue bugs and their percentage (Overdue/Total), based on Owners.
  • Bugs status by Projects : Summary of bugs status across all projects.
  • Bugs to be Fixed by Projects - This Month : Bugs fixed / to be fixed in each project, categorized by Open and Closed status for the current month.
  • Created vs Resolved Bugs - Last 30 days : Total bug count vs. the resolved bug count in the last 30 days.
  • Pending Bugs across Open Milestones : Count of pending bugs across open milestones, categorized by severity.
  • Planned and Actual Time Spent Per Project : Planned time vs. the Actual time spent in fixing bugs for each project.
  • Planned And Actual Time Spent Per User : Planned time vs. the Actual time spent in fixing bugs by each user.

  • Recently Created Bugs - Last 30 days : Bugs count in the last 30 days, grouped by Open and Closed status.
  • Recently Created Bugs by Severity - Last 30 days : Bugs count in the last 30 days, grouped by severity.
  • Resolution Time - Last 30 days : Total resolution time of bugs closed each day, in the last 30 days.
  • Top 5 Members by Bugs handled : Top 5 members, based on the total number of bugs managed.
  • Top 5 Modules by Bug Count : Top 5 modules, based on the total number of bugs managed.
  • Users bugs workload : Users work load, based on the count of pending bugs and their estimated time for closure. 

Create New Ad hoc Reports:

Once you have integrated Projects in Reports, you can view a variety of insightful reports generated automatically based on your project data. This apart you might also want to do your own analysis and create your own reports. This can be easily done using the easy-to-use drag & drop interface of Zoho Analytics. You can also edit the default reports provided to customize it to your needs using the edit report option. This is similar in flow to that of creating new reports.

To create new ad hoc reports:

  1. Click Create button in the top left corner of the database and select New Report.
  2. Click on the required View type in the new report tab.
  3. Select the required table in your workspace from the Select Base Table dialog box.

  4. Click OK to open up a drag and drop designer to create your chart.
  5. From the Field List on the left panel, select any desired column and then drag and drop the column in X-Axis in Graph tab. Similarly select a column for the Y-Axis and then drag and drop the column in Y-Axis.
    • The data dropped from these columns, is used to construct the axes of the chart/graph to be generated.
    • You can also drag and drop columns in Filters and User Filters tabs to apply selected filters to the report.
  6. Click Click Here to Generate Graph. A report is generated based on the information provided.

  7. Click Save to save the report.

  8. In Name , specify a report name.
  9. In Save in folder, select the desired folder to save this report.
  10. In Description, specify additional information about the report.
  11. Click OK to save the report in the desired module.

Add / Delete Projects

Once you have initially synced few projects in Zoho Analytics, you can later start adding or deleting more projects as desired from Zoho Analytics or from Zoho Projects.

To add / delete projects from Zoho Analytics:

  1. In Zoho Analytics, select your workspace.
  2. Click Zoho Projects and then click Edit Setup.

  3. In Edit Zoho Projects Setup, click Show all Projects.

  4. Select the desired number of projects to add.
    • If required, you can also clear the already selected projects to delete those data from the report.
  5. If required, in Perform Import Every, you can change the frequency of time period for synchronizing the project data.
  6. Click Save to save the newly added projects for synchronization.

The report will reflect the modified project data in the next scheduled import.

See Also


    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Get started with Zoho Sign

            in a few quick steps!

            Download Help Guide





                      Still can't find what you're looking for?

                      Write to us:  support@zohoforms.com


                            




                          

                        Zoho Marketing Automation

                          Zoho Sheet Resources

                           




                              Zoho Forms Resources


                                Secure your business
                                communication with Zoho Mail


                                Mail on the move with
                                Zoho Mail mobile application

                                  Stay on top of your schedule
                                  at all times


                                  Carry your calendar with you
                                  Anytime, anywhere




                                        Zoho Sign Resources

                                          Sign, Paperless!

                                          Sign and send business documents on the go!

                                          Get Started Now


                                              Zoho SalesIQ Resources



                                                  Zoho TeamInbox Resources



                                                          Zoho DataPrep Resources



                                                            Zoho DataPrep Demo

                                                            Get a personalized demo or POC

                                                            REGISTER NOW


                                                              Design. Discuss. Deliver.

                                                              Create visually engaging stories with Zoho Show.

                                                              Get Started Now











                                                                                    • Related Articles

                                                                                    • Checklist for Zoho Projects

                                                                                      The Checklist for Zoho Projects extension lets you create a set of instantaneous to-do lists for your tasks and issues in Zoho Projects. With this extension, you can create checklist templates that can be used in any of your tasks and issues and save ...
                                                                                    • DocuSign for Zoho Projects

                                                                                      The DocuSign extension for Zoho Projects provides users with the e-signature functionality required to quickly complete approvals and agreements. With this extension, you can send documents, view their signing status, and even revoke the document ...
                                                                                    • Getting Started with Zoho Projects

                                                                                      Zoho Projects is an online project management software that helps you run your business with ease. It stands as a comprehensive solution to your day-to-day problems in project management and adds value to your business by leaps and bounds. What Does ...
                                                                                    • Zoho Vault for Zoho Projects

                                                                                      Zoho Vault is an online password manager for teams. If you are struggling with remembering numerous passwords, Zoho Vault can keep them safe for you. It helps to store, share, and manage your passwords from anywhere. Zoho Vault is the best way to ...
                                                                                    • Cancel Zoho Projects Subscription

                                                                                      Cancel the Subscription Plan You can cancel your subscription plan if required. Click your profile picture in the upper-right corner of the Zoho Projects top navigation band. Select Subscription Details to view the pricing details. Click Change Plan ...
                                                                                    Wherever you are is as good as
                                                                                    your workplace

                                                                                      Resources

                                                                                      Videos

                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                      eBooks

                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                      Webinars

                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                      CRM Tips

                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                        Zoho Show Resources