Local Business Digital Marketing: Cost per Booking, Small Budgets, Offers, Reviews, Seasonal Calendar & Monthly Reporting
Win bookings for a salon, café or trades business on a small budget. You calculate the cost per booking of every channel, split a monthly budget, work out what a booking is worth and what it may cost, measure offer redemptions and who redeems them, judge search terms, boosted posts and email sends, build a seasonal calendar with lead times and voucher end dates, plan review requests and watch the average rating, read a business profile, value the first year of a new customer, spot lapsed regulars, count empty chairs and no-shows, run a what-if grid and an ad-spend forecast, check tracking against the question at the till and finish with a simple monthly report: 20 hands-on labs, fictional salon data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches the arithmetic of marketing for a small local business in 20 interactive spreadsheet labs. You work for Larkspur & Comb Hair Studio, a fictional two-chair salon, and follow its year: you calculate the cost per booking of every channel, split a small monthly budget, turn the margin of each service into the most a booking may cost and measure vouchers and offers by redemption rate and who redeems them. You judge search terms, boosted posts and email sends on a small budget, plan a seasonal calendar with lead times and voucher end dates, and run review requests and watch the average rating. Later labs read a business profile, value the first year of a new customer, spot lapsed regulars, count empty chairs and no-shows, build a what-if grid and an ad-spend forecast, compare tracking with the question at the till, and finish with a one-page monthly report with a chart. Every formula is checked as you type. All companies, people and numbers are fictional and all benchmarks are illustrative.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Cost per Booking: Spend, Enquiries and Bookings by Channel, the Booking Rate and the Blended Cost of a MonthFree
- Splitting a Small Budget: Shares per Channel with an Absolute Reference, a 100 % Check and Expected Bookings with ROUNDDOWN Locked
- What a Booking Is Worth: Margin per Service, Margin % and the Maximum Cost per Booking with IF Locked
- Offer Redemptions: Redemption Rate, Total Offer Cost, Cost per Redemption and Net Revenue per Offer Locked
- Who Redeems? New vs Existing Customers per Offer with COUNTIF, COUNTIFS and SUMIFS Locked
- Search Ads on a Small Budget: Cost per Click, Click-to-Booking Rate, Cost per Booking by Search Term and a Pause List Locked
- Local Social: Boosted Posts by Cost per Enquiry, Bookings per 1,000 Reached and Cost per Booking by Post Type Locked
- Email on a Small List: Bookings per 1,000 Delivered, Revenue per Email, Unsubscribe Rate and a Check Flag Locked
- The Seasonal Calendar: Average Month, Seasonal Index, a Budget that Follows Demand and the Busiest Month with XLOOKUP Locked
- Campaign Dates: Start Dates from Lead Times, Days until the Start, a Status with IFS and Voucher End Dates with EOMONTH Locked
- Review Requests: Review Rate per Wave, Cost per Review and the Best Way to Ask with SUMIFS Locked
- Review Ratings: Reviews per Month, the Weighted Average Rating with SUMPRODUCT and How Many 5-Star Reviews Lift It Locked
- The Business Profile in One Lesson: Weekly Actions, Actions per 100 Views, Week-on-Week Change and a Trend with SLOPE Locked
- The First Year of a New Customer: Visits, Margin, Cost per New Customer, Net Value and Rank by Source Locked
- Rebooking Rhythm: Days since the Last Visit, Gap Ratio, a Status with IFS and a Count of Customers to Remind Locked
- Empty Chairs and No-Shows: Fill Rate per Slot, No-Show Rate, the Value of Idle Slots and What a Deposit Could Win Back Locked
- A What-If Grid: Budget against Cost per Booking with Mixed References, Whole Bookings, a Heat Map and a Count of Losing Plans Locked
- Forecasting Bookings from Ad Spend: SLOPE, INTERCEPT, R Squared and FORECAST.LINEAR for the Next Three Months Locked
- Tracking Quality: Tracked Bookings against the Question at the Till, the Gap, Till ÷ Tracked and an IFS Verdict Locked
- 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 Locked
Learner reviews
Be the first to review this course.