Reporting and intelligence are not the same thing
A report tells you what happened: income by service, number of schools, renewal percentages. It is necessary, and often the only thing available. But it is retrospective by construction, and by the time it is produced the decisions it might have informed have already been made.
Commercial intelligence is different in purpose. It identifies where action would change an outcome: which customers are drifting, which services are quietly under-adopted, where a customer holds one service but not the obvious companion to it, and where revenue is exposed while there is still time to respond.
Why councils rarely have it
The obstacle is structural rather than analytical. Intelligence requires the customer, catalogue, contract, transaction and engagement records to describe the same reality. In most operations they live in separate systems maintained by separate teams, so any cross-cutting question becomes a bespoke assembly job that only happens when someone senior asks.
The consequence is that analysis is rationed. Questions get asked once a year because asking them is expensive — which is precisely the wrong economics for commercial decision-making.
Four questions worth being able to answer continuously
1. What is each customer's full position?
A single view per organisation: services held, contract values and terms, renewal dates, entitlement usage, training attendance, enquiries raised, previous declines and their reasons. This is the foundation for everything else, and it is also what makes any conversation with a school better informed.
2. Where is uptake unexpectedly low?
Uptake expressed as a percentage of eligible customers rather than an absolute count reveals different things. A service held by most primaries but few secondaries, or strong in one part of the authority and weak in another, is pointing at a positioning, pricing or awareness issue rather than a demand ceiling.
3. Where are the cross-service opportunities?
If schools of a similar type and size typically hold a particular combination of services, the ones that do not represent a straightforward, relevant conversation — not a cold sell. This kind of comparison is trivial with connected data and effectively impossible without it.
4. Where is revenue at risk?
Renewals due, unconfirmed value, engagement history and prior signals combine into a prioritised list. The value is entirely in the timing: the same information after the deadline is a report.
Segment by something meaningful
Averages across a whole school base conceal most of what matters. Useful segmentation dimensions in this market include phase and type, size band, trust membership and structure, geography, breadth of services held, spend band, and engagement level.
Trust structure deserves particular attention. As schools move into multi-academy trusts, purchasing decisions can shift from individual schools to central teams. An operation that models only individual schools will misread both its risk and its opportunity as that consolidation continues.
Signals to capture deliberately
Some of the most useful data is not captured by default because nobody defined a field for it:
- Structured decline reasons, from a short fixed list.
- Entitlement consumption — allowance used versus purchased.
- Training attendance and no-shows.
- Enquiry and complaint volume by customer and by service.
- Renewal responsiveness — how quickly and how willingly a customer renews each year.
- Contact changes, particularly new business managers or headteachers.
- Quotes or discussions that did not convert, and why.
Each is cheap to collect if the process captures it as it happens, and expensive or impossible to reconstruct later.
Make it operational, not just visible
Insight only has value when it results in a different action, which means it needs to reach the right person at the right moment.
- 1
Route it to a named owner
Every identified risk or opportunity should have someone responsible for the next step, with a date.
- 2
Record the outcome
What was done and what resulted, against the customer record — otherwise the same insight resurfaces indefinitely.
- 3
Prioritise ruthlessly
A list of two hundred opportunities is ignored. The ten highest-value, most actionable items get worked.
- 4
Feed decisions back into the catalogue
Pricing, packaging and service scope should change in response to what the data shows, and those changes should then be measurable next cycle.
A realistic starting point
You do not need a data platform to begin. Establish one consistent customer list with type, size and trust membership; record structured decline reasons; produce a monthly renewal-risk list; and hold one regular meeting where a small number of opportunities are assigned and reviewed. That routine will surface most of the value, and it also clarifies what a system should eventually automate.
This is the distinction Service Street is built around. Platforms that manage traded services record what happened; the harder and more valuable problem is helping councils operate and grow them — which is why connected customer, contract, uptake and renewal data sits at the centre of the product rather than in a reporting module bolted on the side.
In summary
The move from reporting to commercial intelligence is mostly a data-structure and habit change. Connect the records, capture the signals as they occur, segment by something meaningful, and make sure every insight has an owner and a recorded outcome.