Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Cost per Booking: Spend, Enquiries and Bookings by Channel, the Booking Rate and the Blended Cost of a MonthLabFree
  2. Splitting a Small Budget: Shares per Channel with an Absolute Reference, a 100 % Check and Expected Bookings with ROUNDDOWNLab Locked
  3. What a Booking Is Worth: Margin per Service, Margin % and the Maximum Cost per Booking with IFLab Locked
  4. Offer Redemptions: Redemption Rate, Total Offer Cost, Cost per Redemption and Net Revenue per OfferLab Locked
  5. Who Redeems? New vs Existing Customers per Offer with COUNTIF, COUNTIFS and SUMIFSLab Locked
  6. Search Ads on a Small Budget: Cost per Click, Click-to-Booking Rate, Cost per Booking by Search Term and a Pause ListLab Locked
  7. Local Social: Boosted Posts by Cost per Enquiry, Bookings per 1,000 Reached and Cost per Booking by Post TypeLab Locked
  8. Email on a Small List: Bookings per 1,000 Delivered, Revenue per Email, Unsubscribe Rate and a Check FlagLab Locked
  9. The Seasonal Calendar: Average Month, Seasonal Index, a Budget that Follows Demand and the Busiest Month with XLOOKUPLab Locked
  10. Campaign Dates: Start Dates from Lead Times, Days until the Start, a Status with IFS and Voucher End Dates with EOMONTHLab Locked
  11. Review Requests: Review Rate per Wave, Cost per Review and the Best Way to Ask with SUMIFSLab Locked
  12. Review Ratings: Reviews per Month, the Weighted Average Rating with SUMPRODUCT and How Many 5-Star Reviews Lift ItLab Locked
  13. The Business Profile in One Lesson: Weekly Actions, Actions per 100 Views, Week-on-Week Change and a Trend with SLOPELab Locked
  14. The First Year of a New Customer: Visits, Margin, Cost per New Customer, Net Value and Rank by SourceLab Locked
  15. Rebooking Rhythm: Days since the Last Visit, Gap Ratio, a Status with IFS and a Count of Customers to RemindLab Locked
  16. Empty Chairs and No-Shows: Fill Rate per Slot, No-Show Rate, the Value of Idle Slots and What a Deposit Could Win BackLab Locked
  17. A What-If Grid: Budget against Cost per Booking with Mixed References, Whole Bookings, a Heat Map and a Count of Losing PlansLab Locked
  18. Forecasting Bookings from Ad Spend: SLOPE, INTERCEPT, R Squared and FORECAST.LINEAR for the Next Three MonthsLab Locked
  19. Tracking Quality: Tracked Bookings against the Question at the Till, the Gap, Till ÷ Tracked and an IFS VerdictLab Locked
  20. Final Project: The Simple Monthly Report with Cost per Booking, Net after Spend, Status per Channel, the Blended Cost, a Chart and a Warning ColourLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy