Why a local business should count bookings, not clicks
A salon, a café or a plumber does not sell clicks. It sells appointments, covers and jobs, and every one of them has to fit into a diary of limited size. Yet most marketing reports start with the numbers a platform happens to show: impressions, reach, likes, followers. They are easy to collect and easy to admire, and they say very little about whether the phone rang.
This lesson starts at the other end. It follows one month of spending through to the thing the owner actually cares about: the cost per booking, that is, what a channel cost divided by the kept appointments it brought. Once you can calculate that number for every channel, you can decide where the next pound should go, which channel to stop, and which one has simply not been given a fair chance.
The example is Larkspur & Comb Hair Studio, a fictional two-chair salon in a fictional town. All numbers in this lesson and in the whole course are invented for practice; they are illustrative and not benchmarks you should expect to match.
The three numbers: spend, enquiries, bookings
Every channel produces the same chain of events. The owner spends money or time (an ad budget, printing, message fees). Some people respond with an enquiry: a phone call, a message, an online booking request that names the channel. A part of those enquiries ends as a booking, an appointment that was actually kept. Cancellations and no-shows are not bookings.
Keeping the definitions strict matters more than it sounds. If one channel counts every click as an enquiry and another counts only phone calls, the comparison is meaningless. In this course an enquiry is a call, message or booking request that named the channel, and a booking is a kept appointment. Write your own definition on the first line of your sheet and never change it halfway through a month.
The worked example: eight channels in April
Larkspur & Comb tracked eight channels in April. For each one the owner wrote down what was spent, how many enquiries named the channel, and how many of them became kept bookings. The sheet in the lab above contains exactly these numbers.
| Channel | Spend £ | Enquiries | Bookings | Booking rate | Cost per booking £ |
|---|---|---|---|---|---|
| Google Search ads | 180 | 42 | 18 | 42.9 % | 10.00 |
| Facebook & Instagram ads | 150 | 55 | 15 | 27.3 % | 10.00 |
| Boosted Instagram posts | 60 | 20 | 4 | 20.0 % | 15.00 |
| Email newsletter | 25 | 30 | 12 | 40.0 % | 2.08 |
| SMS reminders | 30 | 16 | 10 | 62.5 % | 3.00 |
| Local directory listing | 45 | 9 | 3 | 33.3 % | 15.00 |
| Door flyers with QR code | 90 | 14 | 5 | 35.7 % | 18.00 |
| Referral cards | 40 | 12 | 8 | 66.7 % | 5.00 |
| Total | 620 | 198 | 75 | 37.9 % | 8.27 |
Step 1: the booking rate of each channel
The booking rate answers the question: out of the people who got in touch, how many actually came? The formula is bookings divided by enquiries. In the sheet, with enquiries in column C and bookings in column D, the first channel is =D4/C4. Write it once and copy it down to the last channel: the row numbers move along by themselves.
Format the result as a percentage. Google Search ads show 18 ÷ 42 = 42.9 %, referral cards 8 ÷ 12 = 66.7 %, boosted Instagram posts only 4 ÷ 20 = 20.0 %. A low rate is a question, not a verdict. Maybe the replies were slow, the price list was confusing, or the post attracted people who were never going to book. The rate tells you where to look.
Step 2: the cost per booking of each channel
The cost per booking is spend divided by bookings. With spend in column B and bookings in column D, it is =B4/D4, copied down. For Google Search ads: 180 ÷ 18 = £10.00. For door flyers with a QR code: 90 ÷ 5 = £18.00. For the email newsletter: 25 ÷ 12 = £2.08.
Notice what the number does and does not say. It does not say that the newsletter is the best channel and the flyers the worst in every sense. It says that, in April, one booking from the newsletter cost about two pounds and one booking from the flyers eighteen. Whether that matters depends on what a booking is worth, which is the subject of lesson 3.
Step 3: the totals and the blended cost per booking
A month report needs a total row. Use SUM to add a range: =SUM(B4:B11) gives the total spend of £620, and copied to the right it gives 198 enquiries and 75 bookings. SUM adds every number in the range. Do not confuse it with AVERAGE (the typical value) or COUNT (how many numbers there are).
Now the step that most beginners get wrong. The blended cost per booking of the month is the total spend divided by the total bookings: 620 ÷ 75 = £8.27. It is tempting to average the eight channel costs instead. That gives £9.76, and the difference is not just rounding: an average treats a £25 channel exactly like a £180 channel. The blended cost weights every channel by what it actually brought.
- Booking rate (E4):
=D4/C4, copied down to E11. - Cost per booking (F4):
=B4/D4, copied down to F11. - Totals (B12:D12):
=SUM(B4:B11), copied to the right. - Blended cost per booking (F12):
=B12/D12or=SUM(B4:B11)/SUM(D4:D11).
How to read the result
Start with the blended cost: £8.27 per booking in April. Then look at the spread. Three channels are below it: the email newsletter at £2.08, SMS reminders at £3.00 and referral cards at £5.00. The first two reach people who already know the salon and agreed to be contacted, so they are cheap by nature. They are also limited: you cannot send a newsletter to people who are not on the list.
The two search and social channels sit slightly above the blended cost at £10.00 each, and they carry most of the money: £330 of the £620. They are the channels that can grow with the budget, which is why their cost per booking is the number to watch when you scale them. The expensive end of the chart is made of small experiments: the directory listing and the boosted posts at £15.00, the door flyers at £18.00. They are not necessarily bad ideas, but they have not yet earned more money than they have.
Finally compare the booking rate with the cost. Referral cards have the best booking rate (66.7 %) and a cost of £5.00. Boosted posts convert only one in five enquiries and cost three times as much per booking. When a cheap channel with a high booking rate has room for more volume, it is usually the first place where an extra pound should go.
What the cost per booking does not tell you
- The value of a booking. A £9 cost per booking is cheap for a balayage and ruinous for a fringe trim. Lesson 3 turns the margin of each service into a maximum cost per booking.
- Repeat visits. A first booking is the start of a relationship. A channel that brings regulars is worth more than the same cost per booking from a channel that brings one-off bargain hunters (lesson 14).
- Capacity. A cheap booking is worth nothing if the chair was going to be full anyway. Marketing belongs where the diary has gaps (lesson 16).
- Overlap. Someone may see an ad, get a flyer and be told about you by a friend, and then name only one of them. Lesson 19 compares tracking with the question at the till.
None of these limits makes the cost per booking useless. They make it a starting point: simple enough to calculate every month in ten minutes, and honest enough to show where the money went.
Making the numbers trustworthy
The calculation is easy; the counting is hard. Three habits make the data usable without any special software. First, give every channel its own way of being recognised: a voucher code, a dedicated link, a different phone number or simply the question "How did you hear about us?" at the till or in the booking form. Second, write the answer into the booking record at the moment of booking, not at the end of the month from memory. Third, count enquiries and bookings separately, so that you can tell a weak channel from a slow reply.
When a customer cannot say how they found you, record "cannot remember" instead of guessing. A modest share of unknowns is normal. If it grows beyond a third, the question is asked too late or too hurriedly. Most booking and CRM systems have a free-text or drop-down field for the source; a notebook next to the till works too.
Common mistakes and how to spot them
- Upside-down division.
=D4/B4gives bookings per pound (0.1 for Google Search ads), not pounds per booking. If the cheapest channels look the most expensive, check which number is on top. - Dividing by the wrong column.
=B4/C4is the cost per enquiry (£4.29 for Google Search ads). It is a fine number, but it is not the cost per booking. - Averaging the channel costs. The average of the eight channel values is £9.76, the blended cost is £8.27. Use total spend ÷ total bookings.
- Including the total row in a chart or a SUM. If the total is part of the range, it is counted twice or dwarfs every channel in the picture.
- Mixing months. Spend from April and bookings from May belong to different periods. A booking that follows a flyer by three weeks is a real effect, but compare like with like or note the delay.
- Judging on tiny numbers. Three bookings from the directory listing are a hint, not a proof. One booking fewer would raise the cost per booking from £15.00 to £22.50, one more would lower it to £11.25.
A second look: why the blended cost differs from the average
A tiny example shows why the weighting matters. Imagine two channels. Channel X cost £20 and brought 10 bookings (£2.00 each). Channel Y cost £200 and brought 10 bookings (£20.00 each). The simple average of the two costs per booking is £11.00. But the month cost £220 for 20 bookings, which is £11.00 as well, because both channels brought the same number of bookings.
Change one number: let channel Y bring only 5 bookings for its £200, which is £40.00 each. The average of the two costs per booking is now £21.00, whereas the blended cost is £220 ÷ 15 = £14.67. The average is dragged upwards by a channel that brought few bookings, and it would suggest a much worse month than the one the owner actually had. This is why the sheet always totals the spend and the bookings first, and divides afterwards.
Real-world uses
- The monthly five-minute review. Paste the new month under the old one, copy the formulas down and read the bar chart. Decide on one change.
- The conversation with an agency or a freelancer. Ask for spend, enquiries and kept bookings per channel instead of impressions. If they cannot provide them, you now know what to track yourself.
- The test of a new idea. Before you commit to a year of directory listings, give it a month, count the bookings and compare the cost per booking with the channels you already use.
- The budget conversation with a partner or a bank. A one-page table with spend, bookings and cost per booking is a lot more convincing than a feeling that advertising works.
A starter checklist for your own sheet
- Write one line that defines an enquiry and a booking, and stick to it.
- List every channel you pay for or spend time on, including the free ones, one per row.
- Add the monthly spend of each channel. Put the printing bill in the month it was paid.
- Count enquiries and kept bookings per channel from your booking records.
- Calculate the booking rate (bookings ÷ enquiries) and the cost per booking (spend ÷ bookings) with one formula each, copied down.
- Add the total row with SUM and calculate the blended cost per booking.
- Chart the cost per booking as a bar chart, without the total row, and write one sentence under it: what will you change next month?
Keep the sheet from month to month, one tab per month or one block under the other. After three months you can see whether a channel is stable or only had one lucky week.
What the 20 labs of this course cover
The labs follow the work of a small business owner through a year. The first ten build the core: Cost per Booking (this lesson), Splitting a Small Budget across channels with an absolute reference, What a Booking Is Worth with margins and IF, Offer Redemptions, Who Redeems with COUNTIFS and SUMIFS, Search Ads on a Small Budget, Local Social with boosted posts, Email on a Small List, the Seasonal Calendar with XLOOKUP, and Campaign Dates with lead times and EOMONTH.
The second half goes deeper: Review Requests and the Average Rating with SUMPRODUCT, the Business Profile in One Lesson with SLOPE, the First Year of a New Customer with RANK.EQ, Rebooking Rhythm and lapsed customers with IFS, Empty Chairs and No-Shows, a What-If Grid with mixed references, a Forecast with FORECAST.LINEAR, Tracking Quality with IFERROR, and a final project: the Simple Monthly Report with a chart and conditional formatting.
Every lab uses a different data set of the same fictional salon, so you can see how the numbers of one lesson feed the decisions of the next. The Coach checks each formula as you type and explains the typical slip when your answer is close but wrong.
Summary
A local business should judge marketing by kept bookings, not by clicks. The booking rate is =D4/C4, the cost per booking is =B4/D4, and the blended cost of the month is total spend ÷ total bookings: in April £620 ÷ 75 = £8.27. Referral cards (£5.00), SMS (£3.00) and the newsletter (£2.08) are cheap but limited, the search and social ads (£10.00 each) carry the budget, and the small experiments at £15.00 to £18.00 still have to earn their place.
Now scroll up to the lab and build the sheet yourself. It takes about fifteen minutes, the Coach checks each step, and you will end up with a one-page comparison of your channels that you can repeat every month.
Frequently asked questions
What is the cost per booking?
The cost per booking is the money spent on a channel divided by the kept appointments that channel brought. For example, £180 of search ads that led to 18 bookings cost £10.00 per booking. It is the basic number of local marketing because it measures what the business actually sells.
What is the difference between an enquiry and a booking?
An enquiry is a call, message or booking request that named the channel. A booking is an appointment that was actually kept. The booking rate (bookings divided by enquiries) shows how many enquiries turn into customers, and a low rate often points to slow replies or an unclear price list.
Why not just average the cost per booking of all channels?
An average treats a small channel like a large one. The correct blended cost per booking is the total spend divided by the total bookings, which weights every channel by what it really brought. In the worked example the blended cost is £8.27, while the plain average of the eight channel values is £9.76.
How do I count bookings per channel without special software?
Give every channel its own way of being recognised, such as a voucher code, a link, a phone number or the question 'How did you hear about us?' at the till, and write the answer into the booking record at the time of booking. A spreadsheet or a notebook is enough to start.
Is a low cost per booking always good?
No. A cheap channel may have no room for more volume, may bring one-off bargain hunters, or may fill chairs that would have been full anyway. The cost per booking is a starting point; the value of a booking, repeat visits and capacity decide what to do with it.
Do I need Excel experience for this lab?
No. The lab explains each function when it is first used. In this first lesson you need only division, copying a formula down and SUM. The Coach checks every cell and explains typical slips, such as dividing the wrong way round.
Keep going: Local Business Digital Marketing: Cost per Booking, Small Budgets, Offers, Reviews, Seasonal Calendar & Monthly Reporting
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- Splitting a Small Budget: Shares per Channel with an Absolute Reference, a 100 % Check and Expected Bookings with ROUNDDOWN
- What a Booking Is Worth: Margin per Service, Margin % and the Maximum Cost per Booking with IF
- Offer Redemptions: Redemption Rate, Total Offer Cost, Cost per Redemption and Net Revenue per Offer
- Who Redeems? New vs Existing Customers per Offer with COUNTIF, COUNTIFS and SUMIFS
- Search Ads on a Small Budget: Cost per Click, Click-to-Booking Rate, Cost per Booking by Search Term and a Pause List
- Local Social: Boosted Posts by Cost per Enquiry, Bookings per 1,000 Reached and Cost per Booking by Post Type
- Email on a Small List: Bookings per 1,000 Delivered, Revenue per Email, Unsubscribe Rate and a Check Flag
- The Seasonal Calendar: Average Month, Seasonal Index, a Budget that Follows Demand and the Busiest Month with XLOOKUP
- Campaign Dates: Start Dates from Lead Times, Days until the Start, a Status with IFS and Voucher End Dates with EOMONTH
- Review Requests: Review Rate per Wave, Cost per Review and the Best Way to Ask with SUMIFS
- Review Ratings: Reviews per Month, the Weighted Average Rating with SUMPRODUCT and How Many 5-Star Reviews Lift It
- The Business Profile in One Lesson: Weekly Actions, Actions per 100 Views, Week-on-Week Change and a Trend with SLOPE
- The First Year of a New Customer: Visits, Margin, Cost per New Customer, Net Value and Rank by Source
- Rebooking Rhythm: Days since the Last Visit, Gap Ratio, a Status with IFS and a Count of Customers to Remind
- Empty Chairs and No-Shows: Fill Rate per Slot, No-Show Rate, the Value of Idle Slots and What a Deposit Could Win Back
- A What-If Grid: Budget against Cost per Booking with Mixed References, Whole Bookings, a Heat Map and a Count of Losing Plans
- Forecasting Bookings from Ad Spend: SLOPE, INTERCEPT, R Squared and FORECAST.LINEAR for the Next Three Months
- Tracking Quality: Tracked Bookings against the Question at the Till, the Gap, Till ÷ Tracked and an IFS Verdict
- Final Project: The Simple Monthly Report with Cost per Booking, Net after Spend, Status per Channel, the Blended Cost, a Chart and a Warning Colour