Live reporting that revealed what direction the month was heading in

The situation

Reporting is easy to treat as an administrative task that's produced after the event, rather than something that shapes its direction. When managing a single site, that gap is easier to manage since one owner can usually feel when things are going well or badly without much formal measurement at all. But that instinct lessens the more locations you open, and more is happening across the business than any one person can hold in their head.

Before we began this part ofrunning digital operations for the group, there was no reporting stack at all, just one enormous spreadsheet that somebody updated by hand. There was also no meaningful financial reporting or forecasting, meaning the board was making decisions about a fast-growing business without a reliable way of seeing their financial position.

A single spreadsheet updated by hand is a fragile foundation for a business expanding at this pace. Every new studio meant another block of rows to add, another set of formulas to check, and another opportunity for error. The tool had simply outgrown what it was built to do.

What replaced it

We built reporting that was live, interactive and available on demand, rather than a weekly or monthly pack assembled after the event. A business growing as quickly as this one needed to react to cash flow movement as it happened, not learn from historical data.

Speed was a significant change. The problem with a month-end report is that the business relies on whoever compiled that report to answer questions about any data that falls outside of what they've included. This means a request, a wait and a follow-up report. Live, interactive reporting gives you that information on the same day it is asked for, and therefore changes what types of questions are asked, and genuinely reshapes the way business is done.

The argument

Hard cash flow figures are usually what a board asks for first, as it tells you where a business has been. These numbers don't necessarily reflect where a business is going, however, and for that we needed the numbers for conversion rate, average booking value, time to win and lead volume. These are the numbers that come first - cash flow really only represents the deals that have already closed.

Watching lead volume in particular meant seeing where a month was going to land while there was still time to act on it, instead of looking at turnover on the last day of the month and reacting to a result that could no longer be changed. That is what made it possible to juggle advertising spend and marketing activity sensibly, pulling back or leaning in during the month itself instead of after it had already closed.

Of course cash flow still mattered, and it stayed on the dashboard. The biggest change was where the business looked to as the leading signals, and where it looked to for confirmation. A board that only ever looks at cash flow is always looking at a result that has already happened, whereas a board watching lead volume and conversion rate is looking at the thing that produces the result, early enough to influence it.

Granular reporting

Reporting broken down by salesperson, studio, artist, channel and by individual ad was introduced, with finance and cash flow reporting running alongside the sales numbers rather than in a separate document, making the two much easier to cross-reference. Being able to view reports on a more granular level allows for a problem to be traced to its specific source - be it a specific studio, channel, or artist's diary - rather than an unexplained dip in a group-wide total.

Overall business totals are great at hiding things. An average booking value holding steady across twelve studios can signify performance consistency, or it can mean two studios are overperforming while a third is struggling and dragging the average value down. Only granular reporting tells those two situations apart. Telling them apart allows for something to be done about it.

Ad optimisation

Having proper tracking in place allowed more wide-spread, creative testing across a seven-figure annual advertising spend. Previously the only visible number was a generic lead count, which said nothing about which artist, channel or even which studio that spend was working for. At times campaigns ran on the brand's own profiles, and at other times across more than twenty individual artist ad accounts in parallel, and the same reporting infrastructure had to make sense of spend and results across all of it at once.

Running that many accounts in parallel without granular reporting underneath it would have been close to unmanageable. Deciding which artist's account deserved more budget, which artist had stopped working and which studio's campaigns needed attention are all questions that a generic lead count simply cannot answer, and every one of them had to be answerable at the same time across a group that had already grown past the capabilities of a single person.

This is the same granular, live approach to reporting we bring to anymulti-location business trying to see performance by site, by channel and by individual campaign, rather than one blurred number that hides exactly where the movement is coming from. A business that has outgrown what a spreadsheet and a single monthly meeting can reveal is not an industry specific problem - it's an issue seen company-wide.