Why OOH Operators Still Run Spreadsheets

A rep I know in Chicago managed 94 faces across three states. All of them, every single one, lived in a single Excel workbook. Seventeen tabs. When his agency hired a second salesperson, the file got shared over email because it lived on one person's desktop. You can see where this is going.

That story is not unusual. It is not even close to unusual. The out-of-home industry runs on spreadsheets. We talk about programmatic DOOH and real-time bidding and audience measurement, and all of that is real, but underneath it, a large percentage of billboard operators are still managing their core inventory data the same way they were in 2008.

The Outdoor Advertising Association of America publishes annual revenue reports that show the industry's size and growth, but you will not find a line item in any of those reports for spreadsheet reconciliation hours. That cost is invisible because operators absorb it directly.

This post is about why that keeps happening, what actually breaks when your inventory data is wrong, and what you should look for if you are ready to move past the spreadsheet.

The spreadsheet ceiling

Here is how it starts. You have four faces. You know all of them personally. You put them in a spreadsheet because four feels like enough to track but too many to remember. Rates go in one column. Availability in another. A third column has the market. That is the whole system.

The problem is that it works, at first. Four faces is manageable. Then you get six more, and then you are in a secondary market, and then you have three digital faces that need different rate logic than the static ones. So you add columns. Then you add a second tab because the first one got crowded. At some point you have a workbook with fifteen tabs and seventeen columns and nobody except you knows what column Q means.

The operator with the 94 faces in Chicago told me, when I asked what the trigger was for moving off the spreadsheet, that there was no trigger. There was just a slow accumulation of problems until one day his entire sales team was losing two hours a week reconciling who had sold what. Two hours. Every week. For a team of four people.

That is the spreadsheet ceiling. It does not crash. It just starts costing you time, accuracy, and eventually money, in small amounts that are easy to dismiss until they are not.

The double-booking problem nobody talks about honestly

The thing that breaks first is not the rates. It is not the reporting. It is the double-booking.

Here is a specific example. A rep in Atlanta was managing eight bulletin faces across two markets. He kept his availability spreadsheet updated, more or less. The problem was that his colleague in a different regional office was also selling from a spreadsheet, and theirs was not synced. They both sold the same bulletin on I-75 in Kennesaw for the first two weeks of March to two different buyers. One was a regional QSR chain. The other was a political campaign. By the time the conflict surfaced, both buyers had signed insertion orders and the operator was in the position of breaking the news to one of them that their campaign was going to run three weeks later than planned.

Both buyers were unhappy. The political buyer lost their window. The QSR chain paid a discounted rate but sent a formal complaint to corporate, which then called the operator directly to ask what kind of operation they were running.

This happens more than the industry acknowledges. The operators who will tell you about their double-booking incidents are the ones who got caught in them. The ones who handled it quietly, before it became a problem, are not going to mention it to a third party. But ask around. Ask operators what their biggest inventory coordination failure was in the last three years. The stories are consistent. Double-bookings are common. They are just not public.

The mechanism is simple. Inventory availability is a moving target. Every hour that your spreadsheet is not updated is an hour where someone on your team might sell a face that is no longer available.

Stale audience data is silently costing you money

The second thing that goes wrong is that the traffic and audience data in your spreadsheet starts diverging from reality. This one is more subtle, and more expensive in the long run.

A board on a secondary road in a Phoenix submarket had a daily effective circulation of 48,000 impressions according to Geopath. The rate card was $1,850 a month. The problem: there had been a highway construction project rerouting traffic for fourteen months. The actual daily vehicle count, according to Arizona DOT data, was 31,000. The board was still priced at $1,850 a month for a location delivering 31,000 impressions, which would have been more fairly priced at $1,150 to $1,250 a month.

The operator found this because he was doing a routine review before a major RFP. He had been selling that face at $1,850 for fourteen months. He had no idea the data was stale. The buyer who eventually showed him the ADOT data did not do it as a favor.

