Stampede
Schema
AI AnalyticsAI Layer

AI_VenueIntelligence

Aggregated AI insights at venue level — review health, customer overlap between venues, ordering and cancellation patterns per customer.

8 fields6 relationships

Fields

NameTypeReqDescription
avg_ratingnumber—Avg review rating.
avg_positive_sentimentnumber—Avg positive sentiment 0–1.
avg_negative_sentimentnumber—Avg negative sentiment 0–1.
reply_ratenumber—Reply rate 0–1.
avg_response_hoursnumber—Avg hours to respond.
jaccard_indexnumber—Customer overlap 0–1. Used on CUSTOMER_OVERLAP.
cancel_ratenumber—Customer cancel rate at venue. Used on CANCELLATION_PATTERN.
computed_atdatetimeyesLast calculated.

Relationships

Inbound (6)
  • Venue[:REVIEW_INTELLIGENCE]→Organizationtotal_reviews, avg_rating, positive_pct, negative_pct, reply_rate, avg_response_hours, computed_at
  • Venue[:CUSTOMER_OVERLAP]→Venueshared_customer_count, jaccard_index, shared_spend_pennies, computed_at
  • Customer[:ORDER_PATTERN]→Venuetotal_orders, total_spend_pennies, avg_order_value_pennies, computed_at
  • Customer[:CANCELLATION_PATTERN]→Venuetotal_bookings, total_cancellations, no_show_count, cancel_rate, last_cancel_date, computed_at
  • Customer[:PEAK_HOUR_AFFINITY]→Venuevisit_count, computed_at — preferred visit time slot
  • Customer[:SENTIMENT_SHIFT]→Venuefirst_review_rating, latest_review_rating, rating_trend (improving | declining | stable), review_count, computed_at