RT Pastry — AI Analytics Dashboard

Powered by Etch Media • Real-time Store Intelligence

Today: 16 Mar 2026
Capture Rate (入店率)
38.2%
Outer → Inner Zone
+2.4%vs last week
Transaction Conversion
65.8%
Buyers / Visitors
+1.8%vs last week
Network Customers
937
Cross-branch visitors
+12.3%vs last week
Wastage Rate
8.2%
Produced vs wasted
-1.6%vs last week

Weekly Revenue & Visitors Trend

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.

Insight: Saturday and Sunday drive 40% of weekly revenue (RM 32,000). Friday–Sunday buyers are 35% higher than weekday average — prioritize weekend staffing and fresh stock rotation.

Customer Segments

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.

Insight: After-Work Commuters (35%) and Families (25%) represent 60% of customers. Ensuring fresh bakes at 5PM could capture more of the commuter rush.

Branch Performance Comparison

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.

Insight: Pavilion leads in Avg Spend (RM 90) and Capture Rate (45%), while Bangsar excels in Satisfaction (82). Sharing Bangsar's customer experience practices across branches could lift network-wide satisfaction.

Predictive Weekly Forecast

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.

Insight: AI predicts Week +3 revenue of RM 88,500 (+11.3% vs this week), likely driven by upcoming school holidays. Pre-plan production increases for high-demand items like Egg Tart and Butter Croissant.

Capture Rate & Traffic Analytics

AI-powered zone tracking: Outer Zone (passers-by) → Inner Zone (store entry) → Purchase

Outer Zone (Passers-by)
3,535
Today's foot traffic
+8.2%vs last week
Inner Zone (Entries)
1,351
38.2% capture rate
+5.6%vs last week
Buyers
889
65.8% conversion
+3.1%vs last week
Browsers (No Purchase)
462
34.2% browse-only
-2.4%vs last week

Hourly Traffic Funnel — Outer Zone → Inner Zone → Buyers

Hourly Traffic Funnel

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.

Insight: Peak capture occurs at 6–7PM (167 entries from 380 passers-by = 43.9%), well above the daily average of 38.2%. The 2PM dip (67 entries) suggests an opportunity for midday promotions to boost off-peak traffic.

Conversion Funnel

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

Long queue (>5 min)42%
Out-of-stock items31%
Product placement issues18%
Other9%

Weekly Visitor & Buyer Trend (All Branches)

Weekly Visitor & Buyer Trend

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.

Insight: Saturday conversion rate (67.9%) is the highest of the week, while Tuesday (62.6%) is the lowest. Consider Tuesday-specific deals to boost mid-week conversions.

Customer Behavior Analytics

AI-driven behavioral segmentation and cross-branch customer tracking

Behavioral Segmentation

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

Insight: Families spend 2.3x more per visit (RM 42) than After-Work Commuters (RM 18) but are only 25% of traffic. Targeted family bundles and kids' specials could significantly boost average ticket size.

Peak Hours by Segment

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.

Insight: The 6–8PM slot sees the highest footfall with After-Work Commuters and Families overlapping. Ensure top sellers (Egg Tart, Butter Croissant) are freshly stocked by 5:30PM to maximize this golden window.

Cross-Branch Ecosystem — Network Customer Tracking

Cross-Branch Network 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.

BranchUnique VisitorsNetwork CustomersLoyalty RateStatus
Bangsar1,24018615%Strong
KLCC1,58023715%Strong
Sunway98012713%Growing
Mont Kiara86011213%Growing
Pavilion1,72027516%Strong
Insight: Pavilion branch shows the highest network customer rate (16%), suggesting strong brand loyalty pull. Consider cross-promotions between Pavilion and Mont Kiara to boost the latter's 13% loyalty rate.

Product & Wastage Control

Hero vs Laggard analysis, shelf-to-sales optimization, and predictive forecasting

Avg Shelf-to-Sales Ratio
72.4%
Week over week
+3.8%vs last week
Weekly Wastage
650 units
Down from 743 last week
-12.5%vs last week
Laggard Products
3 items
Below 35% shelf score
Forecast Accuracy
91.2%
Last 4 weeks avg
+2.1%vs last week

Hero vs Laggard Product Analysis

Hero vs Laggard Products

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.

Hero
Neutral
Laggard
Insight: Top 4 Heroes (Egg Tart, Butter Croissant, Pandan Cake, Char Siu Bao) score 82+. Bottom 3 Laggards (Coconut Tart, Raisin Bread, Walnut Cake) score below 35 — consider replacing with trending items or repositioning to higher-traffic shelves.

Production vs Sales vs Wastage

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.

Insight: Wastage drops from 120 units (Mon) to 55 units (Sat) as the week progresses, showing the AI model self-corrects production. Monday overproduction is the biggest opportunity — reducing Mon/Tue output by 10% could save ~23 units of waste per week.

Predictive Weekly Forecast

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.

AI Recommendation: Increase Egg Tart and Butter Croissant production by 15% next week. Reduce Walnut Cake and Raisin Bread by 30% to minimize wastage.

Shelf-to-Sales Optimization

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.

Insight: Red Bean Bun has a shelf score of 55 but only 180 units sold — it's well-placed but underperforming. Consider taste testing or bundling with Hero items. Conversely, Char Siu Bao sells 290 units from a score of 65 — give it a better shelf spot to unlock more sales.

Best Sellers — Peak Hour (6–8PM)

Peak Hour Best Sellers

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.

Insight: Egg Tart sells 3.2x more during peak than off-peak. Pre-bake an extra batch at 5PM to avoid the 6:30PM stockout pattern seen the last 3 weeks.

Best Sellers — Full Day

