Tabellab

Local Social Posts: Engagement Rate, Tap Rate and the Best Post Type

Lesson 12 of 20 Lab 🔒 Locked

Lessons in this course

  1. Delivery Commission vs Direct Orders: Fee Rate, Fee in £, Net Revenue and Net Revenue per ChannelLabFree
  2. Contribution per Order: Fee, Food Cost, Packaging and Own Courier by ChannelLab Locked
  3. Break-Even Commission: Contribution per Order, Margin and the Highest Fee Rate a Channel Can BearLab Locked
  4. Shifting App Orders to Direct: Saving per Order, Orders Moved and an Annual What-If GridLab Locked
  5. Direct Ordering Funnel: Basket Rate, Checkout Completion and Promotion Cost per OrderLab Locked
  6. Reservation Sources: Share of Bookings, No-Show Rate and Shown CoversLab Locked
  7. Cost per Seated Cover: Variable Fees, Fixed Costs and Cost as a Share of Sales by Booking SourceLab Locked
  8. Quiet Evenings: Weekday Numbers, Fill Rate, Peak vs Midweek and Conditional FormattingLab Locked
  9. Menu Promotion Test: Change in Units, Margin per Unit, Extra Margin and a Comparison GroupLab Locked
  10. Test vs Control Venue: Weekly Ratio, Before and After Averages and Uplift of a Menu PromotionLab Locked
  11. Menu Engineering: Popularity Share, Weighted Margin, Stars and Puzzles to PromoteLab Locked
  12. Local Social Posts: Engagement Rate, Tap Rate and the Best Post TypeLab Locked
  13. From Post to Booking: Click-to-Booking Rate, Cost per Booking with IFERROR and Contribution after BoostLab Locked
  14. Review Response: Response Rate, 24-Hour Replies, Unanswered Low-Star Reviews and the Star DistributionLab Locked
  15. Rating Target Math: Stars So Far, 5-Star Reviews Needed, Months to Target and Weighted AverageLab Locked
  16. Review Rating Trend: SLOPE, FORECAST.LINEAR, CORREL with Wait Mentions and an Alert LevelLab Locked
  17. Offer Redemption: Redemption Rate, Discount Cost, Discount as a Share of the Bill and RankLab Locked
  18. Offer Incrementality: Holdout Group, Expected Visits Anyway, Incremental Visits and Net ContributionLab Locked
  19. Repeat Visits: Days to Return, a 60-Day Window and Return Rates with and without an OfferLab Locked
  20. Final Project: A Restaurant Digital Marketing Dashboard with Direct Share, Fees, Show-Up Rate and a ForecastLab Locked