Dashboard & Report Templates with Buildout Keys

Check back each month for our latest dashboard or report template. These also get shared on our Blog, and from our monthly User Showcase webinar. 

How to use: View the public dashboard link, then reference the buildout key to recreate these in your own BrightGauge.  If you'd like to submit your own template to be featured or have any questions, please reach out to success@brightgauge.com

 

Note: Some field names displayed in the keys may vary across datasources (ex: date_opened vs date_entered, board_name vs ticket_current_board) as well as datasets (ex: Ticket Statistics vs Ticket Statistics Last 240 Days). These items, though named differently, should show the same relevant data. Any questions on converting between PSAs, reach out to success@brightgauge.com. 

  

NEW!  CIO Operations Dashboard (Jan 2023 DoTM) - Created by longtime partner Joe Somerville of Network People, this dashboard was designed for the CIO/vCIOs department. It provides the data needed to manage their day-to-day operations on all open client items and pulls from tickets, activities, opportunities, and time entries. It can also be used for goal-setting and historical tracking of client-facing meetings. Be sure to check out the notes on the buildout key to see how they're using ticket types/subtypes, source, statuses, activity types, and work types to gauge the efficiency of their CIO/vCIO team(s). To see more of Network People's great work with even more team/individual Dashboards and Quarterly Business Review examples, watch this webinar on Making Data-Driven Decisions featuring Joe Somerville.

Re-build in your account: Buildout Key.

 

Reports 

Onboarding Audit (April 2022 RoTM) - Inspired by our April user showcase webinar with Anne Schoolcraft of a Couple of Gurus, this report was designed to be run at the end of the onboarding period to ensure all critical checkpoints are met. It features metrics on all machines, antivirus protection status, and warranty details. It also details how you might use custom configurations for things like obtaining after hour access details and understanding clients' software criticality.

Re-build in your account: Buildout Key.

Profitability Analysis (December 2020 RoTM) - This report helps MSPs identify trends in profitability, focusing on agreement health, effective hourly rate, time spent on tickets, tickets opened by hour of the day, and margin on agreement and agreement additions. View this report monthly or quarterly. Use filtering in BrightGauge to narrow down by client or agreement type for a more granular look at profitability where needed.  
Re-build in your account: Buildout Key. 

Agreement Performance Report (November 2019 RoTM) - A high-level view of how fixed-fee Agreements are performing. Track your revenue, cost, and margins. Follow these steps to build in your account:  
Re-build in your account: Buildout Key 

Goals and EOS Tracking Weekly Report (Nov 2020 RoTM) - A weekly check-in on where the team stands with their goals, what is being done to meet their core values, tasks currently in the works, open projects, overdue tickets and tasks, and known issues to address.  
Re-build in your account: Buildout Key.  

Client Heartbeat Report (June 2021 RoTM) - This report was created based on the Client Heartbeat Report and other KPIs shared in our May 2021 User showcase Webinar with James Oberhaus of CPI Solutions. It provides a review of team performance and client feedback; and is meant to drive discussion based on survey responses, response speed and efficiency, and the level of communication provided to your clients. 
Re-build in your account: Buildout Key. 

Client End of Month Report - A great monthly recap of the metrics that matter most to your clients: ticket stats, asset management, and computer health.  
Re-build in your account: Buildout Key 

Quarterly Business Review (September 2020 RoTM) - Comprehensive client report that will showcase all of the behind-the-scenes work and value of your services!  
Re-build in your account: Buildout Key 

Engineer Audit Monthly Report (July 2020 RoTM)- Send this to your technicians each month to review their billable %, scorecard, time tracking, CSAT, and more over the last 6 months.  
Re-build in your account: Buildout Key 

Internal Weekly Service Report (February 2020 RoTM) - Our go-to report for sync ups and keeping the team in the loop with work to be done.  
Re-build in your account: Buildout Key 

  

Internal PSA Dashboards 