Full Day Best Sellers

Overall daily sales volume per product. Full-day rankings differ from peak because morning items accumulate volume over more hours.

Insight: Butter Croissant and Pandan Cake rank higher all-day due to steady morning/lunch demand, even though Egg Tart dominates peak hours.

Underperforming Products

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.

Insight: Walnut Cake has a 22% sell-through rate — for every 100 produced, 78 are wasted. Consider discontinuing or converting to a "made-to-order" item to eliminate waste.

Sell-Through Speed — Sold Out vs Left Over

Sell-Through Speed

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.

Insight: Egg Tart sells out by 3PM daily — estimated RM 2,400/week in lost sales from stockouts. Increasing production by 25% could capture this unmet demand.

Customer Demographics

AI-powered facial analysis: age estimation, gender detection, and ethnicity classification

Dominant Age Group
25–34
32% of all visitors
Gender Split
58% / 42%
Female / Male
Top Ethnicity
Malay 45%
Reflects local demographics
Peak Hour Shift
+3% Chinese
6–8PM vs all-day average

All-Day Demographics (8AM – 10PM)

Age Distribution

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.

Insight: 25–44 age group makes up 60% of visitors. Consider modern packaging and social media promotions targeting this demographic.

Gender Split

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.

Insight: Female customers (58%) show 12% higher conversion rate than male visitors. Display cakes and pastries favored by female shoppers at eye-level shelves.

Ethnicity Breakdown

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).

Insight: Malay (45%) and Chinese (35%) make up 80% of visitors. Prioritize halal-certified range and traditional Chinese pastries (Egg Tart, Wife Cake) for maximum appeal.

Peak Hour Demographics (6PM – 8PM)

Age — Peak Hour

Peak Hour Age

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.

Insight: 18–34 jumps from 47% (all-day) to 60% during peak. Quick-grab items and trendy packaging resonate with this younger rush-hour crowd.

Gender — Peak Hour

Peak Hour Gender

Female ratio increases to 62% during peak hours, driven by mothers picking up after-work/school treats. Male ratio drops from 42% to 38%.

Insight: Female share rises to 62% at peak. Family-size bundles and grab-and-go sets displayed near entrance would capture this segment.

Ethnicity — Peak Hour

Peak Hour Ethnicity

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.

Insight: Chinese customers rise +3% at peak. Ensure Egg Tarts and Butter Croissants (top picks for this segment) are freshly stocked by 5:30PM.

Dwell Time Analytics

AI-tracked time-in-store analysis: browse behavior, spend correlation, and zone engagement

Avg Dwell Time (Buyers)
8.2 min
Includes browse + checkout
+0.4 minvs last week
Avg Dwell Time (Browsers)
3.1 min
Left without purchase
-0.2 minvs last week
Browse & Leave Rate
34.2%
462 of 1,351 visitors
-2.4%vs last week
Spend per Minute
RM 2.68
Revenue / total dwell mins
+3.2%vs last week

Browse & Leave — Why Customers Leave Empty-Handed

Browse & Leave Analysis

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.

Insight: 48% of browsers leave within 2 minutes (nothing caught their eye). Better entrance displays and "What's Fresh Now" signage could convert quick-exit browsers into buyers.

Dwell Time vs Spend — Correlation

Dwell Time vs Spend

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.

Insight: Customers staying 10+ min spend RM 38 avg vs RM 12 for under 5 min. Each extra minute = +RM 3.20. Comfortable browsing areas and product sampling could significantly increase basket size.

Top 5 Highest Dwell Time Zones

Highest Dwell Zones

Zones where customers spend the most time. High dwell = strong engagement — prime spots for upselling, cross-selling, and placing new launches.

Insight: Main Display Counter (4.2 min) and Cake Display (3.5 min) are the highest-engagement zones. Place new product launches and premium items here for maximum visibility.

Top 5 Low-Traffic / Dead Zones

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.

Insight: Back Corner Shelf gets only 12 visits/day vs 380+ at Main Display. Moving a hero product (Egg Tart) to the back as an "anchor" could increase traffic by 3x.

Heatmap & Customer Flow

AI movement tracking: customer pathing, hotspot analysis, and destination vs discovery behavior

Destination Traffic
58%
Regulars — know where to go
Discovery Traffic
42%
Explorers — browsing around
Avg Zones Visited
3.4
Per customer per visit
+0.3vs last week
Top Flow Path
Entry → Main
78% of all customers

Customer Flow — Most Visited After Entry

Most Visited Flow

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.

Insight: 78% head to Main Display first, then 62% continue to Bread Section. Place high-margin impulse items along this Entry → Main → Bread corridor.

Customer Flow — Least Visited Areas

Least Visited Flow

Areas that customers rarely visit. Low flow = poor visibility, unappealing layout, or no draw products. These dead zones represent lost sales opportunities.

Insight: Back Corner (8%) and Seasonal Display (12%) are virtually invisible. Adding directional floor signage or a sample tasting station could create a "destination" pull.

Destination vs Discovery Traffic

Destination vs Discovery

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

MetricDestinationDiscovery
Avg Dwell4.5 min11.2 min
Zones Visited1.85.2
Avg BasketRM 16RM 34
Conversion82%45%
Insight: Discovery shoppers spend 2.1x more (RM 34 vs RM 16) but convert at only 45%. A guided "tasting trail" or numbered product journey could boost discovery conversion while maintaining higher basket size.

Zone Traffic by Customer Type

Zone Traffic Breakdown

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.

Insight: Discovery customers are 6x more likely to visit Cake Display and Pastry Corner. Place "staff picks" and "new arrivals" in these zones to reward exploration and increase impulse purchases.