The First Year of a New Customer: Visits, Margin, Cost per New Customer, Net Value and Rank by Source
Lessons in this course
- 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