This is not an edge case. This is a pattern. Most operators do not have a regular cadence for updating circulation data. The data gets updated when an RFP requires a fresh study, or when someone has a reason to look. In fast-growth markets like Phoenix, Austin, and parts of South Florida, traffic patterns change faster than the industry infrastructure can keep up with.

The billboard rate card in that operator's system was a spreadsheet estimate from three years ago. That number was the basis for every CPM calculation, every proposal, every buyer conversation. That number was wrong by 35 percent. If you want to go deeper on why attribution data in OOH is consistently problematic, we wrote about that separately.

Figuring out what you have is harder than it should be

The third problem is one I hear constantly from operators who are trying to scale. They have inventory spread across markets and formats. When a proposal request comes in for a specific location or a package across markets, the question is not what the rate is. The rate is somewhere. The question is what is actually available on the dates the buyer needs.

With a spreadsheet, you open the sheet, you find the face, you check the dates, you check the rate. If you have forty faces across four markets, you do this forty times. If a proposal takes three revisions, you do this one hundred twenty times. At forty faces it is annoying. At one hundred twenty faces it is a full-time job, and it is a job that requires constant attention.

What happens in practice is that operators start estimating. They estimate availability based on recent bookings. They estimate rates based on the last similar deal. We wrote about why proposals still get rejected even when the rates look right on paper. They estimate because the alternative is spending so much time on inventory checks that they do not have time to sell.

That is where the real inefficiency sits. Not in the rate cards being wrong, though they often are. Not in the double-bookings, though those happen. In the estimation. In the fact that your team is making commercial decisions based on best guesses rather than actual data.

When spreadsheets create pricing inconsistency

Rate management is a different problem, and it compounds with scale. When rates live in spreadsheets, they live in different spreadsheets, or in different versions of the same spreadsheet, or in the memories of individual reps who have been around long enough to know what rates were accepted in 2019 versus what was rejected.

A buyer gets quoted $8,400 a month for a digital face in a secondary market. Another buyer, calling two weeks later about the same face, gets quoted $7,200. Neither rep did anything dishonest. The first rep was working from the current card rate. The second rep knew the market had softened and was pricing accordingly. Neither number was wrong exactly, but they were not the same number, and the buyer who got the higher quote was not going to come back. For more on how billboard rates actually get set and what drives them, see our breakdown of what actually determines what you pay. And if you want to understand why attribution data in OOH is consistently a problem, that is a whole separate issue we wrote about.

I have seen this play out in multiple markets. In one case, a sales rep was consistently losing deals to a competitor because his quotes came in high. He thought he was holding the line on pricing. What he was actually doing was quoting from a rate card that had not been updated in two years, while the market had moved. He was not expensive. He was just working from stale information.

This is a different problem from bad data. The rates were accurate at some point. They stopped being accurate when nobody updated them.

The coordination problem hits differently when you have multiple markets

The spreadsheets really start to crack under pressure when you have operators in different markets, or different sales people managing different segments of the inventory. Each team has their own view of what is available. Those views are not always the same.

In one multi-market operation I worked with, each regional team had their own spreadsheet. They were synchronized by email. When someone was out of the office, their teammates had to wait for them to return to find out whether a specific face was available. When someone left the company, there was a period where their territory was essentially invisible to the rest of the team.

This is not a software problem. This is an information architecture problem. The spreadsheets were not bad because they were spreadsheets. They were bad because there was no single source of truth, no shared ownership, no mechanism for real-time synchronization.

For buyers, the spreadsheet is often the first signal that an operator might not have the infrastructure to support a multi-market deal. When you receive a prospect's inventory list and it is clearly an exported spreadsheet with columns that do not quite line up and dates that look hand-entered, you start to wonder what the booking and fulfillment process looks like.

That is a reasonable question to ask.

The cost of staying on spreadsheets is real, just not visible

