Weekly Revenue & Visitors Trend
Compares total store visitors (blue bars), buyers who made a purchase (dark blue bars), and total revenue in RM (pink line) across each day of the week. Helps identify peak revenue days and conversion patterns.
Customer Segments
AI-identified customer profiles based on visit time and purchase behavior. Shows the proportion of each segment: After-Work Commuters, Families, Morning Regulars, Lunch Crowd, and Weekend Explorers. Useful for time-based promotions and baking schedules.
Branch Performance Comparison
Radar chart comparing key metrics across branches: Capture Rate (how many passers-by enter), Conversion (buyers vs visitors), Average Spend, Loyalty Rate, and Customer Satisfaction. Helps identify each outlet's strengths and weaknesses.
Predictive Weekly Forecast
AI-generated revenue predictions for the next 3 weeks based on historical trends, seasonal patterns, and current performance. Enables proactive production planning instead of reactive baking, reducing food wastage and improving stock management.
Capture Rate & Traffic Analytics
AI-powered zone tracking: Outer Zone (passers-by) → Inner Zone (store entry) → Purchase
Hourly Traffic Funnel — Outer Zone → Inner Zone → Buyers
Tracks three AI-detected zones throughout the day: Outer Zone (passers-by in front of the store), Inner Zone (customers who enter), and Buyers (those who make a purchase). Reveals peak hours and helps optimize staffing and product availability.
Conversion Funnel
Visual breakdown of how foot traffic converts: from passers-by to store entries (Capture Rate), then to browsers vs buyers (Transaction Conversion). The "Lost Sales Insights" section identifies why customers leave without purchasing — queue times, stock issues, or placement problems.
Lost Sales Insights
Weekly Visitor & Buyer Trend (All Branches)
Aggregated weekly view of total visitors vs buyers across all branches. Shows day-of-week patterns to help plan staffing, promotions, and inventory across the network.
Customer Behavior Analytics
AI-driven behavioral segmentation and cross-branch customer tracking
Behavioral Segmentation
AI automatically identifies common customer profiles based on visit timing and purchase patterns. Each segment shows peak activity hours and average spend. Use this to optimize baking schedules, product availability, and time-based promotions for each group.
After-Work Commuters 35%
Peak: 6–8PM • Avg: RM 18
Families 25%
Peak: 7–9PM • Avg: RM 42
Morning Regulars 20%
Peak: 8–10AM • Avg: RM 12
Lunch Crowd 15%
Peak: 12–2PM • Avg: RM 22
Weekend Explorers 5%
Peak: Sat–Sun • Avg: RM 35
Peak Hours by Segment
Stacked bar chart showing when each customer segment is most active throughout the day. For example, Morning Regulars dominate 8–10AM while After-Work Commuters and Families peak at 6–8PM. Helps plan which products to bake and display at different times.
Cross-Branch Ecosystem — Network Customer Tracking
AI identifies customers who visit multiple RT Pastry outlets (Network Customers). If a customer visits Branch A and later Branch B, they are recognized as a repeat brand supporter. This helps understand brand loyalty across locations and plan cross-branch promotions.
| Branch | Unique Visitors | Network Customers | Loyalty Rate | Status |
|---|---|---|---|---|
| Bangsar | 1,240 | 186 | 15% | Strong |
| KLCC | 1,580 | 237 | 15% | Strong |
| Sunway | 980 | 127 | 13% | Growing |
| Mont Kiara | 860 | 112 | 13% | Growing |
| Pavilion | 1,720 | 275 | 16% | Strong |
Product & Wastage Control
Hero vs Laggard analysis, shelf-to-sales optimization, and predictive forecasting
Hero vs Laggard Product Analysis
Outlet-specific analysis ranking each product by performance score. Green "Hero" products are high sellers that deserve prime shelf space. Red "Laggard" products underperform and take valuable display space — consider repositioning, repricing, or replacing them.
Production vs Sales vs Wastage
Daily comparison of total items produced (blue), items sold (green), and items wasted (red line). The gap between produced and sold represents waste. A declining red line means the AI forecasting is improving production planning over time.
Predictive Weekly Forecast
AI projects next week's sales trends to help RT Pastry move from reactive baking to proactive production planning. Solid bars show actual revenue; transparent bars show AI-predicted revenue. Benefits include reduced food wastage, better stock planning, and improved operational efficiency.
Shelf-to-Sales Optimization
Links customer movement heatmaps with SKU sales to measure how well a product's shelf position translates into actual sales. A high shelf score with low sales means the placement isn't working. A low shelf score with high sales means the product deserves a better spot. Helps optimize product display for maximum revenue.
Best Sellers — Peak Hour (6–8PM)
Top-selling products during the 6–8PM rush. Quick-grab items outperform during peak. Ensure these are freshly baked and prominently displayed before the rush.
Best Sellers — Full Day
Overall daily sales volume per product. Full-day rankings differ from peak because morning items accumulate volume over more hours.
Underperforming Products
Products with low sales volume, poor sell-through rate, and high wastage. These items occupy shelf space that could be used for better performers.
Sell-Through Speed — Sold Out vs Left Over
How quickly each product sells out vs how much is left over at closing. Green = high sell-through (hero). Red = high leftover (laggard). Products that sell out early = lost revenue, increase production. Products always left over = waste, reduce production.
Customer Demographics
AI-powered facial analysis: age estimation, gender detection, and ethnicity classification
All-Day Demographics (8AM – 10PM)
Age Distribution
AI estimates customer age range using facial analysis. The 25–34 bracket dominates (32%), indicating a young professional customer base. Useful for product development and marketing targeting.
Gender Split
AI detects gender distribution among store visitors. Female customers dominate at 58%, which is typical for bakery retail. Helps tailor product presentation and in-store experience.
Ethnicity Breakdown
AI classifies visitors into Malay, Chinese, Indian, and Others. Reflects the Malaysian demographic mix and helps plan culturally relevant product offerings (e.g., halal-certified items, festive specials for Raya, CNY, Deepavali).
Peak Hour Demographics (6PM – 8PM)
Age — Peak Hour
During peak hours (6–8PM), the age skews younger with 18–34 making up 60% vs 47% all-day. After-work commuters and young families drive this shift.
Gender — Peak Hour
Female ratio increases to 62% during peak hours, driven by mothers picking up after-work/school treats. Male ratio drops from 42% to 38%.
Ethnicity — Peak Hour
Chinese customer share increases from 35% to 38% during peak, while Malay dips from 45% to 42%. Correlates with after-work commuter patterns in urban areas.
Dwell Time Analytics
AI-tracked time-in-store analysis: browse behavior, spend correlation, and zone engagement
Browse & Leave — Why Customers Leave Empty-Handed
34.2% of customers who enter leave without purchasing. AI tracks their dwell time to categorize: short dwell (<2 min) = nothing caught their eye, medium (2–5 min) = interest but no conversion, long (>5 min) = pricing or queue issues prevented purchase.
Dwell Time vs Spend — Correlation
Strong positive correlation (r=0.82): customers who spend more time in-store spend more money. Each additional minute adds ~RM 3.20 to the average transaction. Validates the strategy of creating an engaging in-store experience.
Top 5 Highest Dwell Time Zones
Zones where customers spend the most time. High dwell = strong engagement — prime spots for upselling, cross-selling, and placing new launches.
Top 5 Low-Traffic / Dead Zones
Zones with the fewest visitors per day. These represent wasted retail space. Solutions: better signage, lighting improvements, or relocating popular items to draw traffic.
Heatmap & Customer Flow
AI movement tracking: customer pathing, hotspot analysis, and destination vs discovery behavior
Customer Flow — Most Visited After Entry
Where customers go first after entering. Entry → Main Display is the strongest flow (78%). Understanding these paths helps optimize product placement along high-flow corridors.
Customer Flow — Least Visited Areas
Areas that customers rarely visit. Low flow = poor visibility, unappealing layout, or no draw products. These dead zones represent lost sales opportunities.
Destination vs Discovery Traffic
Destination (58%): Regulars who beeline to products and checkout quickly. 1–2 zones, 4.5 min avg.
Discovery (42%): Explorers who browse multiple zones. 4–6 zones, 11.2 min avg, 28% higher basket size.
Destination (58%)
Avg 1.8 zones • 4.5 min • RM 16 basket
Discovery (42%)
Avg 5.2 zones • 11.2 min • RM 34 basket
| Metric | Destination | Discovery |
|---|---|---|
| Avg Dwell | 4.5 min | 11.2 min |
| Zones Visited | 1.8 | 5.2 |
| Avg Basket | RM 16 | RM 34 |
| Conversion | 82% | 45% |
Zone Traffic by Customer Type
How Destination vs Discovery customers distribute across zones. Destination customers concentrate at Main Display and Checkout. Discovery customers spread more evenly and explore zones that Destination customers skip.