Cognition360 Report Catalog

Marnel Catlett
Marnel Catlett
  • Updated

Our most commonly used reports by app.  Please note, we have a lot of reports so when you start with us, we give you only a curated list of reports that will help get you started on your journey of discovery.  Our reports are jam packed with actionable insights, so we start you off slow. 

For any of the reports listed below not initially visible in your apps these will be listed as Add-On reports. If you have a business need for any of these reports feel free to submit a Support Request to request them. 

If you are looking for something that you don't spot immediately, please use the Getting Started report in the Getting Started App to discover which reports will answer your questions the best.  Between the "Core Reports" and the "Add-On reports" page you can filter by using the easy-to-use checkbox to show only those reports that apply to your needs. 

Have an idea for a new report?  Find out how to submit it to our community for review.

 

Get Started Workspace

  • Get Started with Cognition360 - Start here! Discover the reports, webinars and articles that will get you from onboarding to accelerating in no time.

Agreements Workspace

Core

  • Agreement Cross Sell – view showing which customer has an active agreement and against which agreement type. Allows you to see which customers could be sold/upgraded to another agreement type that they are currently not on.
  • Agreement Renewals – view showing which agreements have ended in the last 30 days, are ending in the next 30 days, are ending in the next 31-90 days. Based on the value of the End Date of the agreement. Plus, any agreement that is close to a yearly anniversary.

Add-On

  • Agreement Additions – View current additions on agreements.
  • Agreement Labor Forecast – shows the impact of additional MMR for tickets and labor per month over the first year of taking on a new agreement.

Benchmarks Workspace

  • Ticket Quality Benchmark – report showing the benchmark value for Ticket Quality. This benchmark is a combination of nine measures on the ticket data across Type, Subtype, SLA, Contact Attached etc. Report information page on the report details the measures included in the benchmark and how the overall score is calculated.
  • Time Entry Benchmark – report showing the benchmark value for Time Entry Quality. This benchmark is the lowest either the Timeliness or Utilization values for the period selected. Report details by time entries the reason for the timeliness score so that users can see how they can improve their scores. Overlap time data is also available in this report.

Customer Workspace

Core

  • Customer Interactions – shows data on labor touch points for each customer in relation to user devices managed/recorded for that customer and by customer staff. Allows the user to see which customers and customer staff are generating the most tickets and associated labor. Report has a self-service page to allow for root cause analysis across interactions per ticket based off of dimensions selected by the user.
  • Technology Business Review – shows TBR data on Ticket & Agreement metrics on Active and Closed tickets, tickets entered and resolved in last and previous months and quarters. Common Issues data on who is submitting tickets, with ticket Type, Subtype and Item analysis. Customer Satisfaction data if it is available CW Manage. Computer Information from the configuration device data.

Add-On

  • Customer Operational report – Internal report that provides TBR/QBR style data on tickets. View active and resolved tickets, filter by customer or view all customer data.
  • Customer Review – TBR type report (see below is this list) that allows the user to see ticket and labor information for a customer for a period of time. For tickets, report shows how tickets are logged, for what common issue, by contact and board.
  • Customer Rating– report uses financial and project data to rate each customer across Gross Margin, Current MRR, Total Revenue and Project Labor. With a score applied to each metric, where the metric values are divided into groups of ten based on the split between top and bottom values. The weighting for each metric is applied to achieve the Customer Rating score. Customer Quality Score is a metric that compares.

  • Customer Product - QBR type report that allows the user to see ticket and labor information for a customer for a period of time. For tickets, the report shows how tickets are logged, for what common issue, by contact and board.
  • Stale Customers - View customer data by last invoice date, to see which active customers can be categorized as stale.

Finance Workspace

Core

  • Agreement Hard Costs – report to allow the user to see all hard costs (costs on agreement additions) in one place. Quickly see additions with zero cost or additions with a cost higher than the price. Compare costs for an addition across all agreements to check the correct costs are applied.
  • Agreement Invoice Comparison – review agreement invoicing for last, current and next period. See which agreements are showing differences, allows the user to quickly review month on month differences ahead of billing to customers.

  • Agreement Profitability – profitability of agreements with tracking over time of the agreement value changes versus actual labor. Report also shows trends on monthly Margins and Billing (Effective) rates.
  • Common Issues – analyze common issues your organization is working on over a selected date range compared to the last 12 months. Across ticket Type, Subtype and Item for tickets and labor (hours/Costs).
  • Customer Profitability – profitability across labor per customer for Agreement, Project and Service tickets. View by select monthly period.

  • Project Profitability – profit reporting for projects. Shows Closed and Active data, across labor and overall project profit.
  • Time Entry Billing – view unbilled billable/invoiceable time entry data for Project and Service (Non-Agreement) tickets. Report allows the user to identify billable labor for the current and past periods that could be invoiced.

