Performance Stats Email

Performance Stat Emails is an automated outbound email program that delivers performance summaries of each restaurant partner’s previous period. The program has two cadences:

1. Weekly — Sent every Monday at 9:00 AM ICT. Covers the previous Monday through Sunday.
2. Monthly — Sent on the 1st of every month at 9:00 AM ICT. Covers the previous calendar month. Both emails are sent to the registered Restaurant Email associated with the active Hungry Hub account. Each email covers Sales, Covers, Conversion Rate, No Show Rate, Best Selling Package, Top Channels, Top Countries, and a Capacity Utilization Matrix (Monthly) that aggregates timeslot GMV into color-coded time blocks to highlight operational bottlenecks. The emails support all active markets (TH, SG, MY) with localized currency rendering (THB, S$, RM) and use a consistent display logic across cadences. This feature replaces the previous “Average Diners Seated” logic and the separate “Benchmark Weekly Growth” widget (benchmarks are now rendered inline inside each Key Stats card).

Objectives

• Automatically notify active restaurant partners of their performance metrics via email on the configured cadence (weekly Monday 9 AM ICT, monthly 1st 9 AM ICT).
• Re-activate dormant partners (those with zero bookings in the previous period) with a tailored Zero Booking Activation Email variant.
• Surface operational bottlenecks through the Capacity Utilization Matrix (Monthly — time-block GMV heatmap).
• Provide a city-level benchmark for each primary metric so partners can gauge performance against their local peer group.
• Display directional growth (MoM/MoW %) with consistent color coding (Green positive, Red negative, Black for 0%).
• Reduce inbound Calendly/AM booking volume by giving partners self-service visibility of their KPIs.
• Email Subject
  • Weekly
    • Have Booking
      • Format : [Restaurant Name] Weekly Summary: [Weekly Date Range]
      • Example : Audrey Cafe Thonglor Weekly Summary: Mar 16 - Mar 22
    • Zero Booking
      • Format : Let's boost your bookings, [Restaurant Name]! ([Weekly Date Range])
      • Example : Let's boost your bookings this week, Nozomi at Millenia Walk! (Mar 23 - Mar 29)
  • Monthly
    • Have Booking
      • Format : [Restaurant Name] Monthly Summary: [Month Year]
      • Example : Audrey Cafe Thonglor Monthly Summary: March 2026
    • Zero Booking
      • Format : Let's get diners through the door in [Next Month]! ([Month Year] Review)
      • Example : Let's get diners through the door in April! (March 2026 Review)

Scope

• Active Hungry Hub restaurant accounts across TH, SG, MY.
• Active partners (with at least one booking in the previous period) → standard summary email.
• Inactive partners (zero bookings in the previous period) → “Zero Booking Activation Email” variant.
• Email routing: emails must strictly be sent to the registered Restaurant Email on the active Hungry Hub account.
• Feature flags:
  • Weekly: ff_performance_weekly_email_v1
  • Monthly: ff_performance_monthly_email_v1

Formulas & Aggregations

1. Bookings
   • Number of bookings in the date range
2. Covers
   • Total covers (sum of party sizes sold)
3. Sales
   • Total revenue from mv_dashboard_revenue
4. Avg. Spend / Pax
   • Formula covers / sales
5. Views
   • From mv_conversion_rates row total_views
6. Conversion Rate
   • From mv_conversion_rates
7. New User
   • total of new users whose first-ever booking at this restaurant
   • Formula: ((new_user_count.to_f / total_unique_users) * 100).round
8. Largest Group Size
   • Biggest party size / adult for the restaurant
9. Max Allotment / Round
   • Restaurant largest table (maximum party size / adult on each booking before turn into Big Group Booking)
10. No Show Rate
    • Count of No Show bookings / (Count of No Show bookings + Pending Arrival bookings + Arrived bookings)
    • Denominator excludes Cancelled bookings (Cancel, Cancel (Modified), Cancel with Refund).
    • No Show Rate is excluded from Cancel Rate formula (and vice versa).
11. Cancel Rate
    • Rate of canceled booking
    • Formula: ((cancelled_count.to_f / cancel_denominator) * 100).round
12. Best Daily Sales
    • Calculate and comparing the daily revenue and get the largest revenue.
13. User’s Country
    • Exclude "Unknown" countries from the denominator.
    • Count of Guests from Country X / Total Guests with a Known Country
14. Top Channels
    • Pulled from the newly introduced Channel Type column (Direct, HH Marketing, 3rd Party, etc.).
15. Best Selling Package
    • “Best Selling” is determined by GMV (Gross Merchandise Value / Sales Revenue), not the count of bookings.
    • The percentage shown is compared against ALL packages, not just the top 3.
    • Formula: Package A GMV / Total GMV of ALL Packages.
    • For dynamic pricing tiers, use the lowest price in the tier.
16. Average Dinners Seated by Day / Time slot
    • Show the (Low / Mid / High) of total seated party_size per day and time-slot.
17. Benchmark
    • The (Benchmark: +X%) represents the aggregate growth percentage for all restaurants located in the same City as the target restaurant.
    • (Total City Metric Current Period - Total City Metric Previous Period) / Total City Metric Previous Period
18. Growth Cap: Cap growth percentage at 1000%.