Tabellab

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

Lesson 20 of 20 Lab 🔒 Locked

Lessons in this course

  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