Add-On

  • Quote to Cash – report allows the user to view Won opportunity data and the related billing/invoice data from CW Manage. View which opportunities are yet to be invoiced in full/or partial based on the expected opportunity revenue. Also see the lag for invoicing to be sent on Won opportunities.

  • Service Profitability – profit reporting for service (time and materials) tickets.

  • Staff Profitability – profitability by Team and Staff. Billable amount is adjusted for fixed project and ticket data. Agreement data is that labor applied to the agreement only

  • Invoice Payments – review all invoice data in CW Manage.

  • Agreement Lifetime Value – view agreement data over the life of the agreement. Contains logic to show potential lifetime value of new MRR, based on the current agreement history.

  • Agreement Additions (New - Cancelled) – View new or cancelled additions for a time period. Useful report for account managers to confirm that changes to agreements have been made.

  • Agreement Churn – information on agreement churn based on quantity and agreement value.

  • Agreement Future Billing – Report takes the agreement data and projects the value to be billed each month, based on the values currently stored in ConnectWise Manage. When an agreement is set to expire in the future, it will only be reported up to that date. Likewise, for additions all future expired and new/effective dates are considered in the data reported.

  • Labor Work Type Costs – analyze data on labor work types recorded and the associated staff costs. See which areas of time entry are recording the highest staff costs. View splits on Agreement, Project, Service and Charge Code costs.

  • Agreement Addition Billing – report shows additions/products billed on the agreement over historical periods. This allows the user to view changes in billing at the addition level. View the data at the Agreement Type level and onwards by Customer and Agreement. Or view from the Addition level by product Class, Type, Category, Subcategory and Product ID. Drill through is available down to the Product ID and Billing level, which allows the user to see the fluctuations in billed for an addition over time.

  • Fixed Fee Tickets - Profit report for tickets marked with a fixed fee amount.
  • Invoice Payments - Review all invoice data in CW Manage.
  • Invoiced Labor - Analyze labor data that has been marked as invoiced.
  • Project Job Costing - Analyze opportunity and project data, reviewing the items recorded on the opportunity and how they convert to a project. With what is delivered in the project. Review estimated versus actual revenue, costs, profit and margins.

 

Procurement Workspace (Add-On)

This workspace is not loaded as a part of Core Reporting. Available upon request.

  • Bill of Materials - Track what materials were shipped
  • Conversions - Reporting on Conversions across your PSA.
  • Procurement Products - Report shows product data for Sales Orders or Purchase Orders. View data on the SO or PO status to track the progress of the product.
  • Product Catalog - Details on your entire Product Catalog
  • Product Received Not Invoiced - A high level overview of what still needs to be billed.
  • Products Sold - View product procurement data. For products sold on Sales Orders, Ticket or Projects. See which products are sold in a period and to which customers. See the products a customer has purchased.
  • Sales Orders Back Orders - View products yet to be fulfilled on Sales Orders
  • Sales Orders - Analyze data on active and closed Sales Orders.

 

Projects Workspace

Core

  • Active Project Tickets – view individual project data to quickly see the progress on a project. Report and views could be presented to a customer as part of the project management process.

  • Project Summary – view active or closed projects across your organization, project manager or customer. See data on which projects are running on track for budget and those which are not. Drill through to project phase, ticket and labor data. Report also shows information on active project scheduled resources and resource schedules across all projects. This allows you to plan resources for future projects.
  • Resource Availability Planning – schedule data presented to show which Team/Resources have capacity available to take on addition work i.e. a new project. Requires the use of the CW Schedule module to ensure all time is schedule in order to see available capacity.

Add-On

  • Project Audit Analysis - Analyze data from the project audit logs.
  • Project Opportunity Revenue - View recurring revenue amounts on opportunities, where the opportunity also contains converted project data. Allows the user to view potential recurring revenue that may start to invoice once the project is completed.
  • Project Phase Details – summary of project phases and tickets associated to the phase. See the performance of the phase in relation to delivery requirements.

  • Project Resource Efficiency – data on staff efficiency for project tickets. Detailing by staff the project tickets that are under and over budget.
  • Project Resource Labor - Review labor for resources on projects. For both Closed and Active projects. Review labor recorded against ticket and project budgets.
  • Project Schedule Compliance – review of schedule data to recorded time. Allows the user to check if schedule time has been recorded on project tickets.

  • Project Team - View roles and resources associated with a project team.
  • Project Unbilled Labor - Labor data on projects that is unbilled (not attached to an invoice).
  • Project Work Plan - Report version of the workplace from CW PSA.

Sales Workspace

Core

  • Opportunity Dashboard – view opportunity data based on when the opportunity was created. View won, lost and open data.

  • Products Sold – view product procurement data. For products sold on Sales Orders, Ticket or Projects. See which products are sold in a period and to which customers. See the products a customer has purchased.

  • Sales Dashboard – view historical and current opportunity data. View by opportunity status, sales & margins by Type, Sales Rep and Customer.

  • Sales Pipeline – report shows pipeline opportunity data.

