Event spinege_shopping_events holds 6.5M events with MPID, session, store, action type, basket total, SKU, quantity, price, brand, and four department levels. This is the raw behavior substrate.retail_analytics.ge_shopping_events
Mission modelge_mission_clusters is a BigQuery ML K-means model with six clusters and 25 features across time, basket size/value, department diversity, and department mix. It trained in five iterations.retail_analytics.ge_mission_clusters
Cluster outputsge_session_missions contains 193,119 session feature vectors; ge_session_clusters contains 196,671 scored sessions with mission_cluster and cluster_distance. ML.EVALUATE returns mean squared distance 19.75 and Davies-Bouldin 2.26.ge_session_missions · ge_session_clusters
Shopper profilege_user_propensity_profiles has 9,366 shopper profiles with primary mission, mission mix, preferred day/hour, stores, basket stats, dietary purchase shares, likely restriction flags, health score, top products, and recency JSON.grocery-agent/grocery/tools/bq.py
Behavioral assetsThe same retail plane includes 344,781 virtual pantry rows, 1.3M co-purchase affinity edges, 69,902 department-affinity rows, and 22,853 promotion rows for contextual offers.ge_virtual_pantry · ge_co_purchase_affinity · ge_promotions
Telemetry substrateThe reusable analytics package defines analytics_* searches, selections, conversations, sessions, and traces; the grocery agent keeps eagle_ai_* equivalents for agent-specific observability and governance joins.analytics/src/analytics/events/tables.py · grocery/analytics/analytics_logger.py