Every operator I have worked with who is still on spreadsheets for inventory management has a version of the same justification: it works for now, we are small enough that we can manage it, the systems are expensive and complicated.

The cost of that decision is not on a balance sheet. It is in the two hours a week your team spends reconciling inventory. It is in the deals lost because you could not confirm availability fast enough to close before a competitor did. It is in the buyer relationships damaged by double-bookings. It is in the rates that were wrong for eighteen months before anyone caught them.

The operators who make the move to dedicated inventory software are not doing it because the spreadsheet stopped working. They are doing it because they have hit the ceiling and they can feel it. At 20 faces, the spreadsheet is a tool. At 80 faces, the spreadsheet is a liability.

What a real inventory system actually fixes

When operators ask me what they should look for in inventory software, I tell them to start with the problem they are actually trying to solve. If the problem is double-bookings, you need a system that tracks availability in real time and prevents conflicts across your team. If the problem is pricing inconsistency, you need a rate management layer that is tied to current market data. If the problem is the proposal workflow, you need software that generates professional quotes directly from your inventory data without retyping.

Most operators, when they migrate to a CMS, do not need the system to do everything. They need it to do three things reliably: track what is actually available, apply correct rates without manual entry, and produce a proposal that does not require copy-pasting from five different tabs.

Everything else is secondary.

The vendors who are doing this well know that the adoption problem is not really a technology problem. It is a change management problem. The operators who successfully migrate to new software do a few things consistently. They run both systems in parallel for a period, not because they do not trust the new system but because they need their team to build trust in it. They involve their sales team in the selection process, not as a committee but as the people who will actually use the tool every day. And they measure success by whether the system is making the team's life easier, not by whether it has more features than they currently need.

If the sales team has to work harder to use the CMS than they did to maintain the spreadsheet, they will go back to the spreadsheet within six weeks. That is not a technology failure. That is a selection failure.

The thing that finally gets most operators to migrate is when the cost of staying on the spreadsheet becomes more visible. When a double-booking costs them a client relationship. When a pricing error costs them a negotiation. When the two hours a week becomes three hours a week and then four.

The spreadsheet ceiling is not a technology problem. It is a growth problem.

FAQ

How long does it take to move off a spreadsheet-based inventory system?

The honest answer is it depends on how messy your current data is and how big your team is. In the cases I have seen, a full migration with data cleaning and team training takes between six and twelve weeks. The operators who take longer are usually dealing with data that was entered inconsistently over many years and needs to be reconciled before it goes into a new system. The ones who move faster had relatively clean spreadsheets to begin with.

What is the minimum feature set a billboard CMS needs to have?

Real-time availability tracking, rate management with a single source of truth, and proposal generation that pulls directly from the inventory database. You do not need reporting dashboards, multi-market heat maps, or automated buyer matching on day one. You need those three things working reliably. Everything else is nice to have.

Does moving to a CMS actually solve the double-booking problem?

It depends on whether your team actually uses it. A CMS that your sales team ignores because it is slower than a shared spreadsheet will not solve anything. The double-booking problem is a data discipline problem. The software is only as good as the process behind it.

How do you get a sales team to actually use a new inventory system?

The operators who get adoption right treat it as a sales tool, not an operations tool. They involve the people who will use it every day in the selection process. They measure adoption by whether the team is closing deals faster, not by whether the data is theoretically correct. And they run the old system in parallel until the new one is clearly better.

Is this problem different for digital versus static inventory?

Yes, in one specific way. Digital inventory changes availability by the day, sometimes by the hour in high-demand markets. A static bulletin spreadsheet does not need to account for daypart-level availability. A digital inventory system does. If you are managing any digital faces, your spreadsheet is probably already failing you in ways that are hard to see until a conflict shows up in a buyer conversation. For operators running digital inventory, our guide to programmatic DOOH covers what you need to know about daypart-level availability.