How spreadsheets can lose your station sales

When a spreadsheet is enough

A spreadsheet can be perfectly fine for a small radio station with a simple sales set up. If one person handles most enquiries, bookings and renewals, and there are not many live advertisers, a well kept sheet can do the job.

It can hold basic contact details. It can show who has been called. It can list which advertisers are live this month. It can also help you keep a simple view of open leads, expected value and next steps.

The trick is honesty. A spreadsheet works when it is tidy, owned by one person, checked often and kept simple. If everyone knows where it is and what each column means, you are in decent shape.

For a very small desk, the safe jobs for a spreadsheet are usually the clear and simple ones.

• Prospect name, business name and contact details
• Lead source, such as web enquiry, call in or rep contact
• Basic sales stage, such as new lead, quoted, booked or lost
• Simple campaign dates
• Package value
• Notes from the last proper conversation
• A next action date if someone checks it every day

Where spreadsheets start to wobble

Spreadsheets struggle when the desk gets busy. Not huge. Just normal radio busy. One person is on air cover. Another is chasing copy. A client calls to move a burst. Someone else sends a new rate request. Then a warm lead waits three days because nobody saw the next action.

This is where the risk begins. The spreadsheet might still be there, looking calm and innocent. But the truth is spread across email, phone notes, calendars and memory. Memory is a poor filing system. It also takes lunch breaks.

The first warning sign is duplicate work. Two people chase the same advertiser. Or nobody chases them because each person thinks the other one has done it. The second warning sign is missing detail. A client asks what was agreed last time and the answer begins with, I think.

Spreadsheets also get risky when you need to hand work from sales to traffic, production, finance or management. If campaign notes are not clear, the booking may be right in one place and wrong in another. That is how small errors become awkward calls.

Renewals are another danger area. Radio sales often depends on timing. If a client had a strong campaign in May, you do not want to remember them in July. You want a clear reminder before the renewal moment passes.

• Leads sit with no clear next action
• Advertiser notes are buried in email threads
• Campaign dates change but not everyone knows
• Renewals depend on one person remembering
• Managers cannot see the true sales picture quickly
• Handover to invoicing or production needs too much chasing

What to compare before you move

Do not move away from spreadsheets just because someone says you should. Move because your desk needs clearer control.

Before you choose a sales or campaign management system, compare how the work really moves through your station. Start with the jobs that cause pain. Not the glossy wish list. The daily grind.

Ask what happens from first enquiry to signed order. If that part is already causing drift, read this guide on moving from yes to signed radio sales. It is a useful place to tighten the bit where many stations lose time.

Then look at what the team needs to see without asking five people. A system should make the important things easier to find. It should not become a second admin job with a nicer login screen. We have all met those. They wear a smart jacket and steal your afternoon.

Compare these areas before you decide.

• Can everyone see the latest advertiser note?
• Can each lead have a clear owner?
• Can the next action be seen without searching emails?
• Can campaign details stay with the advertiser record?
• Can renewal dates be flagged early enough to act?
• Can sales hand over clean details to the next person?
• Can the owner see enough to steer the desk without sitting in every conversation?

Spreadsheet or Sales System checklist

Here is a simple checklist you can use in a sales meeting. It is deliberately plain. If the answer is no to several items, the spreadsheet may be asking too much of your team.

Spreadsheet or Sales System?

• ☐ Lead tracking. Can you see every live lead, who owns it, what stage it is at and what should happen next?
• ☐ Follow up reminders. Does the desk get a clear reminder before a lead goes cold, not after?
• ☐ Campaign details. Are dates, package notes, copy needs and changes kept in one place the team trusts?
• ☐ Advertiser notes. Can anyone with permission see the last useful conversation without digging through emails?
• ☐ Renewal dates. Are renewal chances visible early enough for a proper call, not a rushed apology?
• ☐ Invoicing handover. Can sales pass the right details to the person who bills the client without extra chasing?
• ☐ Reporting. Can the station owner see the state of leads, bookings and renewals without building a new sheet every Friday?

How reminders and notes protect revenue

Most missed sales are not dramatic. They are quiet. A good lead waits too long. A campaign ends with no renewal call. A client who needed copy help is left to work it out. None of this feels like a disaster on the day. Over a month, it costs you.

Reminders matter because they turn good intentions into action. If a rep agrees to call an advertiser next Tuesday, that should not depend on a diary memory and a lucky cup of tea. It should be visible, dated and owned.

Advertiser notes matter because radio selling is personal. A local garage owner may care about a Saturday event. A restaurant may want school holiday pushes. A charity may need gentle handling around dates. These details help the next call sound human, not like a cold start.

Task lists also help managers support people without breathing down their necks. You can ask about the right things. Which leads need help? Which renewals are close? Which campaigns need copy before they can go live?

If the sale has already been agreed, make sure the admin does not slow it down. The piece on getting from yes to signed radio sales covers that danger point in more detail.

Where StationCortex TEX Autopilot fits

Only after you have mapped the work should you look at the tool. StationCortex TEX Autopilot is designed to take repetitive work off the desk while keeping the station in control of the commercial process.

That matters for a smaller team. In many stations, the same few people are selling, chasing, checking details and moving bookings along. Repetitive admin eats the hours that should go into good calls and strong client service.

TEX Autopilot is built to reduce repetitive admin, keep work moving automatically and support a smaller team. The important part is control. Commercial automation should not make your station sound less personal. It should clear away the dull repeat jobs so people have more time for the parts that need judgement.

The human work should stay human. Pricing decisions. Final promises to advertisers. Copy sense checks. Sensitive client calls. Approving campaign details. Deciding when a long standing advertiser needs a proper conversation rather than another reminder.

Used well, a system does not replace local knowledge. It protects it. It keeps the facts close to the work, so your team can act sooner, hand over cleaner details and stop trusting the commercial desk to memory alone.

• Use automation for repeat admin
• Keep people in charge of judgement calls
• Keep advertiser notes clear and current
• Use reminders to protect leads and renewals
• Review the desk often so the system stays useful