Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can Our MSP See Which Clients Raise Far More Tickets Than Their Contract Assumes?
Problems We Solve

How Can Our MSP See Which Clients Raise Far More Tickets Than Their Contract Assumes?

Some MSP clients quietly generate far more tickets than their fee covers. We build a per-client view of ticket volume and effort against each managed contract.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Managed service contracts are priced per user or per device on an assumed level of support, but most MSPs only see ticket volume per client when someone runs a PSA report by hand. We build a per-client view that pulls tickets and time from your PSA, normalises them by seat count and contract tier, and flags clients whose demand has drifted well away from what their contract assumes.

The client everyone knows about

Ask your service desk which client is the busiest, and they will name one straight away. The accounting practice with forty users that raises tickets about printers every day. The one whose office manager emails the helpdesk for everything, including things that are not IT. Everyone knows. Nobody has the numbers.

The contract was priced two years ago on a per-user fee for a certain level of support. Since then, the client has added a second office, moved to a new line-of-business application and hired staff who need more help. The fee went up with the user count, but the effort went up faster. The account manager is about to discuss renewal with no evidence either way.

Why the numbers stay hidden in the PSA

Your PSA, whether ConnectWise PSA, Autotask, HaloPSA or another, holds every ticket and every time entry. The problem is that the reports that matter, effort per user, per client, over time, compared with the contract, need data from more than one place and a bit of cleaning.

  • Seat counts come from contracts or billing, not from the ticket data.
  • Tickets are logged against the wrong company or a catch-all account.
  • Alert tickets from the RMM are mixed with user requests.
  • Project work and out-of-contract work are logged alongside support.
  • Time entries are incomplete, so ticket counts and hours tell different stories.

Company records add their own noise. Tickets raised by a client's staff from personal email addresses land on a catch-all company, and a client with two legal entities may be split across two PSA companies. A per-client figure built on that data is wrong before any analysis starts, so the clean-up has to be part of the work.

What an unseen imbalance costs

Unseen patternConsequence
High-demand client on a standard tierEngineers' time subsidises one account
Rising demand not noticedThe renewal is priced on out-of-date assumptions
Low-demand client not noticedA client who may be under-served or ready to leave
Demand driven by one issueA recurring fault treated as normal support
No evidence for the conversationAccount managers avoid the topic at renewal

High demand is not always the client's fault. Often it points to an unresolved problem, an unsuitable setup or a training need. Seeing it is the start of fixing it.

The per-client demand view we build

  1. A nightly pull of tickets and time entries from your PSA through its API, with company, contact, board or queue, type and source.
  2. Seat and device counts per client from your contracts or billing, so demand is shown per user and per device.
  3. Filters that separate RMM alert tickets, project work and out-of-contract work from normal user support, using rules you agree.
  4. A comparison per client against the tier or assumption their contract was priced on, which you enter.
  5. Trend lines per client over months, and a flag when demand moves outside the range you choose.
  6. A drill-down by category and by user, so you can see if one person, one site or one application is driving it.

Where it helps, we add simple categorisation of ticket text using an AI model such as Anthropic Claude, so vague tickets are grouped by likely cause. Engineers can correct the category, and the correction is kept.

Account reviews after the change

The service manager opens the dashboard on Monday and sees three clients flagged: the accounting practice, whose tickets per user are well above its tier; a new client, still in its busy onboarding period; and a client whose tickets have almost stopped, which prompts a call. The drill-down shows the accounting practice's demand is mostly one application and two users, which becomes a proposal for training and a fix, not an argument about money.

When renewal comes up, the account manager goes in with a year of figures, broken down so the client can see them too.

Is this your service desk?

  • Everyone knows your busiest client, but nobody can show the figures.
  • Renewals are priced on seat count without looking at effort.
  • RMM alerts and user requests are counted together.
  • You have never compared tickets per user across clients.
  • Clients with falling ticket volume go unnoticed until they leave.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Which PSAs can you connect to?

Any with a usable API, which includes ConnectWise PSA, Autotask and HaloPSA. If yours only exports files, we can work from scheduled exports.

Does this replace our PSA's reporting?

No. It uses your PSA's data and adds the contract comparison and trends that are hard to build inside it.

What if our time entries are poor?

The view shows ticket counts and time separately, so gaps in time logging become visible. Improving that is often the first finding.

Will clients see this?

Only if you choose to share a version with them. Many MSPs use a simplified view in account reviews.

What drives the cost?

Mainly the PSA and billing systems involved, how clean the company and contract data is, and whether you want the AI categorisation.

Keep reading

More on Problems We Solve

Start here

Tell us how your MSP measures effort against contracts

Describe your PSA, your RMM, how contracts are recorded and how engineers log time. We will tell you what we would build on top of the tools you already run, and where a report or setting in your PSA would do the job without us.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →