Skip to main content

Outlets dashboard

Within-merchant outlet comparison: revenue share, AOV, channel mix, top items, time-of-week patterns across all outlets in your group.

Written by HB

What this dashboard is for

The Outlets dashboard is the within-merchant comparison view. If you run more than one outlet under the same Papaya account, this is where you see them side by side — revenue share, AOV, meal duration, channel mix, top items, and time-of-week patterns by outlet.

Open it when you want to know which of your outlets is leading on a particular metric, which is dragging, and what the differences look like over time.


How outlets are scoped

The dashboard is pinned to your merchant (your top-level Papaya account). Every chart shows every active outlet under that merchant. If your merchant has only one outlet there is not much to see here — use the Trends or Channels dashboards instead.

Many charts cap at the top 20 outlets by revenue and fold the rest into "Other" — relevant only for very large merchant groups.

The six tabs

  • Overall — six side-by-side comparison views (revenue share, order share, AOV, meal duration, revenue by channel, orders by channel).

  • Items — top 20 items across the merchant, split by outlet.

  • Weekly / Monthly / Yearly — same three charts (revenue, AOV, items per order) over different time scales.

  • Weekday — revenue and orders by hour-of-week heatmap, split by outlet.


Overall tab

1. % Revenue Share

Revenue Share by Outlet

Pie chart of revenue across outlets. Each slice is one outlet's share of the merchant's total revenue in the selected range.

How it's calculated: sum of orders.total on closed orders, grouped by outlet name. Top 19 outlets get their own slice; everything beyond falls into "Other".

2. % Order Share

Order Share by Outlet

The same pie but counting orders rather than revenue.

Reading it: compared with the revenue pie — an outlet with a much bigger order share than revenue share is selling more, smaller orders (often takeaway or delivery-heavy). The reverse means bigger tickets.

3. AOV

AOV by Outlet

Average order value per outlet — bars side by side, highest first.

How it's calculated: revenue ÷ orders per outlet (on closed orders).

4. Median Meal Duration | Dine-in only

Median Meal Duration

How long the average dine-in cheque stays open at each outlet, in minutes — measured as the time between order opening and closing. Median rather than mean so a single very long tab doesn't skew the number.

Reading it: a low number is fast turnover (counter / casual); a high number is leisurely dining. Use it as a sanity check on whether outlets are operating the way you expect.

5. Revenue | by Channel Type

Revenue by Channel Type per outlet

Horizontal bars: revenue, segmented by channel (dine-in, takeaway, partner platforms, etc.), one bar per outlet.

6. Orders | by Channel Type

Orders by Channel Type per outlet

Same shape, counting orders.


Items tab

1. Quantity | Top 20 Items

Top 20 items split by outlet

The 20 best-selling items across the whole merchant, with each item's bar segmented by outlet. Useful for spotting which outlets carry which signature items and where a popular item might be underrepresented.


Weekly tab

1. Revenue | Weekly

Revenue Weekly by Outlet

Stacked bars: one bar per week, each segment an outlet. The merchant's total weekly revenue and how each outlet contributes.

2. AOV | Weekly

AOV Weekly by Outlet

One line per outlet showing AOV over time. Drift between lines tells you whether outlets are diverging in ticket size.

3. Items per Order | Weekly

Items per Order Weekly

Average items on a cheque per outlet per week.


Monthly tab

1. Revenue | Monthly

Revenue Monthly by Outlet

2. AOV | Monthly

AOV Monthly by Outlet

3. Items per Order | Monthly

Items per Order Monthly


Yearly tab

1. AOV | Yearly

AOV Yearly by Outlet

2. Items per Order | Yearly

Items per Order Yearly by Outlet

Note: the Yearly Revenue chart on this tab takes longer to compute than other charts; refer to the Monthly Revenue chart above for a near-equivalent view aggregated to whole years.


Weekday tab

1. Revenue | by Hour-of-Week

Revenue by Hour of Week per outlet

A 168-bucket view (7 days × 24 hours) of revenue, with each hour-of-week stacked by outlet. The labels along the bottom run Mon 00:00, Mon 01:00, …, Sun 23:00.

How it's calculated: bucketed by EXTRACT(ISODOW FROM reportingDate) and EXTRACT(HOUR FROM orderDate) in Bangkok time, summed by outlet.

Reading it: different outlets often have different weekly rhythms — an office-district outlet peaks weekday lunch; a mall outlet peaks weekend afternoons; a late-night spot fills evenings. Stack-shape differences are the giveaway.

2. Orders | by Hour-of-Week

Orders by Hour of Week per outlet

Same shape, counting orders.


How the numbers are defined

  • Scope — every chart is restricted to the outlets under your merchant. The merchantId is the only top-level filter; the dashboard never asks for an outlet.

  • Status filter — closed orders only (status = 'complete'). Voided / open tabs excluded.

  • Item filter (Items tab) — confirmed items only (order_items.status = 'confirmed').

  • Date fieldreportingDate for all time buckets; orderDate for hour-of-day in the Weekday tab.

  • Timezone — Asia/Bangkok.

  • Median meal duration — taken across dine-in cheques only; the difference between order open and order close, expressed in minutes; median across all cheques in the range.

  • Top-20 cap — pies and the items chart cap at the top 20 outlets / items by revenue; smaller outlets fold into "Other".

Filters

  • Reporting Date — the date range.

  • Merchant — pinned to your merchant when the dashboard is embedded in the Papaya portal.

  • Outlet / Outlet Names — optional. By default the dashboard shows every outlet; use these to narrow the comparison to a subset.

What this dashboard does NOT show

  • A single outlet's deep dive — use Today for live ops, Trends for historical trends, Channels / Items / Categories for breakdowns.

  • Multi-tier KPIs with targets and traffic-light colouring — that's the Group KPIs dashboard.

  • Cross-merchant industry benchmark — see Industry.

  • Margin / inventory / cost — see the Inventory module.

Did this answer your question?