Review Response: Response Rate, 24-Hour Replies, Unanswered Low-Star Reviews and the Star Distribution
Lessons in this course
- Delivery Commission vs Direct Orders: Fee Rate, Fee in £, Net Revenue and Net Revenue per ChannelFree
- Contribution per Order: Fee, Food Cost, Packaging and Own Courier by Channel Locked
- Break-Even Commission: Contribution per Order, Margin and the Highest Fee Rate a Channel Can Bear Locked
- Shifting App Orders to Direct: Saving per Order, Orders Moved and an Annual What-If Grid Locked
- Direct Ordering Funnel: Basket Rate, Checkout Completion and Promotion Cost per Order Locked
- Reservation Sources: Share of Bookings, No-Show Rate and Shown Covers Locked
- Cost per Seated Cover: Variable Fees, Fixed Costs and Cost as a Share of Sales by Booking Source Locked
- Quiet Evenings: Weekday Numbers, Fill Rate, Peak vs Midweek and Conditional Formatting Locked
- Menu Promotion Test: Change in Units, Margin per Unit, Extra Margin and a Comparison Group Locked
- Test vs Control Venue: Weekly Ratio, Before and After Averages and Uplift of a Menu Promotion Locked
- Menu Engineering: Popularity Share, Weighted Margin, Stars and Puzzles to Promote Locked
- Local Social Posts: Engagement Rate, Tap Rate and the Best Post Type Locked
- From Post to Booking: Click-to-Booking Rate, Cost per Booking with IFERROR and Contribution after Boost Locked
- Review Response: Response Rate, 24-Hour Replies, Unanswered Low-Star Reviews and the Star Distribution Locked
- Rating Target Math: Stars So Far, 5-Star Reviews Needed, Months to Target and Weighted Average Locked
- Review Rating Trend: SLOPE, FORECAST.LINEAR, CORREL with Wait Mentions and an Alert Level Locked
- Offer Redemption: Redemption Rate, Discount Cost, Discount as a Share of the Bill and Rank Locked
- Offer Incrementality: Holdout Group, Expected Visits Anyway, Incremental Visits and Net Contribution Locked
- Repeat Visits: Days to Return, a 60-Day Window and Return Rates with and without an Offer Locked
- Final Project: A Restaurant Digital Marketing Dashboard with Direct Share, Fees, Show-Up Rate and a Forecast Locked