Add-On

  • Sales Activities – view activities on Opportunities for Closed and Open activity data.

  • Sales Audit Analysis – analyze audit data on the Opportunities.

  • Sales Pipeline Tracker – report shows win ratio calculated on historical data of when Opportunity was open and for each month it was expected to close.

  • Sales Ranking – reports on sales staff quotas and Opportunities won.
  • Sales Revenue Tracker – view MRR, Product and Professional Service opportunity data. This report can track against monthly targets if they are available.

  • Sales Stage Tracking – audit data on Opportunity showing movement between Stages. Allows the user to see the average time between stages.

  • Ticket Products – report shows data for tickets with a Product attached to it. Can be useful for procurement reporting if you convert a product sale to a ticket rather than a sales order.

Service Delivery Workspace

Core

  • Active Tickets – view on active tickets by board. Information shown by last update and ticket age so that you can see how well tickets are being actively managed in your organization.

  • Common Issues (Service Delivery) – analyze common issues your organization is working on over a selected date range compared to the last 12 months. Across ticket Type, Subtype and Item for tickets and labor.

  • Data Overview – direct report to the Cognition360 data warehouse that allows you see how up to date your data is in the data warehouse. Report is a useful to check that report data is up to date.

  • Service Ticket Budgets - Review ticket actual time recorded against the ticket budget hours.

  • Team Utilization – utilization and realization data for teams and team staff. Trending over the last 12 months and comparison by team staff.

  • Technician Efficiency – data on staff efficiency for all customer tickets and labor.
  • Ticket Daily Stats – view showing daily trends for entered, closed and active tickets. Report shows trending and forecasting which can be useful for resource allocation.
  • Ticket KPIs - shows ticket KPIs and metrics for Closed tickets over a selected period. Filters available on Business Unit and Board. Data views for Business Unit, Board, Customer and Technician who resolved the ticket.

  • Ticket SLA Insights – view showing SLA percentages achieved by Response, Plan and Resolved. Uses the CW Manage SLA data and allows you to see the data at an Organization, Board or Customer level.

  • Ticket SLA Modeling - Model changes to your SLA targets. See the impact of increasing or decreasing the SLA targets based on your actual ticket data.

  • Work Type Usage – analyze data on labor work types recorded and the labor hours recorded. See which areas of time entry are recording the highest labor hours. View splits on Agreement, Project, Service and Charge Code hours.

Add-On

  • Active Ticket Closure Analysis – report uses the ticket issue to calculate an average resolution time for closed tickets over the past 6 months. Then applies the average resolution value to the current active tickets. Taking away time already spent on the active ticket, it shows the potential time to close all active tickets, based on the historical resolution time for similar tickets.

  • Charge Codes – analyze time recorded against charge codes.

  • Configuration Tickets – view of configuration data assigned to tickets. See which configuration is generating the most tickets and labor.

  • Configurations – view of configuration data held in CW Manage.
  • Customer Teams – review CW Manage customer team data. See which staff are recorded under which Role for the customer. See which staff are recorded under which Role.
  • Labor Allocation - View labor recorded by business/billing unit. Business/Billing unit will be that recorded on the time entry, rather than the default on the staff member recording the labor.
  • Labor Capacity Overages – shows data for daily total labor hours recorded by staff that is over their daily capacity. Allows the user to investigate if overages are billable or not.

  • Non Business Hours Labor - View time entry records entered outside of your business hours. This will be labor recorded before the start of the business day and also labor recorded after the close of business time.
  • Reopened Tickets – report to view reopened tickets. Reopened tickets are tickets that have gone through the resolved/closed cycle in CW Manage. Then are set to a ticket status other than resolved/closed and labor is recorded after the initial resolved/closed datetime.

  • Schedule Compliance – review of schedule data to recorded time. Allows the user to check if schedule time has been recorded. 

  • Service Board View - View tickets by board, similar to Board view in CW PSA.
  • Staff Skills -Report that surfaces skills data recorded in CW PSA against the member data. Useful for reviewing the skill level available for a particular skill or set of skills.
  • Team Utilization (Last 7 Days) – version of team utilization for the last 7 days. Useful for setting up as a subscription. 

  • Technician Review – TBR style report for technician data. See all key metrics Utilization, Efficiency, Active Ticket load and Issues Worked On for staff in one report.

  • Ticket Audit Analysis – view ticket audit data. Report can be used to analyze any of the ticket audit values e.g. see the tickets moving between boards in CW Manage.
    Ticket Labor Analysis – view labor against Customer, Board and Ticket Type/Subtype.

  • Ticket Lifecycle – view that uses the ticket audit data to show by category which statuses tickets are in the most time for.
  • Ticket SLA Breaches – Report shows data on SLA breaches for Tickets. 
  • Tickets Closed -Analyze closed ticket data.
  • Tickets Open -Analyze open ticket data.
  • Time Entry Analysis - View time entry data by the work type utilization flag in CW PSA.
  • Time Entry Audit Analysis - Analyze time entry audit log data.
  • Timesheets - View timesheet data from CW PSA, see approved and unapproved timesheet data.

Add-On reports available upon request*