Data dictionary frequency_tier category · 3 tiers
A new KPI: each guest's visit frequency tier (Occasional, Regular, Frequent) across dining room, bar and takeout together, with split checks merged into one visit.
Built from checks_12mcheck_tsmember_ref
Data dictionary visit_regularity float · 0 to 1
How regular the gaps between a guest's visits are, from 0 (erratic) to 1 (clockwork), with split checks merged into one visit.
Built from check_tsmember_reflocation
Data dictionary bar_share float · 0 to 1
The share of a guest's checks rung up at the bar rather than in the dining room, with location codes cleaned across POS systems.
Built from locationoffercheck_ts
Data dictionary bundle_response float · 0 to 1
How often a guest takes a pairing or set-menu offer, relative to how often they redeem a straight discount or points reward.
Built from offeritemnet
Data dictionary premium_item_share float · 0 to 1
The share of a guest's spend on the premium end of the menu (prime cuts, the reserve list), with item names mapped to one menu across locations.
Built from itemnetqty