Service Delivery Management Dashboard (June 2022 DoTM) - Inspired by our June user showcase webinar with Jeremiah Best of Aligned Technology Solutions, this dashboard was designed to help manage a service delivery team. Jeremiah spoke about the need for revising your KPIs as you grow and this dashboard showcases top KPIs across that growth spectrum. It includes tech billable utilization, billable percentages and client hours, SLA statistics, and metrics to gauge the team's current ticket performance.

Re-build in your account: Buildout Key.

Ticket Dispatch (March 2022 DoTM) - Inspired by our March user showcase webinar with Ken Smith of 2W Technologies, this dashboard features metrics to help dispatchers prioritize tickets, spot issues, and assign the right technicians. It includes metrics to highlight high priority tickets and tickets with no type, agreement, and/or configuration. It also provides information on the triage and dispatch process and technicians schedules. Towards the bottom of the dashboard, you'll find metrics like same-day resolution rate and average time to resolve to help gauge how efficient the team is operating.  

Re-build in your account: Buildout Key.

Help Desk SLA Scorecard (November 2021 DoTM- Inspired by the KPIs shared in our November 2021 User Showcase Webinar, Future-Proofing your Team with Goal Setting, with Daniel Gilbert of Kite Technology. This dashboard is used to help the service team prioritize tickets based on SLA's. It provides details of tickets whose SLA's are in play, tickets that are opened but missed their SLA's, and an overview of what tickets hit or missed their SLA's overall.

Re-build in your account: Buildout Key. 

Service Operations Management (July 2021 DoTM) - Inspired by the KPIs shared in our June 2021 User Showcase Webinar with Mark Wright of I.T. WORKS! Get a high-level overview of the service team's productivity and gauge clients' happiness against team's performance. The service operations manager can check this dashboard multiple times a month to spot trends or potential problems requiring intervention. Includes KPI's such as tickets and hours per endpoint, SLA adherence, and a ticket escalation ratio.  
Re-build in your account: Buildout Key. 

Support Shift Handoff (April 2021) - For support teams that work shifts, this dashboard will help pass on vital information between shifts. KPIs include a list of critical alerts, unassigned tickets, escalated and stale tickets, average response rate, kill rate, and closed tickets missing configurations. 
Re-build in your account: Buildout Key 

Engineer Dashboard for Self-Triaging (Watch the webinar) Filter this dashboard for an individual tech to see what's on their plate for today, tasks available for pick up, and stats for the last week. KPIs include same day ticket statistics, completed tickets, past due items, in progress, assigned and “In-Progressible” tickets. Also find team stats for current and last week with survey stats.  
Re-build in your account: Buildout Key 

Daily Service Board Support Team Dashboard - Dashboard at a glance view of your ticket status and averages. KPIs include average time to response and resolution, tickets resolved by tech, average ticket lifespan and opened tickets by client are some of the metrics included on this board.   
Re-build in your account: Buildout Key 

Team Capacity Dashboard (January 2020 DoTM) Our User Showcase Webinar Keeping your MSP Reliable with Daily Micro Goals and our Team Capacities blog post dives into how you can track team capacities to drive success. Review for key metrics to track utilization, and see if your techs are meeting capacity with assigned hours per member. 
Re-build in your account: Buildout Key 

Individual Tech Dashboard (Webinar Highlight) – Track individual tech progress and performance with filters. KPIs include NPS, documentation, time worked, and first call resolution. Learn more about the power of tech dashboards in this blog post.  
Re-build in your account: Buildout Key

Service Desk KPI's Based on Connectwise's top recommended service KPIs, this dashboard includes resource utilization, billable percentage, and SLA compliance. For more Connetwise metrics, check out this guide.  
Re-build in your account: Buildout Key 

Team Huddle Dashboard (February 2021 DoTM)  A dashboard overview of the day's action items for your support team. Shared by Paul Bischer of GRIT Technologies, this dashboard helps drive daily meeting agendas with insights on open tickets, daily schedules, and any past due items.  
Re-build in your account: Buildout Key.  

Manage to Zero – The goal is to reach 0 across the board! Manage all metrics to zero through set thresholds. KPIs include all the golden metrics that require action and use color thresholds. Learn more in our blog post 
Re-build in your account: Buildout Key 

Manage to Green An essential dashboard that gives a quick view of current progress. Keep KPIs within the ‘green’ or exceed results! Metrics that turn to red show areas where you may be falling behind. Learn more in our blog post. Follow these steps to build in your account.  
Re-build in your account: Buildout Key 

Daily Service Delivery Board (July 2019 DoTM) – Inspired by our IT Management Associates blog post, this dashboard provides up to date information on tickets, hours entered, SLA stats, survey responses, and more. Re-build in your account: Buildout Key  

Actionable Daily Service Board - Daily view of tickets that need action, hours entered by tech, SLA stats, and survey responses. This dashboard helps the service team ensure that action is taken on all the outstanding items 
Re-build in your account: Buildout Key  

 
Client-Facing Dashboards 

Standard Client Information & Quick Links (March 2021) - Client facing dashboard, ideal for lower touch customers, it's a quick way to get an overview of their account details. It contains basic MSP information for the client like number of servers and workstations, links to open a ticket, make an order, or pay their bill as well as their account manager contact details. Our Client Account Overview blog post highlights how this Dashboard can be used in your organization. 
Re-build in your account: Buildout Key  

Client Service Overview  - A great way to show clients a quick service summary. It focuses on the key metrics like CSAT, ticket stats and SLA summary.  
Re-build in your account: Buildout Key 

Client Service & Remote Monitoring Status For the hands-on customer that loves getting into the KPIs, provide more detailed overview of the service status. This dashboard shows the client a mix of ticketing, CSAT and RMM stats such as average resolution times, out of warranty machines and tickets pending customer.  
Re-build in your account: Buildout Key 

Device Management Client Overview (March DoTM) - This Automate-based shares your workstation, PC, and project stats. Set up for your clients, filter, and share. Check out our Client Success Overview blog post to learn more.  
Re-build in your account: Buildout Key   

Quarterly Business Review Dashboard - A fresh take on the classic QBR report to highlight the services you provide. Set up filters, clone, and share with your clients for visibility into your operation; they will appreciate the transparency! To learn more, you can watch a short video here or check out our blog post Quarterly Business Review 
Re-build in your account: Buildout Key  

 
Financial/Leadership Dashboards 

Invoice Time Review (February 2022 DoTM) - Inspired by our February user showcase webinar with Todd Moss of 24HourTek, this dashboard shares metrics to help the billing and service team review time entries for a more seamless invoicing process. It features time review metrics based on agreement types, work types, and has a member time review section as well.  

Re-build in your account: Buildout Key.

Client Management Overview (January 2022 DoTM) - Inspired by our January user showcase webinar with James Cash of SuperFast IT, this dashboard shares metrics to help account managers build a more proactive approach to relationship building. When filtered by individual client, you can get granular information on recent ticket history, client satisfaction, agreement additions, cross-sell opportunities, and profitability. 

Re-build in your account: Buildout Key.

Client Profitability (December 2021 DoTM) - Inspired by our December user showcase webinar with Paul Recksiek of Solvere One, this dashboard starts off with some high-level metrics like active and supported contacts, MRR, Hours by work type, and Net Profit. Then, the second half of the dashboard allows for a granular, client by client view into profitability.

Re-build in your account: Buildout Key.

Financial Overview (September 2021 DoTM) - This dashboard is intended for the executive-level team. It was inspired by the August 2021 User Showcase Webinar with Kevin of Premier One. Check out his podcast to hear more from him! This dashboard highlights net and gross profit tracking, MRR, P&L Performance, and a 'turning point' gauge that shows when you've hit your 'breaking even' point for the year. A lot of the data on this dashboard leverages Quickbooks and helps inform executive-level decisions.  
Re-build in your account: Buildout Key 

Financial Health Dashboard (January 2021 DoTM) – Our blog post, Financial Health, describes how a financial health dashboard can be advantageous. It assists in keeping track of your most important high level financial metrics like EBITDA (Earnings Before Interest, Tax, Depreciation & Amortization), MRR, Margin %, Churn % and get insight into the potential total revenue each of your customers can bring with Customer Lifetime Value gauge.  
Re-build in your account: Buildout Key  

Leadership KPI's (December 2019 DoTM) - Get an overhead view of the health of your company with stats on income, gross profit, and performance. Check out our Leadership KPI  blog post.  
Re-build in your account: Buildout Key 

Finance KPI's - This board offers a breakdown of distributed revenue by client, hourly rates, and margins.  
Re-build in your account: Buildout Key 

MSP Overview Dashboard - See high-level financial and service metrics on a single board. This dashboard shows some important financial KPI's together with the average response and resolution time stats over the past months and the total number of managed users and endpoints.  
Re-build in your account: Buildout Key 

 
Sales Dashboards 

Company Pipeline (May 2022 DoTM) - Inspired by our May user showcase webinar with D.J. Hanen of Five Star Technology Solutions, this dashboard was designed to help manage to a healthy pipeline, work towards having good sales data, and tracking opportunities won versus lost.

Re-build in your account: Buildout Key.

Account Manager (August 2021 DoTM) - This dashboard provides the client manager (aka account manager) a home base for managing their book of accounts. It was inspired by the July 2021 User Showcase Webinar with Josh Smith and Harrison Teel of System Solutions. It includes proactive gauges like CSAT follow ups and tasks for quarterly business reviews, as well as metrics focused on future client opportunities and won revenue. You can also read more about the Client Manager Dashboard in our blog post here.  
Re-build in your account: Buildout Key.  

Sales Management Dashboard (September 2019 DoTM) - Compare your profits with revenue, margins, and what is in the pipeline.  
Re-build in your account: Buildout Key 

Sales Team KPI's - A clean view of these golden sales metrics: revenue in pipeline, opportunities, revenue won, and other sales activities.  
Re-build in your account: Buildout Key 

Sales Leadership KPI's - A different view of your sales health: total revenue, agreements by product and service, won & lost, opportunities by rep and stage.  
Re-build in your account: Buildout Key 

  

Project Management Dashboards 

Project Overview Dashboard - Set up this board to track time spent across projects, revenue yet to be collected, projects over budget, and project revenue forecasting.  
Re-build in your account: Buildout Key 

Professional Services Key Metrics (October 2021 DoTM) - This Dashboard is brought to you by Craig Howarth of Nuago, an IT Solutions Integrator. For Nuago, professional services includes project management, pre-sales and consulting services. KPIs shared focus on time entries, profitability, team performance, and overall project tracking.  
Re-build in your account: Buildout Key

Project Management - Manager View (July 2022 DoTM) - Inspired by ourJuly user showcase webinar with Derek Diaz of Charter Technology Solutions, this dashboard provides a high-level manager's view of the project team. While Derek shared a more customized dashboard using custom SQL queries, this version is easily built with Manage Cloud. It features project ticket tracking metrics, an average cost performance index, project hours budget assessment metrics, and a project margin breakdown.

Re-build in your account: Buildout Key.

  

Operational Maturity Dashboards  

Watch the May 2020 Webinar, and recreate one of the dashboards below to match where you are in your operational maturity. You can also learn more about Operational Maturity on the Connectwise Blog.  

Operational Maturity Dashboard - Phase 2 
Example Board: Buildout Key  

Operational Maturity Dashboard - Phase 3 
Example Board: Buildout Key 

Operational Maturity Dashboard - Phase 4 
Example Board: Buildout Key 

Operational Maturity Dashboard - Phase 5 
Example Board: Buildout Key 

Was this article helpful?
26 out of 34 found this helpful

Comments

0 comments